OVERVIEWAll 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/WA104381695GETTING 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 miningIntegrated 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
FAQs
How to use cryptosheets in Google Sheets? ›
- Going to the add-ons menu from your Googlesheet.
- Get add-ons.
- Type "cryptosheets" in the search bar in GSuite Marketplace.
- Install.
- Go back to the add-ons menu.
- Select Launch Sidebar from the Cryptosheets menu.
- Press Enter, and the cell will display "Loading" before showing the current Bitcoin price. ...
- In the 'Settings for this spreadsheet' box, go to the 'Calculation' tab. ...
- Click 'Save settings'.
- Sign in/create Cryptowatch account. First, you must sign in to your Cryptowatch account. ...
- Generate API key. In the top right-hand corner of the homepage, click on the Account dropdown and select API Access. ...
- Connect API key to Google Sheets. ...
- Enter formula to extract data.
Marketplace apps
The Google Workspace Marketplace offers more than 5000 3rd-party apps that enhance and extend Google Workspace services including Gmail, Drive, Docs, and Calendar.
To convert currencies in real-time using Google Sheets, you'll need to use the GOOGLEFINANCE function. Here's a step-by-step guide: In a cell, type "=GOOGLEFINANCE(" to start the function. Inside the parentheses, type "CURRENCY:" followed by the currency codes you want to convert from and to, separated by a space.
How do I calculate investments in Google Sheets? ›- Use the FV formula to calculate the future value of an investment. ...
- =FV(0.25%,12,-5000,0,0) ...
- Use the FV formula to calculate the future value of a lump-sum payment. ...
- =FV(1%,120,0,-120000,0) ...
- Use the FV formula to calculate loan payback.
- CoinMarketCap.
- CoinGecko.
- CoinDesk.
- CoinTelegraph.
Under the cost model, companies measure their crypto holdings at cost less impairment losses and amortization, similar to US GAAP requirements before the inception of ASU 2023-08. Any impairment triggers expense recognition and a corresponding write-down of the crypto asset's value on the balance sheet.
Can Google Finance track crypto? ›If you'd like to build your own custom portfolio tracker and dashboard, Google makes it easy by integrating Google Finance with Google Sheets. Users can access financial data about stocks, ETFs, market indexes, and currencies (including cryptocurrency).
Is it safe to use Google Sheets for finances? ›Safety. Google Sheets is secure for tracking your finances because it works through Google server protection: Unless you've shared your Google Sheet with someone, nobody can access your files without your Gmail account username and password.
Can I link Google Sheets to my bank account? ›
BudgetSheet is a Google Sheets add-on that can link to your bank to import live transaction data directly into your spreadsheet. From there, you can do whatever you want with it!
Is Google Workspace Marketplace legit? ›The app passes a brand verification. The app complies with the Google APIs Terms of Service and Google's API Services User Data Policy.
How to get listed on Google Workspace Marketplace? ›Create a Google Cloud project to configure and manage your listing on the Google Workspace Marketplace. If you've already created a Cloud project for your app, then you should use this Cloud project for your listing. Configure OAuth for your app. For public apps, you might need to submit your app for an OAuth review.
Which big companies use Google Workspace? ›Companies using Google Workspace (Formerly Google G-Suite) for Collaboration include: United States Department of Defense, a United States based Government organisation with 2870235 employees and revenues of $721.50 billion, McKesson, a United States based Professional Services organisation with 75000 employees and ...
How do I use currency in Google Sheets? ›- On your computer, open a spreadsheet in Google Sheets.
- Highlight the data you want to format.
- Click Format. Number.
- Click Custom currency.
- Search in the menu text box to select a format. You can also add your own custom currency format into the text box.
- Click Apply.
- Step 1: Convert your files. On your computer, open Google Drive. On the right side panel, click the Macro Converter add-on. ...
- Step 2: Test your converted files. Run your Apps Script code. ...
- Step 3: Fix errors. If you run into errors while testing your files, see Fix errors in your converted code.
Cryptosheets simplifies the process of accessing, aggregating, manipulating, and processing cryptocurrency API data.