[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_196":197,"_198":199},"routes/_app.x.$handle.$name",{"_99":98,"_33":46,"_108":89,"_28":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":27,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":27,"_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":27},"version",10,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","main.ts","latestPath","fileId","0b44dcc2-7da5-11f1-946b-1607ee4eb77e","name","fileType","http","content","import { runScreener, getHistory } from \"./screener.ts\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport default async function(req: Request) {\n const url = new URL(req.url);\n\n // CORS preflight\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n },\n });\n }\n\n // JSON API: run screener and return live results\n if (url.pathname === \"/api\") {\n const data = await runScreener();\n return new Response(JSON.stringify({ data }), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n }\n\n // JSON API: fetch historical screenings from SQLite\n if (url.pathname === \"/api/history\") {\n const ticker = url.searchParams.get(\"ticker\") || undefined;\n const limit = parseInt(url.searchParams.get(\"limit\") || \"30\", 10);\n const history = await getHistory(ticker, limit);\n return new Response(JSON.stringify({ history }), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n }\n\n // Serve the frontend dashboard\n if (url.pathname === \"/\" || url.pathname === \"/index.html\") {\n return await serveFile(req, \"index.html\");\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n","import { runScreener, getHistory } from \"./screener.ts\";\n\nconst HTML_URL = \"https://esm.town/v/omkar1/Screening_stock_For_me/index.html\";\n\nexport default async function(req: Request) {\n const url = new URL(req.url);\n\n // CORS preflight\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n },\n });\n }\n\n // JSON API: run screener and return live results\n if (url.pathname === \"/api\") {\n const data = await runScreener();\n return new Response(JSON.stringify({ data }), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n }\n\n // JSON API: fetch historical screenings from SQLite\n if (url.pathname === \"/api/history\") {\n const ticker = url.searchParams.get(\"ticker\") || undefined;\n const limit = parseInt(url.searchParams.get(\"limit\") || \"30\", 10);\n const history = await getHistory(ticker, limit);\n return new Response(JSON.stringify({ history }), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n }\n\n // Serve the frontend dashboard\n if (url.pathname === \"/\" || url.pathname === \"/index.html\") {\n const htmlRes = await fetch(HTML_URL);\n const html = await htmlRes.text();\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n","createdAt",["D",1783828818638],"branchVersion","branchId","d0e29f34-615f-4c7e-a540-a3b45f95f221","id","5aa12893-4076-416f-86ab-eaf32cf428ce","Screening_stock_For_me",["D",1783828323716],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","My code","imageUrl","b5fbbab0-f5d2-4f9c-9958-689d3b8c7e63","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f546e-8b4e-7169-a75f-2eb4fc366a6d","tursoName","5aa128934076416f86abeaf32cf428ce","tursoHostname","5aa128934076416f86abeaf32cf428ce-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":56,"_104":105,"_106":27},"branch",{"_13":88,"_33":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","omkar1","handle","displayName","Omkar","avatar","https://lh3.googleusercontent.com/a/ACg8ocK_6NRQpyqMa9O2QJsLmecmENFldi1h5pGFQ24V_0iCNSrrOw=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_33":46,"_39":191,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":27,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":192,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":193,"_83":194,"_85":195,"_87":27},"tree",[174,175,176,177],"files",[174,175,176,177],"counts",{"_163":62,"_164":165,"_166":62,"_167":168,"_169":170},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":155,"_33":156,"_31":157,"_137":-5,"_42":43,"_41":158,"_139":27,"_39":159,"_13":62,"_34":160,"_36":161,"_24":27,"_143":-5,"_28":162},{"_44":148,"_33":149,"_31":150,"_137":-5,"_42":43,"_41":151,"_139":27,"_39":152,"_13":62,"_34":20,"_36":153,"_24":27,"_143":-5,"_28":154},{"_44":145,"_33":29,"_31":32,"_137":-5,"_42":43,"_41":14,"_139":27,"_39":146,"_13":138,"_34":35,"_36":38,"_24":27,"_143":-5,"_28":147},{"_44":134,"_33":135,"_31":136,"_137":-5,"_42":43,"_41":138,"_139":27,"_39":140,"_13":62,"_34":141,"_36":142,"_24":27,"_143":-5,"_28":144},"1e91c087-4c23-4ccc-9660-d0ad709e1520","screener.ts","10ff73c4-7da6-11f1-b0da-1607ee4eb77e","parentId",6,"latest",["D",1783828762830],"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Nifty 50 tickers (subset — add more from the full 50 as desired)\nconst NIFTY_TICKERS = [\n \"RELIANCE\",\n \"TCS\",\n \"INFY\",\n \"HDFCBANK\",\n \"ITC\",\n \"SBIN\",\n \"AXISBANK\",\n \"BHARTIARTL\",\n \"LT\",\n \"ICICIBANK\",\n];\n\n// ── Screening criteria ──────────────────────────────────────────\nconst MIN_ROE = 15; // Return on equity %\nconst MAX_DEBT_TO_EQUITY = 0.5;\nconst MIN_PROFIT_MARGIN = 10; // Net profit margin %\n\nexport interface StockResult {\n ticker: string;\n price: number;\n prevClose: number;\n changePct: number;\n roe: number | null;\n debtToEquity: number | null;\n profitMargin: number | null;\n passed: boolean;\n failReasons: string[];\n}\n\nexport async function initDB() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS screenings (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n run_at TEXT NOT NULL,\n ticker TEXT NOT NULL,\n price REAL,\n prev_close REAL,\n change_pct REAL,\n roe REAL,\n debt_to_equity REAL,\n profit_margin REAL,\n passed INTEGER NOT NULL\n )`,\n );\n}\n\nasync function fetchPrice(sym: string) {\n const url = `https://query1.finance.yahoo.com/v8/finance/chart/${sym}.NS?interval=1d&range=1d`;\n const res = await fetch(url, { headers: { \"User-Agent\": \"Mozilla/5.0\" } });\n if (!res.ok) throw new Error(`Chart API ${res.status}`);\n const json = await res.json();\n const meta = json.chart.result[0].meta;\n const price = meta.regularMarketPrice ?? 0;\n const prevClose = meta.chartPreviousClose ?? price;\n const changePct = prevClose > 0 ? ((price - prevClose) / prevClose) * 100 : 0;\n return { price, prevClose, changePct };\n}\n\nasync function fetchFundamentals(sym: string) {\n try {\n const url = `https://query2.finance.yahoo.com/v10/finance/quoteSummary/${sym}.NS?modules=financialData`;\n const res = await fetch(url, { headers: { \"User-Agent\": \"Mozilla/5.0\" } });\n if (!res.ok) return { roe: null, debtToEquity: null, profitMargin: null };\n const json = await res.json();\n const fin = json.quoteSummary.result[0].financialData;\n return {\n roe: fin.returnOnEquity?.raw != null ? fin.returnOnEquity.raw * 100 : null,\n debtToEquity: fin.debtToEquity?.raw != null ? fin.debtToEquity.raw / 100 : null,\n profitMargin: fin.profitMargins?.raw != null ? fin.profitMargins.raw * 100 : null,\n };\n } catch {\n return { roe: null, debtToEquity: null, profitMargin: null };\n }\n}\n\nexport async function runScreener(): Promise {\n await initDB();\n const results: StockResult[] = [];\n const now = new Date().toISOString();\n\n for (const sym of NIFTY_TICKERS) {\n try {\n const { price, prevClose, changePct } = await fetchPrice(sym);\n const { roe, debtToEquity, profitMargin } = await fetchFundamentals(sym);\n\n const failReasons: string[] = [];\n if (roe !== null && roe < MIN_ROE) failReasons.push(`Low ROE (${roe.toFixed(1)}%)`);\n if (debtToEquity !== null && debtToEquity > MAX_DEBT_TO_EQUITY)\n failReasons.push(`High D/E (${debtToEquity.toFixed(2)})`);\n if (profitMargin !== null && profitMargin < MIN_PROFIT_MARGIN)\n failReasons.push(`Low margin (${profitMargin.toFixed(1)}%)`);\n\n const passed = failReasons.length === 0;\n\n results.push({\n ticker: sym, price, prevClose, changePct,\n roe, debtToEquity, profitMargin, passed, failReasons,\n });\n\n // Persist to SQLite\n await sqlite.execute({\n sql: `INSERT INTO screenings\n (run_at, ticker, price, prev_close, change_pct, roe, debt_to_equity, profit_margin, passed)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [now, sym, price, prevClose, changePct, roe, debtToEquity, profitMargin, passed ? 1 : 0],\n });\n } catch (err) {\n results.push({\n ticker: sym, price: 0, prevClose: 0, changePct: 0,\n roe: null, debtToEquity: null, profitMargin: null,\n passed: false, failReasons: [err instanceof Error ? err.message : \"Unknown error\"],\n });\n }\n }\n\n return results;\n}\n\nexport async function getHistory(ticker?: string, limit = 30) {\n await initDB();\n if (ticker) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM screenings WHERE ticker = ? ORDER BY run_at DESC LIMIT ?\",\n args: [ticker, limit],\n });\n return result.rows;\n }\n const result = await sqlite.execute({\n sql: \"SELECT * FROM screenings ORDER BY run_at DESC LIMIT ?\",\n args: [limit],\n });\n return result.rows;\n}\n","label",[135],"b45f8765-6537-4778-85c1-d3e5f3cce125",["D",1783828818638],[29],"681b66d3-45ce-4873-874a-85abed0f7d39","index.html","11059bd2-7da6-11f1-bdff-1607ee4eb77e",7,["D",1783828762831],"\n\n\n \n \n Nifty 50 Stock Screener\n \n\n\n

