[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_105":106,"_107":108},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","moju","name","jup-arb-paper-bot","path","bot.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/moju/jup-arb-paper-bot/code/bot.ts","extension","id","b30043e0-bd20-48a2-b587-3014d6743cc3","fileId","ef72a1e0-a58c-11f1-bfa9-1607ee4eb77e","parentId","branchId","aac67d51-0543-407d-80be-a91c6aa86232","branchVersion",21,"latest",true,"createdAt",["D",1788746402897],"version",17,"fileType","interval","content","// Solana Arbitrage Paper Trading Bot — Jupiter Lite API\n// One scan per invocation (interval trigger handles repetition).\n// Tokens: top 40 by organic score, fetched dynamically each run.\n// Arb measurement: a SINGLE chained round-trip quote (USDC → X → USDC),\n// where the sell leg is quoted on the buy leg's actual output amount.\n// Every scan result (profit OR loss) is recorded — realistic simulation.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ---------- Config ----------\nconst USDC = \"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v\";\nconst JUP_QUOTE = \"https://lite-api.jup.ag/swap/v1/quote\";\nconst JUP_TOP_TOKENS =\n \"https://lite-api.jup.ag/tokens/v2/toporganicscore/24h?limit=60&isStrictList=true\";\n\nconst TRADE_AMOUNT_USDC = 50;\nconst MAX_TOKENS = 40; // scan up to 40 tokens per run\nconst MIN_LIQUIDITY_USD = 50_000; // ignore illiquid tokens\nconst SLIPPAGE_BPS = 30;\nconst GAS_FEE_USDC = 0.005;\nconst MIN_NET_PROFIT = 0.05; // $ threshold to book a \"winning\" trade\nconst MIN_ARB_PERCENT = 0.4; // minimum genuine arb % to act on\nconst REPORT_INTERVAL_MS = 10 * 60 * 1000;\n\n// ---------- Token list (dynamic, top by organic score) ----------\ninterface TokenInfo {\n symbol: string;\n mint: string;\n decimals: number;\n liquidity: number;\n}\n\nasync function fetchTopTokens(): Promise {\n const res = await fetch(JUP_TOP_TOKENS, {\n headers: { accept: \"application/json\" },\n });\n if (!res.ok) throw new Error(`Jupiter tokens ${res.status}`);\n const list = (await res.json()) as any[];\n return list\n .filter(\n (t) =>\n t.id !== USDC &&\n t.id !== \"So11111111111111111111111111111111111111112\" &&\n t.usdPrice > 0 &&\n (t.liquidity ?? 0) >= MIN_LIQUIDITY_USD,\n )\n .slice(0, MAX_TOKENS)\n .map((t) => ({\n symbol: t.symbol,\n mint: t.id,\n decimals: t.decimals,\n liquidity: t.liquidity,\n }));\n}\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 50.0,\n initial_balance REAL NOT NULL DEFAULT 50.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 losing_trades INTEGER NOT NULL DEFAULT 0,\n last_report_time INTEGER NOT NULL DEFAULT 0\n )`);\n await sqlite.execute(\n `ALTER TABLE paper_wallet ADD COLUMN losing_trades REAL NOT NULL DEFAULT 0`,\n ).catch(() => {});\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(`INSERT OR IGNORE INTO paper_wallet (id) VALUES (1)`);\n}\n\ninterface Wallet {\n balance: number;\n initial_balance: number;\n total_scans: number;\n total_trades: number;\n winning_trades: number;\n losing_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 ----------\nasync function fetchQuote(inputMint: string, outputMint: string, amount: string) {\n const url =\n `${JUP_QUOTE}?inputMint=${inputMint}&outputMint=${outputMint}` +\n `&amount=${amount}&slippageBps=${SLIPPAGE_BPS}&onlyDirectRoutes=true`;\n const res = await fetch(url, { headers: { accept: \"application/json\" } });\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; // gross round-trip arb %\n netProfit: number; // after gas fee\n route: string;\n}\n\n// Realistic arb check: chained quotes in sequence.\n// Leg 1: USDC → X. Leg 2: X → USDC using the EXACT tokens we just bought.\n// arb% < 0 is normal (spread + slippage); > 0 means a genuine price dislocation.\nasync function checkToken(t: TokenInfo) {\n const amountIn = BigInt(TRADE_AMOUNT_USDC * 1e6).toString();\n\n // Leg 1: buy X with USDC\n const buy = await fetchQuote(USDC, t.mint, amountIn);\n const tokensBought = buy.outAmount as string;\n\n // Leg 2: immediately sell those exact tokens back to USDC\n const sell = await fetchQuote(t.mint, USDC, tokensBought);\n const outUsdc = Number(sell.outAmount) / 1e6;\n\n const grossProfit = outUsdc - TRADE_AMOUNT_USDC;\n const netProfit = grossProfit - GAS_FEE_USDC;\n const arbPercent = (grossProfit / TRADE_AMOUNT_USDC) * 100;\n\n const route = [\n ...new Set(\n (buy.routePlan || []).concat(sell.routePlan || []).map(\n (s: any) => s.swapInfo?.label ?? s.swapInfo?.ammKey ?? \"?\",\n ),\n ),\n ].join(\" → \");\n\n return { symbol: t.symbol, arbPercent, netProfit, route } 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 / ${w.losing_trades}L / ${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} — Arb: ${t.arb_percent >= 0 ? \"+\" : \"\"}${t.arb_percent.toFixed(3)}% | ` +\n `PnL: ${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\n // Dynamic token list — top 40 liquid tokens\n let tokens: TokenInfo[] = [];\n try {\n tokens = await fetchTopTokens();\n } catch (err) {\n console.error(\"[tokens] fetch failed:\", err);\n }\n\n if (tokens.length === 0) {\n console.log(\"[scan] no tokens fetched; skipping this cycle\");\n return;\n }\n console.log(`[scan] scanning ${tokens.length} tokens (top organic score, liq > $${MIN_LIQUIDITY_USD / 1000}k)`);\n\n let w = await getWallet();\n\n // Sequential round-trips (rate-limit friendly)\n const results = await Promise.allSettled(tokens.map(checkToken));\n\n let scans = 0, executed = 0, wins = 0, losses = 0;\n const arbs: ArbResult[] = [];\n for (const r of results) {\n if (r.status !== \"fulfilled\") {\n console.log(\"[scan] quote failed:\", r.reason?.message ?? r.reason);\n continue;\n }\n const a = r.value;\n scans++;\n arbs.push(a);\n // A trade counts only if the REAL round-trip arb clears the threshold\n if (a.arbPercent >= MIN_ARB_PERCENT && 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 = { ...w, balance: w.balance + a.netProfit, total_trades: w.total_trades + 1, winning_trades: w.winning_trades + 1 };\n executed++; wins++;\n } else if (a.arbPercent < 0 && a.netProfit < 0 && w.balance >= TRADE_AMOUNT_USDC) {\n // book small losses too — keeps the simulation honest\n const loss = Math.max(a.netProfit, -0.05); // cap modeled loss per scan\n await sqlite.execute(\n `INSERT INTO paper_trades (symbol, profit_loss, arb_percent, route, timestamp)\n VALUES (?, ?, ?, ?, ?)`,\n [a.symbol, loss, a.arbPercent, a.route, Date.now()],\n );\n w = { ...w, balance: w.balance + loss, total_trades: w.total_trades + 1, losing_trades: w.losing_trades + 1 };\n executed++; losses++;\n }\n }\n\n w.total_scans += 1;\n await sqlite.execute(\n `UPDATE paper_wallet SET balance = ?, total_scans = ?, total_trades = ?, winning_trades = ?, losing_trades = ?\n WHERE id = 1`,\n [w.balance, w.total_scans, w.total_trades, w.winning_trades, w.losing_trades],\n );\n\n const best = arbs.sort((a, b) => b.arbPercent - a.arbPercent)[0];\n console.log(\n `[scan] round-trips ok: ${scans}/${tokens.length}, wins: ${wins}, losses: ${losses}, balance: $${w.balance.toFixed(2)}` +\n (best ? `, best arb: ${best.symbol} ${best.arbPercent.toFixed(3)}%` : \"\"),\n );\n\n // At most one Telegram summary per 10 minutes\n await maybeSendReport(w);\n}\n","deleted",false,"label",[14],"bc86fafd-3047-4c1e-b370-575e9419e36d",["D",1788215971075],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Jupiter v6 Solana arbitrage paper trading bot","imageUrl","userId","ce1d74cb-7bc9-40a2-bbdd-2eb0b3916b37","pinnedFileId","f5e8ab64-a58c-11f1-91cb-1607ee4eb77e","pinPreview","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",{"_9":10,"_104":99},"org",{"_9":10,"_98":99,"_100":99,"_55":56,"_101":102,"_103":42},"branch",{"_35":30,"_11":89,"_22":28,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_138":139,"_140":141,"_142":143,"_144":42,"_145":42,"_146":42,"_147":32,"_148":-5,"_149":-7,"_150":-7,"_151":63,"_152":42,"_153":42,"_154":-5,"_155":42,"_156":42,"_157":42,"_158":-5},"ENV",{"_109":110,"_111":112,"_113":89,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137},"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"]