Real-time and historical data for 80k securities including stocks, ETFs, mutual funds, FOREX, commodities, cryptocurrencies and more in your spreadsheet.

With FMP, you can forget about wasting hours collecting and organizing financial data for every security you analyze.

Using simple formulas, you can get the data you need for your analysis so you can easily compare and visualize hundreds of stocks, ETFs and more at once in a simple view.

Better yet, you can build analysis models to get your analysis done in a fraction of the time.

Years of financial statements and key metrics in seconds:

Simply select the company symbol and get the annual financials and quarterly financials going back to 2002 in different tabs of your spreadsheet.

Income statement

Balance sheet

Cash flow statement

Stock key metrics

Stock growth metrics

Get your custom stock dashboards, screeners, and DCF's done faster than ever:

Use our custom FMP and FMPPRICE functions and autofill to quickly fill your models and DCF' with all the stock data you need.

Get stock's real-time price and the following live metrics and refresh them when you want at the push of a button, 80,000+ stocks, crypto, ETFs and more globally:

Symbol

Name

Price

Changes Percentage

Change

Day Low

Day High

Year High

Year Low

Market Cap

Price Avg 50

Price Avg 200

Volume

Avg Volume

Exchange

Open

Previous Close

EPS

PE

Shares Outstanding

Along with tons of other accessible data.

Get stock’s dividend data, including the dividend, declaration date, and payment date going back to 1985:

Simply enter =FMPPRICE(“ticker”, “dividend”) and watch your spreadsheet get populated with the dividend data you need

Access historical stock and ETF price data, including open, close, volume, etc:

Enter any of these parameters in the FMPPRICE function and then enter the number of days you’d like to get data from or a specific date range.

Example function calls:

=FMP(“AAPL”, “Revenue”, “TTM”)

=FMP(“TSLA”, “Net income”, 2021, “q3”)

=FMPPRICE(“AMZN”, “Price”)

=FMPPRICE(“AAPL”, “Close”, 20)

=FMPPRICE(“TSLA”, “Dividend”)

The stock data comes directly from the company's reports and is standardized according to the XBRL US GAAP Taxonomy Preparers Guide.

50+ Different exchanges covered:

XETRA (Germany)

NSE (India)

LSE (London)

MCX (Russia)

SIX (Switzerland)

HKSE (Hong Kong)

ASX (Australia)

OSE (Norway)

NYSE (US)

NASDAQ (US)

AMEX (US)

EURONEXT (Europe)

INDEX

TSX (Canada)

EURONEXT (Paris)

OTC (Over the Counter US)

Shanghai

Shenzhen (China)

Nasdaq Stockholm (Stockholm Sweeden)

TYO (Tokyo)

And more...

One single financial data source with everything you need. Perfect for long-term investors, traders and value investors.

Make your investing easier and more effective than ever.

Need support? Email us at info@financialmodelingprep.com we are happy to help.

*Disclaimer: Using this add-in requires a valid paid FMP subscription and account which you can get at https://site.financialmodelingprep.com/. When you create your account, you also agree to our terms of service. This add-in cannot be used without a valid FMP subscription.

FMP

de Wisesheets Inc.