Wallet-Performance-Check

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","aouam_player","name","sentry-wallet-performance-check","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","cc4532ea-dabe-45b3-91bf-5682842beb4f","main.ts","fileId","8c1bd2da-89b0-11f1-bffc-1607ee4eb77e","parentId","branchId","c483b957-6967-4320-a36f-abe49d755834","branchVersion",8,"latest",true,"createdAt",["D",1785260862933],7,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ============================================================================\n// sentry-wallet-performance-check (27.07.2026, siehe Chat) - Val Town HTTP\n// Val, im Browser aufrufbar (analog zu den bestehenden ?debug=...-Routen in\n// sentry-helius-webhook).\n//\n// ZWECK: prueft die 79 aktuell ueberwachten Wallets (Live-Liste aus der\n// Helius-Webhook-Config, siehe WALLET-QUELLE unten) gegen ein\n// Performance-Kriterium ueber die letzten 60 Tage: Win-Rate >= 30% UND\n// realisiertes PnL in USD > 0. Ergebnis: sortierte HTML-Tabelle (absteigend\n// nach realized_pnl_usd) UND persistente Historie in einer neuen\n// sqlite-Tabelle.\n//\n// BESTAETIGT DURCH LIVE-TEST (27.07.2026, 4 Wallets, HTTP 200 - siehe Chat):\n// - Endpoint: POST https://api.nansen.ai/api/v1/profiler/address/pnl-summary\n// - Request-Body: { address: STRING (EINE Adresse, kein Array),\n// chain: \"solana\", date: { from, to } } - KEIN \"parameters\"-Wrapper.\n// - Bestaetigte Response-Feldnamen: win_rate (Dezimalzahl, z.B. 0.5217 =\n// 52.17%), realized_pnl_usd (KANN NEGATIV SEIN), traded_times.\n// - Live-Testergebnis zur Einordnung: 2 von 4 Test-Wallets hatten trotz\n// plausibler Win-Rate (48-52%) ein NEGATIVES realized_pnl_usd ueber die\n// letzten ~2 Monate - genau deshalb ist das Kriterium unten \"Win-Rate UND\n// PnL>0\", nicht nur Win-Rate allein.\n//\n// Damit ist die vorherige Unsicherheit zu realized_pnl_percent (aus der\n// vorigen, rein dokubasierten Version dieses Skripts) hinfaellig - dieses\n// Feld wird hier bewusst NICHT mehr verwendet, das Kriterium stuetzt sich\n// nur noch auf die live bestaetigten Felder.\n//\n// OFFENE FRAGE (weiterhin unverifiziert, siehe Chat): ob Nansen reine\n// Airdrops in win_rate/realized_pnl_usd korrekt herausrechnet. Empfehlung\n// unveraendert: 1-2 auffaellige Wallets stichprobenartig gegen einen\n// Block-Explorer pruefen, bevor Ergebnisse als endgueltig behandelt werden.\n// ============================================================================\n\nconst NANSEN_API_KEY = Deno.env.get(\"NANSEN_API_KEY\");\nconst NANSEN_PNL_SUMMARY_URL =\n \"https://api.nansen.ai/api/v1/profiler/address/pnl-summary\";\nconst CHAIN = \"solana\";\nconst LOOKBACK_DAYS = 60;\n\n// Kriterium: \"30-40% Win-Rate\" als konservative UNTERGRENZE interpretiert\n// (bei Bedarf hier auf 0.40 fuer die strengere Grenze anpassen). PnL-Teil\n// des Kriteriums ist jetzt (Live-Test-bestaetigt) simpel: realisiertes PnL\n// muss POSITIV sein - siehe meetsPerformanceCriteria().\nconst MIN_WIN_RATE = 0.30; // 30%\n\n// Nansen-Preismodell (siehe Chat-Recherche): 1 Credit pro Aufruf, $10 pro\n// 1000 Credits.\nconst CREDITS_PER_CALL = 1;\nconst USD_PER_1000_CREDITS = 10;\n\n// Vom Nutzer bestaetigtes Rate Limit: 20 req/s, 500/min. Bei 79 Wallets\n// SEQUENTIELL (ein Call nach dem anderen) mit DELAY_BETWEEN_CALLS_MS\n// Verzoegerung dazwischen sind wir weit darunter - \"trotzdem mit kleiner\n// Verzoegerung arbeiten, um sicher zu gehen\" (siehe Chat).\nconst DELAY_BETWEEN_CALLS_MS = 150;\n\n// ============================================================================\n// WALLET-QUELLE\n//\n// AKTUALISIERT (28.07.2026): 79 Adressen, live abgerufen ueber\n// sentry-helius-inspect (fragt direkt die Helius-Webhook-API ab) - identisch\n// zum aktuellen accountAddresses-Feld der Helius-Webhook-Config zum\n// Abrufzeitpunkt. Ersetzt die vorherige, veraltete 62er-Zwischenversion\n// komplett (diese war bereits vor der Entfernung schlechter Wallets\n// veraltet).\n// ============================================================================\n\nconst MONITORED_WALLETS: string[] = [\n \"ARKtgyP7xLfoehvGNxjnkvSsPmBYTQ5W6zNDNErRp4wV\",\n \"C1rcJJLdQUCsZp2UuTbiTJf26uas1mnh6St2Un2aHUDm\",\n \"7mGZh58meFf8xsES37bc2hdffEmh8aTDcB2i725Zivyg\",\n \"46eL2xMdTDtfeEM2HpBgfcoWmxgNY6d1MBzjCMfiVH4Q\",\n \"EPjMC11TMkmof494c5y1dAcriSqyFXohCh7hs7URJJTw\",\n \"6Y7VzR1dcfUyGCbUS9b5PiWhRCN7Hg5NAVUWV9gaMks1\",\n \"DEdEW3SMPU2dCfXEcgj2YppmX9H3bnMDJaU4ctn2BQDQ\",\n \"FRLwWJmAfgpJ3fgQgsk8h26uELXL6MThYx9Evk43f23P\",\n \"GdLdKs81rMtJZxMsBPb5SzAwvjAF3KxPr1pbiN1oe1qH\",\n \"21vaYvUUE4ND1bVt1tcGiXUXHe41w53unQd5DmCDeLZ1\",\n \"J3dnz2QDVfiouCjWTXowtX9zpNzVp9eQdnTa1P1xMArB\",\n \"7sFJ9AnUHtc5vyFHqnqkBTmnqcpgax9Q2bUwGRijTLWZ\",\n \"9s6jeGZWxA6B5BnywXSd7DFujjoLSBXoi6zeVSrurCiq\",\n \"F3aJ28RrFAceShmtG1wJPmwgPZqQhVabzonsSao7qjEo\",\n \"4bNvR8AcTZnECdzvFmBPopEv78dBP62rArWGSnDvTpwA\",\n \"4j9kmRHF9Lk6VYZRKbTnvmXMoajXjSuqBrMgjmLLRWek\",\n \"H7PKyDYaESrpuZEMcPv7wjCnSjYA5R3n4i11bRKZFB2E\",\n \"wYFUpdagf9cxr2YRZ27BP3gAzW1SpYGzghnyXvtunoq\",\n \"mDR91ufq4S2uSHa9E2PYL7xg4LwcQXaQFP7YK864a1z\",\n \"GT2Sw7DmWLU8BTJkYjRRiZxmrpw621PbjYoFfyUHrA64\",\n \"9xCbBSFdXehm3qQti2qQ7uEaidZwJvgmULmiMLojCm3v\",\n \"FMji2vPcoPPNJakqmNH28vMpu572CNurzBoRquVYx5HG\",\n \"6613dcBRAbSyhmqXD2J97N5b7sAmagzYDPuqGZzBH7vr\",\n \"5HGyaM8APxzQRZzZKAWZY3Q931q5ExsksQUyTm42kCKR\",\n \"DedWtoz7csvD81NRCSvktt6ey4qxLrFSqH2FMXbYsKDf\",\n \"BNh6xEEKP7wbcTftfVS7xUrJdwe9VZCLcMutEzxJS8ST\",\n \"6SLgFs2h1yW59pBKnbApgJQE715GwhYRmJ5whptmdvou\",\n \"2XjaJcpV95THbUnjbtmbcNGE1GWudMaVTqBthcnchcvN\",\n \"HZG2MqYbo2qvGrEDpWyBg9JKNLGHN35DvhEqvzTYJmby\",\n \"DPiQs7yP5WnBxN7RwttMKkrndmeTzeVZ69sxeAswxm8r\",\n \"2qW5LsgAGnCnyfVvzhwBQBfLsQ6hz3o2uaB29U3CSHBy\",\n \"FGZ72HENqfzUv9RiPAFqF7hCCiMZMAa5MYmWangFnZwD\",\n \"xm1KXMwtKAPzekGTUZdcnGyXKY19EtHRehEg4tgLXrK\",\n \"FjTCtheCQ892C7MS8pK8n9N3tMoyDFfKPh5MKEZsUtGG\",\n \"D3C1Lh9x88kTBdysNiZ7QRfYZTC8T5u1Sjj7f7G64Bah\",\n \"FKEi9ykcdNWxkW7w77d6qLdqhHaPRQAvrhJQDaeDFvhY\",\n \"Cf7qEdZzJg7uC4B3wV93UaabRXkaFrtdVjsiDTJhetNf\",\n \"6GVJhpUJ4SNPN8q3h8fRZiA9UFDJEHS9NMF5MoA3F8TX\",\n \"6HcrxubcevZQs1fcPTVnywzw7N2XWqsyAPxqnmg78UMg\",\n \"2acLWuG8Ly332JmxaPuNdb3p8RwiUdsaWTJe1yGS4sBE\",\n \"F5XvCe4233m6mHRbkkq2ZsFvqrPAnRrDBExeQy2fwagQ\",\n \"FgjLmLZLkQxKia9z6UQSz1CuGm9v3wWCoVMDzbMptLY\",\n \"2NCyVmEup1WREG9QbUA2EZSGRBAzymRBCRytUVqY8HPy\",\n \"GmCqxJx2QPxKfhyiLyk5CdV3rQtwuXKnCoTq5RoFBCoD\",\n \"5949hDDDHaxoXemTJmVHArL6avYXUxKY8Ad7Tz43GnCg\",\n \"9aP2vSFp2rydWR7C7kVZSQLQa2sT62w23ZHVP8BVSR5T\",\n \"yHCxHBEaJW5tbndqC8JciSThr7U1cqLpdcsvHcx6PRe\",\n \"5brv79eFZ2rGprXNvqgVJBkBptkkw8GJX1XydJyZLyAr\",\n \"FTuqW6J148wdknkPvm2EVSJ1EFt4aDhjAYzv6rdjuCRi\",\n \"EeKNznnh3fGYhNrax78xAWgkAmKtsvPJcgyfTQGVSSwT\",\n \"4EsYuWFZAt1PfNJq8Jr7monip43gNqrQ7k2Kne1npqJx\",\n \"GZ1yiJKTq8Mc6RiY2WQrzph8wJcizSLGgyhr4RSgnuUo\",\n \"31iRQFxAApGY6LAXm16QDXmPFHSeY2mP4dW96P22iTBV\",\n \"LuitxHPxN8UU78q5Fp6VjotgtYKAGJNviS2gb2TSt5T\",\n \"BopgSXVHNqks8GNMp5UJ3g54mKP1Wgfs8j6DcRNSCoBb\",\n \"HfN9JFxwS89fERT8of2dt1it6G3P2ia5sJc5J8GkwU5k\",\n \"985sqazousgFWXYTMnoLHBsdUfWJfHoCcPCYhkYBhVdZ\",\n \"6qudAN2kV8mtCcYJxb5QQ6Vr15itdHHdeVbYm99NKMhy\",\n \"EgLu45VULr1UoktfTmkCkJDMfuq6QpdYqUcyjr265g5a\",\n \"B6yHBbrfZVxwxCPzArPAMHD5c9KvJfYateuMEqYsMorZ\",\n \"BprdjjAzFLoS2gVJqUVR1pdJpwCacNK4kctLTiMmcdSh\",\n \"2Xjizmu5FwVX36JyVGcWMDaNoQN1VWU25tz1TFk24nd7\",\n \"9FWx1XY4mvGruimuN6PsgUgBzDzPv97Lt6pg5hH5pzsN\",\n \"pn1rDr6XzcMwjyRsZhBd5nP5mzfhjmaUPxaGUiDS123\",\n \"Fr9B91h3MrqghrH1pfdw3RTAi34TJckcQMp25EKnXVxo\",\n \"DKMqtxwiWT7He3NpmKQ5U3fvLAA7ceHmrMK2LpMfjDxJ\",\n \"GFzX86hjhskjynR8aoqzy8VtGMRVTBcE4macLyzDCZKn\",\n \"J9TYAsWWidbrcZybmLSfrLzryANf4CgJBLdvwdGuC8MB\",\n \"7Np5tf39tpvFSzWnGpwa54NeFkocGdr8DzWVHLktGZGp\",\n \"vbXpsjNXdg57VatGKiYN1ZY4ffwqoumPzztCMnJCxd9\",\n \"appLejqSrQn1612mhpZfyfPLgCFXdnFz6JzhLonoytN\",\n \"7bBpvrmVeCF3hyFWAMynNcaAxprfL2WCnfEpiotKYRfU\",\n \"CMw7kj6ceqVqdj6XLc8FEJaZfPHBSUzubArqXjChfn11\",\n \"zAnr3GphY5t6xPahAaCQKPNBSxhYEtvV41JTqPFqmbb\",\n \"AmMAXw6L2NHWU4kU164Z2GrR1ceJq4L7achaJT7Y9cr4\",\n \"4BHBSZA96XCaepYLvmteV6wLqKTqJPyfkME941X5PqHP\",\n \"AUEQxhkAVz71w2WBa9BYSoZrydhYNJaKmfNomoNs9E4t\",\n \"CxgPWvH2GoEDENELne2XKAR2z2Fr4shG2uaeyqZceGve\",\n \"BNnN2MqfWLvgThYBsv6v8JQaYZXYKYahC5YCy27Ct1cX\",\n];\n\nfunction computeDateRange(\n lookbackDays: number,\n nowIso: string,\n): { from: string; to: string } {\n const to = new Date(nowIso);\n const from = new Date(to.getTime() - lookbackDays * 24 * 60 * 60 * 1000);\n return {\n from: from.toISOString().slice(0, 10),\n to: to.toISOString().slice(0, 10),\n };\n}\n\n// Merged die beiden Quelllisten und dedupliziert unter Beibehaltung der\n// Reihenfolge (analog zu dedupe_preserving_order() in\n// add_axiom_wallets_to_helius_v2.py) - verhindert doppelte Credits-Kosten,\n// falls eine Adresse in beiden Listen vorkommt.\nfunction mergeAndDedupeWallets(\n lists: string[][],\n): { wallets: string[]; duplicatesRemoved: number } {\n const seen = new Set();\n const merged: string[] = [];\n let duplicatesRemoved = 0;\n for (const list of lists) {\n for (const addr of list) {\n if (seen.has(addr)) {\n duplicatesRemoved++;\n continue;\n }\n seen.add(addr);\n merged.push(addr);\n }\n }\n return { wallets: merged, duplicatesRemoved };\n}\n\ntype WalletPnlResult =\n | {\n wallet: string;\n kind: \"ok\";\n winRate: number;\n realizedPnlUsd: number;\n tradedTimes: number;\n }\n | { wallet: string; kind: \"error\"; reason: string };\ntype WalletPnlOk = Extract;\ntype WalletPnlError = Extract;\n\nasync function fetchWalletPnlSummary(\n wallet: string,\n dateRange: { from: string; to: string },\n): Promise {\n try {\n const res = await fetch(NANSEN_PNL_SUMMARY_URL, {\n method: \"POST\",\n headers: {\n apiKey: NANSEN_API_KEY ?? \"\",\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ address: wallet, chain: CHAIN, date: dateRange }),\n });\n if (!res.ok) {\n const bodyText = await res.text();\n return {\n wallet,\n kind: \"error\",\n reason: \"HTTP \" + res.status + \" - \" + bodyText.slice(0, 200),\n };\n }\n const data = await res.json();\n const winRate =\n typeof data.win_rate === \"number\" && Number.isFinite(data.win_rate)\n ? data.win_rate\n : null;\n const realizedPnlUsd =\n typeof data.realized_pnl_usd === \"number\" &&\n Number.isFinite(data.realized_pnl_usd)\n ? data.realized_pnl_usd\n : null;\n const tradedTimes =\n typeof data.traded_times === \"number\" &&\n Number.isFinite(data.traded_times)\n ? data.traded_times\n : null;\n\n if (winRate === null || realizedPnlUsd === null || tradedTimes === null) {\n return {\n wallet,\n kind: \"error\",\n reason:\n \"Antwortstruktur nicht wie erwartet (fehlende/nicht-numerische Felder win_rate/realized_pnl_usd/traded_times)\",\n };\n }\n return { wallet, kind: \"ok\", winRate, realizedPnlUsd, tradedTimes };\n } catch (err) {\n return { wallet, kind: \"error\", reason: \"Netzwerkfehler: \" + String(err) };\n }\n}\n\n// Kriterium (Live-Test-bestaetigt, siehe Kopfkommentar): Win-Rate >=\n// MIN_WIN_RATE UND realisiertes PnL > 0.\nfunction meetsPerformanceCriteria(result: WalletPnlOk): boolean {\n return result.winRate >= MIN_WIN_RATE && result.realizedPnlUsd > 0;\n}\n\nfunction sortByRealizedPnlDesc(\n results: T[],\n): T[] {\n return [...results].sort((a, b) => b.realizedPnlUsd - a.realizedPnlUsd);\n}\n\nfunction computeCreditSummary(\n totalCallsMade: number,\n): { creditsUsed: number; approxUsd: number } {\n const creditsUsed = totalCallsMade * CREDITS_PER_CALL;\n return {\n creditsUsed,\n approxUsd: (creditsUsed / 1000) * USD_PER_1000_CREDITS,\n };\n}\n\nfunction sleep(ms: number): Promise {\n return new Promise((resolve) => setTimeout(resolve, ms));\n}\n\nasync function ensureTables() {\n // Persistente Historie (siehe Chat: \"zusaetzlich in einer neuen\n // sqlite-Tabelle gespeichert\") - JEDER Lauf haengt neue Zeilen an (KEIN\n // Overwrite), damit sich die Performance einer Wallet ueber mehrere\n // Laeufe hinweg nachvollziehen laesst. Fehlgeschlagene Abrufe werden\n // ebenfalls gespeichert (fetch_error gefuellt, restliche Felder NULL) -\n // nie stillschweigend aus der Historie entfernt.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS sentry_wallet_performance_screening (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n run_at TEXT,\n wallet TEXT,\n chain TEXT,\n lookback_days INTEGER,\n win_rate REAL,\n realized_pnl_usd REAL,\n traded_times INTEGER,\n meets_criteria INTEGER,\n fetch_error TEXT\n )`,\n );\n}\n\nasync function persistRun(\n runAtIso: string,\n results: (WalletPnlOk & { meetsCriteria: boolean })[],\n errors: WalletPnlError[],\n) {\n for (const r of results) {\n await sqlite.execute({\n sql: \"INSERT INTO sentry_wallet_performance_screening \" +\n \"(run_at, wallet, chain, lookback_days, win_rate, realized_pnl_usd, traded_times, meets_criteria, fetch_error) \" +\n \"VALUES (?, ?, ?, ?, ?, ?, ?, ?, NULL)\",\n args: [\n runAtIso,\n r.wallet,\n CHAIN,\n LOOKBACK_DAYS,\n r.winRate,\n r.realizedPnlUsd,\n r.tradedTimes,\n r.meetsCriteria ? 1 : 0,\n ],\n });\n }\n for (const e of errors) {\n await sqlite.execute({\n sql: \"INSERT INTO sentry_wallet_performance_screening \" +\n \"(run_at, wallet, chain, lookback_days, win_rate, realized_pnl_usd, traded_times, meets_criteria, fetch_error) \" +\n \"VALUES (?, ?, ?, ?, NULL, NULL, NULL, 0, ?)\",\n args: [runAtIso, e.wallet, CHAIN, LOOKBACK_DAYS, e.reason],\n });\n }\n}\n\nfunction formatPct(n: number): string {\n return (n * 100).toFixed(2) + \"%\";\n}\n\nfunction renderHtml(params: {\n dateRange: { from: string; to: string };\n total: number;\n duplicatesRemoved: number;\n results: (WalletPnlOk & { meetsCriteria: boolean })[];\n errors: WalletPnlError[];\n creditSummary: { creditsUsed: number; approxUsd: number };\n}): string {\n const {\n dateRange,\n total,\n duplicatesRemoved,\n results,\n errors,\n creditSummary,\n } = params;\n const meetsCount = results.filter((r) => r.meetsCriteria).length;\n\n const rows = results\n .map((r) => {\n const pnlColor = r.realizedPnlUsd >= 0 ? \"#0a7d2c\" : \"#c0392b\";\n return (\n \"\" +\n \"\" + r.wallet.slice(0, 4) + \"...\" +\n r.wallet.slice(-4) + \"\" +\n \"\" + formatPct(r.winRate) + \"\" +\n \"$\" +\n r.realizedPnlUsd.toFixed(2) + \"\" +\n \"\" + r.tradedTimes + \"\" +\n \"\" + (r.meetsCriteria ? \"✅ Behalten\" : \"❌ Entfernen\") + \"\" +\n \"\"\n );\n })\n .join(\"\");\n\n const errorRows = errors\n .map(\n (e) =>\n \"\" + e.wallet.slice(0, 4) +\n \"...\" + e.wallet.slice(-4) + \"\" +\n \"\" + e.reason + \"\",\n )\n .join(\"\");\n\n return (\n \"Wallet-Performance-Check\" +\n \"\" +\n \"\" +\n \"

