If you guys are working on a spreadsheet and didn't have time to check the Bitcoin price on the exchange or other flatform, you can use it in the sheet while you work.
It's just a tutorial, and I just make it easy without a ticker or any tool to check the price.
1. You have open your Google spreadsheet and write the code:
=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
For example:
=GOOGLEFINANCE("CURRENCY:BTCUSD", "price", DATE(2023,4,20), DATE(2023,5,1), "DAILY")
so just simply like that, you can be modified the ticker you want like currency (Euro, GBP, etc), and also the date you want.
let's have fun.
cheers.