[{"_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","mikolaj1s","name","tactic3","path","settle.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":-5,"_58":42,"_59":-5,"_60":-5,"_61":62,"_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/mikolaj1s/tactic3/code/settle.ts","extension","id","1a123abf-c2f0-464d-b1af-f7d1d5cd6d55","fileId","3b4e6f80-a417-11f1-8f42-1607ee4eb77e","parentId","branchId","7f2b72a5-99e2-4458-8fdc-5437e15e2bd1","branchVersion",15,"latest",true,"createdAt",["D",1788056210933],"version",3,"fileType","interval","content","/** TACTIC 3 — settlement. File type: interval.\n * Cron: 5 0 * * * (02:05 Warsaw in summer, 01:05 in winter)\n */\nimport { ENV, postSheet, readSheet, round, tg, warsawDate } from \"./lib.ts\";\n\nexport default async function (_interval: Interval) {\n const sheet = await readSheet();\n const cfg = sheet.config;\n\n // anything logged whose kickoff was more than 2.5h ago and is still unresolved\n const pending = sheet.open_bets.filter((b: any) => {\n if (!b.kickoff_utc) return false;\n const ageH = (Date.now() - new Date(String(b.kickoff_utc)).getTime()) /\n 3.6e6;\n return ageH > 2.5 && ageH < 96;\n });\n if (!pending.length) {\n console.log(\"nothing to settle\");\n return;\n }\n\n const leagues = [...new Set(pending.map((b: any) => String(b.league)))];\n const scores = new Map();\n\n for (const lg of leagues) {\n try {\n const r = await fetch(\n `https://api.the-odds-api.com/v4/sports/${lg}/scores/?daysFrom=3&apiKey=${ENV.oddsKey()}`,\n );\n if (!r.ok) continue;\n for (const e of await r.json()) {\n if (!e.completed || !e.scores) continue;\n const h = e.scores.find((s: any) => s.name === e.home_team);\n const a = e.scores.find((s: any) => s.name === e.away_team);\n if (!h || !a) continue;\n const hs = Number(h.score), as = Number(a.score);\n scores.set(e.id, {\n total: hs + as,\n winner: hs > as ? e.home_team : as > hs ? e.away_team : \"Draw\",\n });\n }\n } catch (e) {\n console.error(\"scores failed\", lg, String(e));\n }\n }\n\n const updates: any[] = [];\n const settledSel: any[] = [];\n let dayPnlU = 0;\n\n for (const b of pending) {\n const s = scores.get(String(b.id).split(\":\")[0]);\n if (!s) continue;\n\n const res = resolve(\n String(b.market),\n String(b.line),\n String(b.selection),\n s,\n );\n const isSelected = String(b.status) === \"SELECTED\";\n const units = Number(b.units) || 0;\n const odds = Number(b.betclic_odds);\n const pnlU = !isSelected\n ? 0\n : res === \"WON\"\n ? units * (odds - 1)\n : res === \"LOST\"\n ? -units\n : 0;\n const payout = !isSelected\n ? \"\"\n : res === \"WON\"\n ? round(\n units * odds * Number(cfg.notional_bank) * Number(cfg.unit_pct) / 100,\n 2,\n )\n : 0;\n\n if (isSelected) {\n dayPnlU += pnlU;\n settledSel.push({ b, res, pnlU });\n }\n\n updates.push({\n id: b.id,\n result: res,\n score: `${s.total} total${s.winner ? \" · \" + s.winner : \"\"}`,\n payout,\n pnl_units: isSelected ? round(pnlU, 3) : 0,\n });\n }\n\n if (!updates.length) {\n console.log(\"no results available yet\");\n return;\n }\n await postSheet(\"settle\", { updates });\n\n // rolling CLV + bank\n const withClv = [...sheet.open_bets, ...updates].filter((b: any) =>\n b.clv_pct !== \"\" && b.clv_pct != null\n );\n const clvAll = withClv.length\n ? round(\n withClv.reduce((a: number, b: any) => a + Number(b.clv_pct), 0) /\n withClv.length,\n 2,\n )\n : \"\";\n const bank = round(\n Number(sheet.state.bank) +\n dayPnlU * Number(cfg.notional_bank) * Number(cfg.unit_pct) / 100,\n 2,\n );\n\n await postSheet(\"set_state\", {\n values: {\n bank,\n clv_all: clvAll,\n bets_settled: Number(sheet.state.bets_settled || 0) + settledSel.length,\n last_settle: new Date().toISOString(),\n },\n });\n\n await tg(renderSettle(settledSel, updates.length, dayPnlU, bank, clvAll));\n}\n\nfunction resolve(\n market: string,\n line: string,\n selection: string,\n s: { total: number; winner: string | null },\n) {\n if (market === \"totals\") {\n const pt = Number(line);\n if (s.total === pt) return \"VOID\";\n const over = s.total > pt;\n return (selection === \"Over\") === over ? \"WON\" : \"LOST\";\n }\n if (market === \"h2h\") return selection === s.winner ? \"WON\" : \"LOST\";\n return \"VOID\";\n}\n\nfunction renderSettle(\n sel: any[],\n total: number,\n pnlU: number,\n bank: number,\n clv: any,\n) {\n const L: string[] = [];\n L.push(`📊 Settled · ${warsawDate(new Date(Date.now() - 6 * 3.6e6))}`);\n L.push(`${total} candidates resolved · ${sel.length} were selected`);\n L.push(\"\");\n if (!sel.length) L.push(\"No selected bets yesterday.\");\n for (const { b, res, pnlU: p } of sel) {\n const icon = res === \"WON\" ? \"✅\" : res === \"LOST\" ? \"❌\" : \"◽\";\n const clvTxt = b.clv_pct !== \"\" && b.clv_pct != null\n ? ` · CLV ${Number(b.clv_pct) > 0 ? \"+\" : \"\"}${b.clv_pct}%`\n : \"\";\n L.push(`${icon} ${b.match} — ${b.selection} ${b.line}`);\n L.push(\n ` ${b.units}u @ ${b.betclic_odds} → ${p >= 0 ? \"+\" : \"\"}${\n round(p, 2)\n }u${clvTxt}`,\n );\n }\n L.push(\"\");\n L.push(\n `Day ${pnlU >= 0 ? \"+\" : \"\"}${\n round(pnlU, 2)\n }u · bank ${bank} notional`,\n );\n L.push(`Rolling CLV (all logged): ${clv === \"\" ? \"n/a\" : clv + \"%\"}`);\n L.push(\"\");\n L.push(\n \"CLV is the number that matters. Profit at this sample size is noise.\",\n );\n return L.join(\"\\n\");\n}","deleted",false,"label",[14],"fa28d932-b8ed-4d2c-a9c1-d126495e3821",["D",1788053918612],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","46b46481-1a7a-4baf-9b30-f04e5412be63","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a05044-5188-72ca-95f1-3ce950290209","tursoName","fa28d932b8ed4d2ca9c1d126495e3821","tursoHostname","fa28d932b8ed4d2ca9c1d126495e3821-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789458074143],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":101},"org",{"_9":10,"_98":99,"_100":101,"_55":56,"_102":103,"_104":42},"branch",{"_35":88,"_11":89,"_22":28,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Mikolaj","avatar","https://lh3.googleusercontent.com/a/ACg8ocLzgCtQd72Pq51pH-GC_-hzMB9GlIradk5VahBk0RacetVp2SPj=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":62,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":89,"_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"]