[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_182":183,"_184":185},"routes/_app.x.$handle.$name",{"_96":95,"_32":43,"_105":86,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":26,"_120":121,"_122":24,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_32":43,"_36":44,"_45":-5,"_46":26,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":26,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":26},"version",7,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":26},"previous","deleted",true,"deletedHere",false,"path","index.html","latestPath","fileId","11059bd2-7da6-11f1-bdff-1607ee4eb77e","name","fileType","content","\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","createdAt",["D",1783828762831],"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",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":53,"_101":102,"_103":26},"branch",{"_13":85,"_32":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"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",{"_41":42,"_32":43,"_36":177,"_45":-5,"_46":26,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":26,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":178,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":179,"_80":180,"_82":181,"_84":26},"tree",[164,165,166],"files",[164,165,166],"counts",{"_153":59,"_154":155,"_156":59,"_157":158,"_159":160},"contents",[127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":150,"_32":28,"_30":31,"_133":-5,"_39":40,"_38":14,"_135":26,"_36":151,"_13":59,"_33":20,"_34":35,"_23":26,"_139":-5,"_27":152},{"_41":141,"_32":142,"_30":143,"_133":-5,"_39":40,"_38":144,"_135":26,"_36":145,"_13":146,"_33":147,"_34":148,"_23":26,"_139":-5,"_27":149},{"_41":130,"_32":131,"_30":132,"_133":-5,"_39":40,"_38":134,"_135":26,"_36":136,"_13":59,"_33":137,"_34":138,"_23":26,"_139":-5,"_27":140},"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",[131],"9f7d9129-67e1-4353-8bce-d7d1976bcd9c","main.ts","0b44dcc2-7da5-11f1-946b-1607ee4eb77e",5,["D",1783828548888],4,"http","export default async function stockScreener(req: Request) {\n // Nifty 50 tickers (hardcoded for reliability — NSE doesn't offer a public CSV)\n const tickers = [\n \"RELIANCE\",\n \"TCS\",\n \"INFY\",\n \"HDFCBANK\",\n \"ITC\",\n \"SBIN\",\n \"AXISBANK\",\n \"BHARTIARTL\",\n \"LT\",\n \"ICICIBANK\",\n ];\n\n const outputData = [];\n\n // Fetch live prices from Yahoo Finance chart API for each stock\n for (const sym of tickers) {\n try {\n const yfUrl = `https://query1.finance.yahoo.com/v8/finance/chart/${sym}.NS?interval=1d&range=1d`;\n const yfRes = await fetch(yfUrl, {\n headers: { \"User-Agent\": \"Mozilla/5.0\" },\n });\n\n if (!yfRes.ok) {\n outputData.push({ ticker: sym, error: `Yahoo API returned ${yfRes.status}` });\n continue;\n }\n\n const stockJson = await yfRes.json();\n const meta = stockJson.chart.result[0].meta;\n const livePrice = meta.regularMarketPrice ?? 0;\n const prevClose = meta.chartPreviousClose ?? livePrice;\n const changePct = prevClose > 0\n ? (((livePrice - prevClose) / prevClose) * 100).toFixed(2)\n : \"0.00\";\n\n outputData.push({\n ticker: sym,\n price: livePrice,\n prevClose: prevClose,\n changePct: parseFloat(changePct),\n });\n } catch (err) {\n outputData.push({\n ticker: sym,\n error: err instanceof Error ? err.message : \"Unknown error\",\n });\n }\n }\n\n return new Response(JSON.stringify({ data: outputData }), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}\n",[142],"681b66d3-45ce-4873-874a-85abed0f7d39",["D",1783828762831],[28],"pulls","branches",1,"forks","envVars",{"_161":59,"_163":59},"connections",{"_161":59,"_162":59},"count","unfilledCount","emptyCount",{"_41":150,"_32":28,"_30":31,"_133":-5,"_39":40,"_38":14,"_135":26,"_36":174,"_13":59,"_33":20,"_34":35,"_23":26,"_139":-5,"_168":175,"_27":176},{"_41":141,"_32":142,"_30":143,"_133":-5,"_39":40,"_38":144,"_135":26,"_36":171,"_13":146,"_33":147,"_34":148,"_23":26,"_139":-5,"_168":172,"_27":173},{"_41":130,"_32":131,"_30":132,"_133":-5,"_39":40,"_38":134,"_135":26,"_36":167,"_13":59,"_33":137,"_34":138,"_23":26,"_139":-5,"_168":169,"_27":170},["D",1783828762830],"children",[],[131],["D",1783828548888],[],[142],["D",1783828762831],[],[28],["D",1783828323716],["D",1789439460012],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":53,"_101":102,"_103":26},{"_13":85,"_32":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"ctx",{"_78":-5,"_124":215,"_216":217,"_218":219,"_220":26,"_221":26,"_222":26,"_223":24,"_224":-5,"_225":-7,"_226":-7,"_227":59,"_228":26,"_229":26,"_230":-5,"_231":26,"_232":26,"_233":26,"_234":-5},"ENV",{"_186":187,"_188":189,"_190":86,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214},"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:

Diff · v7