Wallet-Performance-Check

\" +\n \"

Zeitraum: \" + dateRange.from + \" bis \" + dateRange.to + \" (\" +\n LOOKBACK_DAYS + \" Tage) | Chain: \" + CHAIN + \"

\" +\n \"

Kriterium: Win-Rate ≥ \" + formatPct(MIN_WIN_RATE) +\n \" UND realisiertes PnL > $0

\" +\n \"

\" + meetsCount + \" von \" + total +\n \" Wallets erfuellen das Kriterium (Kandidaten zum Behalten)\" +\n (errors.length > 0\n ? \" | \" + errors.length + \" Abruf(e) fehlgeschlagen (siehe unten)\"\n : \"\") +\n (duplicatesRemoved > 0\n ? \" | \" + duplicatesRemoved + \" Duplikat(e) in MONITORED_WALLETS entfernt\"\n : \"\") +\n \"

\" +\n \"

Kosten dieses Laufs: \" + creditSummary.creditsUsed +\n \" Nansen-Credits (~$\" +\n creditSummary.approxUsd.toFixed(2) + \" bei $\" + USD_PER_1000_CREDITS +\n \"/1000 Credits) - 1 Credit pro Wallet-Abruf, \" +\n \"inkl. fehlgeschlagener Aufrufe.

