[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_200":201,"_202":203},"routes/_app.x.$handle.$name",{"_97":96,"_32":43,"_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":47,"_121":122,"_123":25,"_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",{"_41":42,"_32":43,"_36":44,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":47,"_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":47},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",true,"deletedHere","path","README.md","latestPath","fileId","5232588e-7da6-11f1-bfd3-1607ee4eb77e","name","fileType","content","# 📈 Nifty 50 Stock Screener\n\nA live stock screening dashboard for Nifty 50 stocks, built on Val Town.\n\n## Features\n\n| Feature | Status |\n|---|---|\n| **Live prices** | ✅ Real-time data from Yahoo Finance Chart API |\n| **Fundamentals screening** | ⚠️ Requires free FMP API key (see below) |\n| **Frontend dashboard** | ✅ Dark-themed table with color-coded gains/losses |\n| **SQLite history** | ✅ Every screening is stored for trend tracking |\n| **Daily email alerts** | ✅ Cron job at 4 PM IST (weekdays) |\n\n## Live URLs\n\n- **Dashboard:** Visit the val's HTTP endpoint at `/`\n- **API (JSON):** `/api` — runs the screener and returns live results\n- **History (JSON):** `/api/history?ticker=RELIANCE` — returns past screenings from SQLite\n\n## Screening Criteria\n\nStocks must pass **all** of these to get a ✅ PASS:\n\n| Metric | Threshold |\n|---|---|\n| Return on Equity (ROE) | > 15% |\n| Debt-to-Equity | < 0.5 |\n| Net Profit Margin | > 10% |\n\nWhen fundamentals are unavailable (no FMP key + Yahoo v10 blocked), all stocks\npass by default since there's no data to fail them on.\n\n## Enabling Real Fundamentals\n\nYahoo Finance's fundamentals API requires cookie authentication and is blocked\nfrom server-side calls. To get real ROE, D/E, and margin data, use\n[Financial Modeling Prep](https://financialmodelingprep.com/) (free tier: 250\nrequests/day):\n\n1. Sign up at FMP and get your free API key\n2. Add it as an environment variable:\n\n👉 Add FMP_API_KEY here: https://www.val.town/x/omkar1/Screening_stock_For_me/environment-variables?key=FMP_API_KEY\n\nThe screener will automatically detect the key and use FMP for fundamentals.\n\n## File Structure\n\n```\nmain.ts HTTP endpoint — serves dashboard at /, API at /api, history at /api/history\nscreener.ts Shared logic — fetches prices + fundamentals, screens, saves to SQLite\ndaily.ts Interval (cron) — runs daily at 4 PM IST, emails results\nindex.html Frontend — dark-themed dashboard with live table + history viewer\n```\n\n## Tech Stack\n\n- **Runtime:** Deno (Val Town)\n- **Price data:** Yahoo Finance Chart API (`query1.finance.yahoo.com/v8`)\n- **Fundamentals:** Financial Modeling Prep API (optional) / Yahoo Finance v10 (fallback)\n- **Storage:** Val Town SQLite (`std/sqlite`)\n- **Email:** Val Town `std/email`\n- **Scheduling:** Val Town interval (cron: `30 10 * * 1-5`)\n\n## Adding More Stocks\n\nEdit `NIFTY_TICKERS` in `screener.ts` to add more symbols from the Nifty 50:\n\n```ts\nconst NIFTY_TICKERS = [\n \"RELIANCE\", \"TCS\", \"INFY\", // ...add more\n];\n```\n\n## Adjusting Screening Criteria\n\nEdit the constants in `screener.ts`:\n\n```ts\nconst MIN_ROE = 15; // Minimum return on equity %\nconst MAX_DEBT_TO_EQUITY = 0.5;\nconst MIN_PROFIT_MARGIN = 10; // Minimum net profit margin %\n```\n","createdAt",["D",1783829456399],"branchVersion","branchId","d0e29f34-615f-4c7e-a540-a3b45f95f221","id","5aa12893-4076-416f-86ab-eaf32cf428ce","Screening_stock_For_me",["D",1783828323716],"deletedAt","legacyEnvVars",false,"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",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":47},"branch",{"_13":86,"_32":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_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",{"_41":42,"_32":43,"_36":195,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":47,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":196,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":197,"_81":198,"_83":199,"_85":47},"tree",[178,179,180,181],"files",[178,179,180,181],"counts",{"_168":60,"_169":139,"_170":60,"_171":172,"_173":174},"contents",[128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":160,"_32":161,"_30":162,"_135":-5,"_39":40,"_38":163,"_137":47,"_36":164,"_13":60,"_33":165,"_34":166,"_24":47,"_142":-5,"_27":167},{"_41":153,"_32":154,"_30":155,"_135":-5,"_39":40,"_38":156,"_137":47,"_36":157,"_13":60,"_33":20,"_34":158,"_24":47,"_142":-5,"_27":159},{"_41":144,"_32":145,"_30":146,"_135":-5,"_39":40,"_38":147,"_137":47,"_36":148,"_13":149,"_33":150,"_34":151,"_24":47,"_142":-5,"_27":152},{"_41":132,"_32":133,"_30":134,"_135":-5,"_39":40,"_38":136,"_137":47,"_36":138,"_13":139,"_33":140,"_34":141,"_24":47,"_142":-5,"_27":143},"054e11bc-96bd-4ed0-ab88-5fe685f12604","screener.ts","10ff73c4-7da6-11f1-b0da-1607ee4eb77e","parentId",11,"latest",["D",1783828872165],1,"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 // 1. Try Financial Modeling Prep (requires FMP_API_KEY env var)\n // Free tier: 250 req/day — covers ~25 stocks easily\n const fmpKey = Deno.env.get(\"FMP_API_KEY\");\n if (fmpKey) {\n try {\n const url = `https://financialmodelingprep.com/api/v3/ratios/${sym}.NS?apikey=${fmpKey}`;\n const res = await fetch(url);\n if (res.ok) {\n const arr = await res.json();\n if (Array.isArray(arr) && arr.length > 0) {\n const r = arr[0];\n return {\n roe: r.returnOnEquity != null ? r.returnOnEquity * 100 : null,\n debtToEquity: r.debtEquityRatio != null ? r.debtEquityRatio : null,\n profitMargin: r.netProfitMargin != null ? r.netProfitMargin * 100 : null,\n };\n }\n }\n } catch {\n // FMP failed — fall through to Yahoo\n }\n }\n\n // 2. Try Yahoo Finance v10 (often blocked without cookies, but worth trying)\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],"b45f8765-6537-4778-85c1-d3e5f3cce125","main.ts","0b44dcc2-7da5-11f1-946b-1607ee4eb77e",10,["D",1783828818638],6,"http","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",[145],"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",[154],"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",[161],"pulls","branches","forks","envVars",{"_175":60,"_177":60},"connections",{"_175":60,"_176":60},"count","unfilledCount","emptyCount",{"_41":160,"_32":161,"_30":162,"_135":-5,"_39":40,"_38":163,"_137":47,"_36":192,"_13":60,"_33":165,"_34":166,"_24":47,"_142":-5,"_183":193,"_27":194},{"_41":153,"_32":154,"_30":155,"_135":-5,"_39":40,"_38":156,"_137":47,"_36":189,"_13":60,"_33":20,"_34":158,"_24":47,"_142":-5,"_183":190,"_27":191},{"_41":144,"_32":145,"_30":146,"_135":-5,"_39":40,"_38":147,"_137":47,"_36":186,"_13":149,"_33":150,"_34":151,"_24":47,"_142":-5,"_183":187,"_27":188},{"_41":132,"_32":133,"_30":134,"_135":-5,"_39":40,"_38":136,"_137":47,"_36":182,"_13":139,"_33":140,"_34":141,"_24":47,"_142":-5,"_183":184,"_27":185},["D",1783828872165],"children",[],[133],["D",1783828818638],[],[145],["D",1783828762831],[],[154],["D",1783828777976],[],[161],["D",1783828323716],["D",1789526460011],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":47},{"_13":86,"_32":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"ctx",{"_79":-5,"_125":233,"_234":235,"_236":237,"_238":47,"_239":47,"_240":47,"_241":25,"_242":-5,"_243":-7,"_244":-7,"_245":60,"_246":47,"_247":47,"_248":-5,"_249":47,"_250":47,"_251":47,"_252":-5},"ENV",{"_204":205,"_206":207,"_208":87,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232},"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 · v13