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": "LINK/USDT",      "assetType": "crypto",      "strategy": "mean_reversion",      "action": "BUY",      "investment": 49.87,      "requestedInvestment": 50,      "positionSizeMultiplier": 1,      "acceptedByOverride": false,      "overrideReason": "",      "entryPrice": 12.92,      "stopLoss": 12.791,      "stopLossLimit": 12.727,      "takeProfit": 13.199,      "positionSize": 3.86,      "potentialGain": 0.98,      "potentialLoss": 0.6,      "estimatedFees": 0.1,      "riskRewardRatio": 2.16,      "netRiskRewardRatio": 1.63,      "changePercent": -3.17,      "score": 84.4,      "normalizedScore": 77.8,      "reasoning": "LINK/USDT oversold: RSI 26, %B -0.01. Reversión esperada a la media, sin caída sostenida en 1d.",      "marketContext": "Precio cerca de banda inferior de Bollinger.",      "backtest": {        "winRate": 0.6,        "profitFactor": 2.14,        "trades": 43,        "sharpe": 1.78,        "walkForwardPassed": true      },      "backtestWarning": null,      "instructions": {        "buyTiming": "Ahora, si el precio sigue cerca de la entrada.",        "buyPrice": 12.92,        "sellProfitPrice": 13.199,        "sellLossPrice": 12.791,        "deadline": "Si en 24h no toca TP, cierra manualmente a market.",        "exchange": "Binance",        "method": "TP/SL integrado",        "steps": [          "1️⃣ Binance → Spot → LINK/USDT",          "2️⃣ COMPRAR: 3.86 LINK @ market",          "3️⃣ Activar ☑️ TP/SL",          "4️⃣ \uD83C\uDFAF TP: 13.199 (media de Bollinger)",          "   \uD83D\uDED1 SL: 12.791 (límite 12.727) (bajo la banda inferior)"        ],        "note": "⚠️ Si en 24h no toca TP, cierra a market. El stop-limit puede no ejecutarse ante gaps: vigila la posición."      }    },    {      "asset": "ZEC/USDT",      "assetType": "crypto",      "strategy": "mean_reversion",      "action": "BUY",      "investment": 49.54,      "requestedInvestment": 50,

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 38777AE9-72A6-45C4-97CA-1E82A108BE5E in Messages