Bay Area Buzz

Finance, Programming, Analytics, Healthcare, Travel, Food

Public Key

npub1t2zkepe96udm08ahf4v3mq8ajtalzhfxsdnpf3jpa85q6agntm5qyt6c9p

NIP-57 Address

noisymouse4@primal.net

Profile Code

nprofile1qqs94ptvsujawxahn7m56kgasr7e97l3t5ngxes5ceq7n6qdw5f4a6qpz3mhxue69uhhyetvv9ujuerpd46hxtnfduq3vamnwvaz7tmjv4kxz7fwwpexjmtpdshxuet5dm5d9n

Publishing to

relay.damus.io

relay.primal.net

kadargo.zw.is

Author Public Key

npub1t2zkepe96udm08ahf4v3mq8ajtalzhfxsdnpf3jpa85q6agntm5qyt6c9p

Show more details

Last Notes

2024-10-13 03:05:02

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.

2024-10-13 03:05:02