BLOCKCHAIN ANALYTICS PLATFORM

ETH/BTC Wallet Tracker

Real-time Cryptocurrency Portfolio Management & FIFO Tracking System

System Architecture & Data Flow

1

Blockchain Monitoring

Real-time scanning of Ethereum & Bitcoin networks via Etherscan & Mempool APIs

2

Transaction Processing

FIFO-based tracking with gas fee calculation and historical price fetching

3

Data Organization

Automated monthly sheets with client categorization and affiliate tracking

4

Real-time Updates

15-minute automated sync with current market prices from CoinMarketCap

Blockchain Processing Engine

ETH Network Scanner
BTC Network Scanner
ERC-20 Token Support
Gas Fee Calculator
FIFO Algorithm
Historical Prices
Duplicate Prevention
Balance Verification
Error Recovery
Batch Sync
Multi-Chain Support
ETH, BTC, USDT, USDC
FIFO Tracking
Accurate profit/loss calc
Auto Organization
Monthly sheet creation
Historical Data
Price at deposit time
Live Prices
Real-time USD values
Error Handling
Auto-recovery system
100+
Wallets Tracked
15 min
Update Frequency
4 APIs
Data Sources
24/7
Monitoring

Live System Interface

See how the tracker manages wallets and processes transactions

1

Wallet Management Dashboard

🔐 Crypto Wallet Tracker
$2,847,392
Total Portfolio Value
+12.4%
47 ETH
Total Ethereum
+5.2 ETH
3.82 BTC
Total Bitcoin
-0.15 BTC
$124,850
Stablecoins
+$8,400

Active Wallets

Client Wallet Address Type Balance USD Value Last Activity Status
Diamond Trading Co. 0x742d35Cc6634C053...2a65 ETH 12.45 ETH $37,350 2 hours ago ● Active
Crypto Holdings LLC bc1qxy2kgdygjrsqtz...p2pkh BTC 1.82 BTC $172,900 12 hours ago ● Active
Tech Ventures 0x08c65872dd31315a...2620 ETH 8.73 ETH $26,190 1 day ago ● Pending

Recent Transaction Flow

Deposits
24
Processing
FIFO
Withdrawals
18
Balance
Updated
🔍 Real-time Monitoring
Continuous blockchain scanning with 15-minute update intervals for all tracked wallets
⚡ Instant Sync
One-click full synchronization processes entire transaction history with duplicate prevention
📊 Portfolio Analytics
Live portfolio valuation with historical tracking and profit/loss calculations
2

Automated Google Sheets Data Structure

January-2025
February-2025
March-2025
April-2025
May-2025
June-2025
July-2025
August-2025
Error Logs
Date ClientName Token USDatDeposit AmountRemainingCRYPTO AmountRemainingUSD AmountWithdrawnTotalUSD TotalUSD Affiliate Advertiser Wallet
2025-04-01 09:15:22 Diamond Trading Co. ETH $15,000.00 5.00000000 $15,250.00 $0.00 $15,250.00 Partner A Campaign X 0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb
2025-04-02 14:30:45 Crypto Holdings LLC BTC $95,000.00 1.00000000 $97,500.00 $0.00 $97,500.00 Direct Organic bc1qxy2kgdygjrsqtzq2n0yrf2493p83kkfjhx0wlh
2025-04-03 11:45:18 Tech Ventures USDT $50,000.00 50,000.00 $50,000.00 $0.00 $50,000.00 Partner B Campaign Y 0x08c65872dd31315aa668700ac9067da19cac2620
2025-04-05 16:20:33 Diamond Trading Co. ETH $9,000.00 2.85000000 $8,692.50 $1,500.00 $10,192.50 Partner A Campaign X 0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb
2025-04-07 08:55:12 Investment Group USDC $25,000.00 25,000.00 $25,000.00 $0.00 $25,000.00 Partner C Campaign Z 0xBBA11906333a9096b03e360a0bFB30869e68d382
2025-04-08 13:10:45 Crypto Holdings LLC BTC $47,500.00 0.42000000 $40,950.00 $8,450.00 $49,400.00 Direct Organic bc1qxy2kgdygjrsqtzq2n0yrf2493p83kkfjhx0wlh
📅 Monthly Organization
Automatic creation of monthly sheets with chronological sorting for easy navigation and reporting
💎 FIFO Tracking
First-In-First-Out algorithm ensures accurate profit/loss calculations and remaining balances
🔢 Precision Handling
8 decimal places for crypto amounts, automatic USD formatting, and gas fee deduction tracking
3

Metadata & Client Management Sheet

ETH Wallets
BTC Wallets
Analytics
Reports
Wallet Address Client Name Affiliate Advertiser Total Remaining USD Registration Date Last Updated Status
0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb Diamond Trading Co. Partner A Campaign X $37,350.00 2024-01-15 2025-08-09 14:30 Active
0x08c65872dd31315aa668700ac9067da19cac2620 Tech Ventures Partner B Campaign Y $26,190.00 2024-03-20 2025-08-09 14:30 Active
0xd3Ae43f5F3d20331a1Df2cFFF238b792773a60A0 Hedge Fund Alpha Direct Organic $142,800.00 2024-02-10 2025-08-09 14:30 Active
0xBBA11906333a9096b03e360a0bFB30869e68d382 Investment Group Partner C Campaign Z $89,450.00 2024-05-05 2025-08-09 14:30 Active
0x5aAeb6053f3E94C9b9A09f33669435E7Ef1BeAed Crypto Miners Inc. Partner A Campaign W $0.00 2024-06-12 2025-08-09 14:30 Inactive
👥 Client Registry
Centralized management of all wallet addresses with client mapping and affiliate tracking
💵 Live Balances
Real-time USD value aggregation across all transactions for each wallet
📈 Analytics Ready
Structured data perfect for reporting, analysis, and business intelligence