Calculating “Total Received” and Balance by Address: A Step-by-Step Guide

As a cryptocurrency enthusiast, understanding the intricacies of Ethereum’s blockchain can be overwhelming at times. One aspect that often gets overlooked is calculating the total value of received Ether (ETH) and balance for an individual address. In this article, we’ll break down how to do it step by step.

Understanding Ethereum Addresses

Before we dive into calculating “total received” and balance, let’s quickly review Ethereum addresses. An Ethereum address consists of a 40-character string, typically written in hexadecimal (0x…). These strings are unique, public, and can be used to identify an individual user or organization on the Ethereum network.

Total Received

The total value of received Ether is calculated by aggregating all the transactions associated with an address. This requires knowledge of the blockchain’s transaction history, including:

• Transaction hashes: Each transaction is represented by a unique hash. By linking these hashes to their respective addresses and dates, we can reconstruct the entire transaction flow.

• Transaction data: Transaction data contains information such as sender and receiver addresses, amount received or sent, gas fees, etc.

To calculate total received, you’ll need to:

• Fetch the blockchain state using a tool like This will display the current state of your address, including all transactions.

• Extract transaction hashes: Take note of the transaction hashes for each relevant transaction associated with your address.

• Create a database of these transaction hashes and their corresponding addresses. You can use a simple text file or a lightweight database like SQLite.

• Join the transaction data to this hash database, using thehashfields as keys.

Example Use Case

For demonstration purposes, let's say we have an address with 10 transactions:

| Transaction Hash | Receiver Address | Amount Received |

| --- | --- | --- |

| a2...b3c4d5e6f7g8h9i | account1@domain.com | 10 ETH |

To calculate the total received, we can link these hashes to their respective addresses and dates:

| Transaction Hash | Sender Address | Receiver Address | Date |

| --- | --- | --- | --- |

| a2...b3c4d5e6f7g8h9i | account1@domain.com | account2@domain.com | 2022-01-01T00:00:00Z |

| a2...b3c4d5e6f7g8h9i | account1@domain.com | account3@domain.com | 2022-01-02T00:00:00Z |

Balancing the Address

To calculate an individual's balance, you'll need to:

• Fetch the blockchain state: Use a tool like to retrieve your address’s current state.

• Extract sender addresses and amounts: Take note of the sender addresses and their corresponding amounts for each transaction.

Example Use Case

Suppose we want to calculate our balance on January 5th, 2022:

| Transaction Hash | Sender Address | Amount Received |

| — | — | — |

| a2…b3c4d5e6f7g8h9i | account1@domain.com | 100 ETH |

To calculate our balance, we can join the transaction data to this hash database, using the hash fields as keys:

• For January 5th, 2022: a2…b3c4d5e6f7g8h9i

• Sender addresses and amounts for each transaction

Code Example

Here’s an example Python script that demonstrates how to calculate total received and balance using the provided information:

“`python

import sqlite3

Connect to the database

conn = sqlite3.connect(‘transaction_database.db’)

cursor = conn.cursor()

Fetch blockchain state

cursor.execute(“SELECT * FROM transactions WHERE address = ?”, (‘your_address’,))

transactions = cursor.

ethereum name service maker