[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_195":196,"_197":198},"routes/_app.x.$handle.$name",{"_97":96,"_32":44,"_106":87,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":26,"_121":122,"_123":24,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":26,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":26},"version",9,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":26},"previous","deleted",true,"deletedHere",false,"path","daily.ts","latestPath","fileId","1a12ee14-7da6-11f1-adb2-1607ee4eb77e","name","fileType","interval","content","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","createdAt",["D",1783828777976],"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",1789439460012],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":26},"branch",{"_13":86,"_32":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"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",{"_42":43,"_32":44,"_37":190,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":26,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":191,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":192,"_81":193,"_83":194,"_85":26},"tree",[173,174,175,176],"files",[173,174,175,176],"counts",{"_162":60,"_163":164,"_165":60,"_166":167,"_168":169},"contents",[128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":159,"_32":28,"_30":31,"_135":-5,"_40":41,"_39":14,"_137":26,"_37":160,"_13":60,"_33":34,"_35":36,"_23":26,"_141":-5,"_27":161},{"_42":152,"_32":153,"_30":154,"_135":-5,"_40":41,"_39":155,"_137":26,"_37":156,"_13":60,"_33":20,"_35":157,"_23":26,"_141":-5,"_27":158},{"_42":143,"_32":144,"_30":145,"_135":-5,"_40":41,"_39":146,"_137":26,"_37":147,"_13":148,"_33":149,"_35":150,"_23":26,"_141":-5,"_27":151},{"_42":132,"_32":133,"_30":134,"_135":-5,"_40":41,"_39":136,"_137":26,"_37":138,"_13":60,"_33":139,"_35":140,"_23":26,"_141":-5,"_27":142},"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",[133],"445c074d-0ee6-4617-81ce-286511e5c6a8","main.ts","0b44dcc2-7da5-11f1-946b-1607ee4eb77e",8,["D",1783828777974],5,"http","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",[144],"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",[153],"02fbb7a7-bd53-43f7-8709-cf570997d4fa",["D",1783828777976],[28],"pulls","branches",1,"forks","envVars",{"_170":60,"_172":60},"connections",{"_170":60,"_171":60},"count","unfilledCount","emptyCount",{"_42":159,"_32":28,"_30":31,"_135":-5,"_40":41,"_39":14,"_137":26,"_37":187,"_13":60,"_33":34,"_35":36,"_23":26,"_141":-5,"_178":188,"_27":189},{"_42":152,"_32":153,"_30":154,"_135":-5,"_40":41,"_39":155,"_137":26,"_37":184,"_13":60,"_33":20,"_35":157,"_23":26,"_141":-5,"_178":185,"_27":186},{"_42":143,"_32":144,"_30":145,"_135":-5,"_40":41,"_39":146,"_137":26,"_37":181,"_13":148,"_33":149,"_35":150,"_23":26,"_141":-5,"_178":182,"_27":183},{"_42":132,"_32":133,"_30":134,"_135":-5,"_40":41,"_39":136,"_137":26,"_37":177,"_13":60,"_33":139,"_35":140,"_23":26,"_141":-5,"_178":179,"_27":180},["D",1783828762830],"children",[],[133],["D",1783828777974],[],[144],["D",1783828762831],[],[153],["D",1783828777976],[],[28],["D",1783828323716],["D",1789439460012],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":26},{"_13":86,"_32":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"ctx",{"_79":-5,"_125":228,"_229":230,"_231":232,"_233":26,"_234":26,"_235":26,"_236":24,"_237":-5,"_238":-7,"_239":-7,"_240":60,"_241":26,"_242":26,"_243":-5,"_244":26,"_245":26,"_246":26,"_247":-5},"ENV",{"_199":200,"_201":202,"_203":87,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227},"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"]

📊 Daily Nifty 50 Stock Screen

✅ Passed

❌ Failed

📈 Nifty 50 Stock Screener

Price History:

Diff · v9