Help & Support
Send Feedback
Cryptosheets
Cryptosheets simplifies the process of accessing, aggregating, manipulating, and processing cryptocurrency API data.
127 users
Works with
Install
Overview
OVERVIEW
All your crypto data in one place. Access crypto data from hundreds of data providers using simple =CS.QUERY() formulas or browse data sets and send directly to your sheet (no formulas). Browse institutional research, templates, charts, scenarios and customize your workspace with flexible dashboards. Access in Googlesheets, Excel or on the web anytime.

✔ No programming skills or scripts required, just email & password and you are good to go

✔ Over 7,000+ crypto-assets supported
✔ Historical price, volume, trade & orderbook data for 280+ exchanges (1 second - 1yr resolutions)
✔ Hundreds of providers (Coinmarketcap, Cryptocompare, Coingecko, Messari, Coinpaprika, many more..)

✔ 20+ Custom functions =CSPRICE("BTC","USD","2/1/2019")
✔ 180+ Technical Analysis Custom functions 
✔ Powerful custom function arguments for showsFields, sorting, formatDates and more
✔ One click Template library
✔ DeFi, derivatives, ICO, crypto funds, volatility, taxonomy, portfolio analysis
✔ On chain metrics  =CSCHAIN(), =CSMETRICS()
✔ Multi-provider ATH (All-Time-Highs) & ROI data per day, week, month, quarter, year
✔ Global market data, BTC dominance, sentiment, flows
✔ Real time streaming prices (Excel version only*)

✔ Tutorials & support documentation library
✔ Live chat support and interactive help center
✔ See your subscription quota in real time, no more surprises + one click upgrade from the side panel
---------------------------------------------------------------

EXAMPLES (TRY COPYING + PASTING AFTER YOU LOGIN)

=CSPRICE("BTC", "USD")
=CSPRICE("BTC","USD","2/1/2019")
=CSTA("BTC", "USD")
=CSOHLCV("BTC","USD","Coinbase","SPOT","1DAY")
=CSORDERBOOKS("BTC","USD","Coinbase","SPOT","","","1")
=CSTRADES("BTC","USD","Bitmex","PERP")
=CSEXRATE("BTC","USD","1") *Excel only

=CSQUERY("Cryptunit","Earnings Auto")
=CSPARAMETERS("Cryptunit","Earnings Auto")
=CSPROVIDERS("~Coin")
=CSENDPOINTS("Cryptocompare")
=CSEXCHANGES()

=CSADDRESS("1KYiKJEfdJtap9QX2v9BXJMpz2SfU4pgZw","Bitfinex")
=CSADDRESS(,"~Bin")
=CSCHAIN("DASH")
=CSMETRICS("BTC") *Pro subscription for live data
=CSMETRICS("BTC,BCH") *Pro subscription for live data
=CSCLUSTERS("platform")


📔 Help Center: https://intercom.help/cryptosheets/en/
📔 Excel Version: https://appsource.microsoft.com/en-us/product/office/WA104381695


GETTING STARTED

(1) Install the Cryptosheets add-on.

(2) Open a spreadsheet

(3) Start the Cryptosheets add-on from your add-ons menu.

(4) Click “Login” at the top of the side panel. 

(5) If this is the first time you are using Cryptosheets, you will be prompted to register and provide the necessary permissions

(6) Voila, your data is now available via Cryptosheets! You can now modify how the data gets displayed, as well as pull in your favorite endpoints.

TAGS

Bitcoin, Ethereum, Cryptocurrency, Blockchain, Litecoin, Ripple, Altcoins, Mining, Bitcoin Mining, CoinMarketCap, Cryptocompare, Coinbase, Bitmex, Binance, Bitfinex, Bittrex, Cryptonator, Bitcoin Charts, Crypto, WhatToMine
Reviews
A User of Cryptosheets
February 19, 2020
World class functionality like no other, as well as excellent support. I have come here from CryptoFinance and have been VERY impressed so far. Chris even helped me via Zoom to get some problems sorted and is always sharp on support!
Submit reply
Cancel
A User of Cryptosheets
February 7, 2020
I'm new Jamaica is in did house
Submit reply
Cancel
A User of Cryptosheets
January 6, 2020
Still works for what i need to use it for and has for years although it definitely needs an update. sounds like they will be introducing the features from Cryptosheets Excel version into this one soon. looking forward to it
Submit reply
Cancel
A User of Cryptosheets
November 24, 2018
Once you subscribre your login disapear and the charges on the card keep comming, scammer stay away
Submit reply
Cancel
A User of Cryptosheets
November 1, 2018
I like SpreadStreet and its idea but I try to login to my account and it does not work. I try to recover password and it does not work. I try to contact with support and mail does not work. So I try to contact with John directly but he does not reply. But one thing works - charging my card. I do not know what is going on...
Submit reply
Cancel
John Young
November 6, 2018
Hi Radoslaw, Email is working, and I responded to you. The email you gave is not currently even in our system, so if you are paying then you provided the wrong e-mail. I am happy to sort this out with you, but it is impossible for me to assist if I can't find the e-mail that you registered with.
A User of Cryptosheets
September 7, 2018
I'm being charged $15/mo for this and there is no option to cancel on your website.
Submit reply
Cancel
A User of Cryptosheets
June 25, 2018
create application .
Submit reply
Cancel
A User of Cryptosheets
May 15, 2018
very nice tooolll
Submit reply
Cancel
A User of Cryptosheets
April 18, 2018
Cool add-on!
Submit reply
Cancel
A User of Cryptosheets
March 2, 2018
I got it going after reading through the troubleshooting tips in the user reviews and John Young's responses. Turning off Privacy Badger and then refreshing my copy of the spreadsheet did the trick. Now I am wondering how to trade stocks using these techniques. If only I had the time....Anyway, thanks to John Young for his articles on Medium, his posts on Quora, and this add-on.
Submit reply
Cancel
1-10 of 33
Additional information
Search
Clear search
Close search
Google apps
Main menu