Financial Modeling Prep

https://site.financialmodelingprep.com/developer/docs
Admin
Financial Modeling Prep is a comprehensive stock market and financial data API providing real-time...
Tokens:187,759
Snippets:2,013
Trust Score:10
Update:19 hours ago
Show doc for...
Tokens:
Raw
### FMPPRICE: Get all dividend data for a stock

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMPPRICE function with the "dividend" parameter to retrieve all dividend data for a single asset. The example returns ex-date, dividend, adjusted dividend, payment date, and declaration date for Apple (AAPL).

```Excel formula
=FMPPRICE("AAPL", "dividend")
```

--------------------------------

### FMPPRICE: Get stock price on a particular date

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMPPRICE function with a specific date to get the stock price on that date. The example returns the close price for Apple on 01/03/2019.

```Excel formula
=SUM(FMPPRICE("AAPL", "close", , "01/03/2019"))
```

--------------------------------

### FMPPRICE: Get close prices for specific date range

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMPPRICE function with specific start and end dates to retrieve close prices for a single asset. The example returns close prices for Amazon (AMZN) between 01/01/2019 and 01/10/2019.

```Excel formula
=FMPPRICE("AMZN", "close", , "01/01/2019", "01/10/2019")
```

--------------------------------

### FMPPRICE: Get last 30 days of close prices for Apple

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMPPRICE function to retrieve historical close prices for a single asset. The example returns the last 30 days of close prices for Apple (AAPL).

```Excel formula
=FMPPRICE("AAPL", "Close", 30)
```

--------------------------------

### FMPPRICE: Get dividend data for a specific date range

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMPPRICE function with specific dates to retrieve dividend data for a stock. The example returns dividend data for Apple (aapl) between 01/01/2017 and 01/01/2022.

```Excel formula
=FMPPRICE("aapl", "dividend", , "01/01/2017", "01/01/2022")
```

--------------------------------

### GET /stable/quote-short

Source: https://site.financialmodelingprep.com/developer/docs

Quickly access concise forex pair quotes with the Forex Quote Snapshot API. Get a fast look at live currency exchange rates, price changes, and volume in real time.

```APIDOC
## [GET] /stable/quote-short

### Description
Quickly access concise forex pair quotes with the Forex Quote Snapshot API. Get a fast look at live currency exchange rates, price changes, and volume in real time.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/quote-short?symbol=EURUSD

### Parameters
#### Query Parameters
- **symbol** (string) - Required - The currency pair symbol (e.g., EURUSD).

```

--------------------------------

### GET /stable/ipos-prospectus

Source: https://site.financialmodelingprep.com/developer/docs

Access comprehensive information on IPO prospectuses with the FMP IPO Prospectus API. Get key financial details, such as public offering prices, discounts, commissions, proceeds before expenses, and more. This API also provides links to official SEC prospectuses, helping investors stay informed on companies entering the public market.

```APIDOC
## GET /stable/ipos-prospectus

### Description
Access comprehensive information on IPO prospectuses with the FMP IPO Prospectus API. Get key financial details, such as public offering prices, discounts, commissions, proceeds before expenses, and more. This API also provides links to official SEC prospectuses, helping investors stay informed on companies entering the public market.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/ipos-prospectus

### Parameters
No parameters are documented in the source.

```

--------------------------------

### GET /stable/revenue-product-segmentation

Source: https://site.financialmodelingprep.com/developer/docs

Access detailed revenue breakdowns by product line with the Revenue Product Segmentation API. Understand which products drive a company's earnings and get insights into the performance of individual product segments.

```APIDOC
## GET /stable/revenue-product-segmentation

### Description
Access detailed revenue breakdowns by product line with the Revenue Product Segmentation API. Understand which products drive a company's earnings and get insights into the performance of individual product segments.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/revenue-product-segmentation?symbol=AAPL

### Parameters
#### Query Parameters
- **symbol** (string) - Required - The stock symbol (e.g., AAPL).

### Response
#### Success Response (200)
Returns revenue segmentation data by product line.

```

--------------------------------

### GET /stable/available-exchanges

Source: https://site.financialmodelingprep.com/developer/docs

Retrieves a list of supported stock exchanges, providing a comprehensive overview of global exchanges.

```APIDOC
## [GET] https://financialmodelingprep.com/stable/available-exchanges

### Description
Retrieves a list of supported stock exchanges, providing a comprehensive overview of global exchanges.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/available-exchanges

```

--------------------------------

### GET /stable/batch-quote-short

Source: https://site.financialmodelingprep.com/developer/docs

Access real-time, short-form quotes for multiple stocks with the FMP Stock Batch Quote Short API. Get a quick snapshot of key stock data such as current price, change, and volume for several companies in one streamlined request.

