Google Finance does not update this data in real-time, generally, there is a 10-20 minutes delay. For example, by using websites like, the following approach should work for plenty of crypto coins: Where A1 = let’s say “” You’ll need to use alternatives like Binance or other tools. These are not available in Google Finance at the moment, so can’t be used. It doesn’t work for certain altcoins like DOGE, AAVE, DOT, LUNA, etc, … What formula can I use to get Solana and Polkadot prices They add more with time, but at the moment Google Finance only works for certain pairs. ADA and BNB prices) but many others are missing. It seems they have added several more (e.g. (T) Stock Price & News - Google Finance Markets US Europe Asia Futures Stocks are higher after latest inflation data, Fed decision looms: Live updates CNBC Dow Jones 36,538.90. What if you want other currency, like EURO? Just change the USD bit in the formula and will work with any currency ticker:īTC to EURO: =GOOGLEFINANCE("CURRENCY:BTCEUR") Are there new crypto and currencies available? LTC to USD: =GOOGLEFINANCE("CURRENCY:LTCUSD")īCH to USD: =GOOGLEFINANCE("CURRENCY:BCHUSD") ![]() In order to get cryptocurrency prices into Google Spreadsheets for Bitcoin, Ethereum, Litecoin, and Bitcoin cash, you can use the following formulas:īTC to USD: =GOOGLEFINANCE("CURRENCY:BTCUSD")ĮTH to USD: =GOOGLEFINANCE("CURRENCY:ETHUSD") How to get crypto prices into Google Spreadsheet in 2022
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |