SQLite Web: whatsapp_automation.db

Id

Primary key. TEXT NOT NULL

SessionId

TEXT NOT NULL

ChatId

TEXT NOT NULL

FromNumber

TEXT

ToNumber

TEXT

Content

{  "type": "trade_recommendation",  "mode": "mixed",  "candidates": [    {      "asset": "QNT/USDT",      "assetType": "crypto",      "strategy": "trend_pullback",      "action": "BUY",      "investment": 24.84,      "requestedInvestment": 50,      "positionSizeMultiplier": 0.5,      "acceptedByOverride": false,      "overrideReason": "",      "entryPrice": 243.51,      "stopLoss": 234.78,      "stopLossLimit": 233.61,      "takeProfit": 258.07,      "positionSize": 0.102,      "potentialGain": 1.44,      "potentialLoss": 0.94,      "estimatedFees": 0.05,      "riskRewardRatio": 1.67,      "netRiskRewardRatio": 1.53,      "changePercent": 7.81,      "score": 68.1,      "normalizedScore": 29.2,      "reasoning": "\uD83D\uDCC9 QNT/USDT en PULLBACK DE TENDENCIA: subió 7.8% en 24h y retrocede 5.07% desde su máximo. RSI 52 enfriándose, volumen 2.0x. Tendencia intacta — entras en la corrección, no en el pico. ⚠️ Posición al 50% (estrategia nueva, muestra 31 trades/30d).",      "marketContext": "Pullback saludable tras rally de 7.8%. Liquidez ≥$20M. ATR 1h 2.39%. SL = ATR×1.5, TP = ATR×2.5.",      "backtest": {        "winRate": 0.51,        "profitFactor": 1.94,        "trades": 55,        "sharpe": 3.61,        "walkForwardPassed": true      },      "backtestWarning": "\uD83D\uDCC9 TrendPullbackStrategy: retroceso en tendencia alcista. Backtest 30d ($20M liquidity): WR 54.8%, R:R 1.53, EV +1.99%/trade, PnL +61.7%. Posición al 50% por muestra chica. Filtro $20M descarta meme coins ilíquidos. Monto efectivo: $25 (50% de $50).",      "instructions": {        "buyTiming": "Ahora, si el precio sigue cerca de la entrada.",        "buyPrice": 243.51,        "sellProfitPrice": 258.07,        "sellLossPrice": 234.78,        "deadline": "Si en 48h no toca TP, cierra manualmente a market.",        "exchange": "Binance",        "method": "TP/SL integrado",        "steps": [          "1️⃣ Binance → Spot → QNT/USDT",          "2️⃣ COMPRAR: 0.102 QNT @ market",          "3️⃣ Activar ☑️

TEXT NOT NULL

Type

INTEGER NOT NULL

Direction

INTEGER NOT NULL

Status

INTEGER NOT NULL

Timestamp

TEXT NOT NULL

MessageId

TEXT

ErrorMessage

TEXT

SentBy

INTEGER NOT NULL

whatsapp_automation.db — Messages

Update row 0AE9FE01-8224-4BE1-8979-A22837F1F241 in Messages