2023 Crypto Profits and Losses with Dune API

This guide walks you through using a Python notebook for your 2023 crypto tax calculations. By simply inputting your wallet addresses, the notebook fetches line item details and calculates your overall profit or loss (PnL) for the year (in dollar value). It employs the average cost basis method for fungible tokens, which you can learn more about here.

​

Accessing the notebook

• Start editing via this Google Colab Notebook (Note to save you must save another copy.)
• Download from this Hex Notebook

​

Setup

Ensure you have the Dune API SDK installed and your API key ready.

• Install Dune API SDK:

pip install dune_client

• Obtain an API key

​

How to use the notebook

Replace 'your_api_key_here' with your Dune API key:

dune_api_key = 'your_api_key_here'
dune = DuneClient(api_key=dune_api_key, base_url="https://api.dune.com", request_timeout=300)

Input a list of EVM and Solana wallets, separated by commas. For example:

evm_wallets = '0xd8da6bf26964af9d7eed9e03e53415d37aa96045, 0xd7029bdea1c17493893aafe29aad69ef892b8ff2'
# ...
solana_wallets = '6by8iRgL41nY5fzFAmoH8dxzWFwmDmYiMbVUq6fpK69d, FNQVDmTdmWtTaswoL9ysoyorsHZvjRbNsbAdgmcREHVi'

The notebook processes these inputs to provide detailed line items and PnL calculations. Download the line items CSVs and jot down the total PnL. 🎉