📈 Nifty 50 Stock Screener

Live prices from Yahoo Finance · Fundamentals screening (ROE > 15%, D/E < 0.5, Margin > 10%)

\n\n

\n \n \n \n

\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Ticker	Price (₹)	Change %	ROE %	D/E	Margin %	Result	Notes
Click Refresh to load data

\n\n \n\n \n\n\n",[149],"02fbb7a7-bd53-43f7-8709-cf570997d4fa","daily.ts","1a12ee14-7da6-11f1-adb2-1607ee4eb77e",9,["D",1783828777976],"interval","import { runScreener } from \"./screener.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nexport default async function(interval: Interval) {\n console.log(\"Running daily stock screen at\", new Date().toISOString());\n\n const results = await runScreener();\n\n const passed = results.filter(r => r.passed);\n const failed = results.filter(r => !r.passed);\n\n // Build a readable email summary\n const lines = [\n `📊 Daily Nifty 50 Stock Screen — ${new Date().toLocaleDateString(\"en-IN\", { weekday: \"long\", year: \"numeric\", month: \"long\", day: \"numeric\" })}`,\n \"\",\n `✅ ${passed.length} passed screening | ❌ ${failed.length} failed`,\n \"\",\n \"── PASSED ──\",\n ...passed.map(r =>\n `${r.ticker}: ₹${r.price.toFixed(2)} (${r.changePct >= 0 ? \"+\" : \"\"}${r.changePct.toFixed(2)}%)` +\n (r.roe != null ? ` | ROE ${r.roe.toFixed(1)}%` : \"\") +\n (r.debtToEquity != null ? ` | D/E ${r.debtToEquity.toFixed(2)}` : \"\") +\n (r.profitMargin != null ? ` | Margin ${r.profitMargin.toFixed(1)}%` : \"\")\n ),\n \"\",\n \"── FAILED ──\",\n ...failed.map(r =>\n `${r.ticker}: ${r.failReasons.join(\", \") || \"Data unavailable\"}`\n ),\n ];\n\n const textBody = lines.join(\"\\n\");\n\n // Also build a simple HTML version\n const htmlBody = `\n

