[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_104":105,"_106":107},"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-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":36,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":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-report.ts","extension","id","b32d2b73-7a41-472f-a21e-127babba8424","fileId","6280ef4e-a88e-11f1-8e01-1607ee4eb77e","parentId","branchId","706a186d-17b0-49d7-afcd-061e66763458","branchVersion",78,"latest",true,"createdAt",["D",1788546491651],"version",0,"fileType","http","content","// HTTP trigger to build & send the closed-trades report over Telegram.\n// Returns the raw Telegram API response so the caller can see what happened.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/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) return \"ERROR: missing TELEGRAM_BOT_TOKEN / TELEGRAM_CHAT_ID\";\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, 200)}`);\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\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 handler(req: Request) {\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 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 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 const factors = await sqlite.execute(\"SELECT factor, wins, losses FROM strategy_factors ORDER BY factor\");\n const fRows = factors.rows as unknown as { factor: string; wins: number; losses: number }[];\n\n const syms = await sqlite.execute(\n `SELECT symbol, 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' 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 const chunk = (arr: { symbol: string }[], n: number) => {\n const lines: string[] = [];\n for (let i = 0; i < arr.length; i += n) lines.push(arr.slice(i, i + n).map((s) => s.symbol).join(\" \"));\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 result = await sendTelegram(lines.join(\"\\n\"));\n return new Response(result, { headers: { \"content-type\": \"text/plain\" } });\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","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,"_103":98},"org",{"_9":10,"_97":98,"_99":98,"_55":56,"_100":101,"_102":42},"branch",{"_35":30,"_11":88,"_22":28,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":12,"_96":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_137":138,"_139":140,"_141":142,"_143":42,"_144":42,"_145":42,"_146":32,"_147":-5,"_148":-7,"_149":-7,"_150":36,"_151":42,"_152":42,"_153":-5,"_154":42,"_155":42,"_156":42,"_157":-5},"ENV",{"_108":109,"_110":111,"_112":88,"_113":114,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136},"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"]