```APIDOC
## [GET] /stable/batch-quote-short

### Description
Access real-time, short-form quotes for multiple stocks with the FMP Stock Batch Quote Short API. Get a quick snapshot of key stock data such as current price, change, and volume for several companies in one streamlined request.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/batch-quote-short?symbols=AAPL

### Parameters
#### Query Parameters
- **symbols** (string) - Required - Comma-separated list of stock symbols (e.g., AAPL)

```

--------------------------------

### Get segment revenues for multiple years with FMP

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Retrieves segment revenue data for several fiscal years in one function call using an array of years.

```Excel
=FMP("AAPL", "segment revenues", {2022, 2021, 2020})
```

--------------------------------

### GET /stable/tipranks-analyst-summary

Source: https://site.financialmodelingprep.com/developer/docs

Aggregated rollup of every recommendation a single analyst (expertUID) has issued over a date window. Returns one row with totalRecommendations plus distinctSymbols covered, a recommendation breakdown (buy/hold/sell) and analyst-action breakdown (initiated/maintained/upgraded/downgraded/reiterated/resumed). Also includes the analyst's price-target track record: validPriceTargets and comparedPriceTargets counts, beats vs misses, and return metrics (averageReturn, topReturn, worstReturn). Window defaults to the trailing twelve months.

```APIDOC
## [GET] /stable/tipranks-analyst-summary

### Description
Aggregated rollup of every recommendation a single analyst (expertUID) has issued over a date window. Returns one row with totalRecommendations plus distinctSymbols covered, a recommendation breakdown (buy/hold/sell) and analyst-action breakdown (initiated/maintained/upgraded/downgraded/reiterated/resumed). Also includes the analyst's price-target track record: validPriceTargets and comparedPriceTargets counts, beats vs misses, and return metrics (averageReturn, topReturn, worstReturn). Window defaults to the trailing twelve months.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/tipranks-analyst-summary?expertUID=3c6eb8cf1347a4e5757e628fccb684a93abee587

### Parameters
#### Query Parameters
- **expertUID** (string) - Required - The analyst's expertUID.
- **date range** (string) - Optional - The date window for the summary.

### Response
#### Success Response (200)
Returns a summary object with totalRecommendations, distinctSymbols, recommendation breakdown, analyst-action breakdown, and price-target accuracy stats.

#### Response Example
```json
{
  "expertUID": "3c6eb8cf1347a4e5757e628fccb684a93abee587",
  "totalRecommendations": 10,
  "distinctSymbols": 5,
  "recommendationBreakdown": {
    "buy": 6,
    "hold": 3,
    "sell": 1
  },
  "analystActionBreakdown": {
    "initiated": 2,
    "maintained": 4,
    "upgraded": 1,
    "downgraded": 1,
    "reiterated": 1,
    "resumed": 1
  },
  "validPriceTargets": 8,
  "comparedPriceTargets": 7,
  "beats": 5,
  "misses": 2,
  "averageReturn": 0.1,
  "topReturn": 0.25,
  "worstReturn": -0.05
}
```
```

--------------------------------

### FMPPRICE: Average close price over last 30 days

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use spreadsheet formulas with FMPPRICE to perform historical calculations. The example calculates the average close price for Apple over the past 30 days.

```Excel formula
=AVERAGE(INDEX(FMPPRICE("AAPL", "close", 30),,2))
```

--------------------------------

### FMP: Get annual dividend payment for a year

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMP function to get the sum of all dividend payments made during a specific year. The example returns the annual dividend payment for Apple (AAPL) in 2022.

```Excel formula
=FMP("AAPL", "Dividend", 2022)
```

--------------------------------

### FMP: Get annual dividend payments for multiple years

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMP function with an array of years to get annual dividend payments for several years at once. The example returns dividend payments for Apple (AAPL) for 2022, 2021, and 2020.

```Excel formula
=FMP("AAPL", "Dividend", {2022, 2021, 2020})
```

--------------------------------

### FMPPRICE historical open with days

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Returns the last 2 days of historical open prices for AMZN. The number of days is optional and does not require quotes.

```Excel formula
=FMPPRICE("AMZN", "Open", 2)
```

--------------------------------

### Historical Crypto Close Price for Specific Date Range

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Get Bitcoin's close price in US dollars for a specific date range (01/01/2024 to 01/30/2024) using the FMPPRICE function.

```Excel
=FMPPRICE("BTCUSD", "Close", , "01/01/2024", "01/30/2024")
```

--------------------------------

### FMP: Get annual adjusted dividend payment for a year

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMP function with the "Adjusted Dividend" parameter to get the adjusted dividend amount for a specific year. The example returns the adjusted annual dividend for Apple (AAPL) in 2022.

```Excel formula
=FMP("AAPL", "Adjusted Dividend", 2022)
```

--------------------------------

### FMPPRICE: Get adjusted dividend column only

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the INDEX function with FMPPRICE to extract a single column from the dividend data. The example returns the adjusted dividend column for Apple (aapl).

```Excel formula
=INDEX(FMPPRICE("aapl", "dividend"),,2)
```

--------------------------------

