FMP

FMP

Enter

Google Sheet Add-on Integration - Financial Modeli...

Google Sheet Add-on

Installation GuideTroubleshootsList of functions

Installation Guide

Detailed installation process of Google Sheets Add-on

There are two methods to install this add-on: for yourself or the entire domain (G Suite).

Individual installation

This is the easiest and the quickest way to begin working with this add-on by the individual user via Google Workspace Marketplace.

Step 1: Open Spreadsheet and Access Add-ons

Open any spreadsheet, select Extensions ➤ Add-ons ➤ Get add-ons.

Intoduction, Open google sheet, financial modeling prep

Step 2: Search and Access Add-on Page

Type in Financial Modeling Prep in the search bar and open the add-on page.

Open Search, Open google sheet, financial modeling prepAdd on, Open google sheet, financial modeling prep

Step 3: Install Add-on and Grant Permissions

After choosing Install, you will need to confirm granting necessary permissions and click Allow.

Install Add-on, Open google sheet, financial modeling prep

Step 4: Confirm and Finalization

You should see the following confirmation screen after successful installation Click Next Then click Done

Confirm, Open google sheet, financial modeling prep

Then Click Done.

Finalize, Open google sheet, financial modeling prep

Step 5: Set Up API Key

Now go to Extensions ➤ Financial Modeling Prep ➤ Enter API Key, type in your API key, and click the Save button. That’s it; everything is ready for work!

Setup Key, Open google sheet, financial modeling prep

Domain level installation

G Suite Administrators can install this add-on for the domain via the G Suite Admin page.

GSuite, Open google sheet, financial modeling prep

Step 1: Access Admin Page and Add-ons List

From the Google Admin page, go to Apps ➤ Google Workspace Marketplace apps ➤ Apps list. Then, click Add app to the domain install list button.

GSuite List, Open google sheet, financial modeling prep

Step 2: Search and Access Add-on Page

2. Type Financial Modeling prep in the search bar and open the add-on page.

Search Add-on, Open google sheet, financial modeling prepAccess Add-on, Open google sheet, financial modeling prep

Step 3: Domain-Wide Installation Add-on and Grant Permissions

3. Click the Domain install button and confirm the domain-wide install. Then, in the new window, accept the terms and allow access to the data.

Domain wide, Open google sheet, financial modeling prep

Step 4: Confirm and Finalization

4. After successful installation, you should see the following confirmation screen.

Confirm Key, Open google sheet, financial modeling prep

Step 5: Set Up API Key

5. Open the spreadsheet. Go to Add-ons ➤ Financial Modeling prep ➤ Settings, type in the API key, and click the Save button. Now you’re all set!

Save key, Setup Key, Open google sheet, financial modeling prep

Replacing Formula with values

To replace for particular Financial Modeling Prep Add-on functions, you can use the following steps:

1. Go to Extensions ➤ Financial Modeling Prep ➤ Replace formulas with values.

2. Select the range of cells containing the add-on functions you want to replace. Or you can select the entire sheet by clicking on "All".

3. Click the "Replace" button to convert the add-on functions to values.

Replace Formula, Open google sheet, financial modeling prep

Troubleshoots

Q: The add-on functions not appearing in my Google Sheets. What should I do?

A: First, ensure that you have installed the add-on correctly by following the installation steps. Then, check if the add-on is enabled by going to Add-ons ➤ Manage add-ons. If it's listed but disabled, click "Manage" and enable it. If it's not listed at all, try reinstalling the add-on from the Google Workspace Marketplace.

If the add-on is still not appearing, Go to Add-ons ➤ Manage add-ons ➤ Click on the three dots next to the add-on ➤ Use in this document. This will enable the add-on for the current Google Sheet.

Troubleshoot One, Open google sheet, financial modeling prepTroubleshoot Two, Open google sheet, financial modeling prep

Q: I'm getting an error message when trying to use the add-on. How can I troubleshoot this?

A: Error messages can indicate various issues, such as incorrect input, connectivity problems, or conflicts with other add-ons. Check the documentation or support resources provided by the add-on developer for troubleshooting steps related to the specific error message you're encountering.

Q: The add-on is installed, but it's not functioning as expected. What should I check?

A: Ensure that you're using the add-on according to the instructions provided by the developer. Double-check your settings and input to ensure they're correct. If the issue persists, consider reaching out to the developer's support team for assistance.

Q: I'm unable to log in to the add-on. What could be causing this?

A: Make sure you are logged in with the correct Google account. If you are still having trouble, try using a different browser or clearing your browser cache.

If you open a web app or add-on and experience multi-login issues, try one of the following solutions:

Log out of all your Google Accounts and only log in to the one that has the add-on or web app you want to access.

Open an incognito window in Google Chrome, or an equivalent private browsing window, and log in to the Google Account that has the add-on or web app you want to access.

If you're still unable to log in, please refer to the Google Developer Guide.

Q: The add-on worked previously but has suddenly stopped working. What could be causing this?

A: Changes to Google Sheets, browser updates, or updates to the add-on itself can sometimes cause compatibility issues that affect functionality. Try refreshing the page, clearing your browser cache, or restarting your browser to see if the issue resolves itself. If not, check for any updates to the add-on or contact the developer for assistance.

Q: I'm experiencing performance issues with the add-on. How can I improve performance?

A: Performance issues may arise due to various factors, such as the size of your Google Sheet, the complexity of your data, or limitations with your internet connection. Consider optimizing your Google Sheet by reducing the amount of data processed, splitting large sheets into smaller ones, or upgrading your internet connection if possible.

Q: I've accidentally deleted the add-on. Can I recover it?

A: If you've accidentally deleted the add-on, you can reinstall it from the Google Workspace Marketplace. Go to Add-ons ➤ Get add-ons, search for the add-on by name, and reinstall it. Any settings or configurations you had previously may need to be set up again after reinstalling the add-on.

List of functions:

stock fundamentals

FmpFinancialStatementSymbolLists

Discover all companies with financial statements available on our API. Our comprehensive list covers major exchanges such as the NYSE and NASDAQ, as well as international exchanges. This list is regularly updated, so you can always find the information you need. Return List of symbols that have financial statements.

1 =fmpFinancialStatementSymbolLists()
FmpFinancialStatementSymbolLists

FmpIncomeStatement

FMP's Income Statement API provides access to real-time income statement data for a wide range of companies, including public companies, private companies, and ETFs. This data can be used to track a company's profitability over time, to compare a company to its competitors, and to identify trends in a company's business. Returns Income Statement Function: =fmpIncomeStatement(symbol: string, limit: number, period: string, datatype: string, headers: string)

1 =fmpIncomeStatement("AAPL",1,"annual")
FmpIncomeStatement

FmpBalanceSheetStatement

The balance sheet is a financial statement that displays a company’s total assets, liabilities, and shareholder equity over a specific timeframe (quarterly or yearly). Investors can use this statement to determine if the company can fund its operations, meet its debt obligations, and pay a dividend. Returns Balance Sheet Statement Function: =fmpBalanceSheetStatement(symbol: string, limit: number, period: string, datatype: string, headers: string)

1 =fmpBalanceSheetStatement("AAPL",1,"quarterly")
FmpBalanceSheetStatement

FmpCashFlowStatement

The cash flow statement is a financial statement that highlights how cash moves through the company, including both cash inflows and outflows. This statement shows the cash flows in 3 main categories “Operating Cash Flows”, “Investing Cash Flows”, and “Financing Cash Flows”, which help investors to understand if the company is making money or losing money by conducting business. Returns Cash Flow Statement Function: =fmpCashFlowStatement(symbol: string, limit: number, period: string, datatype: string, headers: string)

1 =fmpCashFlowStatement("AAPL",1)
FmpCashFlowStatement

FmpIncomeStatementAsReported

Get the income statement for a company as reported by the company, without any adjustments. This endpoint provides a complete and accurate picture of a company's financial performance over a period of time. Returns Company Financial Statements As Reported Function: =fmpIncomeStatementAsReported (symbol: string, limit: number, period: string, datatype: string, headers: string)

1 =fmpIncomeStatementAsReported("AAPL",1)
FmpIncomeStatementAsReported

FmpIncomeStatementAsReported

Get the income statement for a company as reported by the company, without any adjustments. This endpoint provides a complete and accurate picture of a company's financial performance over a period of time. Returns Company Financial Statements As Reported Function: =fmpIncomeStatementAsReported (symbol: string, limit: number, period: string, datatype: string, headers: string)

1 =fmpIncomeStatementAsReported("AAPL",1)
FmpIncomeStatementAsReported

FmpBalanceSheetStatementAsReported

Get the balance sheet for a company as reported by the company, without any adjustments. This endpoint can be used to assess a company's financial health and to identify potential risks. Returns Balance Sheet Statement as reported Function: =fmpBalanceSheetStatementAsReported(symbol: string, limit: number, period: string, datatype: string, headers: string)

1 =fmpBalanceSheetStatementAsReported("AAPL",1)
FmpBalanceSheetStatementAsReported

FmpCashFlowStatementAsReported

Get the cash flow statement for a company as reported by the company, without any adjustments. This endpoint can be used to assess a company's cash flow generating ability and to identify potential risks. Returns Cash Flow Statement as reported Function: =fmpCashFlowStatementAsReported(symbol: string, limit: number, period: string, datatype: string, headers: string)

1 =fmpCashFlowStatementAsReported("AAPL",1)
FmpCashFlowStatementAsReported

FmpFinancialStatementFullAsReported

FMP's Full Financial Statement As Reported API provides access to all three of the financial statements (income statement, balance sheet, and cash flow statement) for a company as reported by the company. This data can be used to get a complete overview of a company's financial performance and health. Returns Full Financial Statement as reported

