Detailed pricing plans are not available yet for this tool.
Scroll Finsheet - Stock Price in Excel and Google Sheets Finsheet provides 30+ years of market (intraday 1-min) data, stock fundamentals and much more in Excel and Google Sheets for FREE. documentation create free account Empower the best investment and research teams globally Institutional-grade dataFinsheet provides unparalleled access to highest-quality global equities, forex and cryptos data. The same data is being used by hedge funds, investment banks, and many other financial institutions. No learning curve Our Excel and Google Sheets add-ons are extremely easy to use and requires absolutely no coding. If you know how to use Excel/Google Sheets, you already know how to use our add-on. Simple functions Each asset class (stock, forex, crypto) only has maximum 3 functions to get all the data you may need. Function names are exactly the same between Excel and Google Sheets. Closely monitor the market in real-time Stream Live Market Data Our add-on lets you stream live price data for US stocks, ETFs, mutual funds, cryptos and forex right to Excel. You can always pause streaming when you need to and resume later. create free account Access to Market Data wherever you are Finsheet is available in both Excel (Mac + Windows) and Google Sheets (all browsers) Excel add-on Google Sheets add-on Unmatched data coverage Global Fundamentals & ETF holdings Gain access 30+ years of financial statements, 25+ years of analysts' estimates + EPS/Sales surprises and precomputed financial ratios for 61,000+ global companies. You can choose to export a full financial statement or any particular metric you are interested in. We also have comprehensive historical ETF holdings for global ETFs (data updated daily). Check out Docs Learn from the past to predict the future Historical Market Data (1-minute resolution) We provide 30 years of historical intraday (1-minute) data for US market updated in real-time, 15-minute delayed LSE data and End-of-day tick-level data for international markets. You can also access live and historical data from 10+ forex brokers and 15+ crypto brokers with up to 1-minute resolution. Explore functions Pricing Free trial for 3 days. Cancel anytime. Terms apply. Annual Monthly Save up to 35% with an annual plan Free Enough to get you started, no credit card required $0 /mo US stocks only 3 years of historical price End-of-day data Latest fundamentals only Access to Cryptos and Forex Select Plan Basic If you are a Crypto or Forex trader, this is the plan for you $20 /mo All stocks in 1 region Choose one of these 4 regions: United States Canada & Europe Asia / Pacifics Latin America & Africa 10 years of historical price Access to intra-day data 10 years of fundamentals Access to ETFs (1 region) Select Plan Plus Most Popular Excellent for investors who need global equity data and comprehensive historical data $45 /mo Everything in Basic Global equity and ETFs 20 years of historical data Stream real-time price ETF holdings Select Plan Pro All financial data at your fingertip, perfect for professional investors and traders $90 /mo Everything in Plus 30+ years of historical data Mutual funds data Bonds & Futures data Alternative data Select Plan These prices are for Personal use only and have not included 10% taxes. Contact us for Enterprise pricing. If you are a student/educator, email us for 50% - 100% discounts. Detailed Pricing Free Basic Plus Pro Function call limit 500 / day 500 / min 600 / min 700 / min Asset class Equity US stocks 1 region Global Global ETF ETF holdings function is only available for Plus and Pro members. 1 region Global Global Crypto & Forex Mutual Funds & Bonds Data coverage Historical price (end-of-day) 3 years 10 years 20 years All Historical price (intra-day) 1 year 5 years 10 years Historical price resolution End-of-day Intra-day (5-min) Intra-day (1-min) Intra-day (1-min) Stock fundamental Latest 10 years 20 years All Analyst estimates Latest 10 years 20 years All ETF holdings 10 periods 100 periods Real-time Snapshot of real-time price Stream real-time price Technical analysis Pattern recognition Support/Resistance Aggregate indicators Technical indicators Alternative data Earnings Calendar Company ESG Earnings quality score Institutional Portfolios See more See less Abstract Logo Vectors by Vecteezy --- ☰×Register your FREE accountSearch our doc...Ctrl+FINTRODUCTIONIntroductionAuthenticationINSTALLATIONExcel installationGoogle Sheets installationUSAGEUsage GuideREAL-TIMEFS_LatestFS_StreamingEQUITYStock LookupMetric LookupFS_EquityMetricsFS_EquityFullFinancialsFS_EquityCandlesFS_RevenueBreakdownFS_HistoricalMarketCapFS_DividendsFS_EquityTickETFMUTUAL FUNDBONDCRYPTOFOREXTECHNICAL ANALYSISALTERNATIVE DATAIntroductionThis document explains how you can install and use our Excel/Google Sheets add-on to retrieve market data and fundmanentals. We cover stocks, cryptos, forex, global ETFs and mutual funds. AuthenticationWithin Excel/Google Sheets, from the right sidebar of our add-on, you will need to login using your Finsheet email and password before you can use the add-on. If you don't have an account yet, you can register a FREE account here.Excel installationOpen an Excel fileIn the "Home" tab, click "Add-ins" Search for WA200003886 (our add-on's ID) and install our add-onFrom the menu bar, click "Show sidebar"Login using your Finsheet account.Restart Excel and you can begin using our add-onNote: Our add-on works best with Excel 365. Note: If you encounter the error "Error loading Add-Ins", try signing out of Excel by Mac: click Excel (near top left corner) >> Sign Out...Window: click your account name (near top right corner) >> Sign Out...then restart Excel, sign in again and install our add-on again.Google Sheets installationClick here and follow the instructions to install our add-onOpen a Google Sheets file From the menu bar click "Extensions" >> "Stock Price in Google Sheets | Finsheet" >> "Start add-on / Show sidebar"Login using your Finsheet accountYou are now all set and can begin using our add-onNote: You will need to do step 3 everytime you open a new spreadsheet. Note: If you encounter an error when installing, it is likely that you have multiple Google accounts logged in. Solution: open an incognito window, log in just 1 account and install our add-on, then go back to your original window to use the add-on.If Google Sheets keeps returning "Please login using the sidebar" after you already sign in from the sidebar, it is likely you are using our add-on with a secondary Google account in your browser. Solution: switch to your main Google account. Switch to Chrome if the problem persists.Usage GuideClick here to view the usage guide and tips. Most important tip: Avoid using NOW() and TODAY()FS_LatestGet the most current price of any global stock, crypto, forex, etf or mutual fund. To get the most current price automatically updated in real-time, use FS_Streaming instead.Examples:=FS_Latest("VTSAX")=FS_Latest("GOOGL")=FS_Latest("OANDA:EUR_SGD")Arguments:symbolREQUIREDSymbol (any stock, crypto, forex, etf or mutual fund symbol).Sample 1ƒx=FS_Latest("AAPL")ABC1170.252Sample 2ƒx=FS_Latest("BINANCE:ETHBTC")ABC10.0732Sample 3ƒx=FS_Latest("VOO")ABC1412.522FS_StreamingStream real-time price for any US stock, crypto, forex, ETF and mutual fund. If you just need a snapshot of the most current price, use FS_Latest insteadNote: This function is only available for Plus and Pro members. This function is only available in Excel.This function will not return any results for stocks, ETFs and mutual funds if run outside market hours.You can stream up to 300 unique symbols at a time. Examples:=FS_Streaming("VTSAX")=FS_Streaming("GOOGL")=FS_Streaming("VOO")Arguments:symbolREQUIREDSymbol (any stock, crypto, forex, etf or mutual fund symbol).Sample 1ƒx=FS_Streaming("BINANCE:SHIBEUR")ABC10.00002792Sample 2ƒx=FS_Streaming("BINANCE:ETHBTC")ABC10.0688312Sample 3ƒx=FS_Streaming("OANDA:EUR_SGD")ABC11.527512Stock LookupLook up all available stocks. Click here to see the full list of supported stock symbols.Metric LookupLook up all available metrics. Click here to see the full list of supported metrics. These metrics are to be used with FS_EquityMetrics.Balance SheetIncome StatementCash FlowValuationGrowthRiskEfficiencyForecast / Wall St estimatesProfileBook Value Per ShareAccounts PayableAccounts Receivable - Trade, NetAccrued ExpensesAccumulated Depreciation, TotalAdditional Paid-In CapitalCashCash and Short Term InvestmentsCash & EquivalentsCommon Stock, TotalDeferred Income TaxGoodwill, NetIntangibles, NetLong Term DebtLong Term InvestmentsNotes Payable/Short Term DebtOther Current Assets, TotalOther Current Liabilities, TotalOther Equity, TotalOther Liabilities, TotalOther Long Term Assets, TotalOther ReceivablesPrepaid ExpensesProperty/Plant/Equipment, Total - GrossProperty/Plant/Equipment, Total - NetRetained EarningsShort Term InvestmentsTangible Book Value per ShareTotal AssetsTotal Current AssetsTotal Current LiabilitiesTotal DebtTotal EquityTotal InventoryTotal LiabilitiesTotal Liabilities & Shareholders EquityTotal Long Term DebtTotal Receivables, NetCash Per ShareNet DebtMinority InterestCurrent Port. of LT Debt/Capital LeasesUnrealized Gain (Loss)Preferred Stock - Non Redeemable, NetTreasury Stock - CommonNote Receivable - Long TermTotal Preferred Shares OutstandingCash & Due from BanksNet LoansOther Assets, TotalOther Earning Assets, TotalPayable/AccruedTotal DepositsTotal Short Term BorrowingsRedeemable Preferred Stock, TotalOther Bearing Liabilities, TotalDeferred Policy Acquisition CostsPolicy LiabilitiesInsurance ReceivablesTotal Utility Plant, NetFormal Name: Code Name: Periods Available: Default Period: Unit: Millions Examples of Custom PeriodsFS_EquityMetricsGet any financial metric (fundamentals, analyst estimates, key financial ratios) of a company. The list of supported metrics is in the Metric Lookup section. Optionally you can specify the period to get the value at a specific time and/or specify the limit to return data for more than 1 period.Examples:=FS_EquityMetrics("AAPL", "net_income")=FS_EquityMetrics(A1:A20, "revenue", "FY-3")=FS_EquityMetrics("AMZN", "cash", "Q", 5)Arguments:symbolREQUIREDStock symbol(s). This can be a symbol or reference to an array of symbols. If more than 1 symbols are supplied, leave "limit" blank. Free users can request up 10 symbols at a time. Paid users can request up 100 symbols at a time. When possible, always use an array of symbols instead of making individual calls for each ticker. This will speed up the functions and avoid running into your plan's request limit.metricREQUIREDMetric code name.periodoptionalPeriod. Choose among the supported periods and their variants if the metric supports periods. If none is provided, the default period is used.limitoptionalThe number of periods to return data. If none is provided, limit is set to 1. If a custom period such as "TTM-2" and "FY2019.Q3" is used, limit will be ignored.optionsoptionalInclude "NH" to omit the header date row. Include "H" to always show the header date row.Note: By default, the header date is omitted when limit is 1 or a custom period is provided.By default, the header date is displayed when limit is > 1 and no custom period is provided.The header date will not be displayed if more than 1 stock symbol is provided.Sample 1ƒx=FS_EquityMetrics(A1:A3, "cost_of_rev", "FY-3")ABC1AAPL1637562GOOGL595493AMZN139156Sample 2ƒx=FS_EquityMetrics("AAPL", "revenue", "TTM", 3)ABC12019-09-282020-09-262021-09-2522601742745153658173Sample 3ƒx=FS_EquityMetrics("AAPL", "eps_proj_avg", "FY+3")ABC15.98596723FS_EquityFullFinancialsGet standardized balance sheet, income statement and cash flow for global companies going back 30+ yearsNote: This function is not available for Free members. The rate limit for this function is 30 function calls/ minute.Examples:=FS_EquityFullFinancials("AAPL", "ic")=FS_EquityFullFinancials("GOOGL", "bs", "FY-3")=FS_EquityFullFinancials("AMZN", "cf", "YTD", 5)Arguments:symbolREQUIREDStock Symbol.statementREQUIREDStatement can be 1 of these bs, ic, cf for Balance Sheet, Income Statement, Cash Flow respectively.periodoptionalPeriod can be 1 of these TTM, FY, Q, YTD and their variants. TTM (Trailing Twelve Months) option is available for Income Statement and Cash Flow. YTD (Year To Date) option is only available for Cash Flow. If none is provided, Q is used if statement is "bs" otherwise TTM will be used.limitoptionalThe number of periods to return data. If none is provided, limit is set to 1. If a custom period such as "TTM-2" and "FY2019.Q3" is used, limit will be ignored.Sample ƒx=FS_EquityFullFinancials("AAPL", "ic", "TTM", 3)ABCD12019-09-282020-09-262021-09-252Revenue2601742745153658173Total Revenue2601742745153658174Cost of Revenue, Total1617821695592129815Gross Profit983921049561528366SG&A Expense1824519916219737Research & Development1621718752219148Total Operating Expense3446238668438879Operating Income639306628810894910Net Income Before Taxes657376709110920711Provision for Income Taxes1048196801452712Net Income After Taxes552565741194680FS_EquityCandlesGet historical candlestick data for stocks. Daily data will be adjusted for Splits. Intraday data will remain unadjusted.Examples:=FS_EquityCandles("AAPL", "1", "1631562248", "09/15/2021")=FS_EquityCandles("GOOGL", "60", "08/01/2021", "11/15/2021", "Open", "NH")Arguments:symbolREQUIREDStock Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange. Only resolutions D, W, M are available for Free members. Check out this section for specific restrictions for each plan.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default, all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_EquityCandles( "AAPL" , "D" , "1630987200" , "09/15/2021")ABCDEF1PeriodCloseOpenHighLowVolume21630987200156.69154.97157.26154.398227826131631073600155.11156.98157.04153.9757442020741631160000154.07155.49156.11153.955730573051631246400148.97155155.48148.714089323561631505600149.55150.63151.42148.7510240432971631592000148.12150.35151.07146.9110929629581631678400149.03148.56149.44146.3783281315FS_RevenueBreakdownGet revenue breakdown for global companies.Note: This function is only available for Plus and Pro members.Examples:=FS_RevenueBreakdown("WMT", "product")=FS_RevenueBreakdown("GOOGL", "geography", "annual", 3)Arguments:symbolREQUIREDStock Symbol.categoryREQUIREDCategory ("product" or "geography").freqoptionalFrequency ("annual" or "quarterly"). Default is "annual".limitoptionalNumber of periods to returned. If empty, function will return all periods.Response Attributes:ResultResult as a matrix (rows are components, columns are period, unit is millions).Sample ƒx=FS_RevenueBreakdown("GOOGL", "geography", "annual", 3)ABCD12022-12-312023-12-312024-12-312United States1348141462861704473EMEA82062910381021274APAC4702451514568155Other Americas169761832020418FS_HistoricalMarketCapGet daily historical market cap data for global companies.Note: This function is only available for Plus and Pro members.Examples:=FS_HistoricalMarketCap("AAPL", "2024-01-01", "2024-03-01")=FS_HistoricalMarketCap("GOOGL", "2024-06-20", "2024-07-28")Arguments:symbolREQUIREDStock Symbol.fromREQUIREDFrom date YYYY-MM-DD.toREQUIREDTo date YYYY-MM-DD.Response Attributes:DateDate.MarketCapMarket Capitalization on that date in millions.Sample ƒx=FS_HistoricalMarketCap("AAPL", "2024-01-01", "2024-03-01")AB1DateMarketCap22024-01-012994371.232024-01-022870346.242024-01-032848854.252024-01-042812673.5FS_DividendsGet dividends data for common stocks going back 30 years.Examples:=FS_Dividends("AAPL", "2019-02-01", "2020-02-01")=FS_Dividends("GOOGL", "2015-05-05", "2021-01-01")Arguments:symbolREQUIREDStock Symbol.fromREQUIREDFrom (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalTo (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "currency&payDate&&amount"). By default, all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. You can also chain them together "-NH".Response Attributes:adjustedAmountAdjusted dividends.amountAmount in local currency.currencyCurrency.dateEx-Dividend date.declarationDateDeclaration date.payDatePay date.recordDateRecord date.Sample ƒx=FS_Dividends( "AAPL" , "2019-02-01" , "2020-02-01")ABCD1declarationDatepayDateamountadjustedAmount22019-10-302019-11-140.770.7732019-07-302019-08-150.770.7742019-05-012019-05-160.770.77FS_EquityTickGet historical tick data for US exchanges. The data is delayed 15 minute.Note: This function is only available for Pro members.Examples:=FS_EquityTick("AAPL", "2020-03-25", 500, 10)=FS_EquityTick("GOOGL", "2021-08-20", 1000)Arguments:symbolREQUIREDStock Symbol.dateREQUIREDDate (can be string of date, string of UNIX timestamp or reference to a date cell). This date needs to be within the last 10 years.limitREQUIREDLimit number of ticks returned. Maximum value is 25000skipoptionalNumber of ticks to skip. Use this parameter to loop through the entire data. If none is specified it is set to 0.optionsoptionalInclude "CT" to convert Timestamp column from Unix timestamp to your local timezone.Response Attributes:CountNumber of ticks returned. If count < limit, all data for that date has been returned.TotalTotal number of ticks for that date.Venue/ExchangeThe venue/exchange that facilitated the trade.TimestampTimestamp of the trade.PricePrice data.VolumeVolume.Trade conditionA comprehensive list of trade conditions code can be found here.Sample ƒx=FS_EquityTick("AAPL", "2020-03-25", 500, 10)ABCDE1Count3Total32Venue / ExchangeTimestampPriceVolumeTrade conditions3Nasdaq OMX PSX, Inc. LLC1631208040155.11744202071,244Nasdaq OMX PSX, Inc. LLC1631212922154.07573057301,24,125Nasdaq OMX PSX, Inc. LLC1631214803148.971408932351,24,12ETF LookupLook up all available ETFs. Click here to view the full list of supported ETF symbols.FS_EtfProfileGet ETF's profile.Note: This function is not available for Free members.Examples:=FS_EtfProfile("VOO")=FS_EtfProfile("ARKK")Arguments:symbolREQUIREDETF symbol.Response Attributes:SymbolETF symbol.Asset ClassAsset class.AUMAssets under management.Avg Volume30-day average volume.CUSIPCUSIP.DescriptionDescription.DomicileDomicile.ETF IssuerETF issuer.Expense RatioExpense ratio.Inception DateInception date of the ETF.Investment SegmentInvestment segment.ISINISIN.NameETF full name.NAVNet asset value.NAV CurrencyCurrency of net asset value.P/BPrice to Book ratio.P/EPrice to Earnings ratio.Tracking IndexTracking index.WebsiteWebsite.Sample ƒx=FS_EtfProfile("SPY")AB1SymbolSPY2Asset ClassEquity3Avg Volume912212604CUSIP78462F1035DescriptionSPY was created on 1993-01-22 by SPDR...6DomicileUS7ETF IssuerSPDR8Expense Ratio0.09459Inception Date1993-01-2210Investment SegmentLarge Cap11ISINUS78462F103012NameSPDR S&P 500 ETF Trust13P/B4.33048114P/E22.0609315Tracking IndexS&P 500FS_EtfCandlesGet historical candlestick data for ETFs. Click here to view the full list of supported ETF symbols.Note: This function is not available for Free members.Examples:=FS_EtfCandles("VOO", "1", "1631562248", "09/15/2021")=FS_EtfCandles("ARKK", "60", "08/01/2021", "11/15/2021")Arguments:symbolREQUIREDETF Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_EtfCandles( "SPY" , "D" , "1630987200" , "09/15/2021")ABCDEF1PeriodCloseOpenHighLowVolume21630987200451.46452.71452.81450.74235167153431631073600450.91450.89451.67448.865618190741631160000448.98450.7452.57448.725797040751631246400445.44451.04451.49445.318994817461631505600446.58448.64448.92444.118373864971631592000444.17448.12448.34443.227819714081631678400447.88444.62448.41443.4478792222FS_EtfHoldingsGet ETF's holdings.Note: This function is only available for Plus and Pro members.Examples:=FS_EtfHoldings("VOO")=FS_EtfHoldings("ARKK", 2)Arguments:symbolREQUIREDETF symbol.skipoptionalSkip the first n results. You can use this parameter to query historical constituents data. The latest result is returned if skip=0 or not set. Plus can set skip up to 10 while Pro can set skip up to 100.Sample ƒx=FS_EtfHoldings("SPY")ABCDEF1Date2020-12-112SymbolCUSIPISINNamePercentShare3AAPL037833100US0378331Apple Inc6.46171676927094MSFT594918104US5949181Microsoft Corp5.299789348865...Mutual Fund LookupLook up all available mutual funds. Click here to view the full list of supported Mutual Fund symbols.FS_MutualFundProfileGet mutual fund's profile.Note: This function is only available for Pro members.Examples:=FS_MutualFundProfile("VTSAX")=FS_MutualFundProfile("FNILX")Arguments:symbolREQUIREDMutual fund symbol.Response Attributes:SymbolMutual fund symbol.NameFund full name.BenchmarkIndex Benchmark.BetaBeta.DescriptionDescription.Expense RatioAnnual expense Ratio.Fund FamilyFund family.Inception DateFund inception date.Investment SegmentInvestment segment.TurnoverTurnover.Sample ƒx=FS_MutualFundProfile("VTSAX")AB1SymbolVTSAX2BenchmarkCRSP US Total Stock Market TR3Beta1.054CategoryMulti-Cap Core5DescriptionVTSAX was founded on 2000-11-13 ...6Expense Ratio0.047Fund FamilyVANGUARD ADMIRAL8Inception Date2000-11-139Investment SegmentGrowth & Income10Full NameVanguard Index Funds: Vanguard Total Stock Market Index Fund; Admiral Class Shares11Total NAV28075800000012Turnover8FS_MutualFundCandlesGet historical candlestick data for Mutual Funds. Click here to view the full list of supported Mutual Fund symbols. Note: This function is only available for Pro members.Examples:=FS_MutualFundCandles("VTSAX", "1", "1631562248", "09/15/2021")=FS_MutualFundCandles("FNILX", "60", "08/01/2021", "11/15/2021")Arguments:symbolREQUIREDMutual Fund Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_MutualFundCandles( "VTSAX" , "D" , "1630987200" , "09/15/2021")ABCDE1PeriodCloseOpenHighLow21630987200113.54113.54113.54113.5431631073600113.24113.24113.24113.2441631160000112.83112.83112.83112.8351631246400111.95111.95111.95111.9561631505600112.18112.18112.18112.1871631592000111.48111.48111.48111.48FS_MutualFundHoldingsGet Mutual Fund's holdings.Note: This function is only available for Pro members.Examples:=FS_MutualFundHoldings("VTSAX")=FS_MutualFundHoldings("VWIAX", 2)Arguments:symbolREQUIREDMutual Fund symbol.skipoptionalSkip the first n results. You can use this parameter to query historical constituents data. The latest result is returned if skip=0 or not set.Sample ƒx=FS_MutualFundHoldings("VTSAX")ABCDEF1Date2020-12-312SymbolCUSIPISINNamePercentShare3778669200US7786692Rotech Healthcare0.7565119162764DEN24790A101US24790A1Denbury Inc Ordinary Shares - Ne0.3430824018055...FS_BondCandlesGet end-of-day bond's price data. The following datasets are supported: Exchange Segment US Government Bonds Government Bonds FINRA Trace BTDS: US Corporate Bonds FINRA Trace 144A Bonds Note: This function is only available for Pro members.Examples:=FS_BondCandles("US912810TD00", "1661427736", "09/01/2022")=FS_BondCandles("US912810TD00", "08/15/2022")Arguments:isinREQUIREDISIN of bond.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedoptionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps.CloseList of end-of-day close prices.Sample ƒx=FS_BondCandles("US912810TD00" , "1661427736" , "09/01/2022")AB1PeriodClose2163098720097.693163107360098.114163116000098.075163124640098.976163150560096.557163159200097.128163167840098.03FS_BondTickGet trade-level data for bonds. The following datasets are supported: Exchange Segment Delay FINRA Trace BTDS: US Corporate Bonds Delayed 4h FINRA Trace 144A Bonds Delayed 4h Note: This function is only available for Pro members.Examples:=FS_BondTick("US693475BF18", "2022-08-19")=FS_BondTick("US693475BF18", "2022-12-15", 10)Arguments:isinREQUIREDISIN of bond.dateREQUIREDDate (can be string of date, string of UNIX timestamp or reference to a date cell) limitoptionalLimit number of ticks returned. If empty, all ticks of that date will be returnedoptionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps.PriceList of price data.VolumeList of volume data.SideTrade side of the reporting party (dealer).Sample ƒx=FS_BondTick("US693475BF18", "2022-10-15", 7)ABCD1PeriodPriceVolumeSide2163171440097.69829Buy3163171800098.119283Buy4163172160098.07232Sell5163172970098.97828Sell6163172982096.552890Buy7163173258597.122920Sell8163173613298.03124BuyCrypto LookupClick here to view the full list of supported crypto symbolsFS_CryptoProfileGet crypto's profile.Examples:=FS_CryptoProfile("BTC")=FS_CryptoProfile("ETH")Arguments:symbolREQUIREDCrypto symbol such as BTC or ETH.Response Attributes:NameCrypto name.Full NameCrypto full name.DescriptionDescription.Market CapitalizationMarket capitalization of the asset.Total SupplyTotal supply of the asset.Max SupplyMaximum supply of the asset.Circulating SupplyCurrent circulating supply of the asset.Launch DateLaunch date.WebsiteWebsite.Proof TypeProof type of the asset.Sample ƒx=FS_CryptoProfile("BTC")AB1NameBitcoin2Full NameBitcoin (BTC)3DescriptionBitcoin uses peer-to-peer technology to operate ...4Market Capitalization7845230502975Total Supply189491936Max Supply210000007Circulating Supply189491938Launch Date2009-01-039Websitebitcoin.org/en/10Proof TypePoWFS_CryptoCandlesGet historical candlestick data for cryptocurrencies. Click here to view the full list of supported crypto symbols.Examples:=FS_CryptoCandles("POLONIEX:BTC_ETH", "1", "1631562248", "09/15/2021")=FS_CryptoCandles("BINANCE:ETHBTC", "60", "08/01/2021", "08/15/2021")Arguments:symbolREQUIREDCrypto Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange. Only resolutions D, W, M are available for Free members.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default, all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_CryptoCandles( "BINANCE:ETHBTC" , "D" , "1630987200" , "09/15/2021")ABCDEF1PeriodCloseOpenHighLowVolume216309872000.0759690.0732730.0763730.072158161034316310736000.0738190.0759690.0766570.073694121819416311600000.071550.0738250.0747640.070872105531516312464000.0723310.0715560.0731640.07149268656616313328000.0739760.072330.0752510.07204785844716314192000.0731020.0739720.0741250.0713121772816315056000.0729050.0731020.0737140.07159386251916315920000.0750920.0729060.0750990.071662116676Forex LookupClick here to view the full list of supported forex and metal symbols.FS_ForexAllRatesGet rates for all forex pairs.Examples:=FS_ForexAllRates("USD")Arguments:base_currencyREQUIREDBase currency.Sample ƒx=FS_ForexAllRates("USD")AB1AED3.9680122AFN82.3733083CAD1.5253684CZK27.0967375DJF191.9913446DZD139.3840217ETB36.2967678EUR0.919GBP0.87484110JPY114.58354811MDL19.12025112MGA4105.15677613USD1FS_ForexCandlesGet historical candlestick data for forex symbols. Click here to view the full list of supported forex symbols.Examples:=FS_ForexCandles("OANDA:AUD_SGD", "1", "1631562248", "09/15/2021")=FS_ForexCandles("FXCM:EUR/NZD", "60", "08/01/2021", "08/15/2021")Arguments:symbolREQUIREDForex Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange. Only resolutions D, W, M are available for Free members.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default, all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_ForexCandles( "OANDA:GBP_JPY" , "D" , "1630987200" , "09/15/2021")ABCDEF1PeriodCloseOpenHighLowVolume21630987200151.952151.904152.213151.4894016731631073600151.83151.937152.084151.4524037841631160000151.795151.782152.16151.4154213251631246400152.005151.726152.629151.7213522761631505600152.219152.039152.317151.893487571631592000151.421152.148152.84151.324355681631678400151.328151.399151.551150.81843031FS_PatternRecognitionRun pattern recognition algorithm on a symbol. Support double top/bottom, triple top/bottom, head and shoulders, triangle, wedge, channel, flag, and candlestick patterns.Note: This function is only available for Plus and Pro members.Examples:=FS_PatternRecognition("MSFT", "D")=FS_PatternRecognition("BINANCE:BTCUSDT", "60")Arguments:symbolREQUIREDSymbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.Response Attributes:PatternsPatterns and their attributes.Sample ƒx=FS_PatternRecognition("AAPL", "D")ABCD1Pattern NameDouble TopPattern NameHead & Shoulders2Aprice182.13Aprice182.133Atime1639353600Atime16393536004Bprice167.46Bprice167.465Btime1639958400Btime16399584006Cprice182.94Cprice182.947Ctime1641254400Ctime16412544008Dprice0Dprice168.179Dtime0Dtime164177280010End_price167.46End_price168.474211End_time1642550400End_time164255040012Entry167.46Entry168.474313Eprice0Eprice177.1814Etime0Etime164194560015Mature0Mature016PatterntypebearishPatterntypebearish17Profit1151.98Profit1152.460618Profit20Profit2019SortTime1642550400SortTime164255040020Start_price167.46Start_price166.9521Start_time1638748800Start_time163874880022StatuscompleteStatuscomplete23Stoploss184.488Stoploss184.48824Terminal0Terminal0FS_SupportResistanceGet support and resistance levels for a symbol..Note: This function is only available for Plus and Pro members.Examples:=FS_SupportResistance("VOO", "D")=FS_SupportResistance("OANDA:EUR_USD", "60")Arguments:symbolREQUIREDSymbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.Response Attributes:LevelsArray of support and resistance levels.Sample ƒx=FS_SupportResistance("AAPL", "D")ABCD1125.94142.53157.8182.9423FS_AggregateIndicatorsGet aggregate signal of multiple technical indicators such as MACD, RSI, Moving Average, etc...Note: This function is only available for Plus and Pro members.Examples:=FS_AggregateIndicators("TSCO.L", "D")=FS_AggregateIndicators("BINANCE:BTCUSDT", "10")Arguments:symbolREQUIREDSymbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.Response Attributes:BuyNumber of buy signals.NeutralNumber of neutral signals.SellNumber of sell signals.SignalAggregate signal.AdxAdx reading.TrendingWhether market is trending or going sideway.Sample ƒx=FS_AggregateIndicators("VOO", "D")AB1Buy22Neutral83Sell54Aggregate signalneutral5ADX reading28.3436TrendingtrueFS_TechnicalIndicators Return technical indicator with price data. List of supported indicators can be found here.Note: This function is only available for Plus and Pro members.Examples:=FS_TechnicalIndicators("OANDA:AUD_SGD", "D", "macd" ,"1631022248", "09/15/2021")=FS_TechnicalIndicators("AAPL", "60", "sma", "08/01/2021", "08/15/2021", {"timeperiod", 3; "seriestype", "c"})Arguments:symbolREQUIREDForex Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.indicatorREQUIREDIndicator code name. Click here for the full list of supported indicators.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedparametersoptionalList of all parameters and their value (use , to separate a parameter from its value, use ; to separate parameters). Click here to see which indicators and parameters are supported.Sample ƒx=FS_TechnicalIndicators( "AAPL" , "D" , "sma" , "1631022248" , "09/15/2021" , {"timeperiod", 3; "seriestype", "c"})ABCDEF1PeriodCloseSmaOpenHighLow21630987200156.690154.97157.26154.3931631073600155.110156.98157.04153.97541631160000154.07155.29155.49156.11153.9551631246400148.97152.71155155.48148.761631505600149.55150.86150.63151.42148.7571631592000148.12148.88150.35151.07146.9181631678400149.03148.89148.56149.44146.37FS_EarningsCalendarGet historical and coming earnings release. EPS and Revenue in this endpoint are non-GAAP, which means they are adjusted to exclude some one-time or unusual items. This is the same data investors usually react to and talked about on the media. Estimates are sourced from both sell-side and buy-side analysts.Note: This function is only available for Plus and Pro members.Examples:=FS_EarningsCalendar("2022-10-01", "2022-10-10", , "true")=FS_EarningsCalendar("2022-10-01", "2022-10-10", "GOOGL")Arguments:fromoptionalFrom date (can be string of date, string of UNIX timestamp or reference to a date cell).tooptionalTo date (can be string of date, string of UNIX timestamp or reference to a date cell).symboloptionalFilter by stock symbolinternationaloptionalSet to "true" to include international markets. Default value is "false".optionsoptionalSet to "NH" to omit the header row.Response Attributes:DateDate of earnings call.HourHour of earnings call.SymbolStock symbol.Revenue ActualRevenue Actual.Revenue EstimateRevenue Estimate.EPS ActualEPS Actual.EPS EstimateEPS Estimate.Reporting PeriodReporting Period.Sample ƒx=FS_EarningsCalendar("2022-10-01", "2022-10-10")ABCDEF1DateSymbolRev EstRev ActEPS EstEPS Act22022-10-01AAPL88496400918190004.54744.9932022-10-02GOOGL64040000629851613.032.839442022-10-03AMZN75040000760400006.2326.452FS_InstitutionalPortfoliosGet latest holdings of gurus/institutions. The list of supported gurus/institutions can be found here. Examples:=FS_InstitutionalPortfolios("Warren Buffett")=FS_InstitutionalPortfolios("Bill Gates")Arguments:guruREQUIREDGuru/institution name.Sample ƒx=FS_InstitutionalPortfolios("Warren Buffett")ABC1AAPL2BAC3KO4C5CVX6AXP7HPQFS_ESGGet ESG scores and important indicators for 1000+ global companies. Our ESG scoring models takes into account more than 150 different inputs to calculate the level of ESG risks and how well a company is managing them. A higher score means lower ESG risk or better ESG management. ESG scores are in the the range of 0-100. Some key indicators might contain letter-grade score from C- to A+ with C- is the lowest score and A+ is the highest score.Note: This function is only available for Pro members.Examples:=FS_ESG("AAPL")=FS_ESG("GOOGL")Arguments:symbolREQUIREDStock symbol.Sample ƒx=FS_ESG("SPY")AB1Total Woman Percentage342Weaponsfalse3White Employee Percentage474White Management Percentage595Women Management Percentage17.026Hispanic Latino Employee Percentage147Environment Score73.218Governance Score56.069Social Score45.8110Total ESG Score56.04FS_EarningsQualityGets Earnings Quality Score for global companies. Earnings quality refers to the extent to which current earnings predict future earnings. "High-quality" earnings are expected to persist, while "low-quality" earnings do not. A higher score means a higher earnings qualityWe source this data from Finnhub who uses a proprietary model which takes into consideration 4 criteria: Profitability, Growth, Cash Generation & Capital Allocation, Leverage. All metrics of each company in each category are then compared against its peers in the same industry to gauge how quality its earnings is. Note: This function is only available for Pro members.Examples:=FS_EarningsQuality("AAPL", "annual")=FS_EarningsQuality("GOOGL", "quarterly", 5)Arguments:symbolREQUIREDStock symbol.freqREQUIREDFrequency can be either annual or quarterly.limitoptionalNumber of periods to return data. If none is provided, all periods will be returnedResponse Attributes:Cash Generation Capital AllocationCash Generation Capital Allocation score.GrowthGrowth score.LeverageLeverage score.ProfitabilityProfitability score.ScoreTotal score.Letter ScoreLetter score.Sample ƒx=FS_EarningsQuality("AAPL", "annual", 2)ABC12020-09-262021-09-252Cash Generation Capital Allocation47.6405151.0217673Growth69.9838681.562154Leverage33.70809659.5607835Profitability1001006Score62.83311573.036177Letter ScoreA-A Abstract Logo Vectors by Vecteezy --- Finsheet.io Don't have an account yet? Forgot your password? --- ☰×Register your FREE accountSearch our doc...Ctrl+FINTRODUCTIONIntroductionAuthenticationINSTALLATIONExcel installationGoogle Sheets installationUSAGEUsage GuideREAL-TIMEFS_LatestFS_StreamingEQUITYStock LookupMetric LookupFS_EquityMetricsFS_EquityFullFinancialsFS_EquityCandlesFS_RevenueBreakdownFS_HistoricalMarketCapFS_DividendsFS_EquityTickETFMUTUAL FUNDBONDCRYPTOFOREXTECHNICAL ANALYSISALTERNATIVE DATAIntroductionThis document explains how you can install and use our Excel/Google Sheets add-on to retrieve market data and fundmanentals. We cover stocks, cryptos, forex, global ETFs and mutual funds. AuthenticationWithin Excel/Google Sheets, from the right sidebar of our add-on, you will need to login using your Finsheet email and password before you can use the add-on. If you don't have an account yet, you can register a FREE account here.Excel installationOpen an Excel fileIn the "Home" tab, click "Add-ins" Search for WA200003886 (our add-on's ID) and install our add-onFrom the menu bar, click "Show sidebar"Login using your Finsheet account.Restart Excel and you can begin using our add-onNote: Our add-on works best with Excel 365. Note: If you encounter the error "Error loading Add-Ins", try signing out of Excel by Mac: click Excel (near top left corner) >> Sign Out...Window: click your account name (near top right corner) >> Sign Out...then restart Excel, sign in again and install our add-on again.Google Sheets installationClick here and follow the instructions to install our add-onOpen a Google Sheets file From the menu bar click "Extensions" >> "Stock Price in Google Sheets | Finsheet" >> "Start add-on / Show sidebar"Login using your Finsheet accountYou are now all set and can begin using our add-onNote: You will need to do step 3 everytime you open a new spreadsheet. Note: If you encounter an error when installing, it is likely that you have multiple Google accounts logged in. Solution: open an incognito window, log in just 1 account and install our add-on, then go back to your original window to use the add-on.If Google Sheets keeps returning "Please login using the sidebar" after you already sign in from the sidebar, it is likely you are using our add-on with a secondary Google account in your browser. Solution: switch to your main Google account. Switch to Chrome if the problem persists.Usage GuideClick here to view the usage guide and tips. Most important tip: Avoid using NOW() and TODAY()FS_LatestGet the most current price of any global stock, crypto, forex, etf or mutual fund. To get the most current price automatically updated in real-time, use FS_Streaming instead.Examples:=FS_Latest("VTSAX")=FS_Latest("GOOGL")=FS_Latest("OANDA:EUR_SGD")Arguments:symbolREQUIREDSymbol (any stock, crypto, forex, etf or mutual fund symbol).Sample 1ƒx=FS_Latest("AAPL")ABC1170.252Sample 2ƒx=FS_Latest("BINANCE:ETHBTC")ABC10.0732Sample 3ƒx=FS_Latest("VOO")ABC1412.522FS_StreamingStream real-time price for any US stock, crypto, forex, ETF and mutual fund. If you just need a snapshot of the most current price, use FS_Latest insteadNote: This function is only available for Plus and Pro members. This function is only available in Excel.This function will not return any results for stocks, ETFs and mutual funds if run outside market hours.You can stream up to 300 unique symbols at a time. Examples:=FS_Streaming("VTSAX")=FS_Streaming("GOOGL")=FS_Streaming("VOO")Arguments:symbolREQUIREDSymbol (any stock, crypto, forex, etf or mutual fund symbol).Sample 1ƒx=FS_Streaming("BINANCE:SHIBEUR")ABC10.00002792Sample 2ƒx=FS_Streaming("BINANCE:ETHBTC")ABC10.0688312Sample 3ƒx=FS_Streaming("OANDA:EUR_SGD")ABC11.527512Stock LookupLook up all available stocks. Click here to see the full list of supported stock symbols.Metric LookupLook up all available metrics. Click here to see the full list of supported metrics. These metrics are to be used with FS_EquityMetrics.Balance SheetIncome StatementCash FlowValuationGrowthRiskEfficiencyForecast / Wall St estimatesProfileBook Value Per ShareAccounts PayableAccounts Receivable - Trade, NetAccrued ExpensesAccumulated Depreciation, TotalAdditional Paid-In CapitalCashCash and Short Term InvestmentsCash & EquivalentsCommon Stock, TotalDeferred Income TaxGoodwill, NetIntangibles, NetLong Term DebtLong Term InvestmentsNotes Payable/Short Term DebtOther Current Assets, TotalOther Current Liabilities, TotalOther Equity, TotalOther Liabilities, TotalOther Long Term Assets, TotalOther ReceivablesPrepaid ExpensesProperty/Plant/Equipment, Total - GrossProperty/Plant/Equipment, Total - NetRetained EarningsShort Term InvestmentsTangible Book Value per ShareTotal AssetsTotal Current AssetsTotal Current LiabilitiesTotal DebtTotal EquityTotal InventoryTotal LiabilitiesTotal Liabilities & Shareholders EquityTotal Long Term DebtTotal Receivables, NetCash Per ShareNet DebtMinority InterestCurrent Port. of LT Debt/Capital LeasesUnrealized Gain (Loss)Preferred Stock - Non Redeemable, NetTreasury Stock - CommonNote Receivable - Long TermTotal Preferred Shares OutstandingCash & Due from BanksNet LoansOther Assets, TotalOther Earning Assets, TotalPayable/AccruedTotal DepositsTotal Short Term BorrowingsRedeemable Preferred Stock, TotalOther Bearing Liabilities, TotalDeferred Policy Acquisition CostsPolicy LiabilitiesInsurance ReceivablesTotal Utility Plant, NetFormal Name: Code Name: Periods Available: Default Period: Unit: Millions Examples of Custom PeriodsFS_EquityMetricsGet any financial metric (fundamentals, analyst estimates, key financial ratios) of a company. The list of supported metrics is in the Metric Lookup section. Optionally you can specify the period to get the value at a specific time and/or specify the limit to return data for more than 1 period.Examples:=FS_EquityMetrics("AAPL", "net_income")=FS_EquityMetrics(A1:A20, "revenue", "FY-3")=FS_EquityMetrics("AMZN", "cash", "Q", 5)Arguments:symbolREQUIREDStock symbol(s). This can be a symbol or reference to an array of symbols. If more than 1 symbols are supplied, leave "limit" blank. Free users can request up 10 symbols at a time. Paid users can request up 100 symbols at a time. When possible, always use an array of symbols instead of making individual calls for each ticker. This will speed up the functions and avoid running into your plan's request limit.metricREQUIREDMetric code name.periodoptionalPeriod. Choose among the supported periods and their variants if the metric supports periods. If none is provided, the default period is used.limitoptionalThe number of periods to return data. If none is provided, limit is set to 1. If a custom period such as "TTM-2" and "FY2019.Q3" is used, limit will be ignored.optionsoptionalInclude "NH" to omit the header date row. Include "H" to always show the header date row.Note: By default, the header date is omitted when limit is 1 or a custom period is provided.By default, the header date is displayed when limit is > 1 and no custom period is provided.The header date will not be displayed if more than 1 stock symbol is provided.Sample 1ƒx=FS_EquityMetrics(A1:A3, "cost_of_rev", "FY-3")ABC1AAPL1637562GOOGL595493AMZN139156Sample 2ƒx=FS_EquityMetrics("AAPL", "revenue", "TTM", 3)ABC12019-09-282020-09-262021-09-2522601742745153658173Sample 3ƒx=FS_EquityMetrics("AAPL", "eps_proj_avg", "FY+3")ABC15.98596723FS_EquityFullFinancialsGet standardized balance sheet, income statement and cash flow for global companies going back 30+ yearsNote: This function is not available for Free members. The rate limit for this function is 30 function calls/ minute.Examples:=FS_EquityFullFinancials("AAPL", "ic")=FS_EquityFullFinancials("GOOGL", "bs", "FY-3")=FS_EquityFullFinancials("AMZN", "cf", "YTD", 5)Arguments:symbolREQUIREDStock Symbol.statementREQUIREDStatement can be 1 of these bs, ic, cf for Balance Sheet, Income Statement, Cash Flow respectively.periodoptionalPeriod can be 1 of these TTM, FY, Q, YTD and their variants. TTM (Trailing Twelve Months) option is available for Income Statement and Cash Flow. YTD (Year To Date) option is only available for Cash Flow. If none is provided, Q is used if statement is "bs" otherwise TTM will be used.limitoptionalThe number of periods to return data. If none is provided, limit is set to 1. If a custom period such as "TTM-2" and "FY2019.Q3" is used, limit will be ignored.Sample ƒx=FS_EquityFullFinancials("AAPL", "ic", "TTM", 3)ABCD12019-09-282020-09-262021-09-252Revenue2601742745153658173Total Revenue2601742745153658174Cost of Revenue, Total1617821695592129815Gross Profit983921049561528366SG&A Expense1824519916219737Research & Development1621718752219148Total Operating Expense3446238668438879Operating Income639306628810894910Net Income Before Taxes657376709110920711Provision for Income Taxes1048196801452712Net Income After Taxes552565741194680FS_EquityCandlesGet historical candlestick data for stocks. Daily data will be adjusted for Splits. Intraday data will remain unadjusted.Examples:=FS_EquityCandles("AAPL", "1", "1631562248", "09/15/2021")=FS_EquityCandles("GOOGL", "60", "08/01/2021", "11/15/2021", "Open", "NH")Arguments:symbolREQUIREDStock Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange. Only resolutions D, W, M are available for Free members. Check out this section for specific restrictions for each plan.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default, all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_EquityCandles( "AAPL" , "D" , "1630987200" , "09/15/2021")ABCDEF1PeriodCloseOpenHighLowVolume21630987200156.69154.97157.26154.398227826131631073600155.11156.98157.04153.9757442020741631160000154.07155.49156.11153.955730573051631246400148.97155155.48148.714089323561631505600149.55150.63151.42148.7510240432971631592000148.12150.35151.07146.9110929629581631678400149.03148.56149.44146.3783281315FS_RevenueBreakdownGet revenue breakdown for global companies.Note: This function is only available for Plus and Pro members.Examples:=FS_RevenueBreakdown("WMT", "product")=FS_RevenueBreakdown("GOOGL", "geography", "annual", 3)Arguments:symbolREQUIREDStock Symbol.categoryREQUIREDCategory ("product" or "geography").freqoptionalFrequency ("annual" or "quarterly"). Default is "annual".limitoptionalNumber of periods to returned. If empty, function will return all periods.Response Attributes:ResultResult as a matrix (rows are components, columns are period, unit is millions).Sample ƒx=FS_RevenueBreakdown("GOOGL", "geography", "annual", 3)ABCD12022-12-312023-12-312024-12-312United States1348141462861704473EMEA82062910381021274APAC4702451514568155Other Americas169761832020418FS_HistoricalMarketCapGet daily historical market cap data for global companies.Note: This function is only available for Plus and Pro members.Examples:=FS_HistoricalMarketCap("AAPL", "2024-01-01", "2024-03-01")=FS_HistoricalMarketCap("GOOGL", "2024-06-20", "2024-07-28")Arguments:symbolREQUIREDStock Symbol.fromREQUIREDFrom date YYYY-MM-DD.toREQUIREDTo date YYYY-MM-DD.Response Attributes:DateDate.MarketCapMarket Capitalization on that date in millions.Sample ƒx=FS_HistoricalMarketCap("AAPL", "2024-01-01", "2024-03-01")AB1DateMarketCap22024-01-012994371.232024-01-022870346.242024-01-032848854.252024-01-042812673.5FS_DividendsGet dividends data for common stocks going back 30 years.Examples:=FS_Dividends("AAPL", "2019-02-01", "2020-02-01")=FS_Dividends("GOOGL", "2015-05-05", "2021-01-01")Arguments:symbolREQUIREDStock Symbol.fromREQUIREDFrom (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalTo (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "currency&payDate&&amount"). By default, all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. You can also chain them together "-NH".Response Attributes:adjustedAmountAdjusted dividends.amountAmount in local currency.currencyCurrency.dateEx-Dividend date.declarationDateDeclaration date.payDatePay date.recordDateRecord date.Sample ƒx=FS_Dividends( "AAPL" , "2019-02-01" , "2020-02-01")ABCD1declarationDatepayDateamountadjustedAmount22019-10-302019-11-140.770.7732019-07-302019-08-150.770.7742019-05-012019-05-160.770.77FS_EquityTickGet historical tick data for US exchanges. The data is delayed 15 minute.Note: This function is only available for Pro members.Examples:=FS_EquityTick("AAPL", "2020-03-25", 500, 10)=FS_EquityTick("GOOGL", "2021-08-20", 1000)Arguments:symbolREQUIREDStock Symbol.dateREQUIREDDate (can be string of date, string of UNIX timestamp or reference to a date cell). This date needs to be within the last 10 years.limitREQUIREDLimit number of ticks returned. Maximum value is 25000skipoptionalNumber of ticks to skip. Use this parameter to loop through the entire data. If none is specified it is set to 0.optionsoptionalInclude "CT" to convert Timestamp column from Unix timestamp to your local timezone.Response Attributes:CountNumber of ticks returned. If count < limit, all data for that date has been returned.TotalTotal number of ticks for that date.Venue/ExchangeThe venue/exchange that facilitated the trade.TimestampTimestamp of the trade.PricePrice data.VolumeVolume.Trade conditionA comprehensive list of trade conditions code can be found here.Sample ƒx=FS_EquityTick("AAPL", "2020-03-25", 500, 10)ABCDE1Count3Total32Venue / ExchangeTimestampPriceVolumeTrade conditions3Nasdaq OMX PSX, Inc. LLC1631208040155.11744202071,244Nasdaq OMX PSX, Inc. LLC1631212922154.07573057301,24,125Nasdaq OMX PSX, Inc. LLC1631214803148.971408932351,24,12ETF LookupLook up all available ETFs. Click here to view the full list of supported ETF symbols.FS_EtfProfileGet ETF's profile.Note: This function is not available for Free members.Examples:=FS_EtfProfile("VOO")=FS_EtfProfile("ARKK")Arguments:symbolREQUIREDETF symbol.Response Attributes:SymbolETF symbol.Asset ClassAsset class.AUMAssets under management.Avg Volume30-day average volume.CUSIPCUSIP.DescriptionDescription.DomicileDomicile.ETF IssuerETF issuer.Expense RatioExpense ratio.Inception DateInception date of the ETF.Investment SegmentInvestment segment.ISINISIN.NameETF full name.NAVNet asset value.NAV CurrencyCurrency of net asset value.P/BPrice to Book ratio.P/EPrice to Earnings ratio.Tracking IndexTracking index.WebsiteWebsite.Sample ƒx=FS_EtfProfile("SPY")AB1SymbolSPY2Asset ClassEquity3Avg Volume912212604CUSIP78462F1035DescriptionSPY was created on 1993-01-22 by SPDR...6DomicileUS7ETF IssuerSPDR8Expense Ratio0.09459Inception Date1993-01-2210Investment SegmentLarge Cap11ISINUS78462F103012NameSPDR S&P 500 ETF Trust13P/B4.33048114P/E22.0609315Tracking IndexS&P 500FS_EtfCandlesGet historical candlestick data for ETFs. Click here to view the full list of supported ETF symbols.Note: This function is not available for Free members.Examples:=FS_EtfCandles("VOO", "1", "1631562248", "09/15/2021")=FS_EtfCandles("ARKK", "60", "08/01/2021", "11/15/2021")Arguments:symbolREQUIREDETF Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_EtfCandles( "SPY" , "D" , "1630987200" , "09/15/2021")ABCDEF1PeriodCloseOpenHighLowVolume21630987200451.46452.71452.81450.74235167153431631073600450.91450.89451.67448.865618190741631160000448.98450.7452.57448.725797040751631246400445.44451.04451.49445.318994817461631505600446.58448.64448.92444.118373864971631592000444.17448.12448.34443.227819714081631678400447.88444.62448.41443.4478792222FS_EtfHoldingsGet ETF's holdings.Note: This function is only available for Plus and Pro members.Examples:=FS_EtfHoldings("VOO")=FS_EtfHoldings("ARKK", 2)Arguments:symbolREQUIREDETF symbol.skipoptionalSkip the first n results. You can use this parameter to query historical constituents data. The latest result is returned if skip=0 or not set. Plus can set skip up to 10 while Pro can set skip up to 100.Sample ƒx=FS_EtfHoldings("SPY")ABCDEF1Date2020-12-112SymbolCUSIPISINNamePercentShare3AAPL037833100US0378331Apple Inc6.46171676927094MSFT594918104US5949181Microsoft Corp5.299789348865...Mutual Fund LookupLook up all available mutual funds. Click here to view the full list of supported Mutual Fund symbols.FS_MutualFundProfileGet mutual fund's profile.Note: This function is only available for Pro members.Examples:=FS_MutualFundProfile("VTSAX")=FS_MutualFundProfile("FNILX")Arguments:symbolREQUIREDMutual fund symbol.Response Attributes:SymbolMutual fund symbol.NameFund full name.BenchmarkIndex Benchmark.BetaBeta.DescriptionDescription.Expense RatioAnnual expense Ratio.Fund FamilyFund family.Inception DateFund inception date.Investment SegmentInvestment segment.TurnoverTurnover.Sample ƒx=FS_MutualFundProfile("VTSAX")AB1SymbolVTSAX2BenchmarkCRSP US Total Stock Market TR3Beta1.054CategoryMulti-Cap Core5DescriptionVTSAX was founded on 2000-11-13 ...6Expense Ratio0.047Fund FamilyVANGUARD ADMIRAL8Inception Date2000-11-139Investment SegmentGrowth & Income10Full NameVanguard Index Funds: Vanguard Total Stock Market Index Fund; Admiral Class Shares11Total NAV28075800000012Turnover8FS_MutualFundCandlesGet historical candlestick data for Mutual Funds. Click here to view the full list of supported Mutual Fund symbols. Note: This function is only available for Pro members.Examples:=FS_MutualFundCandles("VTSAX", "1", "1631562248", "09/15/2021")=FS_MutualFundCandles("FNILX", "60", "08/01/2021", "11/15/2021")Arguments:symbolREQUIREDMutual Fund Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_MutualFundCandles( "VTSAX" , "D" , "1630987200" , "09/15/2021")ABCDE1PeriodCloseOpenHighLow21630987200113.54113.54113.54113.5431631073600113.24113.24113.24113.2441631160000112.83112.83112.83112.8351631246400111.95111.95111.95111.9561631505600112.18112.18112.18112.1871631592000111.48111.48111.48111.48FS_MutualFundHoldingsGet Mutual Fund's holdings.Note: This function is only available for Pro members.Examples:=FS_MutualFundHoldings("VTSAX")=FS_MutualFundHoldings("VWIAX", 2)Arguments:symbolREQUIREDMutual Fund symbol.skipoptionalSkip the first n results. You can use this parameter to query historical constituents data. The latest result is returned if skip=0 or not set.Sample ƒx=FS_MutualFundHoldings("VTSAX")ABCDEF1Date2020-12-312SymbolCUSIPISINNamePercentShare3778669200US7786692Rotech Healthcare0.7565119162764DEN24790A101US24790A1Denbury Inc Ordinary Shares - Ne0.3430824018055...FS_BondCandlesGet end-of-day bond's price data. The following datasets are supported: Exchange Segment US Government Bonds Government Bonds FINRA Trace BTDS: US Corporate Bonds FINRA Trace 144A Bonds Note: This function is only available for Pro members.Examples:=FS_BondCandles("US912810TD00", "1661427736", "09/01/2022")=FS_BondCandles("US912810TD00", "08/15/2022")Arguments:isinREQUIREDISIN of bond.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedoptionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps.CloseList of end-of-day close prices.Sample ƒx=FS_BondCandles("US912810TD00" , "1661427736" , "09/01/2022")AB1PeriodClose2163098720097.693163107360098.114163116000098.075163124640098.976163150560096.557163159200097.128163167840098.03FS_BondTickGet trade-level data for bonds. The following datasets are supported: Exchange Segment Delay FINRA Trace BTDS: US Corporate Bonds Delayed 4h FINRA Trace 144A Bonds Delayed 4h Note: This function is only available for Pro members.Examples:=FS_BondTick("US693475BF18", "2022-08-19")=FS_BondTick("US693475BF18", "2022-12-15", 10)Arguments:isinREQUIREDISIN of bond.dateREQUIREDDate (can be string of date, string of UNIX timestamp or reference to a date cell) limitoptionalLimit number of ticks returned. If empty, all ticks of that date will be returnedoptionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps.PriceList of price data.VolumeList of volume data.SideTrade side of the reporting party (dealer).Sample ƒx=FS_BondTick("US693475BF18", "2022-10-15", 7)ABCD1PeriodPriceVolumeSide2163171440097.69829Buy3163171800098.119283Buy4163172160098.07232Sell5163172970098.97828Sell6163172982096.552890Buy7163173258597.122920Sell8163173613298.03124BuyCrypto LookupClick here to view the full list of supported crypto symbolsFS_CryptoProfileGet crypto's profile.Examples:=FS_CryptoProfile("BTC")=FS_CryptoProfile("ETH")Arguments:symbolREQUIREDCrypto symbol such as BTC or ETH.Response Attributes:NameCrypto name.Full NameCrypto full name.DescriptionDescription.Market CapitalizationMarket capitalization of the asset.Total SupplyTotal supply of the asset.Max SupplyMaximum supply of the asset.Circulating SupplyCurrent circulating supply of the asset.Launch DateLaunch date.WebsiteWebsite.Proof TypeProof type of the asset.Sample ƒx=FS_CryptoProfile("BTC")AB1NameBitcoin2Full NameBitcoin (BTC)3DescriptionBitcoin uses peer-to-peer technology to operate ...4Market Capitalization7845230502975Total Supply189491936Max Supply210000007Circulating Supply189491938Launch Date2009-01-039Websitebitcoin.org/en/10Proof TypePoWFS_CryptoCandlesGet historical candlestick data for cryptocurrencies. Click here to view the full list of supported crypto symbols.Examples:=FS_CryptoCandles("POLONIEX:BTC_ETH", "1", "1631562248", "09/15/2021")=FS_CryptoCandles("BINANCE:ETHBTC", "60", "08/01/2021", "08/15/2021")Arguments:symbolREQUIREDCrypto Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange. Only resolutions D, W, M are available for Free members.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default, all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_CryptoCandles( "BINANCE:ETHBTC" , "D" , "1630987200" , "09/15/2021")ABCDEF1PeriodCloseOpenHighLowVolume216309872000.0759690.0732730.0763730.072158161034316310736000.0738190.0759690.0766570.073694121819416311600000.071550.0738250.0747640.070872105531516312464000.0723310.0715560.0731640.07149268656616313328000.0739760.072330.0752510.07204785844716314192000.0731020.0739720.0741250.0713121772816315056000.0729050.0731020.0737140.07159386251916315920000.0750920.0729060.0750990.071662116676Forex LookupClick here to view the full list of supported forex and metal symbols.FS_ForexAllRatesGet rates for all forex pairs.Examples:=FS_ForexAllRates("USD")Arguments:base_currencyREQUIREDBase currency.Sample ƒx=FS_ForexAllRates("USD")AB1AED3.9680122AFN82.3733083CAD1.5253684CZK27.0967375DJF191.9913446DZD139.3840217ETB36.2967678EUR0.919GBP0.87484110JPY114.58354811MDL19.12025112MGA4105.15677613USD1FS_ForexCandlesGet historical candlestick data for forex symbols. Click here to view the full list of supported forex symbols.Examples:=FS_ForexCandles("OANDA:AUD_SGD", "1", "1631562248", "09/15/2021")=FS_ForexCandles("FXCM:EUR/NZD", "60", "08/01/2021", "08/15/2021")Arguments:symbolREQUIREDForex Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange. Only resolutions D, W, M are available for Free members.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedmetricsoptionalChoose which metrics to be displayed. You can chain the metric(s) together using & (ex: "Period&Close&Volume"). By default, all metrics will be displayed. optionsoptionalInclude "-" for descending order output. Include "NH" to omit the header row. Include "CT" to convert Period column from Unix timestamp to your local timezone. You can also chain them together "-NHCT".Response Attributes:PeriodList of timestamps for returned candles.CloseList of close prices for returned candles.OpenList of open prices for returned candles.HighList of high prices for returned candles.LowList of low prices for returned candles.VolumeList of volume data for returned candles.Sample ƒx=FS_ForexCandles( "OANDA:GBP_JPY" , "D" , "1630987200" , "09/15/2021")ABCDEF1PeriodCloseOpenHighLowVolume21630987200151.952151.904152.213151.4894016731631073600151.83151.937152.084151.4524037841631160000151.795151.782152.16151.4154213251631246400152.005151.726152.629151.7213522761631505600152.219152.039152.317151.893487571631592000151.421152.148152.84151.324355681631678400151.328151.399151.551150.81843031FS_PatternRecognitionRun pattern recognition algorithm on a symbol. Support double top/bottom, triple top/bottom, head and shoulders, triangle, wedge, channel, flag, and candlestick patterns.Note: This function is only available for Plus and Pro members.Examples:=FS_PatternRecognition("MSFT", "D")=FS_PatternRecognition("BINANCE:BTCUSDT", "60")Arguments:symbolREQUIREDSymbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.Response Attributes:PatternsPatterns and their attributes.Sample ƒx=FS_PatternRecognition("AAPL", "D")ABCD1Pattern NameDouble TopPattern NameHead & Shoulders2Aprice182.13Aprice182.133Atime1639353600Atime16393536004Bprice167.46Bprice167.465Btime1639958400Btime16399584006Cprice182.94Cprice182.947Ctime1641254400Ctime16412544008Dprice0Dprice168.179Dtime0Dtime164177280010End_price167.46End_price168.474211End_time1642550400End_time164255040012Entry167.46Entry168.474313Eprice0Eprice177.1814Etime0Etime164194560015Mature0Mature016PatterntypebearishPatterntypebearish17Profit1151.98Profit1152.460618Profit20Profit2019SortTime1642550400SortTime164255040020Start_price167.46Start_price166.9521Start_time1638748800Start_time163874880022StatuscompleteStatuscomplete23Stoploss184.488Stoploss184.48824Terminal0Terminal0FS_SupportResistanceGet support and resistance levels for a symbol..Note: This function is only available for Plus and Pro members.Examples:=FS_SupportResistance("VOO", "D")=FS_SupportResistance("OANDA:EUR_USD", "60")Arguments:symbolREQUIREDSymbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.Response Attributes:LevelsArray of support and resistance levels.Sample ƒx=FS_SupportResistance("AAPL", "D")ABCD1125.94142.53157.8182.9423FS_AggregateIndicatorsGet aggregate signal of multiple technical indicators such as MACD, RSI, Moving Average, etc...Note: This function is only available for Plus and Pro members.Examples:=FS_AggregateIndicators("TSCO.L", "D")=FS_AggregateIndicators("BINANCE:BTCUSDT", "10")Arguments:symbolREQUIREDSymbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.Response Attributes:BuyNumber of buy signals.NeutralNumber of neutral signals.SellNumber of sell signals.SignalAggregate signal.AdxAdx reading.TrendingWhether market is trending or going sideway.Sample ƒx=FS_AggregateIndicators("VOO", "D")AB1Buy22Neutral83Sell54Aggregate signalneutral5ADX reading28.3436TrendingtrueFS_TechnicalIndicators Return technical indicator with price data. List of supported indicators can be found here.Note: This function is only available for Plus and Pro members.Examples:=FS_TechnicalIndicators("OANDA:AUD_SGD", "D", "macd" ,"1631022248", "09/15/2021")=FS_TechnicalIndicators("AAPL", "60", "sma", "08/01/2021", "08/15/2021", {"timeperiod", 3; "seriestype", "c"})Arguments:symbolREQUIREDForex Symbol.resolutionREQUIREDSupported resolution includes 1, 5, 15, 30, 60, D, W, M . Some timeframes might not be available depending on the exchange.indicatorREQUIREDIndicator code name. Click here for the full list of supported indicators.fromREQUIREDInterval initial value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). tooptionalInterval end value (can be string of datetime, string of UNIX timestamp or reference to a datetime cell). If none is provided, the current timestamp is usedparametersoptionalList of all parameters and their value (use , to separate a parameter from its value, use ; to separate parameters). Click here to see which indicators and parameters are supported.Sample ƒx=FS_TechnicalIndicators( "AAPL" , "D" , "sma" , "1631022248" , "09/15/2021" , {"timeperiod", 3; "seriestype", "c"})ABCDEF1PeriodCloseSmaOpenHighLow21630987200156.690154.97157.26154.3931631073600155.110156.98157.04153.97541631160000154.07155.29155.49156.11153.9551631246400148.97152.71155155.48148.761631505600149.55150.86150.63151.42148.7571631592000148.12148.88150.35151.07146.9181631678400149.03148.89148.56149.44146.37FS_EarningsCalendarGet historical and coming earnings release. EPS and Revenue in this endpoint are non-GAAP, which means they are adjusted to exclude some one-time or unusual items. This is the same data investors usually react to and talked about on the media. Estimates are sourced from both sell-side and buy-side analysts.Note: This function is only available for Plus and Pro members.Examples:=FS_EarningsCalendar("2022-10-01", "2022-10-10", , "true")=FS_EarningsCalendar("2022-10-01", "2022-10-10", "GOOGL")Arguments:fromoptionalFrom date (can be string of date, string of UNIX timestamp or reference to a date cell).tooptionalTo date (can be string of date, string of UNIX timestamp or reference to a date cell).symboloptionalFilter by stock symbolinternationaloptionalSet to "true" to include international markets. Default value is "false".optionsoptionalSet to "NH" to omit the header row.Response Attributes:DateDate of earnings call.HourHour of earnings call.SymbolStock symbol.Revenue ActualRevenue Actual.Revenue EstimateRevenue Estimate.EPS ActualEPS Actual.EPS EstimateEPS Estimate.Reporting PeriodReporting Period.Sample ƒx=FS_EarningsCalendar("2022-10-01", "2022-10-10")ABCDEF1DateSymbolRev EstRev ActEPS EstEPS Act22022-10-01AAPL88496400918190004.54744.9932022-10-02GOOGL64040000629851613.032.839442022-10-03AMZN75040000760400006.2326.452FS_InstitutionalPortfoliosGet latest holdings of gurus/institutions. The list of supported gurus/institutions can be found here. Examples:=FS_InstitutionalPortfolios("Warren Buffett")=FS_InstitutionalPortfolios("Bill Gates")Arguments:guruREQUIREDGuru/institution name.Sample ƒx=FS_InstitutionalPortfolios("Warren Buffett")ABC1AAPL2BAC3KO4C5CVX6AXP7HPQFS_ESGGet ESG scores and important indicators for 1000+ global companies. Our ESG scoring models takes into account more than 150 different inputs to calculate the level of ESG risks and how well a company is managing them. A higher score means lower ESG risk or better ESG management. ESG scores are in the the range of 0-100. Some key indicators might contain letter-grade score from C- to A+ with C- is the lowest score and A+ is the highest score.Note: This function is only available for Pro members.Examples:=FS_ESG("AAPL")=FS_ESG("GOOGL")Arguments:symbolREQUIREDStock symbol.Sample ƒx=FS_ESG("SPY")AB1Total Woman Percentage342Weaponsfalse3White Employee Percentage474White Management Percentage595Women Management Percentage17.026Hispanic Latino Employee Percentage147Environment Score73.218Governance Score56.069Social Score45.8110Total ESG Score56.04FS_EarningsQualityGets Earnings Quality Score for global companies. Earnings quality refers to the extent to which current earnings predict future earnings. "High-quality" earnings are expected to persist, while "low-quality" earnings do not. A higher score means a higher earnings qualityWe source this data from Finnhub who uses a proprietary model which takes into consideration 4 criteria: Profitability, Growth, Cash Generation & Capital Allocation, Leverage. All metrics of each company in each category are then compared against its peers in the same industry to gauge how quality its earnings is. Note: This function is only available for Pro members.Examples:=FS_EarningsQuality("AAPL", "annual")=FS_EarningsQuality("GOOGL", "quarterly", 5)Arguments:symbolREQUIREDStock symbol.freqREQUIREDFrequency can be either annual or quarterly.limitoptionalNumber of periods to return data. If none is provided, all periods will be returnedResponse Attributes:Cash Generation Capital AllocationCash Generation Capital Allocation score.GrowthGrowth score.LeverageLeverage score.ProfitabilityProfitability score.ScoreTotal score.Letter ScoreLetter score.Sample ƒx=FS_EarningsQuality("AAPL", "annual", 2)ABC12020-09-262021-09-252Cash Generation Capital Allocation47.6405151.0217673Growth69.9838681.562154Leverage33.70809659.5607835Profitability1001006Score62.83311573.036177Letter ScoreA-A Abstract Logo Vectors by Vecteezy