### Large Data Requests

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Instead of making many function requests at once, you can get data faster by using ranges in the functions. Enter a range of tickers, parameters, or periods to return every metric for every company across all periods.

```APIDOC
## Large Data Requests

### Description
Instead of making many function requests at once, you can get data faster by using ranges in the functions. Enter a range of tickers, parameters, or periods to return every metric for every company across all periods.

### Syntax
=FMP(ticker_range, parameter_range, period_range)

### Parameters
- **ticker_range** (range) - Required - A range of tickers (e.g., A2:A5).
- **parameter_range** (range) - Required - A range of parameters (e.g., B1:D1).
- **period_range** (range) - Required - A range of periods (e.g., E1:G1).

### Example
=FMP(A2:A5, B1:D1, E1:G1)

### Notes
- This single function call returns every metric for every company across all the periods. It saves you a lot of time and makes your spreadsheet faster.
```

--------------------------------

### GET /stable/tipranks-firm-summary

Source: https://site.financialmodelingprep.com/developer/docs

Aggregated rollup of all ratings issued by analysts at a given firm over a date window. Pools the whole desk into one row with totalRecommendations plus distinctAnalysts and distinctSymbols, a recommendation breakdown (buy/hold/sell) and analyst-action breakdown (initiated/maintained/upgraded/downgraded/reiterated/resumed). Also includes desk-wide price-target accuracy: validPriceTargets and comparedPriceTargets counts, beats vs misses, and return metrics (averageReturn, topReturn, worstReturn). firmName must match the data exactly (e.g. 'Morgan Stanley'). Window defaults to the trailing twelve months.

```APIDOC
## [GET] /stable/tipranks-firm-summary

### Description
Aggregated rollup of all ratings issued by analysts at a given firm over a date window. Pools the whole desk into one row with totalRecommendations plus distinctAnalysts and distinctSymbols, a recommendation breakdown (buy/hold/sell) and analyst-action breakdown (initiated/maintained/upgraded/downgraded/reiterated/resumed). Also includes desk-wide price-target accuracy: validPriceTargets and comparedPriceTargets counts, beats vs misses, and return metrics (averageReturn, topReturn, worstReturn). firmName must match the data exactly (e.g. 'Morgan Stanley'). Window defaults to the trailing twelve months.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/tipranks-firm-summary?firmName=Morgan Stanley

### Parameters
#### Query Parameters
- **firmName** (string) - Required - The firm name, must match exactly.
- **date range** (string) - Optional - The date window for the summary.

### Response
#### Success Response (200)
Returns a summary object with totalRecommendations, distinctAnalysts, distinctSymbols, recommendation breakdown, analyst-action breakdown, and price-target accuracy stats.

#### Response Example
```json
{
  "firmName": "Morgan Stanley",
  "totalRecommendations": 10,
  "distinctAnalysts": 5,
  "distinctSymbols": 8,
  "recommendationBreakdown": {
    "buy": 6,
    "hold": 3,
    "sell": 1
  },
  "analystActionBreakdown": {
    "initiated": 2,
    "maintained": 4,
    "upgraded": 1,
    "downgraded": 1,
    "reiterated": 1,
    "resumed": 1
  },
  "validPriceTargets": 8,
  "comparedPriceTargets": 7,
  "beats": 5,
  "misses": 2,
  "averageReturn": 0.1,
  "topReturn": 0.25,
  "worstReturn": -0.05
}
```
```

--------------------------------

### FMPPRICE

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

The FMPPRICE function retrieves live price data, historical price data, dividend payment information, and more. It accepts a ticker or range of tickers, one or more parameters, and optional date or day-range arguments.

```APIDOC
## FMPPRICE Function

### Description
The FMPPRICE function retrieves live price data, historical price data, dividend payment information, and more. It accepts a ticker or range of tickers, one or more parameters, and optional date or day-range arguments.

### Syntax
=FMPPRICE("ticker/s", "parameter/s", number of days to end, "start date", "end date")

### Parameters
- **Ticker/s** (string or range) - Required - The symbol or symbols of the companies you want data for. Can be typed in (e.g., "AAPL") or a cell reference (e.g., A1:A20).
- **Parameter/s** (string or range) - Required - The data you want the function to return. Accepts one or more parameters. Can be typed in (e.g., "Price") or a cell reference (e.g., B1:D1).
- **Number of days to end** (number) - Optional - For historical price data, the number of days to return. For example, 5 returns the last 5 days of historical prices. Can be typed in (e.g., 5) or a cell reference (e.g., B2).
- **Start date** (date string) - Optional - For historical price data, a specific start date. Must be a date-formatted cell or follow the "mm/dd/yyyy" format. Can be typed in (e.g., "01/30/2022") or a cell reference (e.g., B1). If only a start date is entered, the function returns the value for that specific date.
- **End date** (date string) - Optional - For historical price data, a specific end date. Must be a date-formatted cell or follow the "mm/dd/yyyy" format. Can be typed in (e.g., "01/30/2022") or a cell reference (e.g., B1).

### Examples
=FMPPRICE("TSLA","Price")

=FMPPRICE("AAPL", "Close",,"01/01/2022", "01/30/2022")

=FMPPRICE("AMZN", "Open", 2)

### Tips
- When requesting a lot of data, enter multiple tickers and parameters in the function using cell references.
- Numbers in the function, like 5, don't need quotes (" "). Only text does, like "Close" or "Dividend".
- Use the SUM function to get a single value from historical price data, for example =SUM(FMPPRICE("AAPL", "Close", , "01/28/2022"))

### Large Data Requests
Instead of making many function requests at once, you can get data faster by using ranges in the functions. Simply enter a range of tickers instead of a single ticker, or a range of parameters instead of a single parameter. For example, with tickers in A2:A10 and parameters in B1:D1:

=FMPPRICE(A2:A10, B1:D1)

This single function call returns all the real-time values for every company. It saves you a lot of time and makes your spreadsheet faster.

You can also enter multiple tickers to get historical price data for many securities at once, for example =FMPPRICE(A2:A5, "Close", 10).
```