1 2 3 =fmpFinancialStatementFullAsReported(symbol: string, period: string, headers: string) =TRANSPOSE(fmpFinancialStatementFullAsReported("AAPL",1))
FmpFinancialStatementFullAsReported

FmpFinancialStatements

Returns Financials Statements SEC ZIP https://financialmodelingprep.com/api/v3/financial-statements/AAPL?datatype=zip&source=sheets Function: =fmpFinancialStatements(symbol: string, datatype: string, headers:Object)

1 =fmpFinancialStatements("AAPL","zip")

FmpFinancialReportsDates

FMP's Annual Reports On Form 10-K API provides access to the annual reports on Form 10-K for a company. Form 10-K is an annual report that public companies in the United States are required to file with the Securities and Exchange Commission (SEC). This information can be used to access a wealth of information about a company, including its financial performance, its business operations, and its risk factors. Returns

1 =fmpFinancialReportsDates("AAPL",1)
FmpFinancialReportsDates

FmpFinancialReportsJson

Returns Reports on Form 10-K. JSON format https://financialmodelingprep.com/api/v4/financial-reports-json?symbol=AAPL&year=2020&period=Q1&source=sheets Function: =fmpFinancialReportsJson(symbol: string, year: string_or_number, period: string, headers: string)

1 =fmpFinancialReportsJson("AAPL","2020","Q1")

FmpFinancialReportsXlsx

Returns Reports on Form 10-K. XLS format https://financialmodelingprep.com/api/v4/financial-reports-xlsx?symbol=AAPL&year=2020&period=Q1&source=sheets Function: =fmpFinancialReportsXlsx(symbol: string, year: string_or_number, period: string, headers: string)

1 =fmpFinancialReportsXlsx("AAPL","2020","Q1")

FmpSharesFloat

The number of shares available for trading, this includes Restricted Stock Units (RSUs) Returns Shares Float Function: =fmpSharesFloat(symbol: string, headers: string)

1 =fmpSharesFloat("AAPL")
FmpSharesFloat

FmpRssFeeds

A real-time feed of SEC filings from publicly traded companies, including the filing type, link to SEC page, and direct link to the filing. This endpoint can be used to stay up-to-date on the latest SEC filings for all companies or for a specific set of companies. Returns SEC RSS Feeds Function: =fmpRssFeeds(limit: number, datatype: string, headers: string)

1 =fmpRssFeeds(1)
FmpRssFeeds

FmpRssFeedsV4

A real-time feed of SEC filings from publicly traded companies in the latest RSS feed format (V3). RSS Feed V3 includes a number of new features and improvements, such as support for multiple namespaces, digital signatures, enclosures, and categories and tags. Returns SEC RSS Feeds Function: =fmpRssFeeds(limit: number, datatype: string, headers: string)

1 =fmpRssFeedsV4(1)
FmpRssFeedsV4

FmpEarningCallTranscript

Get the full transcript of an earnings call for a specific company in text format. This endpoint can be used to learn more about a company's financial performance, future plans, and overall strategy. Returns Earning Call Transcript Function: =fmpEarningCallTranscript(symbol: string, year: string_or_number, quarter: string_or_number, headers: string)

1 =fmpEarningCallTranscript("AAPL",2020,3)
FmpEarningCallTranscript

stock calendars

FmpSecFilings

Direct link to SEC filings, including the foiling type, link to SEC page, and direct link to the filing Return SEC Filings Function: =fmpSecFilings(symbol: string, limit: number, type: string, headers: string)

1 =fmpSecFilings("AAPL",1,"10-K")
FmpSecFilings

FmpEarningCalendar

A list of upcoming & past earnings announcements for publicly traded companies, including the date, estimated earnings per share (EPS), and actual EPS (if available). Return Company Earnings Calendar Function: =fmpEarningCalendar(from: date_or_string, to: date_or_string, headers: string)

1 =fmpEarningCalendar("2021-09-01","2021-09-01")
FmpEarningCalendar

FmpHistoricalEarningCalendar

A list of historical & upcoming earnings announcements for a specific company, including the date, estimated EPS, and actual EPS. Return Company Daily Discounted cash flow value Function: =fmpHistoricalEarningCalendar(symbol: string, limit: number, headers: string)

1 =fmpHistoricalEarningCalendar("AAPL",1)
FmpHistoricalEarningCalendar

FmpIpoCalendar

The FMP IPO Calendar By Symbol endpoint provides a list of IPOs that have been confirmed and are scheduled to take place in the near future for a given company. This endpoint includes the same information as the FMP IPO Confirmed endpoint, but it is filtered to only include IPOs for the specified company. Return IPO Calendar Function: =fmpIpoCalendar(from: date_or_string, to: date_or_string, headers: string)

1 =fmpIpoCalendar("2021-08-30","2021-09-01")
FmpIpoCalendar

FmpStockSplitCalendar

A list of upcoming stock splits for publicly traded companies, including the date of the stock split, the split ratio, and the type of stock split. Return Stock Split Calendar Function: =fmpStockSplitCalendar(from: date_or_string, to: date_or_string, headers: string)

1 =fmpStockSplitCalendar(A67,B67)
FmpStockSplitCalendar

FmpStockDividendCalendar

A list of upcoming dividend payments for publicly traded companies, including the date of the dividend payment, the ex-dividend date, and the dividend per share. Returns the current date as a date value. =TODAY()

1 =fmpStockDividendCalendar(TODAY(),TODAY())
FmpStockDividendCalendar

FmpEconomicCalendar

Provides a calendar of upcoming economic data releases. Returns the current date as a date value. =TODAY()

1 =fmpEconomicCalendar(TODAY()-2,TODAY())
FmpEconomicCalendar

stock news

FmpEconomicCalendar

Provides a calendar of upcoming economic data releases. Returns the current date as a date value. =TODAY()

1 =fmpEconomicCalendar(TODAY()-2,TODAY())
FmpEconomicCalendar

FmpArticlesInfo

Returns FMP articles information Function: =fmpArticlesInfo(page: number, size: number, headers: string)

1 =fmpArticlesInfo(1,1)
FmpArticlesInfo

FmpArticles

Get a list of the latest general news articles from a variety of sources, including the headline, snippet, and publication URL. Returns FMP articles

1 2 3 =fmpArticles(page: number, size: number, headers: string) Examples: =fmpArticles(1,1)
FmpArticles

FmpStockNews

Get a list of the latest Stock News articles from a variety of sources, including the headline, snippet, publication URL, and ticker symbol. Returns Stock News Function: =fmpStockNews(tickers: string, limit: number, headers: string)

1 =fmpStockNews("AAPL",1)
FmpStockNews

market performance

FmpPressReleases

Get a list of the latest press releases from a variety of companies, including the headline, snippet, publication URL, and company name. Returns Stock press releases Function: =fmpPressReleases(symbol: string, limit: number, headers: string)

1 =fmpPressReleases("AAPL",1)
FmpPressReleases

FmpSectorPriceEarningRatio

The FMP Sector PE Ratio endpoint provides the price-to-earnings (PE) ratio for each sector of the stock market. The PE ratio is a measure of how expensive a stock is relative to its earnings. Investors can use the sector PE ratio to identify sectors that are overvalued or undervalued. Returns Average price to earnings ratio for sectors Function: =fmpSectorPriceEarningRatio(date: date_or_string, exchange: string, headers: string)

1 =fmpSectorPriceEarningRatio("2021-09-27","NYSE")
FmpSectorPriceEarningRatio

FmpIndustryPriceEarningRatio

The FMP Industry PE Ratio endpoint provides the price-to-earnings (PE) ratio for each industry of the stock market. The PE ratio is a measure of how expensive a stock is relative to its earnings. Investors can use the industry PE ratio to identify industries that are overvalued or undervalued. Returns Average price to earnings ratio for industries Function: =fmpIndustryPriceEarningRatio(date: date_or_string, exchange: string, headers: string)

1 =fmpIndustryPriceEarningRatio("2021-09-27","NYSE")
FmpIndustryPriceEarningRatio

FmpStockSectorsPerformance

The FMP Sector Performance endpoint provides the performance of each sector of the stock market over a specified period of time. This information can be used by investors to identify sectors that are outperforming or underperforming the market. Returns Stock Market Sectors Performance Function: =fmpStockSectorsPerformance(headers: string)

1 =fmpStockSectorsPerformance()
FmpStockSectorsPerformance

FmpHistoricalSectorsPerformance

The FMP Sector Historical endpoint provides historical data on the performance of each sector of the stock market. This information can be used by investors to identify trends in sector performance and to make informed investment decisions. Returns Historical sector performance Function: =fmpHistoricalSectorsPerformance(limit: number, headers: string)

1 =fmpHistoricalSectorsPerformance(1)
FmpHistoricalSectorsPerformance

FmpGainers

The FMP Market Biggest Gainers endpoint provides a list of the stocks that have gained the most value on a given day. This information can be used by investors to identify stocks that are momentum and to potential investment opportunities. Returns Most Gainer Stock Companies Function: =fmpGainers(headers: string)

1 =fmpGainers()
FmpGainers

FmpLosers

The FMP Market Biggest Losers endpoint provides a list of the stocks that have lost the most value on a given day. This information can be used by investors to identify stocks that are underperforming and to potential trading opportunities. Returns Most Losers Stock Companies Function: =fmpLosers(headers: string)

1 =fmpLosers()
FmpLosers

advanced data

FmpActives

The FMP Market Most Active endpoint provides a list of the stocks that have the highest trading volume on a given day. This information can be used by investors to identify stocks that are liquid and to potential trading opportunities. Returns Most Active Stock Companies Function: =fmpActives(headers: string)

1 =fmpActives()
FmpActives

FmpStandardIndustrialClassification

Identify the industry in which a particular company operates, based on the Standard Industrial Classification (SIC) system. Returns Standard Industrial Classification Function: =fmpStandardIndustrialClassification(symbol: string, cik: number, sicCode: number, headers: string)

1 =fmpStandardIndustrialClassification("AAPL")
FmpStandardIndustrialClassification

FmpStandardIndustrialClassificationList

Identify the industry in which a particular company operates, based on the Standard Industrial Classification (SIC) system. Returns Full Standard Industrial Classification List Function: =fmpStandardIndustrialClassificationList(sicCode: number, industryTitle: number, headers: string)

1 =fmpStandardIndustrialClassificationList(3571)
FmpStandardIndustrialClassificationList

FmpStandardIndustrialClassificationList

Identify the industry in which a particular company operates, based on the Standard Industrial Classification (SIC) system. Returns Full Standard Industrial Classification List Function: =fmpStandardIndustrialClassificationList(sicCode: number, industryTitle: number, headers: string)

1 =fmpStandardIndustrialClassificationList(3571)
FmpStandardIndustrialClassificationList

FmpCommitmentOfTradersReportList

The Commitment of Traders Report is a weekly report from the Commodity Futures Trading Commission (CFTC) that provides insights into the positions of market participants in various markets. Our Commitment of Traders Report tool makes it easy to access and analyze this valuable data, helping you to make more informed trading decisions. Returns List of symbols for COT Function: =fmpCommitmentOfTradersReportList(headers: string)

1 =fmpCommitmentOfTradersReportList()
FmpCommitmentOfTradersReportList

FmpCommitmentOfTradersReport

The Commitment of Traders Report is a weekly report from the Commodity Futures Trading Commission (CFTC) that provides insights into the positions of market participants in various markets. Our Commitment of Traders Report tool makes it easy to access and analyze this valuable data, helping you to make more informed trading decisions. Returns Commitments of Traders Report Function: =fmpCommitmentOfTradersReport(symbol: string, from: date_or_string, to: date_or_string, headers: string)

1 =fmpCommitmentOfTradersReport(,"2021-09-14","2021-09-15")
FmpCommitmentOfTradersReport

stock statistics

FmpCommitmentOfTradersReportAnalysis

Returns Commitments of Traders Analysis Function: =fmpCommitmentOfTradersReportAnalysis(symbol: string, from: date_or_string, to: date_or_string, headers: string)

1 =fmpCommitmentOfTradersReportAnalysis(,"2021-09-14","2021-09-15")
FmpCommitmentOfTradersReportAnalysis

FmpSocialSentiment

Returns Social Media sentiment about stocks provided by SentimentInvestor Function: =fmpSocialSentiment(symbol: string, limit: number, headers: string)

1 =fmpSocialSentiment("AAPL",1)
FmpSocialSentiment

FmpGrade

Get a sense of how professional investors view a company with our Stock Grade endpoint. This endpoint provides a rating of a company given by hedge funds, investment firms, and analysts. Returns Stock grade from analysts Function: =fmpGrade(symbol: string, limit: number, headers: string)

1 =fmpGrade("AAPL",1)
FmpGrade

FmpEarningsSurprises

A list of earnings announcements for publicly traded companies that were either positive or negative surprises. This endpoint includes the date of the earnings announcement, the estimated EPS, the actual EPS, and the earnings surprise. Returns Earnings Surprises Function: =fmpEarningsSurprises(symbol: string, limit: number, headers: string)

1 =fmpEarningsSurprises("AAPL",1)
FmpEarningsSurprises

insider trading

FmpAnalystEstimates

The FMP Analyst Estimates endpoint provides analyst estimates for a company's future earnings and revenue. Investors can use this information to get a sense of what analysts expect from a company and to identify potential investment opportunities. Returns Company Analyst Estimates Function: =fmpAnalystEstimates(symbol: string, limit: number, period: string, headers: string)

1 =fmpAnalystEstimates("AAPL",1)
FmpAnalystEstimates

FmpInsiderTrading

Allows users to search for insider trades by company name, ticker symbol, or insider name. Returns Stock insider trading Function: =fmpInsiderTrading(symbol: string, companyCik: Object, reportingCik: Object, limit: number, headers: string)

1 =fmpInsiderTrading(,,"0001214156",1)
FmpInsiderTrading

FmpMapperCikName

Converts a company name to a CIK number. Returns List with names and their CIK Function: =fmpMapperCikName(name: string, headers: string)

1 =fmpMapperCikName("1118 ltd")
FmpMapperCikName

FmpMapperCikCompany

Converts a CIK number to a company name. Returns Company CIK mapper Function: =fmpMapperCikCompany(symbol: string, headers: string)

1 =fmpMapperCikCompany("AAPL")
FmpMapperCikCompany

FmpInsiderTradingRssFeed

Provides an RSS feed of insider trades, updated in real time. Returns RSS Feed of form 3,4 and 5 Function: =fmpInsiderTradingRssFeed(limit: number, headers: string)

1 =fmpInsiderTradingRssFeed(1)
FmpInsiderTradingRssFeed

quotes

FmpFailToDeliver

Returns Fail to deliver data for symbol Function: =fmpFailToDeliver(symbol: string, headers: string)

1 =fmpFailToDeliver("AAPL")
FmpFailToDeliver

FmpQuote

This endpoint gives you the latest bid and ask prices for a stock, as well as the volume and last trade price in real time. Returns Company Quote Function: =fmpQuote(symbol: string, limit: number, headers: string)

1 =fmpQuote("AAPL")
FmpQuote

FmpQuoteShort

Get a simple quote for a stock, including the price, change, and volume. This endpoint can be used to get a quick snapshot of a stock's performance or to calculate its valuation. Returns Real-time stock price Function: =fmpQuoteShort(symbol: string, headers: string)

1 =fmpQuoteShort("AAPL")
FmpQuoteShort

FmpQuotes

This endpoint gives you the latest bid and ask prices for a stock, as well as the volume and last trade price in real time. Returns All Real-time stock price Function: =fmpQuotes(exchange: string, headers: string)

1 =fmpQuotes("NYSE")
FmpQuotes

FmpHistoricalChart

Returns Stock Historical Price Function: =fmpHistoricalChart(symbol: string, time: string, from: date_or_string, to: date_or_string, headers: string)

1 =fmpHistoricalChart("AAPL","4hour", TODAY()-1)
FmpHistoricalChart

FmpHistoricalPriceFull

Returns Daily Stock historical prices with change and volume Function: =fmpHistoricalPriceFull(symbol: string, from: date_or_string, to: date_or_string, timeseries: number, serietype: string, headers: string)

1 =fmpHistoricalPriceFull("AAPL",TODAY()-1)
FmpHistoricalPriceFull

FmpHistoricalPriceFullStockDividend

Returns Stock Daily historical dividend prices Function: =fmpHistoricalPriceFullStockDividend(symbol: string, from: date_or_string, to: date_or_string, headers: string)

1 =fmpHistoricalPriceFullStockDividend("AAPL","2021-08-06","2021-08-06")
FmpHistoricalPriceFullStockDividend

FmpHistoricalPriceFullStockSplit

Returns Stock Daily historical splits Function: =fmpHistoricalPriceFullStockSplit(symbol: string, from: date_or_string, to: date_or_string, headers: string)

1 =fmpHistoricalPriceFullStockSplit("AAPL","2020-08-31","2020-08-31")
FmpHistoricalPriceFullStockSplit

FmpHistoricalPriceFullV4

Returns Survivorship Bias Free end of day Function: =fmpHistoricalPriceFullV4(symbol: string, date: date_or_string, headers: string)

1 =fmpHistoricalPriceFullV4("AAPL","2020-08-31")
FmpHistoricalPriceFullV4

FmpMarketRiskPremium

Provides the market risk premium for a given date. Provides the market risk premium for a given date. Function: =fmpMarketRiskPremium(headers: string)

1 =fmpMarketRiskPremium()
FmpMarketRiskPremium

FmpFullQuoteCommodities

Provides a list of all quotes for all commodities that are traded on exchanges around the world. Provides a list of all quotes for all commodities that are traded on exchanges around the world. Function: =fmpFullQuoteCommodities(headers: string)

1 =fmpFullQuoteCommodities()
FmpFullQuoteCommodities

FmpFullQuoteForex

Provides a full quote for a specific currency pair.A complete quote comprises the current exchange rate for the currency pair, along with daily high, low, and open rates, the spread, and trading volume for the day. Provides a list of all quotes for all currency pairs that are traded on the forex market. Function: =fmpFullQuoteForex(headers: string)

1 =fmpFullQuoteForex()
FmpFullQuoteForex

FmpFullQuoteCrypto

Provides a quote for a specific cryptocurrency. Provides a list of all quotes for all cryptocurrencies that are traded on exchanges around the world. Function: =fmpFullQuoteCrypto(headers: string)

1 =fmpFullQuoteCrypto()
FmpFullQuoteCrypto

FmpQuoteOrder

This endpoint gives you a simplified view of a stock's quote, including the current price, volume, and last trade price. Returns Simplified view of a stock's quote, including the current price, volume, and last trade price. Function: =fmpQuoteOrder(symbol: string, headers: string)

1 =fmpQuoteOrder("AAPL")
FmpQuoteOrder

FmpOTCQuote

