The formula for any cell where you want to store the current Bitcoin price.
=GOOGLEFINANCE("CURRENCY:BTCUSD")
To capture the current price of the Standard and Poor 500 Index:
=GOOGLEFINANCE("SPY")
The more you use it, the better it gets... and so do you.
Price: Free. Start Now: Read the User Guide
____________________________________________________
The formula for any cell where you want to store the current Bitcoin price.
=GOOGLEFINANCE("CURRENCY:BTCUSD")
To capture the current price of the Standard and Poor 500 Index:
=GOOGLEFINANCE("SPY")