--------------------------------

### FMPPRICE: Get close prices for multiple tickers in a range

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMPPRICE function with a range of tickers to retrieve historical close prices for multiple stocks at once. The example returns the last 30 days of close prices for the tickers in cells A2:A5.

```Excel formula
=FMPPRICE(A2:A5, "Close", 30)
```

--------------------------------

### =FMP("AAPL", "geographic revenues", "LQ-2")

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Retrieves a company's revenue breakdown across its geographic markets for a specified quarter. Quarterly data supports the LQ, LQ-1 period system.

```APIDOC
## =FMP("AAPL", "geographic revenues", "LQ-2")

### Description
Retrieves a company's revenue breakdown across its geographic markets for a specified quarter. Quarterly data supports the LQ, LQ-1 period system.

### Method
FMP function

### Endpoint
=FMP("AAPL", "geographic revenues", "LQ-2")

### Parameters
- **ticker** (string) - Required - The company ticker symbol (e.g., "AAPL").
- **dataType** (string) - Required - The type of data to retrieve, set to "geographic revenues".
- **period** (string) - Required - The quarter period, e.g., "LQ-2" for two quarters ago.

### Request Example
=FMP("AAPL", "geographic revenues", "LQ-2")

### Response
Returns the geographic revenue breakdown for the specified quarter.

### Response Example
(No explicit response example provided in the source.)
```

--------------------------------

### Connect to FMP MCP Server via Python using FastMCP

Source: https://site.financialmodelingprep.com/developer/docs/mcp-server

Use this Python example to connect a custom AI agent to the FMP MCP server. It lists available tools and calls the 'quote' tool for a symbol. Replace 'FMP_API_KEY' with your actual API key.

```python
import asyncio
from fastmcp import Client

async def main():
    client = Client("https://financialmodelingprep.com/mcp?apikey=FMP_API_KEY")
    async with client:
        print(await client.list_tools())
        # [Tool(name="quote", description="...", inputSchema={...}), …]
        print(await client.call_tool("quote", {"symbol": "AAPL"}))
        # CallToolResult(..., structured_content={'data': [{'symbol': 'AAPL', 'name': 'Apple Inc.', 'price': 281.37, …}]})

asyncio.run(main())
```

--------------------------------

### GET /stable/tipranks-symbol-summary

Source: https://site.financialmodelingprep.com/developer/docs

Aggregated rollup of all TipRanks ratings on a single ticker over a date window. Returns one row with totalRecommendations plus distinctAnalysts covering the name, a recommendation breakdown (buy/hold/sell) and analyst-action breakdown (initiated/maintained/upgraded/downgraded/reiterated/resumed). Also includes price-target accuracy stats: validPriceTargets and comparedPriceTargets counts, beats vs misses, and return metrics (averageReturn, topReturn, worstReturn). Window defaults to the trailing twelve months.

```APIDOC
## [GET] /stable/tipranks-symbol-summary

### Description
Aggregated rollup of all TipRanks ratings on a single ticker over a date window. Returns one row with totalRecommendations plus distinctAnalysts covering the name, a recommendation breakdown (buy/hold/sell) and analyst-action breakdown (initiated/maintained/upgraded/downgraded/reiterated/resumed). Also includes price-target accuracy stats: validPriceTargets and comparedPriceTargets counts, beats vs misses, and return metrics (averageReturn, topReturn, worstReturn). Window defaults to the trailing twelve months.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/tipranks-symbol-summary?symbol=AAPL

### Parameters
#### Query Parameters
- **symbol** (string) - Required - The ticker symbol.
- **date range** (string) - Optional - The date window for the summary.

### Response
#### Success Response (200)
Returns a summary object with totalRecommendations, distinctAnalysts, recommendation breakdown, analyst-action breakdown, and price-target accuracy stats.

#### Response Example
```json
{
  "symbol": "AAPL",
  "totalRecommendations": 10,
  "distinctAnalysts": 5,
  "recommendationBreakdown": {
    "buy": 6,
    "hold": 3,
    "sell": 1
  },
  "analystActionBreakdown": {
    "initiated": 2,
    "maintained": 4,
    "upgraded": 1,
    "downgraded": 1,
    "reiterated": 1,
    "resumed": 1
  },
  "validPriceTargets": 8,
  "comparedPriceTargets": 7,
  "beats": 5,
  "misses": 2,
  "averageReturn": 0.1,
  "topReturn": 0.25,
  "worstReturn": -0.05
}
```
```

