Cryptosheets makes it easy for anybody to pull a wide variety of crypto data into their Excel or Google Sheets. This tutorial will show you two different ways to do this.
⚠️ Before you do, make sure you have:
There are 2 primary ways to get data:
Custom Functions (aka formulas)*
👉 Method 1 - Custom Functions
Overview
Custom functions are a type of formula you can use in either Excel or Googlesheets. All Cryptosheets custom functions begin with "CS" and can be accessed once you have logged into the side panel.
To get data with a custom function follow these steps...
In any cell type the following:
Excel:=CS.PRICE("BTC","USD")
Googlesheets:=CSPRICE("BTC","USD")Press enter
That's it!
👉 Method 2 - API Console in the Side Panel
Overview
The side panel API console & function builder allows you to quickly query data for any provider or endpoint and will send the data directly to your sheet as a refreshable formula, dynamic template or flat data. The below example uses an endpoint from CryptoCompare to pull in historical trading data for Bitcoin (BTC)
To get data using the API console in the side panel follow these steps...
Search for Cryptocompare under the providers tab in the browse section
Find the endpoint called V2 Histoday
Select the endpoint
Press the green button called "make request"
That's it!
👀 The side panel API console & function builder looks like this and there is one for every single endpoint.
👉 To navigate to the API console from the home/landing screen follow these steps
Click on the
Browse DatabuttonSelect the
endpointstabClick on any
endpointThat's it! ➡️ you've arrived at the API console!
The console is broken out into 6 major parts: