Hey,
Does anybody on the market have a spreadsheet template for holding monitor of your Bitcoin purchases, purchase costs, value common, and many others??
Actually I am on the lookout for a formulation that will take “satoshis bought” for “x complete worth” and work out the worth of a single Bitcoin.
(I.e.) I bought .25btc for $5000 – formulation ought to work out the worth of 1 btc at 20k
Any assist could be appreciated, attempting to get my geese in a row!
Here’s mine. Its got other catagories too to track where and when you purchased.
=SUM($F$2:F2/I2) Cost Basis = TotalBuy/TotalBTC
https://1drv.ms/x/s!AkY-d5AiJXDymibiSJcZC3ZJVVtu?e=6qo1xP