--------------------------------

### Get latest quarterly dividend payment with FMP

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Returns the latest dividend paid by a stock or ETF. Use 'LQ' to get the most recent quarterly dividend. The same applies to the adjusted dividend.

```Excel
=FMP("AAPL", "dividend", "LQ")
```

--------------------------------

### GET /stable/sector-performance-snapshot

Source: https://site.financialmodelingprep.com/developer/docs

Get a snapshot of sector performance. Analyze how different industries are performing in the market based on average changes across sectors.

```APIDOC
## GET /stable/sector-performance-snapshot

### Description
Get a snapshot of sector performance. Analyze how different industries are performing in the market based on average changes across sectors.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/sector-performance-snapshot

### Parameters
#### Query Parameters
- **date** (string) - Required - The date for the snapshot (e.g., 2024-02-01).

### Request Example
https://financialmodelingprep.com/stable/sector-performance-snapshot?date=2024-02-01

```

--------------------------------

### FMP function with ranges for large data requests

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use ranges for tickers, parameters, and periods to fetch multiple data points in one call. This example uses A2:A5 for tickers, B1:D1 for parameters, and E1:G1 for periods.

```Excel formula
=FMP(A2:A5, B1:D1, E1:G1)
```

--------------------------------

### GET /stable/fmp-articles

Source: https://site.financialmodelingprep.com/developer/docs

Access the latest articles from FMP with the FMP Articles API. Get comprehensive updates including headlines, snippets, and publication URLs.

```APIDOC
## GET /stable/fmp-articles

### Description
Access the latest articles from FMP with the FMP Articles API. Get comprehensive updates including headlines, snippets, and publication URLs.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/fmp-articles?page=0&limit=20

### Parameters
#### Query Parameters
- **page** (integer) - Optional - Page number (default: 0)
- **limit** (integer) - Optional - Number of results per page (default: 20)

```

--------------------------------

### GET /stable/crowdfunding-offerings-latest

Source: https://site.financialmodelingprep.com/developer/docs

Retrieves the most recent crowdfunding campaigns, including company details, financial information, and offering terms. Use the page and limit query parameters to control pagination.

```APIDOC
## GET /stable/crowdfunding-offerings-latest

### Description
Retrieves the most recent crowdfunding campaigns, including company details, financial information, and offering terms.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/crowdfunding-offerings-latest

### Parameters
#### Query Parameters
- **page** (integer) - Optional - Page number for pagination (default 0).
- **limit** (integer) - Optional - Number of results per page (default 100).

### Response
#### Success Response (200)
Returns a list of crowdfunding campaigns with details such as company name, campaign name, platform, financial details, and offering terms.

#### Response Example
```json
[
  {
    "companyName": "Example Corp",
    "campaignName": "Example Campaign",
    "platform": "Example Platform",
    "financialDetails": {},
    "offeringTerms": {}
  }
]
```
```

--------------------------------

### GET /stable/quote

Source: https://site.financialmodelingprep.com/developer/docs

Access real-time stock quotes with the FMP Stock Quote API. Get up-to-the-minute prices, changes, and volume data for individual stocks.

```APIDOC
## [GET] /stable/quote

### Description
Access real-time stock quotes with the FMP Stock Quote API. Get up-to-the-minute prices, changes, and volume data for individual stocks.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/quote?symbol=AAPL

### Parameters
#### Query Parameters
- **symbol** (string) - Required - Stock symbol (e.g., AAPL)

```

--------------------------------

### =SUM(FMP("AAPL", "dividend", {"LQ", "LQ-1", "LQ-2", "LQ-3"}))

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Calculates the sum of the past 4 quarterly dividend payments for a stock or ETF.

```APIDOC
## =SUM(FMP("AAPL", "dividend", {"LQ", "LQ-1", "LQ-2", "LQ-3"}))

### Description
Calculates the sum of the past 4 quarterly dividend payments for a stock or ETF.

### Method
FMP function with SUM wrapper

### Endpoint
=SUM(FMP("AAPL", "dividend", {"LQ", "LQ-1", "LQ-2", "LQ-3"}))

### Parameters
- **ticker** (string) - Required - The stock or ETF ticker symbol (e.g., "AAPL").
- **dataType** (string) - Required - The type of data to retrieve, set to "dividend".
- **periods** (array) - Required - An array of period strings, e.g., {"LQ", "LQ-1", "LQ-2", "LQ-3"}.

### Request Example
=SUM(FMP("AAPL", "dividend", {"LQ", "LQ-1", "LQ-2", "LQ-3"}))

### Response
Returns the sum of the dividend payments for the specified periods.

### Response Example
(No explicit response example provided in the source.)
```

