App Icon
Cryptosheets.com
•  27,868
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
Qwartyx Qwartyx
April 12, 2021
Signing me off quite frequently. I'm on paid plan.
Is this review helpful?
Yes
No
Profile Picture
Nasiru Tauhid
April 5, 2021
Very interested
Is this review helpful?
Yes
No
Profile Picture
Justin L
April 3, 2021
Allows me to login and get quotes. So far this app is great! Thank you
Is this review helpful?
Yes
No
Profile Picture
matt jones
March 30, 2021
I agree with the recent comments, it's great when it works, but I get daily errors, very frustrating when you are on a paid plan.
Is this review helpful?
Yes
No
Profile Picture
J B
March 30, 2021
It would be fantastic if this actually worked
Is this review helpful?
Yes
No
Profile Picture
Javier Peredo
March 26, 2021
Uso el template y deja de recuperar datos
Is this review helpful?
Yes
No
Profile Picture
Robin Hansen
March 26, 2021
its great when it works. but im getting errors left and right on a daily basis
Is this review helpful?
Yes
No
Profile Picture
Arthur Collé
March 23, 2021
does not work at all. Fix your stuff. No way to log in, and even when logged in, CSPRICE does not work. Extremely frustrating - think about how much time you waste people when you submit something to the world that doesn't work!
Is this review helpful?
Yes
No
Profile Picture
Teoxihuitl Sintora
March 20, 2021
not working
Is this review helpful?
Yes
No
Profile Picture
MCass
March 18, 2021
It's works very good, and it's very useful. A must have to keep track of your portfolio.
Is this review helpful?
Yes
No
1-10 of 104
Additional information
Cryptosheets.com
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu