[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_335":336,"_337":338},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_48":-7,"_210":-5,"_19":211,"_212":213,"_214":215,"_216":217,"_218":219,"_21":220,"_221":-5,"_222":-5,"_223":24,"_224":225,"_226":24,"_227":-5,"_228":-5,"_229":230},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","ericmller","name","crypto-radar-live","branchName","main","path","dex_discovery.ts","project",{"_42":158,"_13":14,"_46":159,"_160":-5,"_161":24,"_162":163,"_164":163,"_165":166,"_167":-5,"_30":78,"_168":-5,"_169":24,"_170":-5,"_171":-5,"_172":26,"_50":51,"_173":174,"_175":176,"_177":178,"_179":-5,"_180":181,"_182":181,"_183":184,"_185":184,"_186":184,"_187":181,"_188":181,"_63":189,"_190":191,"_192":193,"_194":24},"file",{"_73":74,"_13":18,"_75":76,"_77":24,"_157":-5},"isDirectory",false,"page",0,"history",[31,32,33,34,35,36,37,38,39,40,41],"hasNext","userId",{"_42":149,"_44":45,"_46":150,"_48":151,"_50":51,"_52":152,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":153,"_21":154,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":155},{"_42":141,"_44":45,"_46":142,"_48":143,"_50":51,"_52":144,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":145,"_21":146,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":147},{"_42":133,"_44":45,"_46":134,"_48":135,"_50":51,"_52":136,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":137,"_21":138,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":139},{"_42":125,"_44":45,"_46":126,"_48":127,"_50":51,"_52":128,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":129,"_21":130,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":131},{"_42":118,"_44":45,"_46":119,"_48":120,"_50":51,"_52":111,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":121,"_21":122,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":123},{"_42":111,"_44":45,"_46":112,"_48":113,"_50":51,"_52":103,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":114,"_21":115,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":116},{"_42":103,"_44":45,"_46":104,"_48":105,"_50":51,"_52":106,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":107,"_21":108,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":109},{"_42":96,"_44":45,"_46":97,"_48":98,"_50":51,"_52":88,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":99,"_21":100,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":101},{"_42":88,"_44":45,"_46":89,"_48":90,"_50":51,"_52":91,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":92,"_21":93,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":94},{"_42":81,"_44":45,"_46":82,"_48":83,"_50":51,"_52":43,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":84,"_21":85,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":86},{"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_21":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71},"id","d1d93862-ee25-4f25-a842-5a79eb262ebf","branchId","1f24721f-2036-411a-8118-e59c45c9688a","createdAt",["D",1787513794791],"version",21,"orgId","01a0300b-b4a4-7719-9801-d3db2883fcca","parentId","b79a8483-cf4b-4299-97e9-1a21c44a1da1","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","mcp","clientLabel","ChatGPT","user",{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},"pull","merge","revert","multiple","commits",[72],{"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_21":65,"_66":-5,"_67":-5,"_68":-5},"fileId","f3376cca-9f29-11f1-b902-1607ee4eb77e","fileType","interval","deleted","ca9c5969-d2d6-409f-a9d8-f2ac1832a2bb","avatar","https://lh3.googleusercontent.com/a/ACg8ocI1PZC2VDTkYbxcPEYqtRMNHUOsc4NQYVI5LprQjEJLXuAh=s96-c","cf5103f4-eae6-4cc6-a080-c48a79cb8945",["D",1787513820111],22,{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[87],{"_42":81,"_44":45,"_46":82,"_48":83,"_50":51,"_52":43,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":84,"_21":85,"_66":-5,"_67":-5,"_68":-5},"d9e12965-4b46-4869-a9a1-ec7e95400c0a",["D",1787513879636],25,"fb6255c2-be01-4a72-81db-43bfdba130e0",{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[95],{"_42":88,"_44":45,"_46":89,"_48":90,"_50":51,"_52":91,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":92,"_21":93,"_66":-5,"_67":-5,"_68":-5},"734d3a44-0ecb-4c30-96a2-1a2a61c15487",["D",1787513891012],26,{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[102],{"_42":96,"_44":45,"_46":97,"_48":98,"_50":51,"_52":88,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":99,"_21":100,"_66":-5,"_67":-5,"_68":-5},"6be8c2bc-6048-4650-893c-ad0c1e0b2133",["D",1787513940514],28,"1bc2dcfb-44da-4e4d-bba4-1ab56a3b8541",{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[110],{"_42":103,"_44":45,"_46":104,"_48":105,"_50":51,"_52":106,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":107,"_21":108,"_66":-5,"_67":-5,"_68":-5},"9254a29f-5ea3-4841-a8a1-0e6914863e98",["D",1787513984716],29,{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[117],{"_42":111,"_44":45,"_46":112,"_48":113,"_50":51,"_52":103,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":114,"_21":115,"_66":-5,"_67":-5,"_68":-5},"e2c09837-e454-4dc1-8f8b-2cd1bf0d54f2",["D",1787514004614],30,{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[124],{"_42":118,"_44":45,"_46":119,"_48":120,"_50":51,"_52":111,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":121,"_21":122,"_66":-5,"_67":-5,"_68":-5},"c0a70ee8-40ee-4e2d-8b72-5941177c4872",["D",1787514526256],42,"d879d84a-2b3f-418f-8ab3-57f4c4c8f1be",{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[132],{"_42":125,"_44":45,"_46":126,"_48":127,"_50":51,"_52":128,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":129,"_21":130,"_66":-5,"_67":-5,"_68":-5},"506ddcd7-c208-4e48-82bd-5b6d1951d9a2",["D",1787514567327],44,"01531590-a01b-43c3-8dc3-05bb0bffa1b6",{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[140],{"_42":133,"_44":45,"_46":134,"_48":135,"_50":51,"_52":136,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":137,"_21":138,"_66":-5,"_67":-5,"_68":-5},"f698bd14-b596-4bc0-a49a-fe2110607cdf",["D",1787515625263],64,"e439f3f0-c822-4da0-8030-f9560341395c",{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[148],{"_42":141,"_44":45,"_46":142,"_48":143,"_50":51,"_52":144,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":145,"_21":146,"_66":-5,"_67":-5,"_68":-5},"6178fb94-32e8-4573-bd46-64f911db4168",["D",1787516580676],75,"8a7db4a9-1267-48fc-b95e-fcb7f661d4b1",{"_42":78,"_50":51,"_11":12,"_79":80},{"_73":74,"_13":18,"_75":76,"_77":24},[156],{"_42":149,"_44":45,"_46":150,"_48":151,"_50":51,"_52":152,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":153,"_21":154,"_66":-5,"_67":-5,"_68":-5},"deletedAtVersion","260f4b93-b540-4d31-969e-570a1c5b874e",["D",1787512804582],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","15-minute crypto paper-trading radar","imageUrl","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","260f4b93b5404d31969e570a1c5b874e","tursoHostname","260f4b93b5404d31969e570a1c5b874e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789523429989],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_209":80},"org",{"_11":12,"_204":205,"_79":80,"_30":78,"_206":207,"_208":24},"branch",{"_48":195,"_13":16,"_42":45,"_196":158,"_197":-5,"_198":-5,"_199":-5,"_200":-5,"_201":-5,"_202":14,"_203":12},"isOwned",80,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Eric Müller","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_42":158,"_13":14,"_46":330,"_160":-5,"_161":24,"_162":163,"_164":163,"_165":166,"_167":-5,"_30":78,"_168":-5,"_169":24,"_170":-5,"_171":-5,"_172":26,"_50":51,"_173":174,"_175":176,"_177":331,"_179":-5,"_180":181,"_182":181,"_183":184,"_185":184,"_186":184,"_187":181,"_188":181,"_63":332,"_190":333,"_192":334,"_194":24},"tree",[252,253,254,255,256,257,258,259,260],"files",[252,253,254,255,256,257,258,259,260],"counts",{"_241":26,"_242":243,"_244":26,"_245":246,"_247":248},"contents",[],{"_42":231,"_13":18,"_73":74,"_52":-5,"_44":45,"_232":151,"_233":234,"_46":235,"_48":236,"_75":76,"_237":238,"_77":24,"_239":-5,"_17":240},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"7e5b8af1-f015-4880-b445-d9d5f1398132","branchVersion","latest",true,["D",1787516580676],10,"content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst NETWORK='ethereum';\nconst DEX='uniswap-v3';\nconst BATCH=200;\nconst safe=(x:any)=>{const v=Number(x);return Number.isFinite(v)?v:0};\nconst sleep=(ms:number)=>new Promise(r=>setTimeout(r,ms));\n\nasync function fetchJson(url:string){\n let last:any;\n for(let a=0;a<3;a++){\n try{\n const r=await fetch(url,{headers:{'Accept':'application/json','User-Agent':'crypto-radar-dex/3.0'},signal:AbortSignal.timeout(6000)});\n const t=await r.text();\n if(r.ok){try{return JSON.parse(t)}catch{throw new Error(`Ungültiges JSON ${t.slice(0,300)}`)}}\n last=new Error(`HTTP ${r.status} ${url} BODY ${t.slice(0,500)}`);\n if(r.status<500&&r.status!==429)throw last;\n await sleep(300*(2**a)+Math.random()*200);\n }catch(e){last=e;if(a<2)await sleep(300*(2**a)+Math.random()*200)}\n }\n throw last;\n}\n\nexport default async function(){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS dex_candidates(token_key TEXT PRIMARY KEY,symbol TEXT,name TEXT,network TEXT,address TEXT,liquidity REAL,volume24 REAL,chg1h REAL,chg24h REAL,holders INTEGER,tx24 INTEGER,score REAL,last_seen INTEGER);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS discovery_meta(k TEXT PRIMARY KEY,v TEXT);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS catalog100k(source_id TEXT PRIMARY KEY,symbol TEXT,name TEXT,slug TEXT,status TEXT,date_added TEXT,platform TEXT,last_seen INTEGER,shard INTEGER);`);\n const cursorKey=`dex_cursor_${NETWORK}_${DEX}`;\n const cr=await sqlite.execute({sql:\"SELECT v FROM discovery_meta WHERE k=?\",args:[cursorKey]});\n const cursor=String((cr.rows?.[0] as any)?.v||'');\n let url=`https://pro-api.coinmarketcap.com/public-api/v4/dex/spot-pairs/latest?network_slug=${NETWORK}&dex_slug=${DEX}&limit=100`;\n if(cursor)url+=`&scroll_id=${encodeURIComponent(cursor)}`;\n const p:any=await fetchJson(url);\n const rows:any[]=Array.isArray(p?.data)?p.data:(Array.isArray(p)?p:[]);\n const tokens=new Map();\n for(const x of rows){\n const addr=String(x.base_asset_contract_address||'').trim();\n const sym=String(x.base_asset_symbol||'').toUpperCase().trim();\n if(!addr||!sym)continue;\n const q=Array.isArray(x.quote)?(x.quote[0]||{}):(x.quote?.USD||x.quote||{});\n const liq=safe(q.liquidity),vol=safe(q.volume_24h),h=safe(q.percent_change_price_1h),d=safe(q.percent_change_price_24h),holders=safe(x.holders),tx=safe(x.num_transactions_24h);\n const scans=Array.isArray(x.security_scan)?x.security_scan:[];\n const risky=scans.some((s:any)=>s?.aggregated?.honeypot===true||s?.third_party?.honeypot===true||s?.third_party?.cannot_buy===true||s?.third_party?.cannot_sell_all===true||s?.third_party?.blacklisted===true||s?.third_party?.self_destruct===true);\n const buyTax=safe(x.buy_tax),sellTax=safe(x.sell_tax);\n if(risky||buyTax>10||sellTax>10)continue;\n if(liq<5000||vol<1000)continue;\n const velocity=vol/Math.max(liq,1);\n const washPenalty=(velocity>50||(Math.abs(d)<1&&vol>1000000)||(tx>0&&tx<100&&vol>100000))?0.5:1;\n const score=(Math.log10(Math.max(1,liq))*2+Math.log10(Math.max(1,vol))*2+Math.min(10,Math.max(-10,h))*1.5+Math.min(30,Math.max(-30,d))*.4+Math.log10(Math.max(1,tx)))*washPenalty;\n if(!Number.isFinite(score))continue;\n const key=`${NETWORK}:${addr.toLowerCase()}`;\n const old=tokens.get(key);if(!old||score>old.score)tokens.set(key,{key,sym,name:String(x.base_asset_name||sym),addr,liq,vol,h,d,holders,tx,score});\n }\n const arr=[...tokens.values()];const now=Date.now();\n for(let i=0;i[\n {sql:\"INSERT INTO dex_candidates(token_key,symbol,name,network,address,liquidity,volume24,chg1h,chg24h,holders,tx24,score,last_seen) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT(token_key) DO UPDATE SET symbol=excluded.symbol,name=excluded.name,network=excluded.network,liquidity=excluded.liquidity,volume24=excluded.volume24,chg1h=excluded.chg1h,chg24h=excluded.chg24h,holders=excluded.holders,tx24=excluded.tx24,score=excluded.score,last_seen=excluded.last_seen\",args:[t.key,t.sym,t.name,NETWORK,t.addr,t.liq,t.vol,t.h,t.d,t.holders,t.tx,t.score,now]},\n {sql:\"INSERT INTO catalog100k(source_id,symbol,name,slug,status,date_added,platform,last_seen,shard) VALUES(?,?,?,?,?,?,?,?,?) ON CONFLICT(source_id) DO UPDATE SET symbol=excluded.symbol,name=excluded.name,status=excluded.status,platform=excluded.platform,last_seen=excluded.last_seen\",args:[`dex:${t.key}`,t.sym,t.name,'','dex-aktiv','',`${NETWORK}/${DEX}`,now,0]}\n ]))}\n const nextCursor=String((rows.at(-1) as any)?.scroll_id||p?.status?.scroll_id||p?.scroll_id||'');\n if(nextCursor&&nextCursor!==cursor)await sqlite.execute({sql:\"INSERT INTO discovery_meta(k,v) VALUES(?,?) ON CONFLICT(k) DO UPDATE SET v=excluded.v\",args:[cursorKey,nextCursor]});\n else await sqlite.execute({sql:\"DELETE FROM discovery_meta WHERE k=?\",args:[cursorKey]});\n await sqlite.execute({sql:\"DELETE FROM dex_candidates WHERE last_seenNumber(x.result_r)).filter(Number.isFinite);\n const n=xs.length;\n const avg=n?xs.reduce((a,b)=>a+b,0)/n:0;\n const gp=xs.filter(x=>x>0).reduce((a,b)=>a+b,0),gl=Math.abs(xs.filter(x=>x<0).reduce((a,b)=>a+b,0));\n const pf=gl>0?gp/gl:(gp>0?99:0);\n let equity=0,peak=0,maxDD=0;for(const x of xs){equity+=x;peak=Math.max(peak,equity);maxDD=Math.max(maxDD,peak-equity)}\n let mode='LEARNING';\n if(n>=30&&(avg<=0||pf<1.0||maxDD>=10))mode='PAUSE_REVIEW';\n else if(n>=50&&avg>0.15&&pf>1.25&&maxDD<8)mode='VALIDATED_PAPER';\n else if(n>=30)mode='WATCH';\n const now=Date.now();\n for(const [k,v] of Object.entries({mode,n:String(n),avg_r:String(avg),profit_factor:String(pf),max_drawdown_r:String(maxDD)}))await sqlite.execute({sql:\"INSERT INTO strategy_state(k,v,updated_ts) VALUES(?,?,?) ON CONFLICT(k) DO UPDATE SET v=excluded.v,updated_ts=excluded.updated_ts\",args:[k,String(v),now]});\n console.log(JSON.stringify({ok:true,modus:mode,anzahl:n,durchschnittR:avg,profitFaktor:pf,maxDrawdownR:maxDD,fenster:\"letzte 300 abgeschlossene Trades\"}));\n}","children",[],[262],"7dae4bc4-b4ae-4b3e-87ca-be4a445c4b81","reliability_audit.ts","6e7d1e4e-9f3d-11f1-aa37-1607ee4eb77e",79,["D",1787522162059],"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function(){\n const now=Date.now();\n const [runs,open,closed,guards]=await Promise.all([\n sqlite.execute({sql:\"SELECT ts,status,universe,alerts,error FROM runs ORDER BY ts DESC LIMIT 30\",args:[]}),\n sqlite.execute(\"SELECT COUNT(*) n, MIN(created_ts) oldest FROM paper_signals WHERE status='OPEN'\"),\n sqlite.execute(\"SELECT COUNT(*) n, AVG(result_r) expectancy FROM paper_signals WHERE status='CLOSED' AND result_r IS NOT NULL\"),\n sqlite.execute(\"SELECT COUNT(*) n FROM run_guard WHERE created_ts>?\",[now-86400000] as any).catch(()=>({rows:[]} as any))\n ]);\n const rr:any[]=(runs.rows||[]) as any[];\n const last=rr[0];\n const errors=rr.filter(x=>String(x.status)==='error'||String(x.status).startsWith('pausiert_deep_datenqualitaet'));\n const age=last?now-Number(last.ts):Infinity;\n const result={ok:age<45*60*1000&&errors.length<5,lastRunAgeMin:Number.isFinite(age)?age/60000:null,lastStatus:last?.status||null,recentProblemRuns:errors.length,openSignals:Number((open.rows?.[0] as any)?.n||0),closedSignals:Number((closed.rows?.[0] as any)?.n||0),expectancyR:(closed.rows?.[0] as any)?.expectancy??null,checks:{scannerFresh:age<45*60*1000,errorBurst:errors.length<5}};\n console.log(JSON.stringify(result));return result;\n}",[],[271],"15d35d8c-4138-49ed-906a-f306cd1dc4c9","performance_attribution.ts","5f614976-9f3d-11f1-b6bb-1607ee4eb77e",["D",1787522250616],1,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst n=(x:any)=>Number(x);\nconst valid=(x:any)=>Number.isFinite(n(x));\nconst avg=(xs:number[])=>xs.length?xs.reduce((a,b)=>a+b,0)/xs.length:null;\nconst median=(xs:number[])=>{if(!xs.length)return null;const a=[...xs].sort((x,y)=>x-y),m=Math.floor(a.length/2);return a.length%2?a[m]:(a[m-1]+a[m])/2};\nconst sd=(xs:number[])=>{if(xs.length<2)return null;const m=avg(xs)!;return Math.sqrt(xs.reduce((s,x)=>s+(x-m)**2,0)/(xs.length-1));};\n\nexport default async function(){\n const r=await sqlite.execute(`SELECT symbol,result_r,rr,relvol,spread,broad_score,created_ts,closed_ts,exit_reason FROM paper_signals WHERE status='CLOSED' AND result_r IS NOT NULL ORDER BY closed_ts ASC`);\n const rows:any[]=r.rows as any[];\n const winners=rows.filter(x=>n(x.result_r)>0), losers=rows.filter(x=>n(x.result_r)<=0);\n const rs=rows.map(x=>n(x.result_r)).filter(Number.isFinite);\n const metrics=[\"rr\",\"relvol\",\"spread\",\"broad_score\"] as const;\n const compare:any={};\n for(const m of metrics){\n const w=winners.map(x=>n(x[m])).filter(Number.isFinite), l=losers.map(x=>n(x[m])).filter(Number.isFinite);\n compare[m]={winnerAvg:avg(w),loserAvg:avg(l),winnerMedian:median(w),loserMedian:median(l),deltaAvg:w.length&&l.length?avg(w)!-avg(l)!:null};\n }\n const grossWin=rs.filter(x=>x>0).reduce((a,b)=>a+b,0),grossLoss=Math.abs(rs.filter(x=>x<0).reduce((a,b)=>a+b,0));\n const mean=avg(rs),stdev=sd(rs),se=stdev&&rs.length?stdev/Math.sqrt(rs.length):null;\n let equity=0,peak=0,maxDrawdownR=0;\n for(const x of rs){equity+=x;peak=Math.max(peak,equity);maxDrawdownR=Math.max(maxDrawdownR,peak-equity);}\n const summary={sample:rows.length,wins:winners.length,losses:losers.length,winRate:rows.length?winners.length/rows.length:null,expectancyR:mean,stdevR:stdev,approx95CI_R:se&&mean!=null?[mean-1.96*se,mean+1.96*se]:null,profitFactor:grossLoss>0?grossWin/grossLoss:null,maxDrawdownR,compare,stage:rows.length<30?\"SAMMELN\":rows.length<100?\"VORLAEUFIGE_ATTRIBUTION\":rows.length<200?\"ERWEITERTE_VALIDIERUNG\":\"ROBUSTHEITS_VALIDIERUNG\",allowRuleChanges:rows.length>=100,warning:rows.length<30?\"Unter 30 Trades: keine Schlussfolgerungen.\":rows.length<100?\"30-99 Trades: nur Hypothesen, keine automatische Regeländerung.\":\"Regeländerungen nur nach OOS/Forward-Bestaetigung.\"};\n console.log(JSON.stringify(summary));return summary;\n}",[],[280],"e07c71e1-1ed5-4615-aadf-f395c2cc22a4","main.ts","a50eab96-9f27-11f1-a19c-1607ee4eb77e",73,["D",1787516517734],"import { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst BROAD_LIMIT = 10_000;\nconst DEEP_LIMIT = 50;\nconst MAX_SPREAD_BPS = 40;\nconst MIN_REL_VOL = 1.25;\nconst MIN_RR = 2.0;\nconst MIN_BROAD_COMPLETENESS = 0.90;\nconst MAX_DEEP_ERROR_RATE = 0.20;\nconst STABLE = new Set([\"USDT\",\"USDC\",\"DAI\",\"FDUSD\",\"TUSD\",\"USDE\",\"PYUSD\",\"USDD\"]);\n\nconst sleep = (ms:number) => new Promise(r => setTimeout(r, ms));\nconst avg = (xs:number[]) => xs.length ? xs.reduce((a,b)=>a+b,0)/xs.length : 0;\nconst finite = (x:any, fallback=0) => { const n=Number(x); return Number.isFinite(n) ? n : fallback; };\n\nasync function fetchJson(url:string, timeoutMs=5000){\n let last:any;\n for(let attempt=0; attempt<2; attempt++){\n try{\n const r=await fetch(url,{headers:{\"User-Agent\":\"crypto-radar/4.0\",\"Accept\":\"application/json\"},signal:AbortSignal.timeout(timeoutMs)});\n if(r.ok) return await r.json();\n last=new Error(`HTTP ${r.status} ${url}`);\n if(r.status<500 && r.status!==408 && r.status!==429) throw last;\n const retryAfter=Number(r.headers.get(\"retry-after\")||0);\n await sleep(Math.min(1200,retryAfter>0?retryAfter*1000:250*(2**attempt)+Math.random()*150));\n }catch(e){\n last=e;\n if(attempt===0) await sleep(250+Math.random()*150);\n }\n }\n throw last || new Error(`Abruf fehlgeschlagen ${url}`);\n}\n\nasync function initDb(){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS alerts(symbol TEXT PRIMARY KEY,last_ts INTEGER NOT NULL);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS runs(ts INTEGER,status TEXT,universe INTEGER,alerts INTEGER,error TEXT);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS run_guard(job TEXT,bucket INTEGER,created_ts INTEGER,PRIMARY KEY(job,bucket));`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS paper_signals(id INTEGER PRIMARY KEY AUTOINCREMENT,symbol TEXT,product TEXT,entry REAL,stop REAL,tp1 REAL,tp2 REAL,rr REAL,relvol REAL,spread REAL,broad_score REAL,source TEXT,created_ts INTEGER,status TEXT DEFAULT 'OPEN',closed_ts INTEGER,result_r REAL,exit_reason TEXT);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_paper_open ON paper_signals(status,created_ts);`);\n}\n\nasync function claimRun(job:string, windowMs:number){\n const bucket=Math.floor(Date.now()/windowMs);\n const r:any=await sqlite.execute({sql:\"INSERT OR IGNORE INTO run_guard(job,bucket,created_ts) VALUES(?,?,?)\",args:[job,bucket,Date.now()]});\n await sqlite.execute({sql:\"DELETE FROM run_guard WHERE created_ts0;\n}\n\nfunction broadScore(c:any){\n const vol=finite(c.volume24), cap=finite(c.market_cap_usd), h=finite(c.percent_change_1h), d=finite(c.percent_change_24h), w=finite(c.percent_change_7d);\n const vm=vol/Math.max(cap,1);\n let score=Math.min(8,Math.max(-8,h))*2 + Math.min(20,Math.max(-20,d))*0.6 + Math.min(40,Math.max(-40,w))*0.15 + Math.min(5,vm*10);\n if(vol<500_000) score-=12;\n if(cap<2_000_000) score-=8;\n return Number.isFinite(score)?score:-999;\n}\n\nasync function broadUniverse(){\n const first:any=await fetchJson(\"https://api.coinlore.net/api/tickers/?start=0&limit=100\");\n const expected=Math.min(BROAD_LIMIT,Math.max(100,finite(first?.info?.coins_num,BROAD_LIMIT)));\n const pages=Math.ceil(expected/100);\n const all:any[]=[...(Array.isArray(first?.data)?first.data:[])];\n let failedPages=0;\n for(let base=1;basebase+k);\n const batch=await Promise.all(indexes.map(async p=>{\n try{\n const r:any=await fetchJson(`https://api.coinlore.net/api/tickers/?start=${p*100}&limit=100`);\n return Array.isArray(r?.data)?r.data:[];\n }catch{ failedPages++; return []; }\n }));\n for(const b of batch) all.push(...b);\n }\n const coins=all.slice(0,expected)\n .filter(c=>!STABLE.has(String(c.symbol||\"\").toUpperCase()))\n .map(c=>({\n id:String(c.id||\"\"), symbol:String(c.symbol||\"\").toUpperCase(), name:String(c.name||\"\"),\n score:broadScore(c), rank:finite(c.rank), price:finite(c.price_usd), marketCap:finite(c.market_cap_usd),\n volume24:finite(c.volume24), chg1h:finite(c.percent_change_1h), chg24h:finite(c.percent_change_24h), chg7d:finite(c.percent_change_7d)\n }))\n .filter(c=>c.id && c.symbol && Number.isFinite(c.score))\n .sort((a,b)=>b.score-a.score);\n return {coins, expected, failedPages};\n}\n\nasync function marketStress(){\n try{\n const k:any[]=await fetchJson(\"https://api.exchange.coinbase.com/products/BTC-USD/candles?granularity=300\");\n if(!Array.isArray(k)||k.length<50) return {pause:true,grund:\"BTC_STRESSCHECK_ZU_WENIG_DATEN\"};\n const rows=k.slice(0,50).reverse();\n const closes=rows.map((x:any[])=>finite(x[4],NaN));\n if(closes.some(x=>!Number.isFinite(x))) return {pause:true,grund:\"BTC_STRESSCHECK_UNGÜLTIGE_DATEN\"};\n const last=closes.at(-1)!;\n const ret1h=(last/closes.at(-13)!-1)*100;\n const ret4h=(last/closes.at(-49)!-1)*100;\n const pause=ret1h<=-3 || ret4h<=-7;\n return {pause,ret1h,ret4h,grund:pause?\"BTC_MARKTSTRESS\":\"NORMAL\"};\n }catch(e:any){\n return {pause:true,grund:\"BTC_STRESSCHECK_FEHLER\",fehler:String(e?.message||e)};\n }\n}\n\nasync function scanCoinbase(c:any){\n const product=String(c.product);\n const [ticker,candles]:any[]=await Promise.all([\n fetchJson(`https://api.exchange.coinbase.com/products/${encodeURIComponent(product)}/ticker`),\n fetchJson(`https://api.exchange.coinbase.com/products/${encodeURIComponent(product)}/candles?granularity=300`)\n ]);\n if(!Array.isArray(candles)||candles.length<22) return null;\n const bid=finite(ticker.bid,NaN), ask=finite(ticker.ask,NaN);\n if(!(bid>0&&ask>0&&ask>=bid)) return null;\n const spread=((ask-bid)/bid)*10000;\n if(!Number.isFinite(spread)||spread>MAX_SPREAD_BPS) return null;\n\n const rows=candles.slice(0,30).reverse();\n const cl=rows.map((x:any[])=>finite(x[4],NaN));\n const hi=rows.map((x:any[])=>finite(x[2],NaN));\n const lo=rows.map((x:any[])=>finite(x[1],NaN));\n const vol=rows.map((x:any[])=>finite(x[5],NaN)*finite(x[4],NaN));\n if([...cl,...hi,...lo,...vol].some(x=>!Number.isFinite(x))) return null;\n\n const last=cl.at(-1)!, prev=cl.at(-2)!;\n if(!(last>0&&prev>0)||Math.abs((last-prev)/prev*100)>25) return null;\n const rel=vol.at(-1)!/Math.max(1,avg(vol.slice(-21,-1)));\n const ma5=avg(cl.slice(-5));\n if(last<=ma5*1.001||rel55) return null;\n\n const tr:number[]=[];\n for(let i=1;i0)) return null;\n\n const entry=ask;\n const stop=Math.max(l20-0.5*atr,entry*0.98);\n const tp1=entry+1.5*atr;\n const tp2=entry+2.5*atr;\n const risk=entry-stop;\n if(!(risk>0)) return null;\n const rr=((0.5*(tp1-entry))+(0.5*(tp2-entry)))/risk;\n if(rr86400000;\n}\n\nasync function mark(symbol:string){\n await sqlite.execute({sql:\"INSERT INTO alerts(symbol,last_ts) VALUES(?,?) ON CONFLICT(symbol) DO UPDATE SET last_ts=excluded.last_ts\",args:[symbol,Date.now()]});\n}\n\nasync function alertBudget(){\n const t=Date.now();\n const h=await sqlite.execute({sql:\"SELECT COUNT(*) n FROM paper_signals WHERE created_ts>?\",args:[t-3600000]});\n const d=await sqlite.execute({sql:\"SELECT COUNT(*) n FROM paper_signals WHERE created_ts>?\",args:[t-86400000]});\n return {hour:Number((h.rows?.[0] as any)?.n||0),day:Number((d.rows?.[0] as any)?.n||0)};\n}\n\nasync function savePaper(a:any){\n await sqlite.execute({sql:\"INSERT INTO paper_signals(symbol,product,entry,stop,tp1,tp2,rr,relvol,spread,broad_score,source,created_ts,status) VALUES(?,?,?,?,?,?,?,?,?,?,?,?, 'OPEN')\",args:[a.symbol,a.product,a.entry,a.stop,a.tp1,a.tp2,a.rr,a.rel,a.spread,a.score??0,\"coinlore+coinbase\",Date.now()]});\n}\n\nasync function strategyMode(){\n try{const r=await sqlite.execute(\"SELECT v FROM strategy_state WHERE k='mode'\");return String((r.rows?.[0] as any)?.v||\"LEARNING\")}catch{return \"LEARNING\"}\n}\n\nexport default async function(){\n await initDb();\n const ts=Date.now();\n try{\n if(!(await claimRun(\"hauptscanner\",15*60*1000))){console.log(JSON.stringify({ok:true,status:\"DOPPELLAUF_VERHINDERT\"}));return}\n\n const mode=await strategyMode();\n if(mode===\"PAUSE_REVIEW\"){\n await sqlite.execute({sql:\"INSERT INTO runs VALUES(?,?,?,?,?)\",args:[ts,\"pausiert_strategiepruefung\",0,0,null]});\n console.log(JSON.stringify({ok:true,status:\"PAUSIERT_STRATEGIEPRUEFUNG\"}));return;\n }\n\n const stress=await marketStress();\n if(stress.pause){\n await sqlite.execute({sql:\"INSERT INTO runs VALUES(?,?,?,?,?)\",args:[ts,\"pausiert_btc_marktstress\",0,0,JSON.stringify(stress)]});\n console.log(JSON.stringify({ok:true,status:\"PAUSIERT_BTC_MARKTSTRESS\",stress}));return;\n }\n\n const broadResult=await broadUniverse();\n const broad=broadResult.coins;\n const minRequired=Math.floor(broadResult.expected*MIN_BROAD_COMPLETENESS);\n if(broad.length();\n for(const c of broad) symbolCounts.set(c.symbol,(symbolCounts.get(c.symbol)||0)+1);\n\n const cbProducts:any[]=await fetchJson(\"https://api.exchange.coinbase.com/products\");\n const productMap=new Map();\n for(const p of cbProducts){\n const base=String(p.base_currency||\"\").toUpperCase();\n if(String(p.quote_currency||\"\").toUpperCase()!==\"USD\"||p.status!==\"online\"||p.trading_disabled||!base) continue;\n if(!productMap.has(base)) productMap.set(base,String(p.id||`${base}-USD`));\n }\n\n const deepPool:any[]=[];\n for(const c of broad){\n if(deepPool.length>=DEEP_LIMIT) break;\n if((symbolCounts.get(c.symbol)||0)!==1) continue;\n const product=productMap.get(c.symbol);\n if(!product) continue;\n deepPool.push({...c,product});\n }\n\n if(deepPool.length<20){\n const info={deepPool:deepPool.length,coinbaseProdukte:productMap.size};\n await sqlite.execute({sql:\"INSERT INTO runs VALUES(?,?,?,?,?)\",args:[ts,\"pausiert_zu_wenig_deep_kandidaten\",broad.length,0,JSON.stringify(info)]});\n console.log(JSON.stringify({ok:false,status:\"PAUSIERT_ZU_WENIG_DEEP_KANDIDATEN\",...info}));return;\n }\n\n const found:any[]=[];\n let deepErrors=0;\n for(let i=0;i{try{return await scanCoinbase(c)}catch{deepErrors++;return null}}));\n for(const x of r) if(x&&await cooldown(x.symbol)) found.push(x);\n }\n\n const errorRate=deepErrors/Math.max(1,deepPool.length);\n if(errorRate>MAX_DEEP_ERROR_RATE){\n const info={deepErrors,deepVersuche:deepPool.length,errorRate};\n await sqlite.execute({sql:\"INSERT INTO runs VALUES(?,?,?,?,?)\",args:[ts,\"pausiert_deep_datenqualitaet\",broad.length,0,JSON.stringify(info)]});\n console.log(JSON.stringify({ok:false,status:\"PAUSIERT_DEEP_DATENQUALITAET\",...info}));return;\n }\n\n found.sort((a,b)=>(b.rel*b.rr)-(a.rel*a.rr));\n const budget=await alertBudget();\n const slots=Math.max(0,Math.min(3,3-budget.hour,10-budget.day));\n const alerts=found.slice(0,slots);\n\n for(const a of alerts){\n const stopPct=((a.entry-a.stop)/a.entry)*100;\n const suggestedExposurePct=Math.min(25,0.5/Math.max(stopPct/100,0.002));\n await savePaper(a);\n await email({\n subject:`[PAPER-SIGNAL] ${a.symbol} LONG | CRV ${a.rr.toFixed(1)}`,\n text:`Nur Paper-Trading — keine automatische Echtgeldorder.\\n\\nCoin: ${a.name} (${a.symbol})\\nEinstieg: ${a.entry}\\nStop-Loss: ${a.stop} (${stopPct.toFixed(2)}% Abstand)\\nKursziel 1: ${a.tp1}\\nKursziel 2: ${a.tp2}\\nChance-Risiko-Verhältnis: ${a.rr.toFixed(2)}\\nRelatives Volumen: ${a.rel.toFixed(2)}x\\nSpread: ${a.spread.toFixed(1)} Basispunkte\\nBreitenscore: ${(a.score??0).toFixed(2)}\\nMarktrang: ${a.rank||\"nicht verfügbar\"}\\n24h-Handelsvolumen: ${Math.round(a.volume24||0).toLocaleString(\"de-CH\")}\\n\\nPaper-Managementregel: 50% der Position bei Ziel 1 schließen; danach Stop der restlichen 50% auf Einstand setzen; Rest bei Ziel 2 schließen.\\nRisikomodell: maximal 0,5% hypothetisches Portfoliorisiko pro Setup; indikative Positionsobergrenze ${suggestedExposurePct.toFixed(1)}%.\\n\\nZeitpunkt (UTC): ${new Date().toISOString()}`\n });\n await mark(a.symbol);\n }\n\n await sqlite.execute({sql:\"INSERT INTO runs VALUES(?,?,?,?,?)\",args:[ts,`ok_deep_${deepPool.length}`,broad.length,alerts.length,null]});\n console.log(JSON.stringify({ok:true,broadAnalysiert:broad.length,fehlendeBreitenseiten:broadResult.failedPages,tiefenScanVersuche:deepPool.length,tiefenScanFehler:deepErrors,qualifizierteSetups:found.length,signale:alerts.map(a=>a.symbol),topBreitenscan:broad.slice(0,10).map(x=>x.symbol)}));\n }catch(e:any){\n await sqlite.execute({sql:\"INSERT INTO runs VALUES(?,?,?,?,?)\",args:[ts,\"error\",0,0,String(e?.message||e)]});\n throw e;\n }\n}",[],[288],"89922b71-51cb-4ca1-a0ff-6991ba58c892","healthcheck.ts","21af2bae-9f31-11f1-b5c5-1607ee4eb77e",77,["D",1787516879194],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function(){\n const now=Date.now();\n const r=await sqlite.execute(\"SELECT ts,status,universe,alerts,error FROM runs ORDER BY ts DESC LIMIT 20\");\n const rows=(r.rows||[]) as any[];\n const latest=rows[0];\n const age=latest?now-Number(latest.ts):Infinity;\n const recentErrors=rows.filter(x=>String(x.status)==='error'||String(x.status).startsWith('pausiert_daten')||String(x.status).startsWith('pausiert_deep')).length;\n const p=await sqlite.execute(\"SELECT COUNT(*) total, SUM(CASE WHEN status='OPEN' THEN 1 ELSE 0 END) offen, SUM(CASE WHEN status='CLOSED' THEN 1 ELSE 0 END) geschlossen, AVG(CASE WHEN status='CLOSED' THEN result_r END) avg_r FROM paper_signals\");\n const paper=(p.rows?.[0] as any)||{};\n const ok=age<=45*60*1000 && recentErrors===0;\n const out={ok,status:ok?'GESUND':'PRUEFEN',letzterScannerVorMinuten:Number.isFinite(age)?Math.round(age/60000):null,letzterStatus:latest?.status||null,letztesUniversum:Number(latest?.universe||0),letzteSignale:Number(latest?.alerts||0),fehlerInLetzten20:recentErrors,paper};\n console.log(JSON.stringify(out));\n return out;\n}",[],[296],"8c9fc481-4df2-4ef1-9d95-a5d846200cab","evaluate_paper.ts","ccce4a62-9f2a-11f1-8819-1607ee4eb77e",["D",1787516879194],4,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst sleep=(ms:number)=>new Promise(r=>setTimeout(r,ms));\nasync function j(u:string){let last:any;for(let a=0;a<3;a++){try{const r=await fetch(u,{headers:{\"User-Agent\":\"crypto-radar-eval/3.0\"},signal:AbortSignal.timeout(5000)});if(r.ok)return r.json();last=new Error(`HTTP ${r.status} ${u}`);if(r.status<500&&r.status!==429)throw last;const ra=Number(r.headers.get(\"retry-after\")||0);await sleep(Math.min(2000,ra?ra*1000:300*(2**a)+Math.random()*200))}catch(e){last=e;if(a<2)await sleep(300*(2**a)+Math.random()*200)}}throw last}\n\nasync function candles48h(product:string,createdTs:number){\n const end=Math.min(Date.now(),createdTs+48*3600000);\n const all:any[]=[];\n for(let s=createdTs;s();\n return all.filter((c:any[])=>{const t=Number(c[0]);if(!Number.isFinite(t)||seen.has(t))return false;seen.add(t);return true}).sort((a:any[],b:any[])=>Number(a[0])-Number(b[0]));\n}\n\nexport default async function(){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS paper_signals(id INTEGER PRIMARY KEY AUTOINCREMENT,symbol TEXT,product TEXT,entry REAL,stop REAL,tp1 REAL,tp2 REAL,rr REAL,relvol REAL,spread REAL,broad_score REAL,source TEXT,created_ts INTEGER,status TEXT DEFAULT 'OPEN',closed_ts INTEGER,result_r REAL,exit_reason TEXT);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_paper_open ON paper_signals(status,created_ts);`);\n const open=await sqlite.execute(\"SELECT * FROM paper_signals WHERE status='OPEN' ORDER BY created_ts ASC LIMIT 100\");\n let geschlossen=0,offen=0,fehler=0;\n for(const s of (open.rows||[]) as any[]){\n try{\n const created=Number(s.created_ts),startSec=Math.ceil(created/300000)*300000/1000;\n const rows=(await candles48h(String(s.product),created)).filter((c:any[])=>Number(c[0])>=startSec);\n if(!rows.length){offen++;continue}\n const entry=Number(s.entry),stop=Number(s.stop),tp1=Number(s.tp1),tp2=Number(s.tp2),risk=entry-stop;\n if(!(risk>0)){throw new Error(`Ungültiges Risiko Signal ${s.id}`)}\n const r1=(tp1-entry)/risk,r2=(tp2-entry)/risk;\n let tp1Hit=false; let outcome:null|{reason:string,r:number,ts:number}=null;\n for(const c of rows){\n const ts=Number(c[0])*1000,low=Number(c[1]),high=Number(c[2]);\n if(!tp1Hit){\n const stopHit=low<=stop,t1=high>=tp1,t2=high>=tp2;\n if(stopHit&&(t1||t2)){outcome={reason:'STOP_UNKLAR_GLEICHE_KERZE',r:-1,ts};break}\n if(stopHit){outcome={reason:'STOP',r:-1,ts};break}\n if(t2){outcome={reason:'ZIEL_2',r:.5*r1+.5*r2,ts};break}\n if(t1){tp1Hit=true;continue}\n }else{\n const breakEven=low<=entry,t2=high>=tp2;\n if(breakEven&&t2){outcome={reason:'TP1_DANN_BE_UNKLAR_GLEICHE_KERZE',r:.5*r1,ts};break}\n if(breakEven){outcome={reason:'TP1_DANN_EINSTAND',r:.5*r1,ts};break}\n if(t2){outcome={reason:'ZIEL_2_NACH_TP1',r:.5*r1+.5*r2,ts};break}\n }\n }\n const age=Date.now()-created;\n if(!outcome&&age>=48*3600000){\n const last=rows.at(-1),px=Number(last?.[4]);\n const markR=Number.isFinite(px)?(px-entry)/risk:0;\n outcome={reason:tp1Hit?'ZEITENDE_48H_NACH_TP1':'ZEITENDE_48H',r:tp1Hit?.5*r1+.5*markR:markR,ts:created+48*3600000};\n }\n if(outcome){await sqlite.execute({sql:\"UPDATE paper_signals SET status='CLOSED',closed_ts=?,result_r=?,exit_reason=? WHERE id=? AND status='OPEN'\",args:[outcome.ts,outcome.r,outcome.reason,Number(s.id)]});geschlossen++}else offen++;\n }catch{fehler++;offen++}\n }\n const stats=await sqlite.execute(\"SELECT COUNT(*) n, AVG(result_r) avg_r, SUM(CASE WHEN result_r>0 THEN 1 ELSE 0 END) wins, SUM(CASE WHEN result_r<=0 THEN 1 ELSE 0 END) losses, MIN(result_r) worst_r, MAX(result_r) best_r FROM paper_signals WHERE status='CLOSED'\");\n console.log(JSON.stringify({ok:fehler===0,geprueft:(open.rows||[]).length,geschlossen,offen,fehler,statistik:stats.rows?.[0]||{}}));\n}",[],[304],["D",1787516580676],[],[18],"2cc8f670-9735-4638-a997-597d3e9eaab7","daily_report.ts","e4d003a8-9f2a-11f1-9a39-1607ee4eb77e",74,["D",1787516537856],"import { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nasync function init(){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS runs(ts INTEGER,status TEXT,universe INTEGER,alerts INTEGER,error TEXT);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS paper_signals(id INTEGER PRIMARY KEY AUTOINCREMENT,symbol TEXT,product TEXT,entry REAL,stop REAL,tp1 REAL,tp2 REAL,rr REAL,relvol REAL,spread REAL,broad_score REAL,source TEXT,created_ts INTEGER,status TEXT DEFAULT 'OPEN',closed_ts INTEGER,result_r REAL,exit_reason TEXT);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS catalog100k(source_id TEXT PRIMARY KEY,symbol TEXT,name TEXT,slug TEXT,status TEXT,date_added TEXT,platform TEXT,last_seen INTEGER,shard INTEGER);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS dex_candidates(token_key TEXT PRIMARY KEY,symbol TEXT,name TEXT,network TEXT,address TEXT,liquidity REAL,volume24 REAL,chg1h REAL,chg24h REAL,holders INTEGER,tx24 INTEGER,score REAL,last_seen INTEGER);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS strategy_state(k TEXT PRIMARY KEY,v TEXT,updated_ts INTEGER);`);\n}\n\nexport default async function(){\n await init();\n const seit=Date.now()-86400000;\n const runs=await sqlite.execute({sql:\"SELECT COUNT(*) n, SUM(CASE WHEN status LIKE 'ok%' THEN 1 ELSE 0 END) okruns, SUM(CASE WHEN status='error' THEN 1 ELSE 0 END) errors, MAX(ts) last_ts, MAX(universe) max_universe, COALESCE(SUM(alerts),0) alerts FROM runs WHERE ts>?\",args:[seit]});\n const paper=await sqlite.execute(\"SELECT COUNT(*) n, AVG(result_r) avg_r, SUM(CASE WHEN result_r>0 THEN 1 ELSE 0 END) wins, SUM(CASE WHEN result_r<=0 THEN 1 ELSE 0 END) losses, MIN(result_r) worst_r, MAX(result_r) best_r FROM paper_signals WHERE status='CLOSED'\");\n const offen=await sqlite.execute(\"SELECT COUNT(*) n FROM paper_signals WHERE status='OPEN'\");\n const katalog=await sqlite.execute(\"SELECT COUNT(*) n FROM catalog100k\");\n const dex=await sqlite.execute(\"SELECT COUNT(*) n FROM dex_candidates\");\n let modus='LERNPHASE';\n try{const m=await sqlite.execute(\"SELECT v FROM strategy_state WHERE k='mode'\");const roh=String((m.rows?.[0] as any)?.v||'LEARNING');modus=roh==='LEARNING'?'LERNPHASE':roh==='VALIDATED_PAPER'?'PAPER-STRATEGIE VALIDiert':roh==='WATCH'?'BEOBACHTEN':roh==='PAUSE_REVIEW'?'PAUSIEREN UND PRÜFEN':roh}catch{}\n const r:any=runs.rows?.[0]||{},p:any=paper.rows?.[0]||{},o:any=offen.rows?.[0]||{},c:any=katalog.rows?.[0]||{},d:any=dex.rows?.[0]||{};\n const gesamt=Number(p.n||0),gewinne=Number(p.wins||0);const trefferquote=gesamt?gewinne/gesamt*100:0;\n const lastTs=Number(r.last_ts||0);const alterMin=lastTs?Math.round((Date.now()-lastTs)/60000):null;\n const text=`Krypto-Radar — täglicher Kontrollbericht\\n\\nSystemstatus: ${modus}\\n\\nLäufe in den letzten 24 Stunden: ${r.n||0}\\nDavon erfolgreiche Voll-Läufe: ${r.okruns||0}\\nRuntime-Fehler: ${r.errors||0}\\nLetzter protokollierter Lauf: ${alterMin===null?'nicht verfügbar':`${alterMin} Minuten her`}\\nGrößtes gescanntes Universum: ${r.max_universe||0}\\nSignale in den letzten 24 Stunden: ${r.alerts||0}\\nKatalogisierte Assets: ${c.n||0}\\nDEX-Kandidaten: ${d.n||0}\\n\\nPaper-Trading-Auswertung\\nAbgeschlossene Trades: ${gesamt}\\nOffene Trades: ${o.n||0}\\nTrefferquote: ${trefferquote.toFixed(1)}%\\nDurchschnittliches R: ${Number(p.avg_r||0).toFixed(3)}\\nBestes R: ${Number(p.best_r||0).toFixed(3)}\\nSchlechtestes R: ${Number(p.worst_r||0).toFixed(3)}\\n\\nRegelwerk: 50% bei Ziel 1 schließen, danach Stop der Restposition auf Einstand; Rest bei Ziel 2 schließen. Keine automatischen Echtgeldorders.\\n\\nZeitpunkt (UTC): ${new Date().toISOString()}`;\n await email({subject:\"Krypto-Radar — täglicher Kontrollbericht\",text});\n console.log(JSON.stringify({ok:true,laeufe24h:r.n||0,fehler24h:r.errors||0,katalog:c.n||0,dex:d.n||0,abgeschlossen:gesamt,offen:o.n||0,trefferquote,durchschnittR:Number(p.avg_r||0),modus}));\n}",[],[315],"9b3921d1-17ff-413f-9b35-e7c7bc627270","catalog100k.ts","6e332370-9f29-11f1-b2e5-1607ee4eb77e",76,["D",1787516597049],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst PAGE=5000, SHARDS=20, BATCH=250;\nconst sleep=(ms:number)=>new Promise(r=>setTimeout(r,ms));\n\nasync function fetchJson(url:string){\n let last:any;\n for(let a=0;a<3;a++){\n try{\n const r=await fetch(url,{headers:{\"Accept\":\"application/json\",\"User-Agent\":\"crypto-radar-catalog/3.0\"},signal:AbortSignal.timeout(8000)});\n if(r.ok)return r.json();\n last=new Error(`HTTP ${r.status} ${url}`);\n if(r.status<500&&r.status!==429)throw last;\n await sleep(400*(2**a)+Math.random()*200);\n }catch(e){last=e;if(a<2)await sleep(400*(2**a)+Math.random()*200)}\n }\n throw last;\n}\n\nexport default async function(){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS catalog100k(source_id TEXT PRIMARY KEY,symbol TEXT,name TEXT,slug TEXT,status TEXT,date_added TEXT,platform TEXT,last_seen INTEGER,shard INTEGER);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS discovery_meta(k TEXT PRIMARY KEY,v TEXT);`);\n const m=await sqlite.execute(\"SELECT v FROM discovery_meta WHERE k='catalog_next_shard'\");\n const shard=Number((m.rows?.[0] as any)?.v||0)%SHARDS;\n const start=shard*PAGE+1;\n const statuses=['active','inactive','untracked'];\n const rows:any[]=[];\n let successfulCalls=0,failedCalls=0;\n for(const status of statuses){\n try{\n const p:any=await fetchJson(`https://pro-api.coinmarketcap.com/public-api/v1/cryptocurrency/map?listing_status=${status}&start=${start}&limit=${PAGE}`);\n successfulCalls++;\n for(const c of (Array.isArray(p?.data)?p.data:[]))rows.push({...c,_status:status});\n }catch{failedCalls++}\n }\n if(successfulCalls===0){\n console.log(JSON.stringify({ok:false,status:\"KATALOG_QUELLEN_NICHT_ERREICHBAR\",shard,start,failedCalls}));\n return;\n }\n const seen=new Set();const unique:any[]=[];\n for(const c of rows){const id=String(c.id??'');if(!id||seen.has(id))continue;seen.add(id);unique.push(c)}\n const now=Date.now();let stored=0;\n for(let i=0;i{\n let platform='';if(c.platform)platform=String(c.platform.symbol||c.platform.name||c.platform.token_address||'');\n return {sql:\"INSERT INTO catalog100k(source_id,symbol,name,slug,status,date_added,platform,last_seen,shard) VALUES(?,?,?,?,?,?,?,?,?) ON CONFLICT(source_id) DO UPDATE SET symbol=excluded.symbol,name=excluded.name,slug=excluded.slug,status=excluded.status,date_added=excluded.date_added,platform=excluded.platform,last_seen=excluded.last_seen,shard=excluded.shard\",args:[String(c.id),String(c.symbol||'').toUpperCase(),String(c.name||''),String(c.slug||''),String(c._status||''),String(c.first_historical_data||c.date_added||''),platform,now,shard]};\n });\n if(stmts.length){await sqlite.batch(stmts);stored+=part.length}\n }\n const next=(shard+1)%SHARDS;\n await sqlite.execute({sql:\"INSERT INTO discovery_meta(k,v) VALUES('catalog_next_shard',?) ON CONFLICT(k) DO UPDATE SET v=excluded.v\",args:[String(next)]});\n const total=await sqlite.execute(\"SELECT COUNT(*) n FROM catalog100k\");\n console.log(JSON.stringify({ok:true,technischeKapazitaet:PAGE*SHARDS,aktuellKatalogisiert:Number((total.rows?.[0] as any)?.n||0),shard,start,raw:rows.length,unique:unique.length,stored,successfulCalls,failedCalls,nextShard:next}));\n}",[],[323],["D",1787512804582],["D",1789523429989],{"_11":12,"_209":80},{"_11":12,"_204":205,"_79":80,"_30":78,"_206":207,"_208":24},{"_48":195,"_13":16,"_42":45,"_196":158,"_197":-5,"_198":-5,"_199":-5,"_200":-5,"_201":-5,"_202":14,"_203":12},"ctx",{"_63":-5,"_228":368,"_369":370,"_371":372,"_373":24,"_374":24,"_375":24,"_376":234,"_377":-5,"_378":-7,"_379":-7,"_380":26,"_381":24,"_382":24,"_383":-5,"_384":24,"_385":24,"_386":24,"_387":-5},"ENV",{"_339":340,"_341":342,"_343":16,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367},"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"]

History · dex_discovery.ts