--------------------------------

### Historical Crypto Close Price for Last 10 Days

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Get Bitcoin's close price in US dollars for the last 10 days using the FMPPRICE function with the ticker BTCUSD.

```Excel
=FMPPRICE("BTCUSD", "Close", 10)
```

--------------------------------

### GET /stable/insider-trading/statistics

Source: https://site.financialmodelingprep.com/developer/docs

Analyzes insider trading activity with key statistics. Use this endpoint to get total purchases, sales, and trends for specific companies or stock symbols.

```APIDOC
## [GET] /stable/insider-trading/statistics

### Description
Analyze insider trading activity with the Insider Trade Statistics API. This API provides key statistics on insider transactions, including total purchases, sales, and trends for specific companies or stock symbols.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/insider-trading/statistics?symbol=AAPL

### Parameters
#### Query Parameters
- **symbol** (string) - Required - The stock symbol to retrieve statistics for (e.g., AAPL)

### Response
#### Success Response (200)
- Returns key statistics on insider transactions for the specified symbol.

```

--------------------------------

### GET /stable/news/press-releases-latest

Source: https://site.financialmodelingprep.com/developer/docs

Access official company press releases with the FMP Press Releases API. Get real-time updates on corporate announcements, earnings reports, mergers, and more.

```APIDOC
## GET /stable/news/press-releases-latest

### Description
Access official company press releases with the FMP Press Releases API. Get real-time updates on corporate announcements, earnings reports, mergers, and more.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/news/press-releases-latest?page=0&limit=20

### Parameters
#### Query Parameters
- **page** (integer) - Optional - Page number (default: 0)
- **limit** (integer) - Optional - Number of results per page (default: 20)

```

--------------------------------

### GET /stable/dowjones-constituent

Source: https://site.financialmodelingprep.com/developer/docs

Access data on the Dow Jones Industrial Average. Track current values, analyze trends, and get detailed information about the companies that make up this important stock index.

```APIDOC
## GET /stable/dowjones-constituent

### Description
Access data on the Dow Jones Industrial Average. Track current values, analyze trends, and get detailed information about the companies that make up this important stock index.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/dowjones-constituent

### Response
#### Success Response (200)
- **symbol** (string) - Company symbol
- **name** (string) - Company name
- **sector** (string) - Sector of the company
- **headquarters** (string) - Headquarters location
- **dateAdded** (string) - Date added to the index

#### Response Example
```json
[
  {
    "symbol": "JPM",
    "name": "JPMorgan Chase & Co.",
    "sector": "Financials",
    "headquarters": "New York City, New York",
    "dateAdded": "1991-02-01"
  }
]
```
```

--------------------------------

### Get analyst estimates for multiple metrics and years with FMP

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Returns analyst estimates for financial metrics like revenue, EBITDA, net income, etc. Enter a range of estimate parameters (e.g., B1:D1) and the years needed. Estimates currently go up to 2029; historical data is also available.

```Excel
=FMP("AAPL", B1:D1, {2027, 2026, 2025})
```

--------------------------------

### GET /stable/quote-short

Source: https://site.financialmodelingprep.com/developer/docs

Get fast and accurate quotes for commodities with the FMP Commodities Quick Quote API. Instantly access the current price, recent changes, and trading volume for various commodities.

```APIDOC
## [GET] https://financialmodelingprep.com/stable/quote-short?symbol=GCUSD

### Description
Get fast and accurate quotes for commodities with the FMP Commodities Quick Quote API. Instantly access the current price, recent changes, and trading volume for various commodities.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/quote-short

### Parameters
#### Query Parameters
- **symbol** (string) - Required - The commodity symbol (e.g., GCUSD).
```

--------------------------------

### GET /stable/key-metrics

Source: https://site.financialmodelingprep.com/developer/docs

Access essential financial metrics for a company with the FMP Financial Key Metrics API. Evaluate revenue, net income, P/E ratio, and more to assess performance and compare it to competitors.

```APIDOC
## [GET] /stable/key-metrics

### Description
Access essential financial metrics for a company with the FMP Financial Key Metrics API. Evaluate revenue, net income, P/E ratio, and more to assess performance and compare it to competitors.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/key-metrics?symbol=AAPL

### Parameters
#### Query Parameters
- **symbol** (string) - Required - The stock symbol of the company (e.g., AAPL).

### Response
#### Success Response (200)
Returns key financial metrics for the specified company.

```

--------------------------------

### GET /stable/acquisition-of-beneficial-ownership

Source: https://site.financialmodelingprep.com/developer/docs

