=FINANCE formulas pull Yahoo Finance public data beyond scraping via direct API for speed and accuracy. Get real-time and historical financial data, including stocks, ETFs, mutual funds, FOREX, commodities, cryptocurrencies and indices. Automate your portfolio tracking and power your financial analysis with simple formulas.

The next formulas give access to over 200 live and historical data points:

=FINANCE
=FINANCE_QUOTES
=FINANCE_HISTORY
=FINANCE_STATEMENTS
=FINANCE_OPTIONS

* EXAMPLES

=FINANCE ("BTC-USD")
=FINANCE_QUOTES ("AAPL,BTC-USD,EURUSD=X")
=FINANCE_HISTORY ("GLD","1d","3mo")
=FINANCE_HISTORY2 ("GLD","2020-09-30","2020-02-22")
=FINANCE_STATEMENTS ("MSFT",”*”,"QUARTERLY")
=FINANCE_OPTIONS ("AMZN")
=FINANCE_SEARCH ("Apple")

* PRICING

Start a free 7-day trial to test all features. No credit card is required - just install the add-on and start using it. After the trial, upgrade for unlimited access for as little as $19/month.