Hello Nostr World!
Here's my first contribution to the growing body of knowledge here.
Question: How do you get the price of #bitcoin on #googlesheets through #googlefinance functions?
Answer: Set value of cell A1 to BTC, and on another cell, put one of these formulas:
=GOOGLEFINANCE("AR"&A1)
=GOOGLEFINANCE("CURRENCY:"&A1&"USD")
=IMPORTDATA("https://cryptorates.ai/v1/price/"&A1)
=IMPORTDATA("https://cryptoprices.cc/"&A1&"/")
These could work for other cryptocurrencies too.
Oddbean new post about login | logout
Notes by 5a856c87 | export
Hello Nostr World! Here's my first contribution to the growing body of knowledge here. Question: How do you get the price of #bitcoin on #googlesheets through #googlefinance functions? Answer: Set value of cell A1 to BTC, and on another cell, put one of these formulas: =GOOGLEFINANCE("AR"&A1) =GOOGLEFINANCE("CURRENCY:"&A1&"USD") =IMPORTDATA("https://cryptorates.ai/v1/price/"&A1) =IMPORTDATA("https://cryptoprices.cc/"&A1&"/") These could work for other cryptocurrencies too.