Just launched! 🚀

cryptosheet.cc

A single spreadsheet filled with your cryptocurrency transaction history, account balances and tickers.

Using Cryptosheet.cc: Extract the cumulative historic wallet size for a specific crypto currency and exchange

,
by

This is what I mean with cumulative historic wallet size:

cryptosheet-cumulative-historic-wallet

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.

Open spreadsheet

You can go to your Settings page on cryptosheet.cc, and check the Google Sheets Section for the spreadsheet you configured:

cryptosheet-google-sheets-section.png

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

cryptosheet-create-filtered-worksheet.png

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

In cell A1 of the new sheet, enter the desired filter: ltc-eur-coinbase.

Context: As you can see in your TRANSACTIONS worksheet, in column C named currencyPairExchange, there lies the information to which currency-pair and exchange a transaction belongs to.

cryptosheet.filter-ltc-eur-coinbase.png

Copy transactions header columns

In cell 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:

cryptosheet-create.header.columns.png

Filter transactions

Finally, in cell A3 there is where the magic happens.

Enter =FILTER(TRANSACTIONS!A:M, TRANSACTIONS!C:C = $A$1) and you’ll be amazed.

cryptosheet-filter-transactions.png

Visualize historic cumulative wallet size and value

The results are good, but this is what we are after:

cryptosheet-cumulative-historic-wallet.png

Define cumulative execSize and cumulative execPrice

We choose columns P2 and Q2 as the header rows for the cumulative calculations.

cryptosheet.cumulative-columns.png

In cell P3 enter =SUM($G$3:$G3) and drag down. In cell Q3 enter =P3*E3 and drag down.

And there you have the historic size of your wallet!

Let me know on Twitter @christian_fei!