GetFnData
- get fundamental data

Information / Categories
(AFL 2.90)


SYNTAX GetFnData( ''field'' )
RETURNS NUMBER or STRING
FUNCTION GetFnData allows accessing fundamental data from Information window (Window->Symbol Information) "field" parameter can be one of the following:
  • "EPS"
  • "EPSEstCurrentYear"
  • "EPSEstNextYear"
  • "EPSEstNextQuarter"
  • "PEGRatio"
  • "SharesFloat"
  • "SharesOut"
  • "DividendPayDate"
  • "ExDividendDate"
  • "BookValuePerShare"
  • "DividendPerShare"
  • "ProfitMargin"
  • "OperatingMargin"
  • "OneYearTargetPrice"
  • "ReturnOnAssets"
  • "ReturnOnEquity"
  • "QtrlyRevenueGrowth"
  • "GrossProfitPerShare"
  • "SalesPerShare"
  • "EBITDAPerShare"
  • "QtrlyEarningsGrowth"
  • "InsiderHoldPercent"
  • "InstitutionHoldPercent"
  • "SharesShort"
  • "SharesShortPrevMonth"
  • "ForwardDividendPerShare"
  • "ForwardEPS"
  • "OperatingCashFlow"
  • "LeveredFreeCashFlow"
  • "Beta"
  • "LastSplitRatio"
  • "LastSplitDate"
  • "Alias" (returns symbol alias - string) - 5.50 and above
  • "Address" (returns symbol address - string) - 5.50 and above
  • "Country" (returns symbol country - string) - 5.60 and above
  • "DelistingDate" returns symbol delisting date (as datetime) - 5.70 and above
EXAMPLE AddColumn( Close / GetFnData( "EPS" ) , "Current P/E ratio" );
AddColumn( Close / GetFnData( "EPSEstNextYear" ) , "Est. Next Year P/E ratio" );
Filter = Status("lastbarinrange");
SEE ALSO GetRTData() function , GetRTDataForeign() function

References:

The GetFnData function is used in the following formulas in AFL on-line library:

More information:

Updated on-line reference