JDBC Driver for EdgarOnline

Build 20.0.7655

CoreFinancials_ANN_Ratios

Query from the CoreFinancials-ANN resource.

Columns

Name Type Description
AdjustedEBITDAPctGrowthTTM Float
OperatingProfitPctGrowthTTM Float
RevenuePctGrowthFY Float
NetIncomePctGrowth5YearCAGRFY Float
EBITDAPctGrowthTTM Float
RevenuePctGrowth3YearCAGRFY Float
AdjustedEBITDAPctGrowthFY Float
RevenuePctGrowthTTM Float
EBITDAPctGrowthFY Float
OperatingProfitPctGrowth5YearCAGRFY Float
FreeCashFlowPctGrowthTTM Float
OperatingCashFlowPctGrowth5YearCAGRFY Float
FreeCashFlowPctGrowthFY Float
EBITPctGrowthTTM Float
EBITPctGrowth3YearCAGRFY Float
FreeCashFlowPctGrowth5YearCAGRFY Float
OperatingProfitPctGrowthFY Float
PriceEarningstoGrowthFY Float
EBITDAPctGrowth3YearCAGRFY Float
EBITDAPctGrowth5YearCAGRFY Float
OperatingCashFlowPctGrowth3YearCAGRFY Float
AdjustedEBITDAPctGrowth3YearCAGRFY Float
RevenuePctGrowth5YearCAGRFY Float
NetIncomePctGrowthTTM Float
AdjustedEBITDAPctGrowth5YearCAGRFY Float
NetIncomePctGrowthFY Float
EBITPctGrowth5YearCAGRFY Float
OperatingCashFlowPctGrowthFY Float
NetIncomePctGrowth3YearCAGRFY Float
FreeCashFlowPctGrowth3YearCAGRFY Float
OperatingCashFlowPctGrowthTTM Float
EBITPctGrowthFY Float
PriceEarningstoGrowthTTM Float
OperatingProfitPctGrowth3YearCAGRFY Float
Volume Float
Price52WeekHigh Float
AverageVolume Float
Beta5Year Float
PricePreviousClose Float
PricePctChangeYTD Float
PreviousVolume Float
Date52WeekHigh Datetime
Date52WeekLow Datetime
PricePctChange4Week Float
DatePriceClose Datetime
PricePctChange1Day Float
PricePctChange13Week Float
PriceClose Float
DatePreviousClose Datetime
PricePctChange26Week Float
PricePctChange52Week Float
Price52WeekLow Float
Beta3Year Float
Beta1Year Float
PricePctChange1Week Float
EarningsperShareDilutedTTM Float
EarningsperShareBasicFY Float
EnterpriseValueFY Float
AdjustedEPSDilutedPctGrowth3YearCAGRFY Float
EnterpriseValueEBITDAFY Float
DividendsperShareFY Float
EnterpriseValueEBITFY Float
EarningsperShareNormalizedDilutedFQ Float
EarningsperShareBasicTTM Float
TotalEquityFY Float
PriceRevenueFY Float
EarningsperShareDilutedFQ Float
EnterpriseValueEBITTTM Float
PriceEarningsNormalizedTTM Float
EarningsperShareNormalizedDilutedFY Float
ExpectedAnnualDividends Float
PriceBookExclIntangiblesFY Float
PriceRevenueTTM Float
AdjustedEPSDilutedPctGrowthTTM Float
PriceFreeCashFlowTTM Float
DividendsperShareTTM Float
TotalEquityFQ Float
DividendsperShareFQ Float
AdjustedEPSBasic Float
PriceFreeCashFlowFY Float
AdjustedEPSDiluted Float
EarningsperShareNormalizedDilutedTTM Float
EarningsperShareDilutedFY Float
BasicAverageShares Float
AdjustedEPSDilutedPctGrowthFY Float
DilutedAverageShares Float
AdjustedEPSDilutedPctGrowth5YearCAGRFY Float
EarningsperShareBasicFQ Float
EnterpriseValueFQ Float
PriceEarningsNormalizedFY Float
EnterpriseValueEBITDATTM Float
PriceBookExclIntangiblesFQ Float
FreeCashFlowtoEquityPctFY Float
DegreeofOperationalLeverageTTM Float
DebttoAssetsFY Float
TotalDebtFY Float
LongTermCapitalFQ Float
LongTermDebttoTotalCapitalFY Float
BookEquityFQ Float
OperatingCashFlowTTM Float
FreeCashFlowFY Float
FreeCashFlow Float
BookEquityFY Float
OperatingCashFlowFQ Float
TotalDebtFQ Float
DegreeofFinancialLeverageFY Float
DegreeofCombinedLeverage Float
LongTermDebttoTotalCapitalFQ Float
NetDebtFQ Float
NetDebtFY Float
DebttoAssets Float
LongTermCapitalFY Float
OperatingCashFlowFY Float
DegreeofFinancialLeverageTTM Float
AltmanZscoreFY Float
TotalCapitalFQ Float
DegreeofCombinedLeverageFY Float
AltmanZscoreTTM Float
FreeCashFlowFQ Float
LongTermDebttoLongTermCapitalFQ Float
FreeCashFlowTTM Float
DegreeofOperationalLeverage Float
LongTermDebttoLongTermCapitalFY Float
DebttoAssetsFQ Float
TotalCapitalFY Float
FreeCashFlowtoEquityPctTTM Float
DegreeofCombinedLeverageTTM Float
DegreeofFinancialLeverage Float
DegreeofOperationalLeverageFY Float
BookEquity Float
AdjustedEBITPctGrowth5YearCAGRFY Float
FreeCashFlowMarginPctFY Float
NetIncomeperEmployeeTTM Float
ReturnonAssetsPctTTM Float
FreeCashFlowReturnonAssetsPctFY Float
ReturnonEquityPctFY Float
AftertaxMarginPctFY Float
EBITDATTM Float
AdjustedEBITPctGrowthFY Float
RevenueperEmployee Float
AftertaxMarginPctFQ Float
ReturnonEquityPctTTM Float
AdjustedEBITPctGrowthTTM Float
AdjustedNetIncomeFY Float
ReturnonInvestedCapital Float
AdjustedEBITDATTM Float
AdjustedEBITDAFY Float
ReturnonInvestedCapitalPctTTM Float
AdjustedNetIncomePctGrowth5YearCAGRFY Float
AdjustedEBITDAFQ Float
FreeCashFlowReturnonAssetsPctTTM Float
FreeCashFlowMarginPctFQ Float
PretaxMarginPctFY Float
AdjustedNetIncomeFQ Float
RevenueperEmployeeTTM Float
ReturnonEquity Float
FreeCashFlowReturnonAssets Float
AdjustedNetIncomeTTM Float
ReturnonAssets Float
EBITDAFQ Float
AdjustedNetIncomePctGrowthFY Float
AftertaxMarginPctTTM Float
AdjustedNetIncomePctGrowthTTM Float
PretaxMarginPctFQ Float
AdjustedEBITFY Float
EBITDAFY Float
EBITTTM Float
AdjustedEBITPctGrowth3YearCAGRFY Float
FreeCashFlowMarginPctTTM Float
RevenueperEmployeeFY Float
EBITFY Float
PretaxMarginPctTTM Float
AdjustedEBITTTM Float
AdjustedNetIncomePctGrowth3YearCAGRFY Float
ReturnonInvestedCapitalPctFY Float
NetIncomeperEmployeeFY Float
ReturnonAssetsPctFY Float
AdjustedEBITFQ Float
EBITFQ Float
NetOperatingProfitafterTaxTTM Float
TradeCycleDaysFY Float
ReceivablesCollectionPeriodDaysFY Float
TaxRatePctFQ Float
TradeCycleDaysTTM Float
AccountsPayableTurnoverDaysTTM Float
TaxRatePctFY Float
ReceivablesCollectionPeriodDaysTTM Float
NetOperatingProfitafterTaxFY Float
InventoryTurnoverDaysFY Float
AccountsPayableTurnoverDaysFY Float
NetOperatingProfitafterTaxFQ Float
TaxRatePctTTM Float
InventoryTurnoverDaysTTM Float
CashRatioFQ Float
NetWorkingCapitalFQ Float
CashRatioFY Float
CashRatio Float
NetWorkingCapitalFY Float
MarketCapTSO Float
MarketCapDiluted Float
PriceEarningsFY Float
PriceEarningsTTM Float
MarketCapBasic Float
PriceBookFY Float
PriceBookFQ Float
DebttoEquity Float
DebttoEquityFQ Float
DebttoEquityFY Float
OperatingMarginPctFQ Float
OperatingMarginPctFY Float
GrossMarginPctFY Float
GrossMarginPctFQ Float
GrossMarginPctTTM Float
OperatingMarginPctTTM Float
CurrentRatioFY Float
QuickRatioFY Float
CurrentRatioFQ Float
QuickRatioFQ Float
CurrentRatio Float

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
filter String parameter to filter the result set
primarysymbols String parameter to filter the result set by PrimarySymbol
primaryexchanges String parameter to filter the result set by PrimaryExchange
entityids String parameter to filter the result set by entityId
activecompanies String parameter to filter the result set by activecompany
periodenddate String parameter to filter the result set by PeriodEndDate
fiscalperiod String parameter to filter the result set by FiscalPeriod
numperiods String parameter to filter the result set by numperiods
periodoffset String parameter to filter the result set by periodoffset
deleted String parameter to filter the result set by IsDeleted
modifiedsince String parameter to filter the result set by modifiedSince
companynames String parameter to filter the result set by companyname
marketoperators String parameter to filter the result set by MarketOperator
markettiers String parameter to filter the result set by MarketTier

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655