App Icon
Cryptosheets.com
•  2,794
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 10/1/2020]

✔ Over 10,125+ crypto-assets & 200+ fiat currencies supported
✔ Over 130,000+ crypto instruments supported (derivatives, futures, options, perpetuals)
✔ Over 275,000 total crypto + capital markets instruments supported (crypto + stocks, ETFs, ADRs, bonds, commodities,economic indicators)
✔ Historical price, volume, trade & orderbook data for 306+ exchanges (1 second - 1yr resolutions)
✔ Hundreds of providers (Coinmarketcap, Cryptocompare, Coingecko, Messari, Coinmetrics, Nomics, Coinpaprika, Kaiko many more..)
✔ Over 100,000+ non crypto-assets supported!
✔ Stocks, ETFs, Options, OEF/CEF, commodities, bonds, interest rates, energy, economic indicators, earnings, financials, fundamentals, corporate actions and much more

✔ 84+ 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 10,500+ examples)
✔ Dedicated data provider documentation (over 7,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")
=CSPRICEA("base","ETH","quote","USD","exchange","DERIBIT","type","OPTION","details","200828-400-C")
=CSPRICEA("symbolId","DERIBIT_OPT_ETH_USD_200828_400_C")

=CSTA("BTC", "USD")
=CSATH("BTC", "USD")
=CSOHLCV("BTC","USD")
=CSOHLCV("BTC","USD","Coinbase","SPOT","1MIN")
=CSORDERBOOKS("BTC","USD","Coinbase","SPOT","","","1")
=CSORDERBOOKSL3A("symbolId","COINBASE_SPOT_BTC_USD")
=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
📔 YouTube: https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ
📔 Medium: https://medium.com/cryptosheets
📔 Twitter: https://twitter.com/Cryptosheets_RT
📔 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: stocks API, crypto API, graphql API, defi API, bitcoin API, cryptocurrency API, blockchain API, altcoins, bitcoin mining

Integrated providers: 
CoinMarketCap, MercadoBitcoin, Poloniex, Block, Coinigy, CoinLayer, Livecoin, Blockchain, Cryptonator, Nexchange, Zloader, CoinRanking, Coinlore, Coinlib, CoinDesk, ICObench, Binance, BitcoinAverage, Coinbase, CryptoStandardizer, IEX, Bitfinex, Coinpaprika, BitcoinCharts, Coinbase Pro, CoinGecko, WorldCoinIndex, NiceHash, Bitmex, Bittrex, Gemini, CoinAPI, Messari, CryptUnit, WhatToMine, Nomics, CryptoCompare, Paradigm, The Block, Coinmetrics, Cointracking, Shrimpy, CCXT, Chainz, Crypto51, Earn, Etherscan, Ethplorer, OpenFIGI, Cryptowatch, FOAM, Amberdata, Cryptosheets, Bloxy, Bitwise, Kryptocal, Tokeninsight, Kaiko, Flipside Crypto, Huobi, LocalBitcoins, Kraken, Covalent, TokenAnalyst, DeFi Pulse, Compound, Alethio, Decred Data, Kyber Network, LoanScan, CryptoRank.io, CoinCodex, LedgerX, Deribit, ContractMarketCap, Dapp.review, StableCoinIndex, FTX, DEX.AG, Lunarcrush, dYdX, CryptoQuant, Coinbase Prime, GlassNode, TzStats, Binance Dex, TronScan, 1inch, XRP Ledger, 0xTracker, Radar Relay, Cryptocontrol, Binance US, Coinbase Custody, Smartable Coronavirus API, EOD Historical Data, Bybit, ByteTree, Covidtracking, Bitstamp, Bitflyer, itBit, OKEX, Paraswap, QUME, OmniAPI, Delta Exchange, CoinCodeCap, Crypto.com, 0xAPI, Blocklytics, Blockset, AdaEx, Equos, Paxful, Blockstream, CrossTower, Minerstat, The Graph, Yearn API, QTUM, Infura, IntoTheBlock, Vantage Crypto, Xangle, Iconomi, Blockcypher, Masternodes, IDEX, Uniswap, Coindar, Cryptohopper, KuCoin, DragonGlass
Reviews
Language:
Sort by:
Profile Picture
Douglas
October 28, 2020
Awesome plugin to keep track of my crypto portfolio! Highly recommended, with very supportive customer support!
Is this review helpful?
Yes
No
Profile Picture
Suleyman Duyar
October 24, 2020
really interesting, solves a lot of problems, easy to use
Is this review helpful?
Yes
No
Profile Picture
Tawn D
October 23, 2020
Easy to use and clear
Is this review helpful?
Yes
No
Profile Picture
Serge Lubkin
October 23, 2020
great tool! fast support
Is this review helpful?
Yes
No
Profile Picture
Deniz Derin ÖZER
October 21, 2020
VERY IMPRESSIVE! I started using Cryptosheets today. Very simple to use. Great customer support. I got instant answer from the live chat, and they were really, really patient and helpful!
Is this review helpful?
Yes
No
Profile Picture
Jada Vas Dias
October 8, 2020
I don't why or how it took me this long to find Cryptosheets but am glad I did! I think it saved me about 3 hours on the first day by getting the same data with 2 simple formulas instead of multiple csv downloads, uploads & formatting. I just copy and pasted the formulas from the documentation website and they make it so easy. My questions were answered in minutes by amazing customer support. The amount and types of data you can access is so much larger than anything else ive seen or used and didn't know i could also get stocks and etf prices. only plugin that actually has data for all my coins and defi tokens. also didnt realize you can get streaming live crypto prices in the excel version so going to try that as well. Still exploring all the features but I highly recommend it!
Is this review helpful?
Yes
No
Profile Picture
Hans Samuelsson
October 3, 2020
So far seem to be very powerful and useful. The only one I found with support for vast majority of the cryptos that I hold. All the other ones are restricted on that point, in general some what top 50 to be able to pull data for. Also feels well developed with good efforts to provide a great support as well.
Is this review helpful?
Yes
No
Profile Picture
Vadim
September 29, 2020
The best solution that I managed to find on the Internet. I would especially like to acknowledge the very friendly support.
Is this review helpful?
Yes
No
Profile Picture
stéphane st-pierre
September 4, 2020
Great tool !
Is this review helpful?
Yes
No
Profile Picture
Artu artum12,twitter
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
Cryptosheets Support
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!
1-10 of 65
Additional information
Cryptosheets.com
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu