App Icon
Returns the exchange rate and other data between 2,078 crypto-currencies and 31 fiat currencies =CRYPTOFINANCE("BTC/USD")
Works with:
12,813
Overview
Returns the exchange rate between cryptocurrencies and fiat currencies or bitcoin.
And also the marketcap, volume, total/current supply, name and change (1h/24h/7d) information.

📔 Full doc: https://cryptofinance.ai/docs

Data from CoinMarketCap and over 46 different exchanges. The default quota allows for a good personal usage, but you can upgrade to a plan with more data and and better refresh frequency.

✔ 2,178 crypto-currencies supported
✔ Historical price data for 196 exchanges
✔ ATH (All-Time-Highs) prices, date and custom sparklines available
✔ ROI data per month, quarter and year
✔ Conversion possible to 31 fiat currencies
✔ Altcoins to Bitcoin rates
✔ Market global data
✔ As simple as =CRYPTOFINANCE("BTC/USD")
✔ Bitcoin fee recommended (fastest/half hour/hour)
✔ Many exchanges supported (more to come):
      - AltCoinTrader
      - BTCMarkets
      - Binance
      - Bitfinex
      - Bithumb
      - Bitstamp
      - Bittrex
      - Coinbase
      - CoinMarketCap (market average, requires data proxy subscription for full access)
      - Cryptopia
      - IDEX
      - Gemini
      - GDAX
      - HitBTC
      - Huobi
      - IndependentReserve
      - LiveCoin
      - Kraken
      - Kucoin
      - Liqui.io
      - Luno
      - Poloniex (requires data proxy subscription)
      - Qtrade


CRYPTOFINANCE (This add-on) and its authors are not responsible for any trading loss incurred by following the data returned. The service is provided "as is ",  without any warranty of any kind, expressed or implied.
Additional information
Privacy policy
Terms of service
CRYPTOFINANCE will ask for the permissions shown below. Learn more
CRYPTOFINANCE will need access to your Google account
This will allow CRYPTOFINANCE to :
View and manage spreadsheets that this application has been installed in
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of CRYPTOFINANCE
June 27, 2018
I love this app, but it seems that it is not working since yesterday or so (it worked 2 or 3 days ago for sure, so it is not Binance or Coinmarketcap banning requests). I'm using this: =CRYPTOFINANCE("KRAKEN:ETH/EUR") . Although the add-on is installed and the sheet is using it, a message appears: "Error Unknown function: 'CRYPTOFINANCE'.". I'm not the only one, a friend told me yesterday night that he's having the same problem.
Is this review helpful?
Yes
No
Profile Picture
A User of CRYPTOFINANCE
September 7, 2017
Hi, I installed it but when I tried to use the function, it shows up error as "Unknown function: 'CRYPTOFINANCE'." Tried reopened chrome doesn't help. I will certainly change the rating after the problem is fixed. (sorry as there is no Q&A section so I have to use the review section) Thanks. **update** Thanks Julien it works!!! Save tons of my time!! Thanks for this nice add-on!! Looking forward to the future update! :) 5 stars!!
Is this review helpful?
Yes
No
Profile Picture
A User of CRYPTOFINANCE
December 13, 2017
Update: I created a new worksheet to test, and that worked - - Then I opened my old one and it suddenly worked. Who knows! Thanks for a great service. Posting for support - After working great for days, my fields that calll cryptofinance just say "Error: Loading Data." No matter how long I leave the spreadsheet open for. Any ideas? Is this a global or local problem? Thanks!
Is this review helpful?
Yes
No
Profile Picture
A User of CRYPTOFINANCE
November 21, 2017
This is exactly what I was looking for, for keeping and updated view on rates. One issue I have noticed today though is that the rates are updating. Even when I click refresh on the page or even close my Google sheet and reopen it. The only way I can get it to update the rate is to erase part of the function, leave the cell so it shows an error, then fix the function to the correct format. This then fetches the correct updated rate. Is there a fix for this?
Is this review helpful?
Yes
No
Profile Picture
A User of CRYPTOFINANCE
June 17, 2017
Siacoin is not appearing for calls of rank or % changes per hour, day, or year, but works with price and market cap. On the surface seems to be an issue with the letters SC appearing alone and not followed by a conversion currency of 3 letters. X currency (XC), TransferCoin (TX,) Asia Coin (AC), 42 coin (42), El Coin (EL) all seem not to work and work in the same way. Seems to be an issue with 2 letter symbols. Hope this helps, otherwise awesome but could refresh faster. Understand you're working on that though (Y)
Is this review helpful?
Yes
No
Profile Picture
A User of CRYPTOFINANCE
March 1, 2018
For some reason NCASH is giving me an error. Still love the add-on, thank you for everything!
Is this review helpful?
Yes
No
Profile Picture
Gayan Gunawardana
January 31, 2018
Have been using a ton. Great plugin. My one question/complaint is, I haven't been able to find a way to use a cell reference inside the formulas. I want to use cell references because then I can easily copy the functions down a table rather than having to hard code the ticker on each of the cells. If I try [=CRYPTOFINANCE("B2/usd", "marketcap"] where B2 is BTC, this gives me an error. Any tips?
Is this review helpful?
Yes
No
Profile Picture
A User of CRYPTOFINANCE
November 22, 2017
Super useful for tracking the prices of all your bags. Only issue I face is error: "Service invoked too many times". That seems like a GSheet issue though as I have this happen using other scripts as well. Any thoughts on how to fix this? I think I've been refreshing prices too many times... I'm sure some of you can relate!
Is this review helpful?
Yes
No
Profile Picture
A User of CRYPTOFINANCE
August 14, 2017
Great plugin, huge time saver for my personal crypto ledger. One quick way to refresh the plugin data I noticed is to add or delete a row anywhere above the cells that use the formula. This forces the plugin to refresh all instances of the data below it. Would be nice to have a dedicated refresh option, but this works pretty quickly and easily.
Is this review helpful?
Yes
No
Profile Picture
A User of CRYPTOFINANCE
November 15, 2017
Very useful thanks! As for many other folks rates don't refresh as regularly as we'd like to, neither after refreshing the page BUT... there is another way people, just select the data you wanna refresh, delete it and then press ctrl + z to let them take their place back again. This way data is fresh.
Is this review helpful?
Yes
No
1-10 of 372
Search
Clear search
Close search
Google apps
Main menu