Help & Support
Send Feedback
CRYPTOFINANCE
Returns the exchange rate and other data between 2,078 crypto-currencies and 31 fiat currencies =CRYPTOFINANCE("BTC/USD")
13 users
Works with
Install
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.

> Install the open-source version: https://github.com/cryptofinance-ai/cryptofinance-google-sheets-add-on

Data from CoinMarketcap and over 30 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,078 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")
✔ Twitter/Reddit coin mention data and sentiment analysis for +200 coins
✔ 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

📔 Full doc: https://cryptofinance.ai/docs/getting-started-with-cryptofinance/


Social volume data are provided by Solume.io

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.
Reviews
March 15, 2019
Plugin works really well and Julien made himself avaiable even for a screenshare call in order to troubleshoot some of my issues, good support. Everything works now. Best of luck!
Submit reply
Cancel
March 11, 2019
Does not work
Submit reply
Cancel
March 3, 2019
A great Add-on. Does exactly what it says on the box and the support is first class. Very impressed :-)
Submit reply
Cancel
February 14, 2019
Not working anymore 50 free api calls limitation
Submit reply
Cancel
January 24, 2019
It used to work, sotpped working a few days ago
Submit reply
Cancel
December 31, 2018
Doesn't work anymore unless you pay $10 a month
Submit reply
Cancel
December 28, 2018
Hi, I just discovered this evening. I start using is and I discovered one pai for which is far to be the correct one: =CRYPTOFINANCE("BITFINEX:AGI/ETH") gives a value of approximately 0,0005961 this evening, whilee on Bitfinex website, it is indicated at 0,0003 : difference is abotu 100%: is there an error somewhere? I checked other pai, and they are ok. Weird? Bests, Pierre
Submit reply
Cancel
A Google User
December 29, 2018
Hi Pierre, I just had a look, =CRYPTOFINANCE("BITFINEX:AGI/ETH") returns 0.00039029, which is what Bitfinex API returns also. The add-on connects directly to each exchange API by default. I'm thinking maybe you had a formatting issue in your cell, or Bitfinex API had a glitch for that market for a short amount of time (their API is still in beta). Don't hesitate to let me know if you see any more issue.
December 28, 2018
sorry for all the mispellings... my, this is terrible...
December 26, 2018
Used to work ok, but now gives "You reached your CRYPTOFINANCE quota of 50 requests/day. " every time even tho I only check it like once a day, if that ... Useless ...
Submit reply
Cancel
A Google User
March 9, 2019
Can anyone suggest which Exchange gives prices to all coins in USD similar to CoinMarketCap. Like XVG/USD ?
March 9, 2019
Now it's throwing an error for "=CRYPTOFINANCE("KUCOIN:OCN/BTC","", "", $A$2)" :(
December 23, 2018
=CRYPTOFINANCE("BINANCE:XVG/USDT") still doesn't work ... why do some coins only work with '/BTC' and not '/USDT'? ... Also, what happened to 24h and 1h % change? There's no option to specify interval anymore?
A Google User
December 23, 2018
Hi Marina, Binance doesn't have USD markets, only USDT markets, try this syntax: =CRYPTOFINANCE("BINANCE:BTC/USDT")
December 22, 2018
Nope. Just checked it. Definitely still throws an error for certain coins. Like can't get =CRYPTOFINANCE("BINANCE:BTC/USD") to work, also QTUM, XVG, VEN, EXP...
November 30, 2018
Error: Rate limit excedeed!. (line 288). This is the most common error you'll see using this add-on
Submit reply
Cancel
November 22, 2018
CRYPTOFINANCE not work well anymore....can you please help?
Submit reply
Cancel
1-10 of 132
Additional information
Search
Clear search
Close search
Google apps
Main menu