App Icon
Cryptosheets.com
•  1,806
Overview
Cryptosheets simplifies the process of accessing, aggregating, manipulating, and processing cryptocurrency API data.
OVERVIEW
All your crypto data in one place (and now all your capital & conventional markets data also!). Access crypto data from hundreds of data providers using simple =CSQUERY() 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

[last updated 7/22/2020]

✔ Over 9,500+ crypto-assets supported
✔ Over 120,000+ crypto instruments supported (derivatives, futures, options, perpetuals)
✔ Over 194,500 total crypto + capital markets instruments supported (crypto + stocks, ETFs, ADRs, bonds, commodities,economic indicators)
✔ Historical price, volume, trade & orderbook data for 305+ exchanges (1 second - 1yr resolutions)
✔ Hundreds of providers (Coinmarketcap, Cryptocompare, Coingecko, Messari, Coinpaprika, Kaiko many more..)
✔ Over 70,000+ non crypto-assets supported via our IEX Cloud API integration!
✔ Stocks, ETFs, Options, OEF/CEF, commodities, bonds, interest rates, energy, economic indicators, earnings, financials, fundamentals, corporate actions and much more

✔ 79+ Custom functions =CSPRICE("BTC","USD","2/1/2019")
✔ 180+ Technical Analysis Custom functions 
✔ Powerful custom function arguments for _fields, _orderBy, _formatDates, extract JSON arrays using _path and more
✔ One click Template library
✔ DeFi, derivatives, ICO, crypto funds, volatility, taxonomy, portfolio analysis, historical scenarios
✔ On chain metrics  =CSCHAIN(), =CSMETRICS()
✔ Multi-provider ATH (All-Time-Highs) & ROI data per day, week, month, quarter, year (=CSTA)
✔ Global market data, BTC dominance, sentiment, flows

✔ Real time streaming prices (Excel version only*)
✔ Automatic custom refresh at any interval for any data using CS.TIME! (Excel version only*)

✔ Tutorials & support documentation library (over 9,500+ examples)
✔ Dedicated data provider documentation (over 5,000+ pages)
✔ 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")
=CSPRICE("BTC", "USDT",,"Binance","ASK")
=CSPRICE("BTC", "USD",,"Coinbase","BID")
=CSTA("BTC", "USD")
=CSATH("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")
=CSQUERY('Coingecko','exchanges')
=CSQUERY("Paradigm","Performance")
=CSPARAMETERS("Cryptunit","Earnings Auto")
=CSPROVIDERS("~Coin")
=CSENDPOINTS("Cryptocompare")
=CSEXCHANGES()
=CSSYMBOLS('type', 'futures')
=CSQUERYA()


=CSRSI()
=CSMACD()
=CSEMA()
=CSBBANDS()
... many more (try =CSTAMETADATA() to see over 180+ technical indicators functions)

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


📔 Help Center: https://intercom.help/cryptosheets/en/
📔 Docs Portal: https://docs.cryptosheets.com
📔 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 by selecting "Launch Sidebar"

(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, Bitcoin price history, Ethereum, Cryptocurrency, Blockchain, Litecoin, Ripple, Altcoins, Mining, Bitcoin Mining, CoinMarketCap, Cryptocompare, Cointracking, Coingecko, Coinbase, Bitmex, Binance, Bitfinex, Bittrex, Bitstamp, Huobi, OKEx, Cryptonator, Bitcoin Charts, Crypto, FTX, WhatToMine, IEX Cloud, stocks API, crypto API
Reviews
Language:
Sort by:
Profile Picture
A User of Cryptosheets
July 24, 2020
Really helpful!
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
July 15, 2020
always freezes.
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
July 13, 2020
Beware of the "." "," and ";" it can change according location. Friendly staff. Figured it out pretty fast. Thx support. Great GREAT product and SUPPORT
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
July 13, 2020
awesome product!
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
July 12, 2020
Thanks for this.
Is this review helpful?
Yes
No
Profile Pciture
A user of Cryptosheets
July 23, 2020
Thanks to
Profile Picture
A User of Cryptosheets
July 7, 2020
Thanks
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
June 28, 2020
I installed it but when I click launch siderbar, it's completely white. This means that it is unusable
Is this review helpful?
Yes
No
Profile Pciture
A user of Cryptosheets
July 9, 2020
refresh your browser. i noticed the same issue.
Profile Picture
A User of Cryptosheets
June 24, 2020
Best Support ever ! Answering very fast to all my inquiries with some extremely competent solutions !
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
June 9, 2020
Still processing but looks simple enough.
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
May 20, 2020
AMAZING AMAZING AMAZING! Professional and easy-to-use templates along with a very very professional and helpful support staff! Would rate 10 starts if I could.
Is this review helpful?
Yes
No
Profile Pciture
Rishabh Gupta
June 3, 2020
I am not able to use it in my excel. Can you please help
1-10 of 49
Additional information
Cryptosheets.com
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu