This tracker keeps track of crypto coins in your possession. It provides an overview of:
- Warm storage: Coins and value on the exchange
- Cold storage: Coins and value in hardware wallets
- Stocks: (Currently under development)
- Total Assets: (Cold, Warm, Stocks and specific profit loss if csv has been loaded)
It reads CSV files from your exchange and provides summaries and pivot tables in tracker.xlsx.
You can adjust refresh rates, enable Excel writing, and view optional live view websites via the Parameters screen.
Tracker was born out of frustration—too many screens to monitor my crypto holdings, stock values, and average purchase prices. Maintaining a spreadsheet manually took too much effort.
Instead of opting for an integrated solution, I chose to experiment with AI tools like Copilot, Claude, Gemini, DeepSeek, and ChatGPT. The journey was full of trial and error—especially the Crypto Fear and Greed Index, where pointer directions and color logic took many iterations to get right.
Starting from basic Python knowledge, this project deepened my understanding of Python and AI. It’s still a work in progress—and a fun one at that.
You can run the program in a Python environment or build a Windows executable using auto-py-to-exe.
tracker.py
tracker.cfg
config_tracker_module.py
calcpiv_module.py
show_readme_module.py
fng_module.py
crypto_ticker_module.py
/crypto/
/screens
Install in the python environment the following
pip install pillow
pip install requests
pip install beautifulsoup4
pip install pywebview
pip install markdown
pip install matplotlib
pip install pywin32
or copy the above in requirements.txt
and on the command line use
pip install -r requirements.txt
Navigate tot Credentials worksheet
- Fill in the name of the exchange (Bitvavo)
- API Key,
- Secret Key
- URL (https://api.bitvavo.com/v2/)
Navigate to Cold_Storage worksheet
- Fill in the short name of the Coin(s) and the Amount in cold_storage
Save the excel files
Start tracker (e.g. python3 tracker.py)
Main program. Checks for tracker.xlsx, creates it if not found.
Credentials sheet: add API keys from your exchange (read only !).
Cold_Storage sheet: enter coin name and amount (value is fetched live).
Auto-generated config file with default settings:
==RefreshRate==
main = 30
warm = 15
cold = 15
total = 15
[WriteData]
warm = True
cold = False
total = True
csv = True
[OptionalURL]
url1 = https://cointelegraph.com/
name1 = Cointelegraph
url2 = https://www.coindesk.com/
name2 = Coindesk
url3 = https://coinmarketcap.com/sentiment/
name3 = Coinmarket Sentiment
[Miscellaneous]
debugmode = False
darkmod = False
demomode = False
cold storage available = True
Handles screen refresh rates and Excel writing.
Note:
- Setting the main screen refresh below 15s may result in CoinGecko rejecting requests.
- dark mode , debug mode* and demo mode toggles are currently functional.
Processes your exchange CSV file.
If enabled in config, it writes:
- Summary →
CSV_History - Raw data →
Raw Data - Pivot tables →
Pivot Table SummaryandPivot Table Detail
Show the current Fear and Greed index. Projects the top 10 Gainers and top 10 Losers. Wil show on the bottom line a crypto ticker with the 20 biggest according to marketcap
Displays this README from within the program.
Contains screen and crypto icons in crypto/ico/32/.
Missing icons have been auto-created. You may customize them.
- Always starts with Bitcoin
- Dropdown: choose other coins
- Bottom-right: exchange rate (EUR/USD)
- Bottom-left: all-time high of selected coin
View coins stored on your exchange.
Manually enter your cold storage holdings in Cold_Storage worksheet. Values are fetched live using your exchange credentials.
Currently, only manual input of total stock value.
Future version will include API integration.
-
Fear and Greed: current crypto Fear and Greed index
including top 10 Gainers & Losers -
AGGR View: live Bitcoin trading
-
User-defined Crypto Sentiments:
- Default 1: Cointelegraph
- Default 2: Coindesk
- Default 3: Coinmarket Sentiment
Loads and processes CSV from your exchange:
- Creates
CSV_History,Raw Data, and pivot tables intracker.xlsx(if enabled).
- Top left: Set screen refresh rates
- Top right: Enable writing data to Excel
- Bottom left: Set URLs for live views
- Bottom right: Toggle:
- Debug mode
- Dark mode
- Demo Mode
- Cold storage availability
- Open Excel: Opens
tracker.xlsx - Init Excel: Creates a fresh
tracker.xlsxWarning: All existing data will be lost!
RefillCredentialsto restart tracking
You're reading it!
Will read a CSV file (e.g. bitvavo's CSV) and calculate and write to
tracker.xlsx (if activated in parameters)
➕Better layout of the screens: Warm, Cold storage, Total Assets. Changed Both Assets in Crypto Assets. All these screens will show the relative change (24h)
(10-07-2025) ➕New menu under options: Both Storage Assets. Shows Warm and Cold Storage combined ➖ Removed obsolete calls
(09-07-2025) ➕Better design of the screens with use of grids, no more alignment issues. Shorter piece of code
(05-07-2025)
➕If on a windows platform the Load & Calculate will create real pivot
tables. Static pivot tables with other platforms. Total overhaul of
this module. Includes: Average buy, Average Sell, Invested
➕README.md will now display icons in color. README will show examples of
screens. Instead of doing the parsing of the text in-program it is now converted to html
➖Removed the in-program parser
Use this program however you like—adjust, expand, break, or improve it.
I'd love to hear about improvements or ideas!
Happy Tracking! 🚀