Tracks changes in stock ownership during acquisitions. Use this endpoint to get detailed information on how mergers, takeovers, or beneficial ownership changes impact the stock ownership structure of a company.

```APIDOC
## [GET] /stable/acquisition-of-beneficial-ownership

### Description
Track changes in stock ownership during acquisitions. This API provides detailed information on how mergers, takeovers, or beneficial ownership changes impact the stock ownership structure of a company.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/acquisition-of-beneficial-ownership?symbol=AAPL

### Parameters
#### Query Parameters
- **symbol** (string) - Required - The stock symbol to retrieve acquisition ownership information for (e.g., AAPL)

### Response
#### Success Response (200)
- Returns detailed information on stock ownership changes during acquisitions.

```

--------------------------------

### FMPPRICE with ticker and parameter ranges

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Uses cell ranges for tickers (A2:A10) and parameters (B1:D1) to fetch real-time values for multiple companies in one call, improving performance for large data requests.

```Excel formula
=FMPPRICE(A2:A10, B1:D1)
```

--------------------------------

### GET /stable/insider-trading-transaction-type

Source: https://site.financialmodelingprep.com/developer/docs

Retrieves a comprehensive list of insider transaction types. Use this endpoint to get details on various transaction actions, including purchases, sales, and other corporate actions involving insider trading.

```APIDOC
## [GET] /stable/insider-trading-transaction-type

### Description
Access a comprehensive list of insider transaction types. This API provides details on various transaction actions, including purchases, sales, and other corporate actions involving insider trading.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/insider-trading-transaction-type

### Response
#### Success Response (200)
- Returns a list of insider transaction types.

```

--------------------------------

### GET /stable/batch-commodity-quotes

Source: https://site.financialmodelingprep.com/developer/docs

Get up-to-the-minute quotes for commodities with the FMP Commodities Quotes API. Track the latest prices, changes, and volumes for a wide range of commodities, including oil, gold, and agricultural products.

```APIDOC
## [GET] /stable/batch-commodity-quotes

### Description
Get up-to-the-minute quotes for commodities with the FMP Commodities Quotes API. Track the latest prices, changes, and volumes for a wide range of commodities, including oil, gold, and agricultural products.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/batch-commodity-quotes

```

--------------------------------

### Get geographic revenues for a quarter with FMP

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Returns a company's revenue breakdown across geographic markets for a specified quarter. Quarterly data only supports the LQ, LQ-1 period system. Only available for SEC-reporting companies.

```Excel
=FMP("AAPL", "geographic revenues", "LQ-2")
```

--------------------------------

### GET /stable/profile-bulk

Source: https://site.financialmodelingprep.com/developer/docs

Retrieves comprehensive company profile data for multiple companies in a single request. Includes company details, stock price, market cap, sector, industry, and more.

```APIDOC
## [GET] https://financialmodelingprep.com/stable/profile-bulk

### Description
Retrieves comprehensive company profile data for multiple companies in a single request. Includes company details, stock price, market cap, sector, industry, and more.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/profile-bulk

### Parameters
#### Query Parameters
- **part** (integer) - Required - Specifies the part of the bulk data to retrieve.

### Response
#### Success Response (200)
Returns bulk company profile data.

#### Response Example
```json
[
  {
    "symbol": "AAPL",
    "companyName": "Apple Inc.",
    "price": 150.25,
    "marketCap": 2500000000000,
    "sector": "Technology",
    "industry": "Consumer Electronics"
  }
]
```
```

--------------------------------

### Live Crypto Prices with FMPPRICE

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use the FMPPRICE function to get live price data for multiple cryptocurrency tickers in cells A2:A5. Tickers should omit the '-' (e.g., BTCUSD). Refresh data using the add-on's Refresh Data button.

```Excel
=FMPPRICE(A2:A5, "Price")
```

--------------------------------

### GET /stable/earning-call-transcript-dates

Source: https://site.financialmodelingprep.com/developer/docs

Access earnings call transcript dates for specific companies with the FMP Transcripts Dates By Symbol API. Get a comprehensive overview of earnings call schedules based on fiscal year and quarter.

```APIDOC
## GET /stable/earning-call-transcript-dates

### Description
Access earnings call transcript dates for specific companies with the FMP Transcripts Dates By Symbol API. Get a comprehensive overview of earnings call schedules based on fiscal year and quarter.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/earning-call-transcript-dates?symbol=AAPL

### Parameters
#### Query Parameters
- **symbol** (string) - Required - Stock symbol (e.g., AAPL)

```

--------------------------------

### GET /stable/ratios

Source: https://site.financialmodelingprep.com/developer/docs

Analyze a company's financial performance using the Financial Ratios API. This API provides detailed profitability, liquidity, and efficiency ratios, enabling users to assess a company's operational and financial health across various metrics.

