I'm not sure how many of you track your purchases, but I do and yesterday I decided to have a bit of fun.
I wanted to see what the % change in price was for all of my individual purchases, so first I needed to add a box for current bitcoin price. I was going to manually update it but found this little gem to have the price auto update:
=GOOGLEFINANCE("BTC-USD")
Now that I have a cell that displays current price all i had to do is plug in a quick formula.
=ROUND((($I$2-D7)/D7),4)
A quick explanation of what that means
=ROUND(((formula)),4)
This is the round function. It's to limit how many decimal places you want. Quick note, if you want 2 pick 4 because when you format a cell to percent ot changes where the decimal is. Example: .3564 becomes %35.64
This is the round function. It's to limit how many decimal places you want. Quick note, if you want 2 pick 4 because when you format a cell to percent ot changes where the decimal is. Example: .3564 becomes %35.64
The next part is the formula to find percent increase. Cell I2 is my bitcoin price, but when I populate a whole colume I don't want the formula to change on every row. Normal a formula you copy would automatically increase so I2 I3 I4 etc. The $ means that this is an absolute value and I dont want it to change.
The D column is my original purchase price. Because I didn't put the $ in every row automatically goes up by one when you automatically fill the formula.
Note the D44 switches to D45 on the following row.
Hopefully this is useful to somone.