[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_169":170,"_171":172},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_127":-5,"_20":128,"_22":129,"_130":131,"_132":133,"_25":134,"_24":-5,"_135":136,"_137":138,"_139":50,"_140":141,"_142":50,"_143":-5,"_144":-5,"_145":146},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":28,"_29":-5,"_30":31,"_32":33,"_34":-5},"handle","gbalan","name","smc_alert_pipeline2","branchName","main","version","path","","project",{"_35":83,"_13":14,"_37":84,"_48":-5,"_85":50,"_51":52,"_86":52,"_87":19,"_88":-5,"_89":90,"_91":-5,"_92":50,"_93":-5,"_94":-5,"_95":31,"_54":55,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":110,"_111":112,"_113":114,"_49":50},"tree",[78],"file","contents",[58],"upstream",{"_35":36,"_37":38,"_39":40,"_13":16,"_41":42,"_17":43,"_44":-5,"_45":-5,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":12,"_54":55,"_56":57},"pull","ahead",0,"behind",7,"envVars","id","c43b470c-a52c-4e86-b0e1-faf2b0a81fb0","createdAt",["D",1787283613474],"updatedAt",["D",1787788088151],"projectId","1613203d-9c3f-4d66-a4e0-32ca3618e27d",20,"forkedBranchId","forkedBranchVersion","lockfileKey","1787788088672-esm.town_v_gbalan_smc_alert_pipeline@20-main","deletedAt","isOwned",false,"privacy","public","userHandle","orgId","01a01ddf-09ab-72bf-b40b-a414b0b07946","projectName","smc_alert_pipeline",{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":70,"_17":31,"_71":72,"_73":74,"_75":50,"_76":-5,"_18":77},"3e598c62-7537-4f44-b1f1-8733c1ee4c89","main.ts","fileId","01a03cb9-6790-7271-b20d-066c5a261bc8","parentId","branchId","2a1ebf8f-3f07-47e4-9874-43a2d78d9d1c","branchVersion",1,"latest",true,["D",1787725178632],"fileType","interval","content","// Val.town Cron Val — 1H Liquidity Sweep + 5M MACD Cross Confluence Alert\n// Trigger type: Cron\n// Recommended schedule: */5 * * * * (every 5 minutes)\n//\n// Fixed vs the previous version: uses Twelve Data's BATCH endpoint\n// (comma-separated symbols in ONE request) instead of looping symbol-by-symbol\n// with sleep() delays. That was what blew the 60s free-tier execution limit.\n// This version makes at most 2 HTTP calls per run — well under a second or two.\n//\n// Logic:\n// 1H layer: detect a liquidity sweep on the most recently CLOSED 1H candle.\n// - Buy-side sweep = 1H high > recent swing high, closes back below it\n// -> BEARISH bias\n// - Sell-side sweep = 1H low < recent swing low, closes back above it\n// -> BULLISH bias\n// Bias stays \"active\" for the rest of that hour.\n//\n// 5M layer: standard MACD(12,26,9) on 5-minute closes, checked every cycle.\n//\n// Alert fires when a fresh 5M MACD cross matches the direction implied by\n// the current hour's active 1H sweep.\n//\n// Env vars required:\n// TWELVE_DATA_API_KEY\n// TELEGRAM_BOT_TOKEN\n// TELEGRAM_CHAT_ID\n//\n// API BUDGET (Twelve Data free tier: 8 req/min, 800 credits/day — batching\n// saves TIME, not credits; each symbol in a batch still costs 1 credit):\n// 5m layer: 3 symbols x 288 cycles/day = 864 credits/day\n// 1h layer: 3 symbols x 24 refreshes/day = 72 credits/day\n// TOTAL: 936/day <-- slightly over 800. Drop to 2 symbols (624/day) to be\n// safely under budget, or keep 3 if you have headroom from other vals.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst TWELVE_DATA_KEY = Deno.env.get(\"TWELVE_DATA_API_KEY\")!;\nconst TELEGRAM_BOT_TOKEN = Deno.env.get(\"TELEGRAM_BOT_TOKEN\")!;\nconst TELEGRAM_CHAT_ID = Deno.env.get(\"TELEGRAM_CHAT_ID\")!;\n\n// Trim to 2 symbols to stay safely under the 800/day cap — see notes above.\nconst SYMBOLS = [\"EUR/USD\", \"GBP/USD\", \"XAU/USD\"];\n\nconst SWING_LOOKBACK = 10; // 1H candles used to define the reference swing high/low\nconst MACD_FAST = 12;\nconst MACD_SLOW = 26;\nconst MACD_SIGNAL = 9;\n\ntype Candle = { high: number; low: number; close: number };\n\n// ---------- setup ----------\n\nasync function ensureTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sweep_macd_state (\n symbol TEXT NOT NULL,\n key TEXT NOT NULL,\n value TEXT,\n PRIMARY KEY (symbol, key)\n )\n `);\n}\n\n// ---------- indicators ----------\n\nfunction ema(values: number[], period: number): number[] {\n const out: number[] = new Array(values.length).fill(NaN);\n if (values.length < period) return out;\n const k = 2 / (period + 1);\n let sum = 0;\n for (let i = 0; i < period; i++) sum += values[i];\n out[period - 1] = sum / period;\n for (let i = period; i < values.length; i++) {\n out[i] = values[i] * k + out[i - 1] * (1 - k);\n }\n return out;\n}\n\nfunction macd(closes: number[]): { macdLine: number[]; signalLine: number[] } {\n const emaFast = ema(closes, MACD_FAST);\n const emaSlow = ema(closes, MACD_SLOW);\n const macdLine = closes.map((_, i) =>\n Number.isNaN(emaFast[i]) || Number.isNaN(emaSlow[i])\n ? NaN\n : emaFast[i] - emaSlow[i]\n );\n\n const validStart = MACD_SLOW - 1;\n const macdValid = macdLine.slice(validStart);\n const signalValid = ema(macdValid, MACD_SIGNAL);\n const signalLine: number[] = new Array(closes.length).fill(NaN);\n for (let i = 0; i < signalValid.length; i++) {\n signalLine[validStart + i] = signalValid[i];\n }\n return { macdLine, signalLine };\n}\n\nfunction detectMacdCross(\n prevMacd: number,\n prevSignal: number,\n currMacd: number,\n currSignal: number,\n): \"up\" | \"down\" | null {\n if (\n [prevMacd, prevSignal, currMacd, currSignal].some((v) => Number.isNaN(v))\n ) return null;\n if (prevMacd < prevSignal && currMacd >= currSignal) return \"up\";\n if (prevMacd > prevSignal && currMacd <= currSignal) return \"down\";\n return null;\n}\n\nfunction detectLiquiditySweep(\n candles: Candle[],\n lookback = SWING_LOOKBACK,\n): \"buy_side\" | \"sell_side\" | null {\n if (candles.length < lookback + 2) return null;\n const refWindow = candles.slice(-(lookback + 1), -1);\n const swingHigh = Math.max(...refWindow.map((c) => c.high));\n const swingLow = Math.min(...refWindow.map((c) => c.low));\n const last = candles[candles.length - 1];\n\n if (last.high > swingHigh && last.close < swingHigh) return \"buy_side\"; // bearish\n if (last.low < swingLow && last.close > swingLow) return \"sell_side\"; // bullish\n return null;\n}\n\n// ---------- batched data fetch ----------\n\n// Twelve Data returns a top-level {values:[...]} for a single symbol, or\n// {\"EUR/USD\": {values:[...]}, \"GBP/USD\": {values:[...]}, ...} for a batch.\nasync function fetchBatchCandles(\n symbols: string[],\n interval: string,\n outputsize: number,\n): Promise> {\n const symbolParam = symbols.join(\",\");\n const url = `https://api.twelvedata.com/time_series?symbol=${\n encodeURIComponent(\n symbolParam,\n )\n }&interval=${interval}&outputsize=${outputsize}&apikey=${TWELVE_DATA_KEY}`;\n\n const res = await fetch(url);\n const data = await res.json();\n\n const result: Record = {};\n\n const parseValues = (values: any[]): Candle[] =>\n values\n .map((v: { high: string; low: string; close: string }) => ({\n high: parseFloat(v.high),\n low: parseFloat(v.low),\n close: parseFloat(v.close),\n }))\n .reverse(); // chronological order\n\n if (symbols.length === 1) {\n result[symbols[0]] = data.values ? parseValues(data.values) : null;\n if (!data.values) {\n console.error(\n `[${symbols[0]} ${interval}] no data:`,\n data.message ?? data,\n );\n }\n } else {\n for (const symbol of symbols) {\n const entry = data[symbol];\n if (entry?.values) {\n result[symbol] = parseValues(entry.values);\n } else {\n result[symbol] = null;\n console.error(\n `[${symbol} ${interval}] no data:`,\n entry?.message ?? entry ?? \"missing from response\",\n );\n }\n }\n }\n\n return result;\n}\n\n// ---------- telegram ----------\n\nasync function sendTelegramAlert(text: string) {\n const url = `https://api.telegram.org/bot${TELEGRAM_BOT_TOKEN}/sendMessage`;\n const res = await fetch(url, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: TELEGRAM_CHAT_ID,\n text,\n parse_mode: \"Markdown\",\n }),\n });\n if (!res.ok) console.error(\"Telegram send failed:\", await res.text());\n}\n\n// ---------- kv helpers ----------\n\nasync function getState(symbol: string, key: string): Promise {\n const row = await sqlite.execute(\n `SELECT value FROM sweep_macd_state WHERE symbol = ? AND key = ?`,\n [symbol, key],\n );\n return (row.rows[0]?.[0] as string) ?? null;\n}\n\nasync function setState(symbol: string, key: string, value: string) {\n await sqlite.execute(\n `INSERT INTO sweep_macd_state (symbol, key, value) VALUES (?, ?, ?)\n ON CONFLICT(symbol, key) DO UPDATE SET value = excluded.value`,\n [symbol, key, value],\n );\n}\n\n// ---------- main ----------\n\nexport default async function () {\n await ensureTable();\n\n const now = new Date();\n const currentHourKey = now.toISOString().slice(0, 13);\n const isNearTopOfHour = now.getUTCMinutes() < 5;\n\n // ---- one batched call for all symbols' 5m candles ----\n const m5Batch = await fetchBatchCandles(SYMBOLS, \"5min\", 100);\n\n // ---- one batched call for 1h candles, only near the top of the hour ----\n let h1Batch: Record = {};\n if (isNearTopOfHour) {\n h1Batch = await fetchBatchCandles(SYMBOLS, \"1h\", SWING_LOOKBACK + 5);\n }\n\n const summary: Record = {};\n\n for (const symbol of SYMBOLS) {\n // ---- 5m MACD ----\n const m5Candles = m5Batch[symbol];\n let m5Cross: \"up\" | \"down\" | null = null;\n if (m5Candles) {\n const closes = m5Candles.map((c) => c.close);\n const { macdLine, signalLine } = macd(closes);\n const n = closes.length;\n m5Cross = detectMacdCross(\n macdLine[n - 2],\n signalLine[n - 2],\n macdLine[n - 1],\n signalLine[n - 1],\n );\n }\n\n // ---- 1h liquidity sweep (cached outside the top-of-hour window) ----\n let activeSweep = await getState(symbol, \"active_sweep\");\n let activeSweepHour = await getState(symbol, \"active_sweep_hour\");\n\n const h1Candles = h1Batch[symbol];\n if (isNearTopOfHour && h1Candles) {\n const sweep = detectLiquiditySweep(h1Candles);\n if (sweep) {\n activeSweep = sweep;\n activeSweepHour = currentHourKey;\n await setState(symbol, \"active_sweep\", sweep);\n await setState(symbol, \"active_sweep_hour\", currentHourKey);\n }\n }\n\n const sweepValidThisHour = activeSweepHour === currentHourKey\n ? activeSweep\n : null;\n const impliedDir = sweepValidThisHour === \"buy_side\"\n ? \"down\"\n : sweepValidThisHour === \"sell_side\"\n ? \"up\"\n : null;\n\n summary[symbol] = { m5Cross, sweepValidThisHour };\n\n // ---- confluence check ----\n if (m5Cross && impliedDir && m5Cross === impliedDir) {\n const alertKey = `${symbol}:${m5Cross}:${currentHourKey}`;\n const alreadySent = await getState(symbol, \"last_alert_key\");\n if (alreadySent !== alertKey) {\n const emoji = m5Cross === \"up\" ? \"🟢\" : \"🔴\";\n const dir = m5Cross === \"up\" ? \"BULLISH\" : \"BEARISH\";\n const sweepLabel = sweepValidThisHour === \"buy_side\"\n ? \"Buy-side liquidity swept\"\n : \"Sell-side liquidity swept\";\n await sendTelegramAlert(\n `${emoji} *SWEEP + MACD CONFLUENCE — ${dir}*\\n` +\n `${symbol}\\n` +\n `1H: ${sweepLabel} this hour\\n` +\n `5M: MACD crossed ${m5Cross}\\n` +\n `Time: ${now.toISOString()}`,\n );\n await setState(symbol, \"last_alert_key\", alertKey);\n }\n }\n }\n\n return { checked: SYMBOLS.length, time: now.toISOString(), summary };\n}","deleted","label",[60],{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":79,"_17":31,"_71":72,"_73":74,"_75":50,"_76":-5,"_80":81,"_18":82},["D",1787725178632],"children",[],[60],"1bf4005e-5307-42e9-ac07-9813282fa3d8",["D",1787725178632],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","84194e8d-7d79-4039-9c35-8beb9b55c1d3","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_126":122},"org",{"_11":12,"_119":120,"_121":122,"_89":90,"_123":124,"_125":50},"branch",{"_17":67,"_13":16,"_35":65,"_41":83,"_44":36,"_45":115,"_116":52,"_117":42,"_118":55,"_56":14,"_53":12},13,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","jayabulan70","avatar","https://lh3.googleusercontent.com/a/ACg8ocIJdGgPLI9cxQZhRQBzVCI9N8rwVan_Z3y42MiQy-ocz58CcQ=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":83,"_13":14,"_37":165,"_48":-5,"_85":50,"_51":52,"_86":52,"_87":19,"_88":-5,"_89":90,"_91":-5,"_92":50,"_93":-5,"_94":-5,"_95":31,"_54":55,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":166,"_111":167,"_113":168,"_49":50},[162],"files",[162],"counts",{"_152":31,"_153":67,"_154":31,"_34":155,"_156":157},[150],"upstreamProject",{"_35":42,"_13":57,"_87":19,"_88":-5,"_51":52,"_109":149},"upstreamBranch",{"_35":36,"_37":147,"_39":148,"_13":16,"_41":42,"_17":43,"_44":-5,"_45":-5,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":12,"_54":55,"_56":57},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1787283613474],["D",1787788088151],{"_11":12,"_126":122},{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":70,"_17":31,"_71":72,"_73":74,"_75":50,"_76":-5,"_18":151},[60],"pulls","branches","forks",{"_158":160,"_161":31},"connections",{"_158":31,"_159":31},"count","unfilledCount",3,"emptyCount",{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":79,"_17":31,"_71":72,"_73":74,"_75":50,"_76":-5,"_80":163,"_18":164},[],[60],["D",1787725178632],{"_11":12,"_126":122},{"_11":12,"_119":120,"_121":122,"_89":90,"_123":124,"_125":50},{"_17":67,"_13":16,"_35":65,"_41":83,"_44":36,"_45":115,"_116":52,"_117":42,"_118":55,"_56":14,"_53":12},"ctx",{"_109":-5,"_144":202,"_203":204,"_205":206,"_207":50,"_208":50,"_209":50,"_210":69,"_211":-5,"_212":-7,"_213":-7,"_214":31,"_215":50,"_216":50,"_217":-5,"_218":50,"_219":50,"_220":50,"_221":-5},"ENV",{"_173":174,"_175":176,"_177":16,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

Code