JDBC Driver for EdgarOnline

Build 20.0.7655

CoreFinancials_QTR_Ratios

Query from the CoreFinancials-QTR resource.

Columns

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