Using Shrimpy data in Cryptosheets
This article demonstrates two examples of how to pull Shrimpy data into your spreadsheet using the
side panel console and
You can currently pull 10 endpoints from Shrimpy into Cryptosheets including:
get-ticker, orderbooks, candles, exchanges, trading pairs, exchange assets
Explore more Shrimpy endpoints here (**see more about Shrimpy historical data at bottom of this article)
Although Shrimpy has 10 available endpoints, we will use
candles as our example.
This endpoint retrieves live candlestick data. The candlestick data is typically used to plot a candlestick or OHLCV chart. When retrieving candlestick data for plotting first call the endpoint without specifying a startTime. This will return data associated with the most recent 1000 candlesticks. Subsequently periodically call the endpoint specifying the startTime as the time associated with the most recent candlestick. Note that the last or most recent candlestick is for the current not-yet-committed frame. All times are in returned in UTC.
Example data returned:
1. Install the Cryptosheets add-in from Microsoft AppSource Store
2. Make sure you are logged into your Cryptosheets account
Using the console
1. From the Cryptosheets ribbon click
2. Type in type in "Shrimpy..." then click on
3. Scroll through the console parameters and input your values
4. Select the cell you want to place the data into
Using custom functions
1. In any cell type the following:
If you need help remembering the exact parameters for any function, you can always just type in any cell:
*Note: you must have one of the supported versions of Microsoft Office or Excel for custom functions to work
**Shrimpy historical data:
In order to access the historical data endpoints from Shrimpy, users will need to generate Shrimpy API master keys. These keys can be accessed by signing up for the Shrimpy developer APIs here
Upon signing up, you will see a page where you can create new master keys by selecting the “Create Api Master Key” button.
Before leaving the Shrimpy developer application after generating your keys, ensure you have enabled "Data" permissions on your master keys. Without all this permission set, you will not be able to make requests to historical data endpoints.
Once updated with these permissions, save your keys in a safe location. Keys can be put directly in your spreadsheets , referenced as named values or stored with Cryptosheets in their secure back end.
Note: The Shrimpy Developer APIs cost $35 for the lowest data tier. This gives you access to all of the historical data endpoints
Visit the API documentation for Shrimpy here
Troubleshooting: please reference the following troubleshooting code: PAR-1250-472
Learn more here
Tags: portfolio, Shrimpy, ohlcv, candles, excel, googlesheets, spreadsheet