Bitcoin Watch

New Subscriber

NOTE: Spreadsheet @ bottom.  If you are on mobile,  you will need to scroll to the right to see all columns. 

I never did much with bitcoin until recently. I was intrigued by a shop owner in Fort Lauderdale who had a Bitcoin ATM in his shop. We got to talking (I went in there everyday for a bit) and he advised me to buy $200 worth and forget about it.. I like supporting like minded people, so that’s exactly what I did about a month ago….  Anyway, I’m sharing a simple spreadsheet that keeps track of your bitcoin transactions. You can also use it for What If scenarios. I don’t advise any investment unless you study and know what you’re doing. I haven’t been this enthused about an investment since my great grandfather introduced me to pork belly futures and Drip Funds (esp Coca Cola) when I was a teenager! It pulls data from Google Finance.

Below is a simple spreadsheet keeping track of my bitcoin purchases…. you can also use it for “what if” scenarios or exercises… i.e If I had bought 100 dollars worth of bitcoin on July 31, 2017 what would it be worth today… The formula to pull Bitcoin data from Google Finance is: =GOOGLEFINANCE(“CURRENCY:BTCUSD”) The formula I use for the end of day price (23:59) is =INDEX(GOOGLEFINANCE(“BTCUSD”,”price”,date(2017,7,31)),2,2).

Bitcoin changes all the time….  Price/Bitcoin is the price I paid for my bitcoins. If you see any mistakes, please let me know. I’m working on a more complex spreadsheet which will include other along with other features. See the screenshot below for an explanation… the spreadsheet is below the screenshot.   If you have any questions, comments , concerns or suggestions,  please leave them below the spreadsheet.

Have Questions or comments about this spreadsheet?
Ask them below – You can Also View Answers.