[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_172":173,"_174":175},"routes/_app.x.$handle.$name",{"_103":102,"_37":49,"_111":93,"_32":105,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_26":-5,"_122":-5,"_123":-5,"_124":30,"_125":126,"_127":62,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":36,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":30},"version",2,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","464d1959-6479-4323-88bd-d17d0deb59d1","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","webhook.ts","latestPath","fileId","f5e8ab64-a58c-11f1-91cb-1607ee4eb77e","name","fileType","http","content","// Telegram webhook handler — responds to /stats (and other commands).\n// Set the webhook to this endpoint's URL in Telegram:\n// https://api.telegram.org/bot/setWebhook?url=\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { buildReport } from \"./bot.ts\";\n\nexport async function http(req: Request) {\n let text = \"Unknown command. Try /stats.\";\n try {\n const update = await req.json();\n const msg = update?.message;\n const cmd: string = (msg?.text ?? \"\").split(/[ @]/)[0];\n\n if (cmd === \"/start\") {\n text = \"Solana Arb Paper Bot ready. Use /stats for the current report.\";\n } else if (cmd === \"/stats\" || cmd === \"/report\") {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS paper_wallet (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n balance REAL NOT NULL DEFAULT 1000.0,\n initial_balance REAL NOT NULL DEFAULT 1000.0,\n total_scans INTEGER NOT NULL DEFAULT 0,\n total_trades INTEGER NOT NULL DEFAULT 0,\n winning_trades INTEGER NOT NULL DEFAULT 0,\n last_report_time INTEGER NOT NULL DEFAULT 0\n )`,\n );\n await sqlite.execute(`INSERT OR IGNORE INTO paper_wallet (id) VALUES (1)`);\n text = await buildReport();\n }\n } catch (e) {\n text = \"Error: \" + (e instanceof Error ? e.message : String(e));\n }\n\n // If this came from a Telegram webhook, reply directly to the chat\n try {\n const update = await req.clone().json();\n const chatId = update?.message?.chat?.id;\n if (chatId) {\n const token = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\n if (token) {\n 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, parse_mode: \"HTML\" }),\n });\n return new Response(\"ok\");\n }\n }\n } catch { /* not a webhook call */ }\n\n return new Response(text, {\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n}\n","createdAt",["D",1788216026411],"branchVersion","branchId","aac67d51-0543-407d-80be-a91c6aa86232","id","bc86fafd-3047-4c1e-b370-575e9419e36d","jup-arb-paper-bot",["D",1788215971075],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Jupiter v6 Solana arbitrage paper trading bot","imageUrl","ce1d74cb-7bc9-40a2-bbdd-2eb0b3916b37","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a059f6-d6ad-7343-b9ef-2e04007a610e","tursoName","bc86fafd30474c1eb370575e9419e36d","tursoHostname","bc86fafd30474c1eb370575e9419e36d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_110":105},"org",{"_103":102,"_104":105,"_106":105,"_19":59,"_107":108,"_109":30},"branch",{"_13":92,"_37":93,"_47":46,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":49,"_101":102},"isOwned",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","moju","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_47":48,"_37":49,"_42":167,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":36,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":168,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":169,"_87":170,"_89":171,"_91":30},"tree",[158,159],"files",[158,159],"counts",{"_148":66,"_149":143,"_150":66,"_151":152,"_153":154},"contents",[132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":140,"_37":141,"_35":142,"_135":-5,"_45":46,"_44":143,"_136":30,"_42":144,"_13":66,"_38":145,"_40":146,"_29":30,"_138":-5,"_32":147},{"_47":134,"_37":33,"_35":36,"_135":-5,"_45":46,"_44":14,"_136":62,"_42":137,"_13":66,"_38":39,"_40":41,"_29":30,"_138":-5,"_32":139},"968577be-4bb7-4838-b333-796f044de4d0","parentId","latest",["D",1788216026411],"label",[33],"2a6f4e8e-ee1d-40c3-813f-bacdaf142cac","bot.ts","ef72a1e0-a58c-11f1-bfa9-1607ee4eb77e",1,["D",1788216015627],"interval","// Solana Arbitrage Paper Trading Bot — Jupiter Quote API v6\n// Runs every 1–2 minutes. Logs paper trades to SQLite, sends a Telegram\n// summary at most every 10 minutes. No per-trade notifications.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ---------- Config ----------\nconst USDC = \"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v\";\nconst TOKENS: { symbol: string; mint: string }[] = [\n { symbol: \"RAY\", mint: \"4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R\" },\n { symbol: \"PYTH\", mint: \"HZ1Jov316AYPjh9211JH28C32V5p2823673523537235\" },\n { symbol: \"ORCA\", mint: \"orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE\" },\n { symbol: \"JTO\", mint: \"jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL\" },\n { symbol: \"KMNO\", mint: \"KMNo3nJsBXf32CTCh4x2P3f3725v456789123456789\" },\n { symbol: \"DRIFT\", mint: \"DriFtupJYLTosbwoN8koLmwFCZXYX41H2145678912\" },\n { symbol: \"TNSR\", mint: \"TNSR823456789123456789123456789123456789123\" },\n { symbol: \"RENDER\", mint: \"rndR1fSrL32555B2mFu16m615555555555555555555\" },\n];\n\nconst TRADE_AMOUNT_USDC = 100;\nconst SLIPPAGE_BPS = 30;\nconst GAS_FEE_USDC = 0.005;\nconst MIN_NET_PROFIT = 0.05;\nconst REPORT_INTERVAL_MS = 10 * 60 * 1000;\nconst JUP_QUOTE = \"https://quote-api.jup.ag/v6/quote\";\n\nconst BASE58_RE = /^[1-9A-HJ-NP-Za-km-z]{32,44}$/;\n// Skip mints that are obviously invalid (bad length/base58) so Jupiter isn't spammed\nconst TOKENS_VALID = TOKENS.filter(\n (t) => BASE58_RE.test(t.mint) && t.mint.length === 44,\n);\nconst TOKENS_SKIPPED = TOKENS.filter((t) => !TOKENS_VALID.includes(t));\n\n// ---------- DB ----------\nasync function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS paper_wallet (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n balance REAL NOT NULL DEFAULT 1000.0,\n initial_balance REAL NOT NULL DEFAULT 1000.0,\n total_scans INTEGER NOT NULL DEFAULT 0,\n total_trades INTEGER NOT NULL DEFAULT 0,\n winning_trades INTEGER NOT NULL DEFAULT 0,\n last_report_time INTEGER NOT NULL DEFAULT 0\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS paper_trades (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n symbol TEXT NOT NULL,\n profit_loss REAL NOT NULL,\n arb_percent REAL NOT NULL,\n route TEXT NOT NULL,\n timestamp INTEGER NOT NULL\n )`);\n await sqlite.execute(\n `INSERT OR IGNORE INTO paper_wallet (id) VALUES (1)`,\n );\n}\n\ninterface Wallet {\n balance: number;\n initial_balance: number;\n total_scans: number;\n total_trades: number;\n winning_trades: number;\n last_report_time: number;\n}\n\nasync function getWallet(): Promise {\n const r = await sqlite.execute(\"SELECT * FROM paper_wallet WHERE id = 1\");\n return r.rows[0] as unknown as Wallet;\n}\n\n// ---------- Jupiter quotes (parallel) ----------\nasync function fetchQuote(inputMint: string, outputMint: string) {\n const url =\n `${JUP_QUOTE}?inputMint=${inputMint}&outputMint=${outputMint}` +\n `&amount=${BigInt(TRADE_AMOUNT_USDC * 1e6)}&slippageBps=${SLIPPAGE_BPS}` +\n `&onlyDirectRoutes=true`;\n const res = await fetch(url, {\n headers: { accept: \"application/json\" },\n });\n if (!res.ok) throw new Error(`Jupiter ${res.status}`);\n const j = await res.json();\n if (!j || !j.outAmount) throw new Error(\"no route\");\n return j;\n}\n\ninterface ArbResult {\n symbol: string;\n arbPercent: number;\n netProfit: number;\n route: string;\n}\n\nasync function checkToken(t: { symbol: string; mint: string }) {\n // USDC -> token, then token -> USDC (round-trip), concurrently\n const [buy, sell] = await Promise.all([\n fetchQuote(USDC, t.mint),\n fetchQuote(t.mint, USDC),\n ]);\n const outUsdc = Number(sell.outAmount) / 1e6;\n const grossProfit = outUsdc - TRADE_AMOUNT_USDC;\n const netProfit = grossProfit - GAS_FEE_USDC;\n const arbPercent = (grossProfit / TRADE_AMOUNT_USDC) * 100;\n return {\n symbol: t.symbol,\n arbPercent,\n netProfit,\n route:\n (buy.routePlan || [])\n .map((s: any) => s.swapInfo?.label ?? s.swapInfo?.ammKey ?? \"?\")\n .join(\" → \") || \"direct\",\n } as ArbResult;\n}\n\n// ---------- Telegram ----------\nasync function sendTelegram(text: string) {\n const token = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\n const chatId = Deno.env.get(\"TELEGRAM_CHAT_ID\");\n if (!token || !chatId) {\n console.log(\"[telegram] missing TELEGRAM_BOT_TOKEN / TELEGRAM_CHAT_ID; skipping send\");\n return false;\n }\n 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, parse_mode: \"HTML\" }),\n });\n return true;\n}\n\n// Shared by cron and the /stats HTTP handler\nexport async function buildReport() {\n const w = await getWallet();\n const since = w.last_report_time;\n const trades = await sqlite.execute(\n \"SELECT * FROM paper_trades WHERE timestamp > ? ORDER BY timestamp\",\n [since],\n );\n const recent = trades.rows as unknown as {\n symbol: string;\n profit_loss: number;\n arb_percent: number;\n route: string;\n timestamp: number;\n }[];\n\n const pnl = w.balance - w.initial_balance;\n const pnlPct = (pnl / w.initial_balance) * 100;\n const winRate = w.total_trades > 0 ? (w.winning_trades / w.total_trades) * 100 : 0;\n const avgArb = recent.length\n ? recent.reduce((s, t) => s + t.arb_percent, 0) / recent.length\n : 0;\n\n const lines = [\n \"📊 Solana Arb Paper Bot — 10min Report\",\n \"\",\n `💰 Balance: $${w.balance.toFixed(2)}`,\n `📈 PnL: ${pnl >= 0 ? \"+\" : \"\"}$${pnl.toFixed(4)} (${pnlPct.toFixed(3)}%)`,\n `🎯 Win Rate: ${winRate.toFixed(1)}% (${w.winning_trades}/${w.total_trades})`,\n `🔍 Total Scans: ${w.total_scans}`,\n `⚡ Trades (last 10m): ${recent.length}`,\n `📊 Avg Arb (last 10m): ${avgArb.toFixed(4)}%`,\n \"\",\n ];\n if (recent.length === 0) {\n lines.push(\"No trades captured in the last 10 minutes.\");\n } else {\n lines.push(\"Last 10m trades:\");\n for (const t of recent) {\n lines.push(\n `• ${t.symbol} | ${t.arb_percent.toFixed(3)}% | ` +\n `${t.profit_loss >= 0 ? \"+\" : \"\"}$${t.profit_loss.toFixed(4)} | ${t.route}`,\n );\n }\n }\n return lines.join(\"\\n\");\n}\n\nasync function maybeSendReport(w: Wallet): Promise {\n const now = Date.now();\n if (now - w.last_report_time < REPORT_INTERVAL_MS) return w;\n const report = await buildReport();\n await sendTelegram(report);\n await sqlite.execute(\n \"UPDATE paper_wallet SET last_report_time = ? WHERE id = 1\",\n [now],\n );\n return { ...w, last_report_time: now };\n}\n\n// ---------- Cron entrypoint ----------\nexport default async function paperTradingBot() {\n await initDb();\n let w = await getWallet();\n\n // Parallel quote sweep across all tokens\n const results = await Promise.allSettled(TOKENS_VALID.map(checkToken));\n\n const arbs: ArbResult[] = [];\n for (const r of results) {\n if (r.status === \"fulfilled\") {\n arbs.push(r.value);\n } else {\n console.log(\"[scan] quote failed:\", r.reason?.message ?? r.reason);\n }\n }\n\n // Execute profitable paper trades (quiet — no per-trade notifications)\n let executed = 0;\n for (const a of arbs) {\n if (a.netProfit >= MIN_NET_PROFIT && w.balance >= TRADE_AMOUNT_USDC) {\n await sqlite.execute(\n `INSERT INTO paper_trades (symbol, profit_loss, arb_percent, route, timestamp)\n VALUES (?, ?, ?, ?, ?)`,\n [a.symbol, a.netProfit, a.arbPercent, a.route, Date.now()],\n );\n w = {\n ...w,\n balance: w.balance + a.netProfit,\n total_trades: w.total_trades + 1,\n winning_trades: w.winning_trades + 1,\n };\n executed++;\n }\n }\n\n w.total_scans += 1;\n await sqlite.execute(\n `UPDATE paper_wallet SET balance = ?, total_scans = ?, total_trades = ?, winning_trades = ?\n WHERE id = 1`,\n [w.balance, w.total_scans, w.total_trades, w.winning_trades],\n );\n\n console.log(\n `[scan] quotes ok: ${arbs.length}/${TOKENS_VALID.length}, executed: ${executed}, balance: $${w.balance.toFixed(2)}`,\n );\n if (TOKENS_SKIPPED.length) {\n console.log(\n \"[scan] skipped invalid mints:\",\n TOKENS_SKIPPED.map((t) => t.symbol).join(\", \"),\n );\n }\n\n // At most one Telegram summary per 10 minutes\n await maybeSendReport(w);\n}\n",[141],"pulls","branches","forks","envVars",{"_155":14,"_157":66},"connections",{"_155":66,"_156":66},"count","unfilledCount","emptyCount",{"_47":140,"_37":141,"_35":142,"_135":-5,"_45":46,"_44":143,"_136":30,"_42":164,"_13":66,"_38":145,"_40":146,"_29":30,"_138":-5,"_161":165,"_32":166},{"_47":134,"_37":33,"_35":36,"_135":-5,"_45":46,"_44":14,"_136":62,"_42":160,"_13":66,"_38":39,"_40":41,"_29":30,"_138":-5,"_161":162,"_32":163},["D",1788216026411],"children",[],[33],["D",1788216015627],[],[141],["D",1788215971075],["D",1789526460011],{"_103":102,"_110":105},{"_103":102,"_104":105,"_106":105,"_19":59,"_107":108,"_109":30},{"_13":92,"_37":93,"_47":46,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":49,"_101":102},"ctx",{"_85":-5,"_129":205,"_206":207,"_208":209,"_210":30,"_211":30,"_212":30,"_213":62,"_214":-5,"_215":-7,"_216":-7,"_217":66,"_218":30,"_219":30,"_220":-5,"_221":30,"_222":30,"_223":30,"_224":-5},"ENV",{"_176":177,"_178":179,"_180":93,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v2