Hedge Analysis

Query hedge performance

ssh [email protected] "source ~/.nvm/nvm.sh && cd ~/projects/binance-tele-bot && node -e \"
const { MongoClient } = require('mongodb');
require('dotenv').config();
(async()=>{
  const c=new MongoClient(process.env.MONGODB_URI); await c.connect(); const db=c.db();

  // All completed signals with hedge history
  const sigs=await db.collection('ai_signals').find({status:'COMPLETED','hedgeHistory.0':{\\\$exists:true}}).sort({positionClosedAt:-1}).limit(20).toArray();
  console.log('=== HEDGE PERFORMANCE (last 20 hedged signals) ===');
  for(const s of sigs){
    const hh=s.hedgeHistory||[];
    const banked=hh.reduce((sum,h)=>sum+(h.pnlUsdt||0),0);
    const mainPnl=s.pnlUsdt||0;
    const cycles=hh.length;
    const winCycles=hh.filter(h=>(h.pnlUsdt||0)>0).length;
    const recovery=Math.abs(mainPnl)>0?Math.abs(banked/mainPnl*100):0;
    console.log(s.symbol,s.direction,'| cycles:'+cycles,'('+winCycles+'W) | banked:\\\$'+banked.toFixed(2),'| mainPnl:\\\$'+mainPnl.toFixed(2),'| recovery:'+recovery.toFixed(0)+'%','|',s.closeReason);
  }

  // Active signals with hedge
  console.log('\\n=== ACTIVE HEDGED ===');
  const active=await db.collection('ai_signals').find({status:'ACTIVE',hedgeActive:true}).toArray();
  for(const s of active){
    console.log(s.symbol,s.direction,'hedgeCycles:'+s.hedgeCycleCount,'hedgeDir:'+s.hedgeDirection,'hedgeEntry:'+s.hedgeEntryPrice);
  }

  await c.close();
})()\""