This seems to work:
=INDEX(googlefinance("Currency:BTCUSD", "price", TODAY()),2,2)
Thanks, but the bug has been fixed now at Google's end. Your formula gives me a different value, perhaps because it's less up-to-date.
reply