App Icon
Get your exchange rate between crypto-currencies and fiat currencies. We support all crypto-currencies and fiat currencies.
By:Winthan Aung
Works with:
1,241
Overview
Calculate with Crypto function for exchange rates on Google Sheets. It supports for Coinbase/Kraken exchanges for BTC/LTC/ETH as well as all crypto currencies exchange rates. The common exchange rate is from BraveNewCoin API. 

---------------------

=crypto("btc", "usd") 
=crypto("eth", "sgd")
=crypto("ltc", "eur") 
Support all Crypto-currencies / Fiat currencies

=inBTC("eth")
=inBTC("xlm") 
- Support all Alt-currencies

=BTC("coinbase") 
=BTC("coinbase, "EUR")
Support All fiat currencies for Coinbase

=BTC("poloniex") 
=BTC("poloniex, "STR")
Support All pairs with BTC for Poloniex

=BTC("kraken")
=BTC("kraken", "GBP")
Support CAD, EUR, GBP, JPY, USD for Kraken

=ETH("poloniex")
=ETH("poloniex", "GNT") 
Support All pairs with ETH for Poloniex

=ETH("coinbase")
=ETH("coinbase", "USD") 
Support All Fiat currencies for Coinbase

=ETH("karken")
=ETH("kraken", "JPY")
BTC, CAD, EUR, GBP, JPY, USD for Kraken

=LTC("coinbase") 
=LTC("coinbase", "usd") 
Support All Fiat currencies for Coinbase

=LTC("kraken") 
=LTC("kraken", "usd") 
Support BTC, EUR, USD for Kraken

-----------------

Buy me a coffee @ - 1AtE5tuAuAMusuNXAMKrZhDvUQqbmLDpug
Additional information
DeveloperWinthan Aung
SupportNot available
Privacy policyNot available
Terms of service
Crypto Function will ask for the permissions shown below. Learn more
Crypto Function will need access to your Google account
This will allow Crypto Function to :
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 Crypto Function
December 6, 2017
you should put a refresh option, so we can choose the period of auto-refreshing....
Is this review helpful?
Yes
No
Profile Picture
A User of Crypto Function
June 23, 2017
Why is GBP from coinbase for ethereum and ltc not available? Would be really useful if you could fix it as this is what I need! Thanks
Is this review helpful?
Yes
No
Profile Picture
A User of Crypto Function
December 7, 2018
great script but nyc,html,dime,esp and few more coins are not getting data
Is this review helpful?
Yes
No
Profile Picture
A User of Crypto Function
September 7, 2017
love it, but seems to be down for hours now. any news?
Is this review helpful?
Yes
No
Profile Picture
Graham Mace
December 23, 2017
I took the script from below and modded it a little to allow for multiple tabs. I have tabs named "MAIN" and "ETHFUND" My sheet has 10 tabs... 1 for each coin i own. I didn't put the entire script with every coin but you should be able to follow. If someone knows how to do the array with if then loop thing that would be better! function insertRow() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var MAIN = ss.getSheetByName("MAIN"); var ETHFUND = ss.getSheetByName("ETHFUND"); MAIN.activate(); var targetSheet = SpreadsheetApp.getActiveSpreadsheet(); targetSheet.insertRowAfter(1); targetSheet.deleteRow(2); ETHFUND.activate(); var targetSheet = SpreadsheetApp.getActiveSpreadsheet(); targetSheet.insertRowAfter(1); targetSheet.deleteRow(2); }
Is this review helpful?
Yes
No
Profile Picture
A User of Crypto Function
June 26, 2018
It is a nice add-on. Is there any documentation? A list of available commands, a list of supported coins? Does it support change percentage for the last hour, day week? Thanks, I appreciate the effort.
Is this review helpful?
Yes
No
Profile Picture
A User of Crypto Function
June 3, 2019
used to work great, now it doesn't refresh at all.
Is this review helpful?
Yes
No
Profile Picture
A User of Crypto Function
December 20, 2017
Very good script. I love that they don't require many permissions. As for the slow refresh. I just inserted a button-image, and assigned the following script to it, works like a charm! function insertRow() { var targetSheet = SpreadsheetApp.getActiveSpreadsheet(); targetSheet.insertRowAfter(1); targetSheet.deleteRow(2); }
Is this review helpful?
Yes
No
Profile Picture
A User of Crypto Function
June 11, 2017
Great app, can you add EURO option for coinbase
Is this review helpful?
Yes
No
Profile Picture
A User of Crypto Function
January 1, 2018
Just got it, has been great so far. Only thing is I cannot find a way to get BTH (bitcoin cash) on it. Could you guys add that? Coinbase just added it to their website.
Is this review helpful?
Yes
No
1-10 of 33
Search
Clear search
Close search
Google apps
Main menu