get_sector_fpi_investment

io.github.aatharva16/dalalos · Verify this server

Fortnightly FPI net investment and assets under custody by sector, from NSDL's Fortnightly Sector-wise FPI Investment data. Covers every FPI across BOTH depositories (NSDL and CDSL), 2012 onward -- the current sector-level FPI source; get_sector_fii_flow's CDSL feed stopped publishing after March 2025. Scope-keyed alongside its siblings: get_market_fii_dii_flow is market-wide DAILY cash flow; get_sector_fii_flow / get_stock_fii_flow are DAILY CDSL-only transaction flow; get_shareholding is per-company QUARTERLY holding %. This is FORTNIGHTLY, per NSDL sector. `from_date`/`to_date` are optional ISO dates matched to each fortnight's period_end (default trailing ~6 months; capped at 5 years unless `sector` is given); `sector` narrows to one NSDL label (case-insensitive; 'Grand Total' is NSDL's all-sector row); `instrument` picks one column (default equity; also debt_general, debt_vrr, debt_far, hybrid, aif, total, mf_equity, mf_debt, mf_hybrid, mf_solution_oriented, mf_other); `include_subsectors` adds pre-2022 nested sub-sector rows, which are already included in their parent. Each row is `{period_start, period_end, taxonomy, sector, row_kind, parent_sector, instrument, net_inr_cr, net_usd_mn, auc_inr_cr, auc_usd_mn}` as NSDL published it (INR crore / USD million; null = not published). Sector labels switch to BSE's Common Industry Classification from 2022-04-30 (`taxonomy` marks it) and are NSDL's own, not securities.sector. No computation beyond row selection.