Dec 23 2021 06:34 PM - edited Dec 23 2021 07:48 PM
Hi, newbie here... I am wanting to have my spreadsheet keep track of my Crypto auto-buys.
So, each week my cryptocurrency site automatically buys a certain amount Bitcoin (BTC) and it is added to my portfolio (dollar-cost-averaging) via a recurring buy order.
Now I want that reflected in my Crypto spreadsheet. So that every 7 days the spreadsheet updates the cells with a new total dollar amount invested for each coin.
So for example, assuming that cell C3 shows my current amount invested in BTC as $5000, then something that would reflect that (if todays date = (previous date + 7 days) then (c3=c3+$50)). Therefore showing a new total of $5050 in C3 for BTC total invested.
Is something like this possible?
Cheers
Muddypaw
Dec 23 2021 10:36 PM
Dec 23 2021 11:38 PM
@Max_ie You could use a formula that calculates the number of whole weeks that have past since your first buy. In its simplest form, that could look something like this:
where A5 contains =TODAY()