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.
/ Bay Area Buzz
npub1t2…t6c9p
2024-10-13 03:05:02
Author Public Key
npub1t2zkepe96udm08ahf4v3mq8ajtalzhfxsdnpf3jpa85q6agntm5qyt6c9pSeen on
wss://relay.damus.ioPublished at
2024-10-13 03:05:02Event JSON
{
"id": "e2b167c8d1f6a728045c41f06b96a95e63dfb2bca2a521396f905d9fa94e928f",
"pubkey": "5a856c8725d71bb79fb74d591d80fd92fbf15d26836614c641e9e80d75135ee8",
"created_at": 1728788702,
"kind": 1,
"tags": [
[
"t",
"bitcoin"
],
[
"t",
"googlesheets"
],
[
"t",
"googlefinance"
]
],
"content": "Hello Nostr World! \n\nHere's my first contribution to the growing body of knowledge here. \n\nQuestion: How do you get the price of #bitcoin on #googlesheets through #googlefinance functions?\n\nAnswer: Set value of cell A1 to BTC, and on another cell, put one of these formulas:\n\n=GOOGLEFINANCE(\"AR\"\u0026A1)\n=GOOGLEFINANCE(\"CURRENCY:\"\u0026A1\u0026\"USD\")\n=IMPORTDATA(\"https://cryptorates.ai/v1/price/\"\u0026A1)\n=IMPORTDATA(\"https://cryptoprices.cc/\"\u0026A1\u0026\"/\")\n\nThese could work for other cryptocurrencies too.",
"sig": "b0f1c28276f155eb0ffa3d2dc24befd395a846eb9b4acc46c11e6be625ee76b6809ea3584466e370d852b6ae33e5f27071d774cb3ec204ec8ea7f434de323fa9"
}