This endpoint gives you the latest bid and ask prices for an over-the-counter (OTC) stock, as well as the volume and last trade price in real time. Returns The latest bid and ask prices for an over-the-counter (OTC) stock, as well as the volume and last trade price in real time. Function: =fmpOTCQuote(symbol: string, headers: string)

1 =fmpOTCQuote("BATRB")
FmpOTCQuote

FmpStockPriceChange

This endpoint gives you the change in a stock's price over a given period of time. Returns The change in a stock's price over a given period of time. Function: =fmpStockPriceChange(symbol: string, headers: string)

1 =fmpStockPriceChange("AAPL")
FmpStockPriceChange

FmpAftermarketTrade

This endpoint gives you information on trades that have occurred in the aftermarket. Returns Information on trades that have occurred in the aftermarket. Function: =fmpAftermarketTrade(symbol: string, headers: string)

1 =fmpAftermarketTrade("AAPL")
FmpAftermarketTrade

FmpAftermarketQuote

This endpoint gives you the latest bid and ask prices for a stock in the aftermarket. Returns The latest bid and ask prices for a stock in the aftermarket. Function: =fmpAftermarketQuote(symbol: string, headers: string)

1 =fmpAftermarketQuote("AAPL")
FmpAftermarketQuote

fund holdings

FmpTechnicalIndicator

Returns Technical Indicators Function: =fmpTechnicalIndicator(symbol: string, time: string, from: date_or_string, to: date_or_string, period, type: string, headers: string)

1 =fmpTechnicalIndicator("AAPL","daily",TODAY())
FmpTechnicalIndicator

FmpEtfHolder

The FMP ETF Holder endpoint provides a list of all the institutional investors that own shares of an ETF. For example, an investor may want to know which institutions are buying or selling shares of a particular ETF. Returns ETF Holders Function: =fmpEtfHolder(symbol: string, headers: string)

1 =fmpEtfHolder("SPY")
FmpEtfHolder

FmpInstitutionalHolder

Provides a list of all institutional investment managers that are required to file Form 13F reports. Returns Institutional holders of a company Function: =fmpInstitutionalHolder(symbol: string, headers: string)

1 =fmpInstitutionalHolder("AAPL")
FmpInstitutionalHolder

FmpMutualFundHolder

The FMP Mutual Funds endpoint provides a list of all the mutual funds that are registered with the Securities and Exchange Commission (SEC). This information can be used by investors to identify potential investment opportunities. For example, an investor who is interested in investing in the technology sector may want to browse the list of mutual funds that track the S&P 500 index. Returns Mutual Fund Holders of a company Function: =fmpMutualFundHolder(symbol: string, headers: string)

1 =fmpMutualFundHolder("AAPL")
FmpMutualFundHolder

FmpEtfSectorWeightings

The FMP ETF Sector Weighting endpoint provides a breakdown of the percentage of an ETF's assets that are invested in each sector. For example, an investor may want to invest in an ETF that has a high exposure to the technology sector if they believe that the technology sector is poised for growth. Returns ETF Sector Weightings Function: =fmpEtfSectorWeightings(symbol: string, headers: string)

1 =fmpEtfSectorWeightings("SPY")
FmpEtfSectorWeightings

FmpEtfCountryWeighting

The FMP ETF Country Weighting endpoint provides a breakdown of the percentage of an ETF's assets that are invested in each country. For example, an investor may want to invest in an ETF that has a high exposure to China if they believe that the Chinese economy is poised for growth. Returns ETF Country Weightings Function: =fmpEtfCountryWeightings(symbol: string, headers: string)

1 =fmpEtfCountryWeightings("SPY")
FmpEtfCountryWeighting

FmpCikList

Our CIK List provides a comprehensive database of CIK numbers for SEC-registered entities. A CIK number is a unique identifier assigned to each SEC-registered entity, and it is required for many financial transactions. Our CIK List is a valuable resource for businesses and individuals who need to quickly and easily find CIK numbers. Returns Complete list of all institutional investment managers by cik Function: =fmpCikList(headers: string)

1 =fmpCikList()
FmpCikList

FmpCikSearch

Quickly find registered company names linked to SEC-registered entities using their CIK Number with our CIK Search.. Returns FORM 13F cik search by name Function: =fmpCikSearch(name: string, headers: string)

1 =fmpCikSearch("apple")
FmpCikSearch

FmpCik

Returns FORM 13F get company name by cik Function: =fmpCik(cik: string, headers: string)

1 =fmpCik("0001694461")
FmpCik

FmpFormThirteen

Provides quarterly reports on the equity holdings of institutional investment managers with over $100 million in assets under management. Returns FORM 13F statements Function: =fmpFormThirteen(cik: string, date: string, headers: string)

1 =fmpFormThirteen("0001067983")
FmpFormThirteen

FmpFormThirteenDate

Provides the dates on which Form 13F reports are filed. Returns 13F Filings Dates by cik Function: =fmpFormThirteenDate(cik: string, headers: string)

1 =fmpFormThirteenDate("0001067983")
FmpFormThirteenDate

FmpCusip

Access information about financial instruments and securities by simply entering their unique CUSIP (Committee on Uniform Securities Identification Procedures) numbers with our CUSIP Search.. Returns Cusip mapper Function: =fmpCusip(cusip: string, headers: string)

1 =fmpCusip("000360206")
FmpCusip

stock list

FmpCusipila

Returns Cusip mapper Function: =fmpCusip(cusip: string, headers: string)

1 =fmpCusip("000360206")
FmpCusipila

FmpStockList

Returns All Companies ticker symbols available in FMP Function: =fmpStockList(headers: string)

1 =fmpStockList()
FmpStockList

FmpAvailableTradedList

Returns All tradable Symbols Function: =fmpAvailableTradedList(headers: string)

1 =fmpAvailableTradedList()
FmpAvailableTradedList

bulk and batch

FmpEtfList

Returns All ETF symbols Function: =fmpEtfList(headers: string)

1 =fmpEtfList()
FmpEtfList

FmpBatchRequestEndOfDayPrices

Batch request that contains all end of day prices for specific date Returns Financials Statements SEC ZIP https://financialmodelingprep.com/api/v4/batch-historical-eod?source=sheets Function: =fmpBatchRequestEndOfDayPrices(date: date_or_string)

1 =fmpBatchRequestEndOfDayPrices()

FmpIncomeStatementBulk

All quarter or annual Income Statements for specific year Returns Financials Statements SEC ZIP https://financialmodelingprep.com/api/v4/income-statement-bulk?year=2024&period=annual&source=sheets Function: =fmpIncomeStatementBulk(year: date_or_string, period: string)

1 =fmpIncomeStatementBulk()

FmpBalanceSheetStatementBulk

All quarter or annual Balance Sheet Statements for specific year Returns All quarter or annual Balance Sheet Statements for specific year https://financialmodelingprep.com/api/v4/balance-sheet-statement-bulk?year=2024&period=annual&source=sheets Function: =fmpBalanceSheetStatementBulk(year: date_or_string, period: string)

1 =fmpBalanceSheetStatementBulk()

FmpCashFlowStatementBulk

All quarter or annual Cash Flow Statements for specific year Returns All quarter or annual Cash Flow Statements for specific year https://financialmodelingprep.com/api/v4/cash-flow-statement-bulk?year=2024&period=annual&source=sheets Function: =fmpCashFlowStatementBulk(year: date_or_string, period: string)

1 =fmpCashFlowStatementBulk()

FmpRatiosBulk

All quarter or annual Ratios for specific year Returns All quarter or annual Ratios for specific year https://financialmodelingprep.com/api/v4/ratios-bulk?year=2024&period=annual&source=sheets Function: =fmpRatiosBulk(year: date_or_string, period: string)

1 =fmpRatiosBulk()

FmpKeyMetricsBulk

All quarter or annual Key Metrics for specific year Returns All quarter or annual Key Metrics for specific year https://financialmodelingprep.com/api/v4/key-metrics-bulk?year=2024&period=annual&source=sheets Function: =fmpKeyMetricsBulk(year: date_or_string, period: string)

1 =fmpKeyMetricsBulk()

FmpEarningsSurprisesBulk

All Earning Surprises for specific year Returns All Earning Surprises for specific year https://financialmodelingprep.com/api/v4/earnings-surprises-bulk?year=2024&source=sheets Function: =fmpEarningsSurprisesBulk(year: date_or_string)

1 =fmpEarningsSurprisesBulk()

FmpBulkStockPeers

Stock peers for all symbols with profile Stock peers for all symbols with profile Function: =fmpBulkStockPeers(headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkStockPeers()
FmpBulkStockPeers

FmpBulkRatings

All latest company ratings. All latest company ratings. Function: =fmpBulkRatings(headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkRatings(,0,10)
FmpBulkRatings

FmpAllLatestDcf

All latest DCF Function: =fmpAllLatestDcf(headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpAllLatestDcf(,0,2)
FmpAllLatestDcf

FmpBulkKeyMetricsTtm

Key Metrics TTM for every stock Key Metrics TTM for every stock Function: =fmpBulkKeyMetricsTtm(headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkKeyMetricsTtm(,0,2)
FmpBulkKeyMetricsTtm

FmpBulkRatioTtm

Ratios TTM for every stock Ratios TTM for every stock Function: =fmpBulkRatioTtm(headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkRatioTtm(,0,2)
FmpBulkRatioTtm

FmpBulkScores

All stock financial scores All stock financial scores Function: =fmpBulkScores(headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkScores(,0,2)
FmpBulkScores

FmpBulkFinancialGrowth

All quarter or annual growth entries for specific year All quarter or annual growth entries for specific year Function: =fmpBulkFinancialGrowth(year: string_or_number, period: string, headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkFinancialGrowth(2020,"annual",,0,2)
FmpBulkFinancialGrowth

FmpBulkIncomeStatementsGrowth

All quarter or annual Income Statements Growth for specific year All quarter or annual Income Statements Growth for specific year Function: =fmpBulkIncomeStatementsGrowth(year: string_or_number, period: string, headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkIncomeStatementsGrowth(2020,"annual",,0,2)
FmpBulkIncomeStatementsGrowth

FmpBulkBalanceSheetGrowth

All quarter or annual Balance Sheet Statements Growth for specific year All quarter or annual Balance Sheet Statements Growth for specific year Function: =fmpBulkBalanceSheetGrowth(year: string_or_number, period: string, headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkBalanceSheetGrowth(2020,"annual",,0,2)
FmpBulkBalanceSheetGrowth

FmpBulkCashFlowStatementsGrowth

All quarter or annual Cash Flow Statements Growth for specific year All quarter or annual Cash Flow Statements Growth for specific year Function: =fmpBulkCashFlowStatementsGrowth(year: string_or_number, period: string, headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkCashFlowStatementsGrowth(2020,"annual",,0,2)
FmpBulkCashFlowStatementsGrowth

FmpBulkPriceTargetSummary

Price target summary for every stocks Price target summary for every stocks Function: =fmpBulkPriceTargetSummary(headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkPriceTargetSummary(,0,2)
FmpBulkPriceTargetSummary

FmpBulkUpgradesDowngradesConsensus

Upgrades downgrades consensus for every stock Upgrades downgrades consensus for every stock Function: =fmpBulkUpgradesDowngradesConsensus(headers: string, linesFrom: string, linesTo: string, linesNo: string)

1 =fmpBulkUpgradesDowngradesConsensus(,0,2)
FmpBulkUpgradesDowngradesConsensus

market indexes

FmpProfileAll

It contains all profiles from our API in one CSV file Returns It conains all profiles from our API in one CSV file https://financialmodelingprep.com/api/v4/profile/all?source=sheets Function: =fmpProfileAll()

1 =fmpProfileAll()

FmpSp500Constituent

Provides a list of all companies that are included in the S&P 500 index. Returns All S&P 500 constituents Function: =fmpSp500Constituent(datatype: string, headers: Object)

1 =fmpSp500Constituent()
FmpSp500Constituent

FmpHistoricalSp500Constituent

Provides historical data for all companies that are included in the S&P 500 index. Returns Historical S&P 500 constituents List Function: =fmpHistoricalSp500Constituent()

1 =fmpHistoricalSp500Constituent()
FmpHistoricalSp500Constituent

FmpNasdaqConstituent

Provides a list of all companies that are listed on the NASDAQ stock exchange. Returns All Nasdaq 100 constituents Function: =fmpNasdaqConstituent(datatype: string, headers: Object)

1 =fmpNasdaqConstituent()
FmpNasdaqConstituent

FmpDowjonesConstituent

Provides a list of all companies that are included in the Dow Jones Industrial Average. Returns All Dow Jones constituents Function: =fmpDowjonesConstituent(datatype: string, headers: Object)

1 =fmpDowjonesConstituent()
FmpDowjonesConstituent

FmpHistoricalDowjonesConstituent

Returns Historical Dow Jones constituents List Function: =fmpHistoricalDowjonesConstituent()

1 =fmpHistoricalDowjonesConstituent()
FmpHistoricalDowjonesConstituent

FmpSymbol

Find symbols for traded and non-traded stocks with our Symbol List. This comprehensive list includes over 80,000 stocks, making it the perfect resource for investors and traders of all levels. Returns All Real-time stock price Function: =fmpSymbol(available: string, headers: string)

1 =fmpSymbol("available-indexes")
FmpSymbol

FmpHistoricalNasdaqConstituents

Provides historical data for all companies that are listed on the NASDAQ stock exchange. Provides historical data for all companies that are listed on the NASDAQ stock exchange. Function: =fmpHistoricalNasdaqConstituents(headers: string)

1 =fmpHistoricalNasdaqConstituents()
FmpHistoricalNasdaqConstituents

FmpRevenueProductSegmentation

Provides a breakdown of a company's revenue by product category. Provides a breakdown of a company's revenue by product category. Function: =fmpRevenueProductSegmentation(symbol: string, period: string, headers: string)

1 =fmpRevenueProductSegmentation("AAPL","quarter")
FmpRevenueProductSegmentation

FmpRevenueGeoSegmentation

Provides a breakdown of a company's revenue by geographic region. Provides a breakdown of a company's revenue by geographic region. Function: =fmpRevenueGeoSegmentation(symbol: string, period: string, headers: string)

1 =fmpRevenueGeoSegmentation("AAPL","annual")
FmpRevenueGeoSegmentation

quotes

FmpFx

This endpoint gives you a list of all foreign exchange (FX) prices. Returns Forex Currency Exchange Rate (FX) Function: =fmpFx(pair: string, headers: string)

1 =fmpFx("EURUSD")
FmpFx

company information

FmpSearchName

Find ticker symbols and exchange information for equity securities and exchange-traded funds (ETFs) by searching with the company name. Returns Find ticker symbols and exchange information Function: =fmpSearchName(query: string, limit: number, exchange: string, headers: string)

1 =fmpSearchName("META",1,"NASDAQ")
FmpSearchName

FmpSymbolChange

Stay up-to-date on the latest symbol changes with our easy-to-use tool. Track symbol changes due to mergers, acquisitions, stock splits, and name changes. Returns Track symbol changes due to mergers, acquisitions, stock splits, and name changes Function: =fmpSymbolChange(headers: string)

1 =fmpSymbolChange()
FmpSymbolChange

FmpExecutiveCompensation

Understand how a company compensates its executives with our Executive Compensation endpoint. This endpoint provides information such as salary, bonus, and stock options for each executive. Returns Salary, bonus, and stock options for each executive. Function: =fmpExecutiveCompensation(symbol: string, headers: string)

1 =fmpExecutiveCompensation("AAPL")
FmpExecutiveCompensation

FmpExecutiveCompensationBenchmark

Compare a company's executive compensation to other companies in the same industry with our Compensation Benchmark endpoint. This endpoint can help you understand how competitive a company's executive compensation is. Returns Compare a company's executive compensation to other companies Function: =fmpExecutiveCompensationBenchmark(year: string, headers: string)

1 =fmpExecutiveCompensationBenchmark(2022)
FmpExecutiveCompensationBenchmark

FmpCompanyNotes

Stay up-to-date on a company's financial condition, operations, and risks with our Company Notes endpoint. This endpoint provides information about notes reported by a company in their financial statements. Returns Notes reported by a company in their financial statements. Function: =fmpCompanyNotes(symbol: string, headers: string)

1 =fmpCompanyNotes("AAPL")
FmpCompanyNotes

FmpHistoricalEmployee

Track how a company's workforce has grown or shrunk over time with our Historical Employees endpoint. This endpoint provides historical data about the number of employees in a company. Returns Historical data about the number of employees in a company. Function: =fmpHistoricalEmployee(symbol: string, headers: string)

1 =fmpHistoricalEmployee("AAPL")
FmpHistoricalEmployee

FmpEmployeeCount

Get the current number of employees in a company with our Employee Count endpoint. This endpoint can help you understand the size of a company's workforce and compare it to other companies. Returns Get the current number of employees in a company Function: =fmpEmployeeCount(symbol: string, headers: string)

1 =fmpEmployeeCount("AAPL")
FmpEmployeeCount

FmpCompanyCoreInformation

Verify a company's identity or find additional information about a company with our Company Core Information summary endpoint. This endpoint provides core information such as CIK, exchange, and address. Returns Verify a company's identity or find additional information about a company Function: =fmpCompanyCoreInformation(symbol: string, headers: string)

1 =fmpCompanyCoreInformation("AAPL")
FmpCompanyCoreInformation

FmpAnalystRecommendation

The FMP Analyst Recommendation endpoint provides analyst recommendations for buying, selling, or holding a company's stock. Investors can use this information to get a sense of what analysts think of a company's stock and to make informed investment decisions. Returns Analyst recommendations for buying, selling, or holding a company's stock. Function: =fmpAnalystRecommendation(symbol: string, headers: string)

1 =fmpAnalystRecommendation("AAPL")
FmpAnalystRecommendation

FmpHistoricalShareFloat

The FMP Historical Share Float endpoint provides historical data on the number of shares that are publicly traded for a given company. This is also known as the company's float. The float is calculated by subtracting the number of restricted shares from the total number of outstanding shares. Returns Historical data on the number of shares that are publicly traded for a given company. Function: =fmpHistoricalShareFloat(symbol: string, headers: string)

1 =fmpHistoricalShareFloat("AAPL")
FmpHistoricalShareFloat

bulk and batch

FmpBatchQuote

This endpoint gives you quotes for multiple stocks at once. Returns Quotes for multiple stocks at once. Function: =fmpBatchQuote(symbol: string, headers: string)

1 =fmpBatchQuote("AAPL")
FmpBatchQuote

FmpBatchTrade

This endpoint gives you trades for multiple stocks at once. Returns To place trades for multiple stocks at once. Function: =fmpBatchTrade(symbol: string, headers: string)

1 =fmpBatchTrade("AAPL,GOOG")
FmpBatchTrade

quotes

FmpLastForex

This endpoint gives you the latest price for a currency pair. Returns The latest bid and ask prices for a currency pair. Function: =fmpLastForex(symbol: string, headers: string)

1 =fmpLastForex("EURUSD")
FmpLastForex

FmpLastCrypto

This endpoint gives you the latest price for a cryptocurrency. Returns The latest price for a cryptocurrency. Function: =fmpLastCrypto(symbol: string, headers: string)

1 =fmpLastCrypto("btcusd")
FmpLastCrypto

FmpRealtimePrice

This endpoint gives you a list of all real-time full stock prices. Returns The latest price for a stock, ETF, mutual fund, or cryptocurrency. Function: =fmpRealtimePrice(symbol: string, headers: string)

1 =fmpRealtimePrice("AAPL")
FmpRealtimePrice

FmpLiveFullPrice

This endpoint gives you the latest bid and ask prices for a stock, as well as the volume and last trade price, in real time. Returns The latest bid and ask prices for a stock, as well as the volume and last trade price, in real time. Function: =fmpLiveFullPrice(symbol: string, headers: string)

1 =fmpLiveFullPrice("AAPL")
FmpLiveFullPrice

stock fundamentals

FmpCashflowGrowth

Get the cash flow growth rate for a company. Measure how quickly a company's cash flow is growing. Returns The cash flow growth rate for a company. Function: =fmpCashflowGrowth(symbol: string, limit: number, period: string, headers: string)

1 =fmpCashflowGrowth("AAPL",1,"quarter")
FmpCashflowGrowth

FmpBalanceSheetGrowth

Get the balance sheet growth rate for a company. Measure how quickly a company's assets and liabilities are growing. Returns The balance sheet growth rate for a company. Function: =fmpBalanceSheetGrowth(symbol: string, limit: number, period: string, headers: string)

1 =fmpBalanceSheetGrowth("AAPL",1,"annual")
FmpBalanceSheetGrowth

FmpFinancialScore

Financial Growth Get the financial growth rate for a company. Measure how quickly a company's overall financial performance is improving. Returns A financial score for a company Function: =fmpFinancialScore(symbol: string, headers: string)

1 =fmpFinancialScore("AAPL")
FmpFinancialScore

FmpOwnerEarnings

Get the owner earnings for a company, which is a measure of its profitability after accounting for all expenses, including taxes and debt payments. Assess a company's true profitability and compare it to its competitors. Returns The owner earnings for a company including taxes and debt payments. Function: =fmpOwnerEarnings(symbol: string, headers: string)

1 =fmpOwnerEarnings("AAPL")
FmpOwnerEarnings

FmpDiscountedCashflow

Get the discounted cash flow (DCF) valuation for a company, a method to estimate the value of an investment based on its expected future cash flows. Returns The discounted cash flow (DCF) valuation for a company. Function: =fmpDiscountedCashflow(symbol: string, headers: string)

1 =fmpDiscountedCashflow("AAPL")
FmpDiscountedCashflow

FmpAdvancedDCF

Calculate the DCF valuation for a company with advanced features like modeling multiple scenarios and using different valuation methods. Returns The DCF valuation for a company with advanced features like modeling multiple scenarios and using different valuation methods. Function: =fmpAdvancedDCF(symbol: string, headers: string)

1 =fmpAdvancedDCF("AAPL")
FmpAdvancedDCF

FmpLeveredDCF

Get the DCF valuation for a company, taking into account its debt levels. Returns Get the DCF valuation for a company, taking into account its debt levels. Function: =fmpLeveredDCF(symbol: string, headers: string)

1 =fmpLeveredDCF("AAPL")
FmpLeveredDCF

market performance

FmpPriceTarget

Get the price target for a company, which is the price at which an analyst believes the company's stock is fairly valued. Price targets can be used to make investment decisions, such as whether to buy, sell, or hold a stock. Returns Get the price target for a company, which is the price at which an analyst believes the company's stock is fairly valued. Function: =fmpPriceTarget(symbol: string, headers: string)

1 =fmpPriceTarget("AAPL")
FmpPriceTarget

FmpPriceTargetSummary

Get a summary of the price targets for a company from different analysts. This summary includes the average price target, the high price target, and the low price target. Returns Get a summary of the price targets for a company from different analysts. Function: =fmpPriceTargetSummary(symbol: string, headers: string)

1 =fmpPriceTargetSummary("AAPL")
FmpPriceTargetSummary

FmpPriceTargetByName

Get the price targets for a company from a specific analyst. This can be useful if you want to track the price targets of a particular analyst that you trust. Returns Get the price targets for a company from a specific analyst. Function: =fmpPriceTargetByName(name: string, headers: string)

1 =fmpPriceTargetByName("Tim Anderson")
FmpPriceTargetByName

FmpPriceTargetByCompany

Get the price targets for all companies in a specific industry or sector. This can be useful if you want to compare the price targets of different companies in the same industry. Get the price targets for all companies in a specific industry or sector. Function: =fmpPriceTargetByCompany(company: string, headers: string)

1 =fmpPriceTargetByCompany("Barclays")
FmpPriceTargetByCompany

FmpPriceTargetConsensus

Get the consensus price target for a company, which is the average of all price targets from different analysts. This can be useful if you want to get a general idea of what analysts think about a company's stock. Get the consensus price target for a company, which is the average of all price targets from different analysts. Function: =fmpPriceTargetConsensus(symbol: string, headers: string)

1 =fmpPriceTargetConsensus("AAPL")
FmpPriceTargetConsensus

FmpPriceTargetRSSFeed

Get an RSS feed of price target updates for a company. This way, you can stay up-to-date on the latest price targets from analysts. Get an RSS feed of price target updates for a company. Function: =fmpPriceTargetRSSFeed(page: string, headers: string)

1 =fmpPriceTargetRSSFeed(1)
FmpPriceTargetRSSFeed

FmpUpgradesDowngrades

Get a comprehensive list of all stock upgrades and downgrades from different analysts, including the rating change, the analyst firm, and the date of the rating change. This information can be used to identify potential investment opportunities and assess the risk of current investments. Subscribe to an RSS feed of all stock upgrades and downgrades from different analysts. This RSS feed is updated on a daily basis. Function: =fmpUpgradesDowngrades(page: number, headers: string)

1 =fmpUpgradesDowngrades(2)
FmpUpgradesDowngrades

FmpUpgradesDowngradesConsensus

Get the consensus rating for a company, which is the average rating from different analysts. This information can be used to get a general idea of what analysts think about a company's stock and to make more informed investment decisions. Get the consensus rating for a company, which is the average rating from different analysts. Function: =fmpUpgradesDowngradesConsensus(symbol: string, headers: string)

1 =fmpUpgradesDowngradesConsensus("AAPL")
FmpUpgradesDowngradesConsensus

FmpUpgradesDowngradesByCompany

Get a comprehensive list of all stock upgrades and downgrades for a specific company, including the rating change, the analyst firm, and the date of the rating change. This information can be used to track analyst sentiment for a company and to identify potential investment opportunities or risks. Get a comprehensive list of all stock upgrades and downgrades for a specific company, including the rating change, the analyst firm, and the date of the rating change. Function: =fmpUpgradesDowngradesByCompany(company: string, headers: string)

1 =fmpUpgradesDowngradesByCompany("Barclay")
FmpUpgradesDowngradesByCompany

stock-news

FmpArticlesV3

FMP articles v3 Function: =fmpArticlesV3(page: number, size: number, headers: string)

1 =fmpArticlesV3(1,1)
FmpArticlesV3

FmpArticlesInfoV3

FMP articles v3 information Function: =fmpArticlesInfoV3(page: number, size: number, headers: string)

1 =fmpArticlesInfoV3(1,1)
FmpArticlesInfoV3

FmpGeneralNews

Get a list of the latest general news articles from a variety of sources, including the headline, snippet, and publication URL. Function: =fmpGeneralNews(page: number, headers: string)

1 =fmpGeneralNews(1)
FmpGeneralNews

FmpStockNewsSentiments

Get a list of the latest Stock News articles from a variety of sources, including the headline, snippet, publication URL, and ticker symbol. Get an RSS feed of the latest Stock News articles with their sentiment analysis, including the headline, snippet, publication URL, ticker symbol, and sentiment score. Function: =fmpStockNewsSentiments(page: number, headers: string)

1 =fmpStockNewsSentiments(0)
FmpStockNewsSentiments

FmpForexNews

Get a list of the latest forex news articles from a variety of sources, including the headline, snippet, and publication URL Get a list of the latest forex news articles from a variety of sources, including the headline, snippet, and publication URL. Function: =fmpForexNews(page: number, symbol: string, headers: string)

1 =fmpForexNews(0,"EURUSD")
FmpForexNews

FmpCryptoNews

Get a list of the latest crypto news articles from a variety of sources, including the headline, snippet, and publication URL. (Note: This endpoint requires the symbol in the format of BTCUSD to be passed in as a query parameter.) Get a list of the latest crypto news articles from a variety of sources, including the headline, snippet, and publication URL. Function: =fmpCryptoNews(page: number, symbol: string, headers: string)

1 =fmpCryptoNews(0,"BTCUSD")
FmpCryptoNews

FmpHistoricalSocialSentiment

Provides historical social sentiment data for a given ticker or company name. Provides historical social sentiment data for a given ticker or company name. Function: =fmpHistoricalSocialSentiment(symbol: string, page: number, headers: string)

1 =fmpHistoricalSocialSentiment("AAPL",0)
FmpHistoricalSocialSentiment

FmpTrendingSocialSentiment

Provides trending social sentiment data for a given ticker or company name. Provides trending social sentiment data for a given ticker or company name. Function: =fmpTrendingSocialSentiment(type: string, source: number, headers: string)

1 =fmpTrendingSocialSentiment("bullish","stocktwits")
FmpTrendingSocialSentiment

FmpSocialSentimentChanges

Provides changes in social sentiment data for a given ticker or company name over a period of time. Provides changes in social sentiment data for a given ticker or company name over a period of time. Function: =fmpSocialSentimentChanges(type: string, source: number, headers: string)

1 =fmpSocialSentimentChanges("bullish","stocktwits")
FmpSocialSentimentChanges

fund holdings

FmpTranscriptDates

Get a list of all upcoming earnings call dates for a specific company. This endpoint can be used to plan your trading activity around earnings call dates. Get a list of all upcoming earnings call dates for a specific company. Function: =fmpTranscriptDates(symbol: string, headers: string)

1 =fmpTranscriptDates("AAPL")
FmpTranscriptDates

FmpBatchEarningCallTranscript

Batch Earning Call Transcript Function: =fmpBatchEarningCallTranscript(symbol: string, year: number, headers: string)

1 =fmpBatchEarningCallTranscript("AAPL",2020)
FmpBatchEarningCallTranscript

FmpRssFeed8k

A real-time feed of 8-K SEC filings from publicly traded companies. Function: =fmpRssFeed8k(page: number, from: date_or_string, to: date_or_string, hasFinancial: boolean, limit: number, headers: string)

1 =fmpRssFeed8k(0,"2024-03-08","2024-03-08",TRUE,1)
FmpRssFeed8k

FmpIndustryClassificationAll

Get a comprehensive overview of all industries, classified according to the SIC system. Get a comprehensive overview of all industries, classified according to the SIC system. Function: =fmpIndustryClassificationAll(headers: string)

1 =fmpIndustryClassificationAll()
FmpIndustryClassificationAll

FmpSharesFloatAll

The number of shares available for trading, this includes Restricted Stock Units (RSUs) The number of shares available for trading, this includes Restricted Stock Units (RSUs) Function: =fmpSharesFloatAll(headers: string)

1 =fmpSharesFloatAll()
FmpSharesFloatAll

FmpEarningsConfirmed

A list of earnings announcements for publicly traded companies that have already been confirmed. A list of earnings announcements for publicly traded companies that have already been confirmed. Function: =fmpEarningsConfirmed(from: date_or_string, to: date_or_string, limit: number, headers: string)

1 =fmpEarningsConfirmed("2023-06-01","2023-06-11",1)
FmpEarningsConfirmed

FmpIpoConfirmed

The FMP IPO Confirmed endpoint provides a list of IPOs that have been confirmed and are scheduled to take place in the near future. A list of IPOs that have been confirmed and are scheduled to take place in the near future. Function: =fmpIpoConfirmed(from: date_or_string, to: date_or_string, headers: string)

1 =fmpIpoConfirmed("2024-03-05","2024-03-06")
FmpIpoConfirmed

FmpIpoProspectus

The FMP IPO Prospectus endpoint provides a link to the IPO prospectus for a given company. The IPO prospectus is a legal document that provides detailed information about the company, its IPO, and its securities. A link to the IPO prospectus for a given company. Function: =fmpIpoProspectus(from: date_or_string, to: date_or_string, headers: string)

1 =fmpIpoProspectus("2024-02-02","2024-02-05")
FmpIpoProspectus

FmpMergersAcquisitionsRssFeed

The FMP M&A RSS Feed provides investors, analysts, and other market participants with a real-time stream of M&A news and announcements. The FMP M&A RSS Feed provides investors, analysts, and other market participants with a real-time stream of M&A news and announcements. Function: =fmpMergersAcquisitionsRssFeed(page: number, headers: string)

1 =fmpMergersAcquisitionsRssFeed(1)
FmpMergersAcquisitionsRssFeed

FmpMergersAcquisitionsSearch

The FMP Search M&A endpoint allows users to search for M&A deals based on a variety of criteria, Users can also specify a date range to search for M&A deals that were announced during that period. The FMP Search M&A endpoint allows users to search for M&A deals based on a variety of criteria, Users can also specify a date range to search for M&A deals that were announced during that period. Function: =fmpMergersAcquisitionsSearch(name: string, headers: string)

1 =fmpMergersAcquisitionsSearch("syros")
FmpMergersAcquisitionsSearch

FmpEtfHoldingDates

The FMP ETF Holding Dates endpoint provides a list of the dates on which ETF holdings are updated. For example, an investor may want to know when an ETF's holdings are updated in order to make sure that they are still aligned with their investment goals. A list of the dates on which ETF holdings are updated. Function: =fmpEtfHoldingDates(symbol: string, cik: number, headers: string)

1 =fmpEtfHoldingDates(,"0000036405")
FmpEtfHoldingDates

FmpEtfHoldings

The FMP ETF Holdings endpoint provides a list of all the securities that are held by an ETF. For example, an investor may want to know which ETF has the highest exposure to a particular industry or sector. A list of the dates on which ETF holdings are updated. Function: =fmpEtfHoldings(symbol: string, cik: number, date: date_or_string, headers: string)

1 =fmpEtfHoldings("SPY",,"2023-09-30")
FmpEtfHoldings

FmpEtfInformation

The FMP ETF Information endpoint provides basic information about an ETF, such as its ticker symbol, name, expense ratio, and asset under management. For example, an investor may want to compare the expense ratios of different ETFs to find the one that is most cost-effective. Basic information about an ETF, such as its ticker symbol, name, expense ratio, and asset under management. Function: =fmpEtfInformation(symbol: string, headers: string)

1 =fmpEtfInformation("SPY")
FmpEtfInformation

FmpEtfSectorExposure

The FMP ETF Sector Exposure endpoint provides a measure of how much of an ETF's performance is attributable to each sector. For example, an investor may want to invest in an ETF that has a high exposure to the technology sector if they believe that the technology sector is likely to outperform the overall market. A measure of how much of an ETF's performance is attributable to each sector. Function: =fmpEtfSectorExposure(symbol: string, headers: string)

1 =fmpEtfSectorExposure("AAPL")
FmpEtfSectorExposure

FmpMutualFundDates

The FMP Mutual Fund Dates endpoint provides a list of the dates on which mutual fund holdings are updated. This information can be used by investors to stay up-to-date on the latest changes to mutual fund portfolios. For example, an investor may want to know when a mutual fund's holdings are updated in order to make sure that they are still aligned with their investment goals. A list of the dates on which mutual fund holdings are updated. Function: =fmpMutualFundDates(symbol: string, cik: number, headers: string)

1 =fmpMutualFundDates(,"0000036405")
FmpMutualFundDates

FmpMutualFunds

The FMP Mutual Funds endpoint provides a list of all the mutual funds that are registered with the Securities and Exchange Commission (SEC). This information can be used by investors to identify potential investment opportunities. For example, an investor who is interested in investing in the technology sector may want to browse the list of mutual funds that track the S&P 500 index. Function: =fmpMutualFunds(symbol: string, date: date_or_string, cik: number, headers: string)

1 =fmpMutualFunds("FXAIX","2023-08-31")
FmpMutualFunds

FmpMutualFundByName

The FMP Mutual Fund By Name endpoint provides detailed information about a specific mutual fund. This information includes the fund's ticker symbol, name, investment objective, expense ratio, and asset under management. Investors can use this information to learn more about a particular mutual fund before deciding whether to invest in it. Detailed information about a specific mutual fund. Function: =fmpMutualFundByName(name: string, headers: string)

1 =fmpMutualFundByName("Vanguard")
FmpMutualFundByName

FmpEsgSearch

Find companies and funds that align with your ESG values with FMP's ESG Search tool. Search by ESG rating, performance, controversies, and business involvement screens. Find companies and funds that align with your ESG values with FMP's ESG Search tool. Function: =fmpEsgSearch(symbol: string, headers: string)

1 =fmpEsgSearch("AAPL")
FmpEsgSearch

FmpEsgRatings

Get ESG ratings for companies and funds to make informed investment decisions. FMP's ESG Ratings are based on a variety of data sources, including corporate sustainability reports, ESG research firms, and government agencies. Get ESG ratings for companies and funds to make informed investment decisions. Function: =fmpEsgRatings(symbol: string, headers: string)

1 =fmpEsgRatings("AAPL")
FmpEsgRatings

FmpEsgBenchmark

Compare the ESG performance of companies and funds to their peers with FMP's ESG Benchmark tool. Identify ESG leaders and laggards to make informed investment decisions. Compare the ESG performance of companies and funds to their peers with FMP's ESG Benchmark tool. Function: =fmpEsgBenchmark(year: string, headers: string)

1 =fmpEsgBenchmark(2024)
FmpEsgBenchmark

FmpSenateTrading

Track the trading activity of US Senators and identify potential conflicts of interest with the FMP Senate Trading endpoint. This endpoint provides a list of all the trades that have been made by US Senators, including the date of the trade, the asset traded, the amount traded, and the price per share. A list of all the trades that have been made by US Senators, including the date of the trade, the asset traded, the amount traded, and the price per share. Function: =fmpSenateTrading(symbol: string, headers: string)

1 =fmpSenateTrading("AAPL")
FmpSenateTrading

FmpSenateTradingRssFeed

Stay up-to-date on the trading activity of US Senators and identify potential conflicts of interest with the FMP Senate Trading RSS Feed. This feed provides real-time updates on all the trades that are made by US Senators, including the same information as the Senate Trading endpoint. Real-time updates on all the trades that are made by US Senators, including the same information as the Senate Trading endpoint. Function: =fmpSenateTradingRssFeed(page: string, headers: string)

1 =fmpSenateTradingRssFeed()
FmpSenateTradingRssFeed

FmpHouseDisclosure

House Disclosure Function: =fmpHouseDisclosure(symbol: string, headers: string)

1 =fmpHouseDisclosure("AAPL")
FmpHouseDisclosure

FmpHouseDisclosureRssFeed

Stay up-to-date on the financial interests of House Representative and identify potential conflicts of interest with the FMP House Disclosure RSS Feed. This feed provides real-time updates on all the financial disclosures that are made by House Representative, including the same information as the House Disclosure endpoint. Real-time updates on all the financial disclosures that are made by House Representative, including the same information as the House Disclosure endpoint. Function: =fmpHouseDisclosureRssFeed(page: number, headers: string)

1 =fmpHouseDisclosureRssFeed()
FmpHouseDisclosureRssFeed

FmpSectorPerformance

The FMP Sector Performance endpoint provides the performance of each sector of the stock market over a specified period of time. This information can be used by investors to identify sectors that are outperforming or underperforming the market. The performance of each sector of the stock market over a specified period of time. Function: =fmpSectorPerformance(headers: string)

1 =fmpSectorPerformance()
FmpSectorPerformance

FmpMarketBiggestGainers

The FMP Market Biggest Gainers endpoint provides a list of the stocks that have gained the most value on a given day. This information can be used by investors to identify stocks that are momentum and to potential investment opportunities. A list of the stocks that have gained the most value on a given day. Function: =fmpMarketBiggestGainers(headers: string)

1 =fmpMarketBiggestGainers()
FmpMarketBiggestGainers

FmpMarketBiggestLosers

The FMP Market Biggest Losers endpoint provides a list of the stocks that have lost the most value on a given day. This information can be used by investors to identify stocks that are underperforming and to potential trading opportunities. A list of the stocks that have lost the most value on a given day. Function: =fmpMarketBiggestLosers(headers: string)

1 =fmpMarketBiggestLosers()
FmpMarketBiggestLosers

FmpMarketMostActive

The FMP Market Most Active endpoint provides a list of the stocks that have the highest trading volume on a given day. This information can be used by investors to identify stocks that are liquid and to potential trading opportunities. A list of the stocks that have the highest trading volume on a given day. Function: =fmpMarketMostActive(headers: string)

1 =fmpMarketMostActive()
FmpMarketMostActive

Fmp13fAssetAllocation

Provides the asset allocation of institutional investment managers, including their holdings of stocks, bonds, and other assets. The asset allocation of institutional investment managers, including their holdings of stocks, bonds, and other assets. Function: =fmp13fAssetAllocation(date: date_or_string, headers: string)

1 =fmp13fAssetAllocation("2021-09-30")
Fmp13fAssetAllocation

Fmp13fAssetAllocation

Provides the dates on which 3F asset allocation data is updated. The asset allocation of institutional investment managers, including their holdings of stocks, bonds, and other assets. Function: =fmp13fAssetAllocation(date: date_or_string, headers: string)

1 =fmp13fAssetAllocation("2021-09-30")
Fmp13fAssetAllocation

FmpInstitutionalHoldersList

Provides a list of all institutional investment managers that are required to file Form 13F reports. A list of all institutional investment managers that are required to file Form 13F reports. fmpInstitutionalHoldersList(headers: string)

1 =fmpInstitutionalHoldersList()
FmpInstitutionalHoldersList

FmpInstitutionalHoldersSearch

Allows users to search for institutional investment managers by name, ticker symbol, or CUSIP number. Institutional investment managers by name, ticker symbol, or CUSIP number. Function: =fmpInstitutionalHoldersSearch(name: string, headers: string)

1 =fmpInstitutionalHoldersSearch("Berkshire Hathaway")
FmpInstitutionalHoldersSearch

FmpPortfolioHoldingsDates

Provides the dates on which portfolio holdings data is updated. Provides the dates on which portfolio holdings data is updated. Function: =fmpPortfolioHoldingsDates(cik: string, headers: string)

1 =fmpPortfolioHoldingsDates("0001067983")
FmpPortfolioHoldingsDates

FmpInstitutionalHolderRss

Provides an RSS feed of institutional holder data. Provides an RSS feed of institutional holder data. Function: =fmpInstitutionalHolderRss(page: number, headers: string)

1 =fmpInstitutionalHolderRss()
FmpInstitutionalHolderRss

FmpInstitutionalStockOwnership

Provides the institutional ownership of individual stocks. Provides the institutional ownership of individual stocks. Function: =fmpInstitutionalStockOwnership(symbol: string, includeCurrentQuarter: string, headers: string)

1 =fmpInstitutionalStockOwnership("AAPL",FALSE)
FmpInstitutionalStockOwnership

FmpStockOwnershipByHolders

Provides the stock ownership of individual holders, including institutional and individual investors. Provides the stock ownership of individual holders, including institutional and individual investors. Function: =fmpStockOwnershipByHolders(symbol: string, date: date_or_string, page: number, headers: string)

1 =fmpStockOwnershipByHolders("AAPL","2021-09-30")
FmpStockOwnershipByHolders

FmpPortfolioHoldingsSummary

Provides a summary of portfolio holdings, including the top holdings, sector allocation, and industry allocation. Provides a summary of portfolio holdings, including the top holdings, sector allocation, and industry allocation. Function: =fmpPortfolioHoldingsSummary(cik: string, page: number, headers: string)

1 =fmpPortfolioHoldingsSummary("0001067983")
FmpPortfolioHoldingsSummary

FmpIndustryOwnershipSummary

Provides a summary of industry ownership, including the top industries and the institutional ownership of each industry. Provides a summary of industry ownership, including the top industries and the institutional ownership of each industry. Function: =fmpIndustryOwnershipSummary(cik: string, date: date_or_string, headers: string)

1 =fmpIndustryOwnershipSummary("0001067983","2023-06-30")
FmpIndustryOwnershipSummary

FmpTransactionTypes

Provides a list of all insider transaction types, such as purchases, sales, and gifts. Provides a list of all insider transaction types, such as purchases, sales, and gifts. Function: =fmpTransactionTypes()

1 =fmpTransactionTypes()
FmpTransactionTypes

FmpInsidersBySymbol

Function: =fmpInsidersBySymbol(symbol: string, headers: string)

1 =fmpInsidersBySymbol("AAPL")
FmpInsidersBySymbol

FmpInsiderTradeStatistics

Provides statistics on insider trading activity, such as the total number of insider trades, the average value of insider trades, and the most popular insider stocks. Provides statistics on insider trading activity, such as the total number of insider trades, the average value of insider trades, and the most popular insider stocks. Function: =fmpInsiderTradeStatistics(symbol: string, headers: string)

1 =fmpInsiderTradeStatistics("AAPL")
FmpInsiderTradeStatistics

FmpCrowdfundingRss

Provides an RSS feed of crowdfunding campaigns, updated in real time. Provides an RSS feed of crowdfunding campaigns, updated in real time. Function: =fmpCrowdfundingRss(page: number, headers: string)

1 =fmpCrowdfundingRss()
FmpCrowdfundingRss

FmpCrowdfundingSearch

Allows users to search for crowdfunding campaigns by company name, campaign name, or platform. Allows users to search for crowdfunding campaigns by company name, campaign name, or platform. Function: =fmpCrowdfundingSearch(name: string, headers: string)

1 =fmpCrowdfundingSearch("enotap")
FmpCrowdfundingSearch

FmpCrowdfundingByCik

Provides a list of all crowdfunding campaigns that have been launched by a particular company. Provides a list of all crowdfunding campaigns that have been launched by a particular company. Function: =fmpCrowdfundingByCik(cik: string, headers: string)

1 =fmpCrowdfundingByCik("0001916078")
FmpCrowdfundingByCik

FmpEquityOfferingRss

Provides an RSS feed of equity offering announcements, updated in real time. Provides an RSS feed of equity offering announcements, updated in real time. Function: =fmpEquityOfferingRss(page: number, headers: string)

1 =fmpEquityOfferingRss()
FmpEquityOfferingRss

FmpEquityOfferingSearch

Allows users to search for equity offerings by company name, offering name, or exchange. Allows users to search for equity offerings by company name, offering name, or exchange. Function: =fmpEquityOfferingSearch(name: string, headers: string)

1 =fmpEquityOfferingSearch("NJOY")
FmpEquityOfferingSearch

FmpEquityOfferingByCik

Provides a list of all equity offerings that have been announced by a particular company. Provides a list of all equity offerings that have been announced by a particular company. Function: =fmpEquityOfferingByCik(cik: string, headers: string)

1 =fmpEquityOfferingByCik("0001547416")
FmpEquityOfferingByCik

FmpTreasuryRates

Provides real-time and historical Treasury rates for all maturities. Provides real-time and historical Treasury rates for all maturities. Function: =fmpTreasuryRates(from: date_or_string, to: date_or_string, headers: string)

1 =fmpTreasuryRates("2023-08-10","2023-10-10")
FmpTreasuryRates

FmpEconomicIndicators

Provides real-time and historical economic data for a variety of economic indicators, such as GDP, unemployment, and inflation. Provides real-time and historical economic data for a variety of economic indicators, such as GDP, unemployment, and inflation. Function: =fmpEconomicIndicators(name: string, headers: string)

1 =fmpEconomicIndicators("GDP")
FmpEconomicIndicators
FMP

FMP

Financial Modeling Prep API provides real time stock price, company financial statements, major index prices, stock historical data, forex real time rate and cryptocurrencies. Financial Modeling Prep stock price API is in real time, the company reports can be found in quarter or annual format, and goes back 30 years in history.
twitterlinkedinfacebookinstagram
2017-2024 © Financial Modeling Prep