GetFnDataForeign
- get fundamental data for specified symbol

Information / Categories
(AFL 4.20)


SYNTAX GetFnDataForeign( ''field'', ''symbol' )
RETURNS NUMBER or STRING
FUNCTION GetFnDataForeign allows accessing fundamental data from Information window (Window->Symbol Information) for specified (non-current) symbol "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
  • "PointValue" - returns symbols point value
  • "FullName" - returns full name of the symbol
EXAMPLE AddColumn( Foreign( "MSFT", "C") / GetFnDataForeign( "EPS", "MSFT" ) , "MSFT Current P/E ratio" );
AddColumn( Foreign( "MSFT", "C") / GetFnDataForeign( "EPSEstNextYear", "MSFT" ) , "MSFT Est. Next Year P/E ratio" );
Filter =
Status("lastbarinrange");
SEE ALSO GetFnData() function

References:

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

More information:

Updated on-line reference