FMP

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.