[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","Tringelar","name","binance-arb-paper-bot","path","send-closed-report.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/Tringelar/binance-arb-paper-bot/code/send-closed-report.ts","extension","id","0fd45b75-11b8-4503-bbbf-5f0512015c0a","fileId","c0eee9b6-a88c-11f1-8787-1607ee4eb77e","parentId","branchId","706a186d-17b0-49d7-afcd-061e66763458","branchVersion",76,"latest",true,"createdAt",["D",1788546336880],"version",7,"fileType","script","content","// ============================================================\n// Send Closed-Trades Category Report over Telegram\n// ------------------------------------------------------------\n// Builds a categorized report of all CLOSED trades (tp1/tp2 = win,\n// sl = loss) grouped by exit type, POI type, trend, liquidity,\n// confidence and side — and sends it to the configured Telegram chat.\n// Run manually via run_file.\n// ============================================================\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nasync function sendTelegram(text: string): Promise {\n const token = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\n const chatId = Deno.env.get(\"TELEGRAM_CHAT_ID\");\n if (!token || !chatId) throw new Error(\"Missing TELEGRAM_BOT_TOKEN / TELEGRAM_CHAT_ID\");\n // Split into chunks of <= 3900 chars (Telegram) and send each message.\n const chunks: string[] = [];\n for (let i = 0; i < text.length; i += 3900) chunks.push(text.slice(i, i + 3900));\n const parts: string[] = [];\n for (let i = 0; i < chunks.length; i++) {\n const res = await fetch(`https://api.telegram.org/bot${token}/sendMessage`, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text: chunks[i], parse_mode: \"HTML\", disable_web_page_preview: true }),\n });\n const body = await res.text();\n parts.push(`part${i + 1}/${chunks.length} -> ${res.status}: ${body.slice(0, 120)}`);\n }\n return parts.join(\"\\n\");\n}\n\nconst wrPct = (w: number, l: number) =>\n (w + l) > 0 ? ((w / (w + l)) * 100).toFixed(1) : \"0.0\";\n\n// One grouped row rendered as a Telegram line.\nfunction line(label: string, n: number, w: number, l: number) {\n const pct = wrPct(w, l);\n const emoji = n === 0 ? \"⚪\" : (w / n) >= 0.5 ? \"🟢\" : \"🔴\";\n return `• ${emoji} ${label} — ${pct}% (${w}W/${l}L) · ${n} صفقة`;\n}\n\nexport default async function sendClosedReport() {\n // ---- Overall ----\n const overall = await sqlite.execute(\n `SELECT COUNT(*) AS n,\n SUM(CASE WHEN status IN ('tp1','tp2') THEN 1 ELSE 0 END) AS wins,\n SUM(CASE WHEN status='sl' THEN 1 ELSE 0 END) AS losses\n FROM strategy_trades WHERE status != 'open'`,\n );\n const o = overall.rows[0] as { n: number; wins: number; losses: number };\n\n // ---- Exit types ----\n const exits = await sqlite.execute(\n `SELECT status, COUNT(*) AS n FROM strategy_trades WHERE status != 'open' GROUP BY status`,\n );\n const em = new Map((exits.rows as { status: string; n: number }[]).map((r) => [r.status, r.n]));\n\n // ---- Grouped queries ----\n const grouped = async (col: string, extra = \"\") => {\n const r = await sqlite.execute(\n `SELECT ${col} AS label, COUNT(*) AS n,\n SUM(CASE WHEN status IN ('tp1','tp2') THEN 1 ELSE 0 END) AS wins,\n SUM(CASE WHEN status='sl' THEN 1 ELSE 0 END) AS losses\n FROM strategy_trades WHERE status != 'open' AND ${col} IS NOT NULL\n GROUP BY ${col} ${extra} ORDER BY ${col}`,\n );\n return r.rows as unknown as { label: string; n: number; wins: number; losses: number }[];\n };\n\n const poi = await grouped(\"poi_type\", \", side\");\n const trend = await grouped(\"trend_type\");\n const liq = await grouped(\"liquidity\");\n const conf = await grouped(\"confidence\");\n const side = await grouped(\"side\");\n\n // ---- Smart-learning factors (strategy_factors) ----\n const factors = await sqlite.execute(\n \"SELECT factor, wins, losses FROM strategy_factors ORDER BY factor\",\n );\n const fRows = factors.rows as unknown as { factor: string; wins: number; losses: number }[];\n\n // ---- Per-symbol performance (winning / losing pairs) ----\n const syms = await sqlite.execute(\n `SELECT symbol,\n COUNT(*) AS n,\n SUM(CASE WHEN status IN ('tp1','tp2') THEN 1 ELSE 0 END) AS wins,\n SUM(CASE WHEN status='sl' THEN 1 ELSE 0 END) AS losses,\n SUM(pnl) AS net\n FROM strategy_trades WHERE status != 'open'\n GROUP BY symbol ORDER BY net DESC`,\n );\n const symRows = syms.rows as unknown as {\n symbol: string; n: number; wins: number; losses: number; net: number;\n }[];\n const winsArr = symRows.filter((s) => s.net > 0);\n const lossesArr = symRows.filter((s) => s.net < 0);\n\n // Render a comma-separated list of symbols in chunks (Telegram 4096 char limit).\n const chunk = (arr: { symbol: string; net: number }[], n: number) => {\n const lines: string[] = [];\n for (let i = 0; i < arr.length; i += n) {\n lines.push(arr.slice(i, i + n).map((s) => s.symbol).join(\" \"));\n }\n return lines;\n };\n\n const lines: string[] = [\n \"📊 تقرير الصفقات المغلقة (مصنّف)\",\n \"\",\n `🧮 الإجمالي: ${o.n} صفقة مغلقة`,\n `✅ رابحة: ${o.wins} · ❌ خاسرة: ${o.losses}`,\n `📈 معدل الربح: ${wrPct(o.wins, o.losses)}%`,\n \"\",\n \"① حسب نوع الخروج:\",\n `• 🎯 TP1 (1:1): ${em.get(\"tp1\") ?? 0} · 🎯 TP2 (1:2): ${em.get(\"tp2\") ?? 0} · ⛔ SL: ${em.get(\"sl\") ?? 0}`,\n \"\",\n \"② حسب نوع الدخول (POI + الطرف):\",\n ...poi.map((p) => line(p.label, p.n, p.wins, p.losses)),\n \"\",\n \"③ حسب الاتجاه:\",\n ...trend.map((p) => line(p.label, p.n, p.wins, p.losses)),\n \"\",\n \"④ حسب السيولة:\",\n ...liq.map((p) => line(p.label, p.n, p.wins, p.losses)),\n \"\",\n \"⑤ حسب الثقة:\",\n ...conf.map((p) => line(p.label, p.n, p.wins, p.losses)),\n \"\",\n \"⑥ حسب الطرف:\",\n ...side.map((p) => line(p.label, p.n, p.wins, p.losses)),\n \"\",\n \"🧠 عوامل التعلم الذكي (strategy_factors):\",\n ...fRows.map((f) => line(f.factor, f.wins + f.losses, f.wins, f.losses)),\n \"\",\n `🤑 الأزواج الرابحة (${winsArr.length}):`,\n ...chunk(winsArr, 12),\n \"\",\n `📉 الأزواج الخاسرة (${lossesArr.length}):`,\n ...chunk(lossesArr, 12),\n \"\",\n \"⭐ أفضل الأزواج:\",\n ...winsArr.slice(0, 5).map((s) => `• ${s.symbol} — +${s.net}R (${s.wins}W/${s.losses}L)`),\n \"\",\n \"⚠️ أسوأ الأزواج:\",\n ...lossesArr.slice(0, 5).map((s) => `• ${s.symbol} — ${s.net}R (${s.wins}W/${s.losses}L)`),\n ];\n\n const sent = await sendTelegram(lines.join(\"\\n\"));\n console.log(`Report sent: ${sent}`);\n await blob.setJSON(\"report_send_status\", { at: Date.now(), result: sent });\n return sent;\n}\n","deleted",false,"label",[14],"4656a5b0-561d-4ff3-812e-b3949dee3507",["D",1788372422505],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Binance triangular arbitrage paper bot","imageUrl","userId","a79beaf8-5d23-4a58-a785-4a70bab11255","pinnedFileId","01a0634d-9e20-77ee-876e-733794a7e2e2","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0634a-0ca9-7584-9a97-35a1aeb44011","tursoName","4656a5b0561d4ff3812eb3949dee3507","tursoHostname","4656a5b0561d4ff3812eb3949dee3507-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789501263826],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":100},"org",{"_9":10,"_99":100,"_101":100,"_55":56,"_102":103,"_104":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",78,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":63,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":90,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]