Excel

Google Sheets

> We provide FUNDAMENTAL data, INTRADAY and DAILY historical stock prices for stocks, ETFs, Mutual Funds and Bonds all around the world.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data">EOD Historical Data</a>** endpoint using **Cryptosheets** through:

- `side panel console`
- `custom functions` (Excel & Googlesheets)
- `templates`

## Excel

<div class="markdown">

| App Url                                                                                 | Docs Url                                                                                 | Name                        | Example                                             | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | --------   | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Technicals" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/technicals) | **Technicals** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Technicals",{"api_token","Your api_token";"symbol","AAPL.US";"function","sma";"fmt","json";"period","50";"from","1596240000";"to","1596283200";"order","d"})'>=CS.QUERY("EOD Historical Data","Technicals")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Technicals")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Intraday%20Historical" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/intraday-historical) | **Intraday Historical** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Intraday Historical",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json";"interval","5m";"from","1596240000";"to","1596283200"})'>=CS.QUERY("EOD Historical Data","Intraday Historical")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Intraday Historical")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Bonds%20Fundamentals" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/bonds-fundamentals) | **Bonds Fundamentals** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Bonds Fundamentals",{"api_token","Your api_token";"symbol","910047AG4";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Bonds Fundamentals")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Bonds Fundamentals")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/End%20Of%20Day" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/end-of-day) | **End Of Day** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","End Of Day",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json";"from","44044";"to","44058";"order","d";"period","d"})'>=CS.QUERY("EOD Historical Data","End Of Day")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","End Of Day")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Options" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/options) | **Options** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Options",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json";"from","today";"to","73051"})'>=CS.QUERY("EOD Historical Data","Options")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Options")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Real%20Time" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/real-time) | **Real Time** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Real Time",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Real Time")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Real Time")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Fundamentals" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/fundamentals) | **Fundamentals** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Fundamentals",{"api_token","Your api_token";"symbol","AAPL.US"})'>=CS.QUERY("EOD Historical Data","Fundamentals")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Fundamentals")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Historical%20Dividends" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/historical-dividends) | **Historical Dividends** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Historical Dividends",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Historical Dividends")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Historical Dividends")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Upcoming%20Earnings" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/upcoming-earnings) | **Upcoming Earnings** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Upcoming Earnings",{"api_token","Your api_token";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Upcoming Earnings")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Upcoming Earnings")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Upcoming%20IPOs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/upcoming-ipos) | **Upcoming IPOs** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Upcoming IPOs",{"api_token","Your api_token";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Upcoming IPOs")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Upcoming IPOs")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Upcoming%20Splits" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/upcoming-splits) | **Upcoming Splits** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Upcoming Splits",{"api_token","Your api_token";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Upcoming Splits")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Upcoming Splits")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/exchanges) | **Exchanges** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Exchanges",{"api_token","Your api_token";"exchange_code","US";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Exchanges")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Exchanges")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Search" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/search) | **Search** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Search",{"api_token","Your api_token";"query_string","AAPL";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Search")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Search")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/EOD%20Bulk%20Last%20Day" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/eod-bulk-last-day) | **EOD Bulk Last Day** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","EOD Bulk Last Day",{"api_token","Your api_token";"symbol","US";"fmt","json"})'>=CS.QUERY("EOD Historical Data","EOD Bulk Last Day")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","EOD Bulk Last Day")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Short%20Interest" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/short-interest) | **Short Interest** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Short Interest",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Short Interest")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Short Interest")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Historical%20Splits" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/historical-splits) | **Historical Splits** | <inline-code functionvalue='=CS.QUERY("EOD Historical Data","Historical Splits",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json"})'>=CS.QUERY("EOD Historical Data","Historical Splits")</inline-code> | <inline-code>=CS.PARAMETERS("EOD Historical Data","Historical Splits")</inline-code> | 3 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Technicals" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/technicals) | **Technicals** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Technicals",{"api_token","Your api_token";"symbol","AAPL.US";"function","sma";"fmt","json";"period","50";"from","1596240000";"to","1596283200";"order","d"})'>=CSQUERY("EOD Historical Data","Technicals")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Technicals")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Intraday%20Historical" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/intraday-historical) | **Intraday Historical** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Intraday Historical",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json";"interval","5m";"from","1596240000";"to","1596283200"})'>=CSQUERY("EOD Historical Data","Intraday Historical")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Intraday Historical")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Bonds%20Fundamentals" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/bonds-fundamentals) | **Bonds Fundamentals** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Bonds Fundamentals",{"api_token","Your api_token";"symbol","910047AG4";"fmt","json"})'>=CSQUERY("EOD Historical Data","Bonds Fundamentals")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Bonds Fundamentals")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/End%20Of%20Day" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/end-of-day) | **End Of Day** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","End Of Day",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json";"from","44044";"to","44058";"order","d";"period","d"})'>=CSQUERY("EOD Historical Data","End Of Day")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","End Of Day")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Options" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/options) | **Options** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Options",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json";"from","today";"to","73051"})'>=CSQUERY("EOD Historical Data","Options")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Options")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Real%20Time" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/real-time) | **Real Time** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Real Time",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json"})'>=CSQUERY("EOD Historical Data","Real Time")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Real Time")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Fundamentals" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/fundamentals) | **Fundamentals** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Fundamentals",{"api_token","Your api_token";"symbol","AAPL.US"})'>=CSQUERY("EOD Historical Data","Fundamentals")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Fundamentals")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Historical%20Dividends" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/historical-dividends) | **Historical Dividends** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Historical Dividends",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json"})'>=CSQUERY("EOD Historical Data","Historical Dividends")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Historical Dividends")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Upcoming%20Earnings" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/upcoming-earnings) | **Upcoming Earnings** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Upcoming Earnings",{"api_token","Your api_token";"fmt","json"})'>=CSQUERY("EOD Historical Data","Upcoming Earnings")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Upcoming Earnings")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Upcoming%20IPOs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/upcoming-ipos) | **Upcoming IPOs** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Upcoming IPOs",{"api_token","Your api_token";"fmt","json"})'>=CSQUERY("EOD Historical Data","Upcoming IPOs")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Upcoming IPOs")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Upcoming%20Splits" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/upcoming-splits) | **Upcoming Splits** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Upcoming Splits",{"api_token","Your api_token";"fmt","json"})'>=CSQUERY("EOD Historical Data","Upcoming Splits")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Upcoming Splits")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/exchanges) | **Exchanges** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Exchanges",{"api_token","Your api_token";"exchange_code","US";"fmt","json"})'>=CSQUERY("EOD Historical Data","Exchanges")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Exchanges")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Search" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/search) | **Search** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Search",{"api_token","Your api_token";"query_string","AAPL";"fmt","json"})'>=CSQUERY("EOD Historical Data","Search")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Search")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/EOD%20Bulk%20Last%20Day" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/eod-bulk-last-day) | **EOD Bulk Last Day** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","EOD Bulk Last Day",{"api_token","Your api_token";"symbol","US";"fmt","json"})'>=CSQUERY("EOD Historical Data","EOD Bulk Last Day")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","EOD Bulk Last Day")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Short%20Interest" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/short-interest) | **Short Interest** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Short Interest",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json"})'>=CSQUERY("EOD Historical Data","Short Interest")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Short Interest")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/EOD%20Historical%20Data/Historical%20Splits" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/eod-historical-data/historical-splits) | **Historical Splits** | <inline-code functionvalue='=CSQUERY("EOD Historical Data","Historical Splits",{"api_token","Your api_token";"symbol","AAPL.US";"fmt","json"})'>=CSQUERY("EOD Historical Data","Historical Splits")</inline-code> | <inline-code>=CSPARAMETERS("EOD Historical Data","Historical Splits")</inline-code> | 3 |

</div>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

**<a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-EOD Historical Data">Get Cryptosheets for Microsoft Excel</a>**

**<a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget?src=docs-EOD Historical Data">Get Cryptosheets for Googlesheets</a>**

\*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work

**<a href="https://eodhistoricaldata.com/knowledgebase/">Click here</a>** for additional documentation from EOD Historical Data

Learn more [here](https://intercom.help/cryptosheets/en/)

---

Tags: `EOD Historical Data` `provider` 


How to pull EOD Historical Data data into Excel and Google Sheets