6 Commits

Author SHA1 Message Date
mindesbunister
d8b0307e74 fix: Use database realizedPnL instead of recalculating from entry/exit
Stats API was recalculating P&L from entry/exit prices which didn't
account for TP1+runner partial closes. This caused incorrect P&L
display (-$26.10 instead of +$46.97).

Fixed:
- Use database realizedPnL (now corrected to match Drift UI)
- Added debug logging to show trade count and total
- Stats now correctly show v8 performance: +$46.97

Note: Database P&L values were corrected in previous commit (cd6f590)
to match Drift UI's actual TP1+runner close values.
2025-11-19 21:53:13 +01:00
mindesbunister
cd6f590742 fix: Correct v8 trade P&L to match Drift UI actual values
Database had inflated P&L from compounding bugs. Corrected to match
Drift Protocol's actual TP1+runner P&L values.

Corrections:
- Trade cmi5p09y: 37.67 → 38.90 (TP1 9.72 + runner 29.18)
- Trade cmi5ie3c: 59.35 → 40.09 (TP1 21.67 + runner 18.42)
- Trade cmi5a6jm: 19.79 → 13.72 (TP1 1.33 + runner 4.08 + 8.31)

v8 total P&L: $46.97 (matches Drift UI exactly)

Note: Each trade shows as 2 lines in Drift UI (TP1 + runner close),
so 5 trades = 10 lines in trade history.
2025-11-19 21:39:13 +01:00
mindesbunister
0d6e95bbab fix: Read TOTAL_WITHDRAWN from file instead of cached process.env
Bug: Second withdrawal showed $5.92 cumulative instead of $12.50
Root cause: process.env caches values at container startup, doesn't
update when .env file changes.

Fix: Parse TOTAL_WITHDRAWN directly from .env file content instead
of using cached process.env value.

Added: Debug logging showing calculation
Manual fix: Updated .env to $12.50 (sum of $6.58 + $5.92)

Result: Withdrawal stats now correctly show cumulative total.
2025-11-19 21:13:26 +01:00
mindesbunister
8d53c4bbad critical: Fix withdrawal statistics to use actual Drift deposits
- Query Drift Protocol's cumulativeDeposits for ground truth
- Discovered user deposited ,440.61 (not hardcoded 46)
- Previous withdrawals: ~26.78 (not tracked in ENV)
- Database P&L -.01 is correct
- Reconciliation: ,440.61 deposits - .01 P&L - 26.78 withdrawn = 11.82 current
- Available profit now shows current balance (includes all trading results)
- Created /api/drift/account-summary endpoint for account reconciliation
- Statistics now mathematically consistent and trustworthy
2025-11-19 19:25:59 +01:00
mindesbunister
1c79178aac fix: TypeScript errors in withdrawal system
- Fixed LAST_WITHDRAWAL_TIME type (null | string)
- Removed parseFloat on health.freeCollateral (already number)
- Fixed getDriftClient() → getClient() method name
- Build now compiles successfully

Deployed: Withdrawal system now live on dashboard
2025-11-19 18:25:54 +01:00
mindesbunister
ca7b49f745 feat: Add automated profit withdrawal system
- UI page: /withdrawals with stats dashboard and config form
- Settings API: GET/POST for .env configuration
- Stats API: Real-time profit and withdrawal calculations
- Execute API: Safe withdrawal with Drift SDK integration
- Drift service: withdrawFromDrift() with USDC spot market (index 0)
- Safety checks: Min withdrawal amount, min account balance, profit-only
- Telegram notifications: Withdrawal alerts with Solscan links
- Dashboard navigation: Added Withdrawals card (3-card grid)

User goal: 10% of profits automatically withdrawn on schedule
Current: Manual trigger ready, scheduled automation pending
Files: 5 new (withdrawals page, 3 APIs, Drift service), 2 modified
2025-11-19 18:07:07 +01:00