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": "spot",  "candidates": [    {      "asset": "ZRO/USDT",      "assetType": "crypto",      "action": "BUY",      "investment": 50,      "entryPrice": 1.621,      "stopLoss": 1.56789413,      "stopLossLimit": 1.56005466,      "takeProfit": 1.67157702,      "stopLossPercent": 3.28,      "takeProfitPercent": 3.12,      "positionSize": 30.8452,      "potentialGain": 1.56,      "potentialLoss": 1.64,      "riskRewardRatio": 0.95,      "changePercent": 2.53,      "score": 94,      "scoreBreakdown": {        "score15m": 80,        "score1h": 86,        "score4h": 94,        "atrScore": 65,        "rsiScore": 80,        "adxScore": 100,        "adx1h": 34,        "trendAligned": true,        "emaAligned": true      },      "backtest": {        "trades": 57,        "winRate": 0.561,        "profitFactor": 1.18,        "passed": true      },      "reasoning": "ZRO/USDT muestra momentum con alineación alcista en los 3 timeframes (15m/1h/4h). EMA 9/21 alcista confirmada. Backtest 60d: 57 trades, WR 56 %, PF 1.18. Tendencia confirmada (ADX 1h: 34). ATR de 1.56% en zona saludable. RSI en 49. Sube 2.53% en 24h. Stop-Loss de 3.28% — TP calibrado al ATR real.",      "marketContext": "Cambio 24h: 2.53%. Rango: $1.545000 - $1.703000. Distancia al máximo 24h: 4.82%. ATR: 1.56%. ADX 1h: 34.",      "warnings": [],      "instructions": {        "buyTiming": "Ahora. Tendencia confirmada en 15m/1h/4h.",        "buyPrice": 1.621,        "sellProfitPrice": 1.67157702,        "sellLossPrice": 1.56789413,        "sellLossLimitPrice": 1.56005466,        "deadline": "Cierra en las próximas 2–4 horas (intradía).",        "exchange": "Binance",        "method": "TP/SL integrado (automático)",        "steps": [          "1️⃣ Binance → Trade → Spot → ZRO/USDT",          "2️⃣ COMPRAR: Precio 1.621 | Cantidad 30.8452 ZRO",          "3️⃣ Activa ☑️ TP/SL debajo de 'Total'",          "4️⃣ \uD83C\uDFAF Take Profit: 1.67157702",          "   \uD83D\uDED1 Activación

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 BE0C80C8-455D-4156-A032-CF8F6CA9D808 in Messages