Search

Our Search API for Stocks, ETFs, Mutual Funds and Indices is one of the best ways to quickly search assets either by code or by company or asset name. The search engine automatically understands if there asset name or code or even ISIN and prioritize the search fields accordingly. The search engine has several parameters for result ordering. We take into account not only search query but also market capitalization and the average trading volume for the past period.

How to use EOD Historical Data data in Excel & Googlesheets with Cryptosheets

This article demonstrates three examples of how to pull EOD Historical Data API data into your spreadsheet using the side panel console, custom functions and templates.

Explore more EOD Historical Data endpoints [here](https://app.cryptosheets.com/#/browse/EOD Historical Data)

Example Parameters:

  • api_token: Your api_token
  • query_string: AAPL
  • fmt: json

Excel:

=CS.QUERY("EOD Historical Data","Search",{"api_token","Your api_token";"query_string","AAPL";"fmt","json"})

Googlesheets:

=CSQUERY("EOD Historical Data","Search",{"api_token","Your api_token";"query_string","AAPL";"fmt","json"})

Usage

Cryptosheets data can be pulled through multiple interfaces:

Setup

Setup

  1. Install the Cryptosheets add-in from the [Microsoft AppSource Store](https://appsource.microsoft.com/en-us/product/office/WA104381695?src=intercom-EOD Historical Data)

  2. Install the Cryptosheets add-in from the [Google GSuite Marketplace](https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?src=intercom-EOD Historical Data)

  3. After it is installed, make sure you are logged into your Cryptosheets account through the Cryptosheets side panel

Using the console

Using the console

  1. From the Cryptosheets Excel ribbon click data
  2. From the Googlesheets Add-ons menu click Cryptosheets then select Launch side-bar
  3. Type in EOD Historical Data... then click on Search
  4. Scroll through the console parameters and input your values
  5. Select the cell you want to place the data into
  6. Click make request

img

img

Using custom functions

Using custom functions

Tip: For both Excel and Googlesheeets you can use either the QUERY or QUERYA custom function

  1. Excel In any cell type the following:

=CS.QUERY("EOD Historical Data","Search",{"api_token","Your api_token";"query_string","AAPL";"fmt","json"})

  1. Googlesheets In any cell type the following:

=CSQUERY("EOD Historical Data","Search",{"api_token","Your api_token";"query_string","AAPL";"fmt","json"})

  1. In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the function/formula builder, then click the clipboard icon to copy the full formula string and paste it into any cell see detailed examples and tutorial

Hint: If you need help remembering the exact parameters for any function, you can always just type in any cell: =CS.PARAMETERS("EOD Historical Data","Search") for Excel or =CSPARAMETERS("EOD Historical Data","Search") for Googlesheets

Using templates

Using templates

  1. From the Cryptosheets Excel ribbon click templates OR click on the templates tab in the browse section
  2. From the Googlesheets Add-ons menu click Cryptosheets then select Templates
  3. Load the template called Query Builder and type EOD Historical Data and Search
  4. You can also try searching "EOD Historical Data..." for other templates

Signing up for Cryptosheets is free get crypto data in 30 seconds or less

Note: you must have one of the supported versions of Microsoft Office or Excel for custom functions to work. Learn more here

Helpful Resources:

  • Visit the API documentation for EOD Historical Data here
  • See tutorials and examples for EOD Historical Data on the Cryptosheets YouTube channel
  • Troubleshooting: please reference the following troubleshooting code: QUE-1715-2062. Learn more here

Tags: Search EOD Historical Data endpoint