\" +\n \"\" +\n \"\" +\n rows +\n \"

Wallet	Win-Rate	Realisiertes PnL $	Trades	Kandidat

\" +\n (errors.length > 0\n ? \"

Fehlgeschlagene Abrufe (\" + errors.length +\n \")

\" +\n errorRows + \"

Wallet	Grund

\"\n : \"\") +\n \"

Ergebnisse wurden zusaetzlich in der Tabelle \" +\n \"sentry_wallet_performance_screening gespeichert (Historie, kein Overwrite). Offene Frage weiterhin \" +\n \"unverifiziert: ob Nansen reine Airdrops korrekt aus win_rate/realized_pnl_usd herausrechnet - \" +\n \"Stichprobe gegen einen Block-Explorer empfohlen.

\" +\n \"\"\n );\n}\n\nexport default async function (req: Request): Promise {\n await ensureTables();\n\n const url = new URL(req.url);\n // mergeAndDedupeWallets() wird hier bewusst weiter auf die (jetzt\n // einzelne) MONITORED_WALLETS-Liste angewendet - reines Sicherheitsnetz\n // gegen versehentliche Copy-Paste-Duplikate, KEIN funktionaler Merge mehr\n // (siehe Kommentar oben - schon selbst gegen die vorige 21er-Axiom-Liste\n // gegengeprueft, keine Duplikate gefunden).\n const { wallets: allWallets, duplicatesRemoved } = mergeAndDedupeWallets([\n MONITORED_WALLETS,\n ]);\n\n // Sicherheitsventil (wie im vorigen Screening-Val): ?offset=&limit= erlaubt\n // batchweises Screening, falls ein Lauf ueber alle Wallets an ein\n // Val-Town-Zeitlimit stossen sollte.\n const offset = Number(url.searchParams.get(\"offset\") ?? \"0\");\n const limitParam = url.searchParams.get(\"limit\");\n const limit = limitParam !== null ? Number(limitParam) : allWallets.length;\n const safeOffset = Number.isFinite(offset) && offset >= 0 ? offset : 0;\n const safeLimit = Number.isFinite(limit) && limit > 0\n ? limit\n : allWallets.length;\n const wallets = allWallets.slice(safeOffset, safeOffset + safeLimit);\n\n if (allWallets.length === 0) {\n return new Response(\n \"FEHLER: MONITORED_WALLETS ist leer - bitte die Wallet-Liste im Code pruefen.\",\n { status: 200, headers: { \"Content-Type\": \"text/plain; charset=utf-8\" } },\n );\n }\n\n const nowIso = new Date().toISOString();\n const dateRange = computeDateRange(LOOKBACK_DAYS, nowIso);\n\n const raw: WalletPnlResult[] = [];\n for (const wallet of wallets) {\n raw.push(await fetchWalletPnlSummary(wallet, dateRange));\n await sleep(DELAY_BETWEEN_CALLS_MS);\n }\n\n const ok = raw.filter((r): r is WalletPnlOk => r.kind === \"ok\");\n const errors = raw.filter((r): r is WalletPnlError => r.kind === \"error\");\n const withCriteria = ok.map((r) => ({\n ...r,\n meetsCriteria: meetsPerformanceCriteria(r),\n }));\n const sorted = sortByRealizedPnlDesc(withCriteria);\n const creditSummary = computeCreditSummary(raw.length);\n\n await persistRun(nowIso, sorted, errors);\n\n return new Response(\n renderHtml({\n dateRange,\n total: wallets.length,\n duplicatesRemoved,\n results: sorted,\n errors,\n creditSummary,\n }),\n { status: 200, headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1785260862933],"children",[],[35],"1388e94f-0969-4d5b-9b29-522a78d5451d",["D",1785152678285],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","d88c9cf0-3002-4a43-9725-2854852c6d09","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f8659-48bc-71e6-8825-ef535d702ef9","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":19},"org",{"_11":12,"_109":19,"_110":19,"_70":71,"_111":112,"_113":53},"branch",{"_17":100,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned",12,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":149,"_95":150,"_97":151,"_99":53},[145],"files",[145],"counts",{"_135":77,"_136":137,"_138":77,"_31":139,"_140":141},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":134},[35],"pulls","branches",1,"forks",{"_142":137,"_144":77},"connections",{"_142":77,"_143":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":146,"_18":147},[],[35],["D",1785152678285],{"_11":12,"_114":19},{"_11":12,"_109":19,"_110":19,"_70":71,"_111":112,"_113":53},{"_17":100,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_93":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":77,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"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"]