```APIDOC
## [GET] /stable/ratios

### Description
Analyze a company's financial performance using the Financial Ratios API. This API provides detailed profitability, liquidity, and efficiency ratios, enabling users to assess a company's operational and financial health across various metrics.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/ratios?symbol=AAPL

### Parameters
#### Query Parameters
- **symbol** (string) - Required - The stock symbol of the company (e.g., AAPL).

### Response
#### Success Response (200)
Returns financial ratios for the specified company.

```

--------------------------------

### FMP function examples for financial data

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Valid calls to the =FMP function for financial data. Ticker, parameter, and period are required; quarter and divisor are optional. Text values need quotes, numbers do not.

```Excel formula
=FMP("AAPL","ROE","TTM")
```

```Excel formula
=FMP("TSLA", "Revenue", "LY",,1000000)
```

```Excel formula
=FMP("AAPL","Free Cash Flow",2019,"Q3")
```

--------------------------------

### GET /stable/batch-forex-quotes

Source: https://site.financialmodelingprep.com/developer/docs

Retrieve real-time quotes for multiple forex currency pairs with the FMP Batch Forex Quote API. Get real-time price changes and updates for a variety of forex pairs in a single request.

```APIDOC
## [GET] /stable/batch-forex-quotes

### Description
Retrieve real-time quotes for multiple forex currency pairs with the FMP Batch Forex Quote API. Get real-time price changes and updates for a variety of forex pairs in a single request.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/batch-forex-quotes

```

--------------------------------

### =FMP("AAPL", "dividend", "LQ")

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Retrieves the latest quarterly dividend payment for a stock or ETF. The same applies to the adjusted dividend.

```APIDOC
## =FMP("AAPL", "dividend", "LQ")

### Description
Retrieves the latest quarterly dividend payment for a stock or ETF. The same applies to the adjusted dividend.

### Method
FMP function

### Endpoint
=FMP("AAPL", "dividend", "LQ")

### Parameters
- **ticker** (string) - Required - The stock or ETF ticker symbol (e.g., "AAPL").
- **dataType** (string) - Required - The type of data to retrieve, set to "dividend".
- **period** (string) - Required - The period for the dividend, e.g., "LQ" for the latest quarter.

### Request Example
=FMP("AAPL", "dividend", "LQ")

### Response
Returns the latest dividend payment amount.

### Response Example
(No explicit response example provided in the source.)
```

--------------------------------

### GET /stable/batch-etf-quotes

Source: https://site.financialmodelingprep.com/developer/docs

Get real-time price quotes for exchange-traded funds (ETFs) with the FMP ETF Price Quotes API. Track current prices, performance changes, and key data for a wide variety of ETFs.

```APIDOC
## [GET] /stable/batch-etf-quotes

### Description
Get real-time price quotes for exchange-traded funds (ETFs) with the FMP ETF Price Quotes API. Track current prices, performance changes, and key data for a wide variety of ETFs.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/batch-etf-quotes

```

--------------------------------

### GET /stable/price-target-summary-bulk

Source: https://site.financialmodelingprep.com/developer/docs

Provides a comprehensive overview of price targets for all listed symbols over multiple timeframes. Helps investors compare current prices to projected targets across different periods.

```APIDOC
## [GET] https://financialmodelingprep.com/stable/price-target-summary-bulk

### Description
Provides a comprehensive overview of price targets for all listed symbols over multiple timeframes. Helps investors compare current prices to projected targets across different periods.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/price-target-summary-bulk

### Response
#### Success Response (200)
Returns bulk price target summary data.

#### Response Example
```json
[
  {
    "symbol": "AAPL",
    "priceTarget": 200,
    "currentPrice": 150.25,
    "timeframe": "1Y"
  }
]
```
```

--------------------------------

### FMPFUNDS function with single ticker and parameter (PICK Nav)

Source: https://site.financialmodelingprep.com/developer/docs/excel-add-on

Use =FMPFUNDS("PICK","Nav") to retrieve the net asset value for the PICK ETF. This is another valid single-ticker, single-parameter call.

```Excel formula
=FMPFUNDS("PICK","Nav")
```

--------------------------------

### GET /stable/quote-short

Source: https://site.financialmodelingprep.com/developer/docs

Get quick snapshots of real-time stock quotes with the FMP Stock Quote Short API. Access key stock data like current price, volume, and price changes for instant market insights.

```APIDOC
## [GET] /stable/quote-short

### Description
Get quick snapshots of real-time stock quotes with the FMP Stock Quote Short API. Access key stock data like current price, volume, and price changes for instant market insights.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/quote-short?symbol=AAPL

### Parameters
#### Query Parameters
- **symbol** (string) - Required - Stock symbol (e.g., AAPL)

```

--------------------------------

### GET /stable/senate-positions

Source: https://site.financialmodelingprep.com/developer/docs

Congressional positions a member has held, with term dates, party, and state.

```APIDOC
## [GET] /stable/senate-positions

### Description
Congressional positions a member has held, with term dates, party, and state.

### Method
GET

### Endpoint
https://financialmodelingprep.com/stable/senate-positions

### Parameters
No parameters documented.
```
Tokens:
Raw