Hey 👋🏻

My name is Christian, an Agile Developer, living in Trento (IT)

I write good code at Wonderflow

You can follow me on and Github


More about me 🤖




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

This is what I mean with cumulative historic wallet size:

cryptosheet-cumulative-historic-wallet
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
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
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
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
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
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
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
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](https://twitter.com/christian_fei)!