This is what I mean with cumulative historic wallet size:
As you can see, it gives me a visualization of how my wallet changed over time and how various price changes, buys & sells influenced it.
Create a new Filtered Worksheet
As an example, we’ll choose LTC-EUR as the currency-pair and coinbase as the exchange.
Let’s give the new Worksheet a name:
LTC-EUR-COINBASE - TRANSACTIONS
FILTER to the rescue
Well use the
FILTER formula to filter transaction for a specific currency-pair and exchange
Define currency-pair and exchange filter
A1 of the new sheet, enter the desired filter:
Context: As you can see in your
TRANSACTIONSworksheet, in column
currencyPairExchange, there lies the information to which currency-pair and exchange a transaction belongs to.
Copy transactions header columns
A2 of the sheet, enter the following formula to copy the header columns:
=FILTER(TRANSACTIONS!A:M, TRANSACTIONS!A:A = "exchange")
It will result in the following:
Finally, in cell
A3 there is where the magic happens.
=FILTER(TRANSACTIONS!A:M, TRANSACTIONS!C:C = $A$1) and you’ll be amazed.
Visualize historic cumulative wallet size and value
The results are good, but this is what we are after:
cumulative execSize and
We choose columns
Q2 as the header rows for the cumulative calculations.
=SUM($G$3:$G3) and drag down.
=P3*E3 and drag down.
And there you have the historic size of your wallet!
Let me know on Twitter @christian_fei!