pull down to refresh

21 sats \ 0 replies \ @Hodl117 9h \ on: Fun with Google sheets. bitcoin
I thought I'd provide a guide for inputting the price into Excel. I have my own transaction tracker, and your post inspired me to look into it, thanks!
  1. Type in a cell, "BTC/USD".
  2. While the cell is selected, go to the Data tab, choose Stocks, and the data type of the cell should change
  1. On the cell, you should see a symbol appear next to it labeled "Insert Data" when hovered over. Select this, and a list of properties should appear,
  1. Select Price from the list of properties, and the current price should appear to the right of the cell!
If it's in an Excel Table, to refresh the price, right click "BTC/USD" and click "Refresh" from the dropdown menu.
write
preview