“Messtone Devices Enables FS_Global Stock Example: =FS_Latest(“VTSAX”) =FS_Latest(“GOOGL”) =FS_Latest(“OANDA:EUR_SGD”) Symbol.Example: =FS_Streaming(“VTSAX”) =FS_Streaming(“GOOGL”) =FS_Streaming(“VOO”) Lookup Example: =FS_EquityMetrics(“AAPL”,”Messtone Devices Enables FS_Global Stock Example: =FS_Latest(“VTSAX”) =FS_Latest(“GOOGL”) =FS_Latest(“OANDA:EUR_SGD”) Symbol.Example: =FS_Streaming(“VTSAX”) =FS_Streaming(“GOOGL”) =FS_Streaming(“VOO”) Lookup Example: =FS_EquityMetrics(“AAPL”,”net_income”) =FS_EquityMetrics(A1:A20,”revenue”,”FY-3″) =FS_EquityMetrics(“AMZN”,”cash”,”Q”,5) Functions 30 function calls/minute Example: =FS_EquityFullFinancials(“AAPL”, “ic”) =FS_EquityFullFinancials(“GOOGL”, “bs”,”FY-3″) =FS_EquutyFullFinancials(“AMZN”,”cf”,”YTD”,5) FS_EquityCandles Example: =FS_EquityCandles(“AAPL”, “1”,”1631562248″,”09/15/2021″) =FS_EquityCandles(“GOOGL”,”60″,”08/01/2021″,”11/15/2021″,”Open”,”NH”) FS_Dividends Example: =FS_Dividends(“AAPL”,”2019-02-01″,”2020-02-01″) =FS_Dividends(“GOOGL”2015-05-05″,”2021-01-01”) Tick data from US exchanges Example: =FS_EquityTick(“AAPL”,”2020-03-25″,500,10) =FS_EquityTick(“GOOGL”,”2021-08-20″,1000) FS_EtfProfile Example: =FS_EtfProfile(“VOO”) =FS_EtfProfile(“ARKK”)



Leave a comment