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 custom functions.

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.

Description:

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:

open: 10334.74
high: 10358.55
low: 10282.01
close: 10290.01
volume: 276.48
quoteVolume: 2854927
btcVolume: 276.47
usdVolume: 2854927
time: 2019-05-24T23:00:00.000Z

________________________________________________________________

Setup

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 data
2. Type in type in "Shrimpy..." then click on candles
3. Scroll through the console parameters and input your values
4. Select the cell you want to place the data into
5. Click make request

________________________________________________________________

Using custom functions

1. In any cell type the following:
=CS.QUERY("Shrimpy","candles",{"exchange","coinbasepro";"baseTradingSymbol","BTC";"quoteTradingSymbol","USD";"interval","1H";"startTime","2019-05-24T23:00:00.000Z"})

If you need help remembering the exact parameters for any function, you can always just type in any cell:
=CS.PARAMETERS("Shrimpy","candles")

*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

Helpful Resources:

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