App Icon
Cryptosheets.com
•  3,545
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 1/12/2021]

✔ Over 11,000+ crypto-assets & 200+ fiat currencies supported
✔ Over 147,000+ crypto instruments supported (derivatives, futures, options, perpetuals)
✔ Over 475,000 total crypto + capital markets instruments supported (crypto + stocks, ETFs, ADRs, bonds, commodities, economic indicators)
✔ Historical price, volume, trade & orderbook data for 309+ exchanges (1 second - 1yr resolutions), 800+ exchanges total
✔ [NEW] support for CoinGecko, CryptoCompare & Messari as default pricing sources!
✔ Hundreds of providers (Coinmarketcap, Cryptocompare, Coingecko, Messari, Coinmetrics, Nomics, Coinpaprika, Kaiko many more..)
✔ Over 250,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 12,250+ examples)
✔ Dedicated data provider documentation (over 6,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")

=CSPRICEA("base","BTC","quote","USD","source","CoinGecko")
=CSPRICEA("base","BTC","quote","USD","source","CryptoCompare")
=CSPRICEA("base","BTC","source","Messari")

=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, NeoScan, Stellar, TokenView, CryptoAPIs.io, Beaconchain, WAVES, Bonfida, OpenSea, Decentraland, GrinMint, Polkascan, TokenLists, Uniswap
Reviews
Language:
Sort by:
Profile Picture
Diver Gent
January 17, 2021
at the beginning it was working, but now there's always one or more coins price unreachables, so I can't have the amount of all my cryptos value, it's pretty useless, sorry
Is this review helpful?
Yes
No
Profile Picture
Blake Fix
January 7, 2021
Wish there was a super simple function for the 24h change that ONLY returned the 24h change.
Is this review helpful?
Yes
No
Profile Pciture
Cryptosheets Support
January 8, 2021
Hi Blake, thx for the feedback and we are working on something exactly like what you're describing. Because crypto is a 24/7 market & 24hr change can be relative to your location or UTC time etc it's also calculated differently by different providers. There are still many ways to easily get that data using simple formulas including some examples below and many more. Happy to help, just ping us anytime in the support chat, thx! =CSQUERYA("Cryptowatch","Performance 24H","pair","BTCUSD","_path","@.result.change") =(CSPRICE("BTC","USD")-CSPRICE("BTC","USD","1/7/2021"))/CSPRICE("BTC","USD","1/7/2021") =CSMETRICS("BTC",{"_path","result[].change1"}) =CS.TA("BTC","USD",,{"_fields","change1"}) =CSTA("BTC","USD",,{"_fields","exchange,change1"})
Profile Picture
Cosmin Stefan
January 4, 2021
Good app and great potential, but asks dangerous permissions: read and edit for ALL your documents in drive. Beware!
Is this review helpful?
Yes
No
Profile Picture
Eric Admati
December 18, 2020
seems great, others don't work. only thing is, I registered, did not get a verification email, checked spam too. online chat guy had to send me verification email.
Is this review helpful?
Yes
No
Profile Picture
Darius Askari
December 10, 2020
Great add-on with some serious versatile functionality. You’re able to get a massive amount of data from what appears to be unlimited sources, plus the team is super helpful. It’s now a “must-have” for tracking our portfolio.
Is this review helpful?
Yes
No
Profile Picture
Brian Blandin
December 7, 2020
The app is extremely useful and Chris' customer service is top notch
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 3, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Felicity Chevalier
December 1, 2020
Really useful sheet tools with some specifically important ones that make active margin trading easier. Templates are also good for starting points though it's just the functions are incredibly useful in generally adding them to already existing ledger designs. The team is really responsive + willing to help when you have a concern/specific requirement, which is a lot more than most devs will do these days
Is this review helpful?
Yes
No
Profile Picture
Steffen Engman
November 30, 2020
Works like a charm, and the customer service is very helpful, even with non-paying customers. Need any crypto prices in your sheets? This is your app!
Is this review helpful?
Yes
No
Profile Picture
EtnyBZH BHZ
November 24, 2020
Very good tool, the customer service is great and very friendly and they will help you even if your English is as bad as a French
Is this review helpful?
Yes
No
1-10 of 84
Additional information
Cryptosheets.com
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu