App Icon
Cryptosheets.com
•  2,639
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
September 4, 2020
Great tool !
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
September 4, 2020
today just finished an ETH buy-write chart: Inside my gSheet, I wrote: 'Thank you, Cryptosheets, for your excellence in quality & communication'. Look forward to continued use of CS functions & joint project development. ainafin developer
Is this review helpful?
Yes
No
Profile Pciture
A user of Cryptosheets
September 4, 2020
Thank you @Artum12 for your crypto options market analysis showcasing how to leverage some of our latest custom functions like =CSPRICEA to unlock derivatives data capabilities and market insights!
Profile Picture
A User of Cryptosheets
September 2, 2020
Amazing plugin, EXCELLENT customer service. I am very satisfied with this product and would recommend it to anyone.
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
September 1, 2020
Awesome customer service!!
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
August 27, 2020
Amazing customer support and bad ass queries!! The customer support alone made me subscribe!
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
August 18, 2020
The best tool I have seen so far for in my case Google Sheets, and a super fast support for all my questions. Definitely download worthy!
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
August 12, 2020
Have just barely scratched the surface on pricing vs. usage using free account. Had question & support was exceptionally helpful, went above & beyond my question. Will update review as I use it more and find out about usage fee's and possibility of paid-for account.
Is this review helpful?
Yes
No
Profile Picture
A User of Cryptosheets
August 7, 2020
Love CryptoSheets. Works really well for me!
Is this review helpful?
Yes
No
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
1-10 of 57
Additional information
Cryptosheets.com
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu