Blog

We Clustered 200 ETFs on Nothing But Price History, and It Already Flagged Which International Funds Would Sit Out This Week's Rally

By @psanivarapu · 2026-10-09

We ran hierarchical clustering with no category labels across 2.75 years of daily returns for 200 ETFs with long NSE trading histories using insights from bhavcopydata.com. The algorithm cleanly separated a cluster of 21 gold and silver funds, isolated the one ETF this site already flagged for an unexplained 89.6% move, and split the site's own International category into at least three distinct groups. This week, the Motilal Oswal Nasdaq Q-50 ETF (MONQ50) rose 30.46%, the Mirae Asset S&P 500 Top 50 ETF (MASPTOP50) rose 13.36% and the Mirae Asset NYSE FANG+ ETF (MAFANG) rose 15.66%. Exactly the cluster the algorithm had already grouped together. While the two Hang Seng linked International funds rose only 1.27% and 3.71%. The correlation between MONQ50 and MASPTOP50 also reached its highest sustained level in the full 2.75 years of data, a finding we checked against a rank based correlation test before trusting it.

This Week on BhavCopyData, The Motilal Oswal Nasdaq Q-50 ETF Rallies 30% After Two Straight Weeks of Declines, A Steel Tube Maker Hits Its Upper Circuit Four Days Running, and the Week's Two Biggest Block Trades Are One Fund Crossing Itself (5 to 9 October 2026)

By @psanivarapu · 2026-10-09

Weekly NSE data wrap for 5 to 9 October 2026, a full five session week. The Motilal Oswal Nasdaq Q-50 ETF (MONQ50) rose 30.46% after two straight weeks of declines, as all three international ETFs on the site rallied together. Surani Steel Tubes Ltd. (SURANI) hit its upper price band four sessions running and gained 59.97% for the week, and the week's two largest block and bulk deals were both exact crossings between PI Opportunities AIF V LLP and Pioneer Investment Fund Scheme II, in ICICI Bank Ltd (ICICIBANK) and Kajaria Ceramics Ltd (KAJARIACER).

This Week in Futures and Options, Stock Futures Tilt More Bearish Than the Index Move Suggests, HDFC Bank Sees the Week's Heaviest Futures Turnover Unwind, and Bank Nifty's Put Call Ratio Climbs From 0.86 to 0.98 (5 to 9 October 2026)

By @psanivarapu · 2026-10-09

Weekly NSE F&O data wrap for 5 to 9 October 2026. Comparing open interest from Wednesday 1 October to the week's close, 259 stock futures landed in short buildup against 173 in long buildup, even as the Nifty 50 and the Bank Nifty both closed the week higher. HDFC Bank Limited (HDFCBANK) saw the week's heaviest single stock future turnover at INR 11,503.2 crores while open interest unwound 7.4%, and the Bank Nifty's October put call ratio by open interest climbed from 0.8646 to 0.9831 across the week.

This Week on BhavCopyData, The Motilal Oswal Nasdaq Q-50 ETF Falls Another 10% After Its Rally Unwind, A Penny Stock Triples On Turnover of Just INR 3,270, and Jupiter Capital Sells INR 829.7 Crores of AXISCADES Tech In One Block Trade (28 September to 1 October 2026)

By @psanivarapu · 2026-10-02

Weekly NSE data wrap for 28 September to 1 October 2026, a four session week with NSE closed on 2 October for Gandhi Jayanti. The Motilal Oswal Nasdaq Q-50 ETF (MONQ50) fell another 9.99% as its rally unwind continued. Party Cruisers Ltd (PARTY-RE) appeared to triple on turnover of just INR 3,270. Jupiter Capital Private Limited sold INR 829.7 crores of AXISCADES Tech Ltd (AXISCADES) in a single block trade, and Augment India I Holdings LLC exited INR 1,095.9 crores of Clean Max Enviro Energy Solutions Limited (CLEANMAX).

This Week in Futures and Options, September's Monthly Contracts Expire and October Inherits the Book, PB Fintech Falls Another 16% After Last Week's Plunge, and BSE Sees Matching Bearish Signals in Cash and Derivatives (28 September to 1 October 2026)

By @psanivarapu · 2026-10-02

Weekly NSE F&O data wrap for 28 September to 1 October 2026. September's monthly futures contracts expired on Tuesday 29 September, and the Nifty 50's October contract fell 3.15% while carrying almost all the week's open interest. PB Fintech Limited (POLICYBZR) fell a further 16.15% after last week's 33.7% plunge, and BSE Limited (BSE) was net sold in the cash market the same week its futures fell 4.00% on rising open interest.

State of the SME Segment, September 2026

By @psanivarapu · 2026-09-30

Monthly NSE SME data wrap for September 2026. Turnover rose 16.9% from August to INR 7,021.3 crores. Breadth stayed mildly negative, a stock split and a bonus issue both got excluded from the mover count, and a pair of circuit day runs produced the month's sharpest new 52 week highs.