📊 Daily Nifty 50 Stock Screen

${passed.length} passed · ${failed.length} failed

✅ Passed

${r.ticker} — ₹${r.price.toFixed(2)} (${r.changePct >= 0 ? \"+\" : \"\"}${r.changePct.toFixed(2)}%)

❌ Failed

${r.ticker} — ${r.failReasons.join(\", \") || \"Data unavailable\"}

Run at ${new Date().toISOString()}

\n `;\n\n await email({\n subject: `📊 Daily Stock Screen: ${passed.length} passed, ${failed.length} failed`,\n text: textBody,\n html: htmlBody,\n });\n\n console.log(`Daily screen complete. Email sent. ${passed.length} passed, ${failed.length} failed.`);\n}\n",[156],"pulls","branches",1,"forks","envVars",{"_171":62,"_173":62},"connections",{"_171":62,"_172":62},"count","unfilledCount","emptyCount",{"_44":155,"_33":156,"_31":157,"_137":-5,"_42":43,"_41":158,"_139":27,"_39":188,"_13":62,"_34":160,"_36":161,"_24":27,"_143":-5,"_179":189,"_28":190},{"_44":148,"_33":149,"_31":150,"_137":-5,"_42":43,"_41":151,"_139":27,"_39":185,"_13":62,"_34":20,"_36":153,"_24":27,"_143":-5,"_179":186,"_28":187},{"_44":145,"_33":29,"_31":32,"_137":-5,"_42":43,"_41":14,"_139":27,"_39":182,"_13":138,"_34":35,"_36":38,"_24":27,"_143":-5,"_179":183,"_28":184},{"_44":134,"_33":135,"_31":136,"_137":-5,"_42":43,"_41":138,"_139":27,"_39":178,"_13":62,"_34":141,"_36":142,"_24":27,"_143":-5,"_179":180,"_28":181},["D",1783828762830],"children",[],[135],["D",1783828818638],[],[29],["D",1783828762831],[],[149],["D",1783828777976],[],[156],["D",1783828323716],["D",1789526460011],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":56,"_104":105,"_106":27},{"_13":88,"_33":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"ctx",{"_81":-5,"_127":229,"_230":231,"_232":233,"_234":27,"_235":27,"_236":27,"_237":25,"_238":-5,"_239":-7,"_240":-7,"_241":62,"_242":27,"_243":27,"_244":-5,"_245":27,"_246":27,"_247":27,"_248":-5},"ENV",{"_200":201,"_202":203,"_204":89,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228},"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"]

📈 Nifty 50 Stock Screener

Price History:

📊 Daily Nifty 50 Stock Screen

✅ Passed

❌ Failed

Diff · v10