SQLite Web: whatsapp_automation.db

Id

Primary key. TEXT NOT NULL

SessionId

TEXT NOT NULL

ChatId

TEXT NOT NULL

FromNumber

TEXT

ToNumber

TEXT

Content

"positionSizeMultiplier": 1,      "acceptedByOverride": false,      "overrideReason": "",      "entryPrice": 1208.18,      "stopLoss": 1177.26,      "stopLossLimit": 1171.37,      "takeProfit": 1278.12,      "positionSize": 0.041,      "potentialGain": 2.77,      "potentialLoss": 1.37,      "estimatedFees": 0.1,      "riskRewardRatio": 2.26,      "netRiskRewardRatio": 2.03,      "changePercent": -8.36,      "score": 62.9,      "normalizedScore": 47,      "reasoning": "ZEC/USDT oversold: RSI 20, %B 0.12. Reversión esperada a la media, sin caída sostenida en 1d.",      "marketContext": "Precio cerca de banda inferior de Bollinger.",      "backtest": {        "winRate": 0.49,        "profitFactor": 1.47,        "trades": 55,        "sharpe": 1.05,        "walkForwardPassed": true      },      "backtestWarning": null,      "instructions": {        "buyTiming": "Ahora, si el precio sigue cerca de la entrada.",        "buyPrice": 1208.18,        "sellProfitPrice": 1278.12,        "sellLossPrice": 1177.26,        "deadline": "Si en 24h no toca TP, cierra manualmente a market.",        "exchange": "Binance",        "method": "TP/SL integrado",        "steps": [          "1️⃣ Binance → Spot → ZEC/USDT",          "2️⃣ COMPRAR: 0.041 ZEC @ market",          "3️⃣ Activar ☑️ TP/SL",          "4️⃣ \uD83C\uDFAF TP: 1278.12 (media de Bollinger)",          "   \uD83D\uDED1 SL: 1177.26 (límite 1171.37) (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."      }    }  ]}

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 50F9BB76-7638-4CCC-AFCD-48E46FD64A85 in Messages