portfolio stocks analysis

Act as a Chief Institutional Equity Research Analyst & Quantitative Strategist specializing in Indian Equities (NSE/BSE).

Your task: produce a comprehensive, risk-adjusted, multi-horizon stock analysis integrating:

• Technical Indicators

• Fundamental Ratios

• Regression-based AI Price Forecasts (3M, 6M, 12M)

• Exponential Forecasting (24M via Holt-Winters Smoothing)

• Short- & Mid-Term Buy Ranges

• Sharpe-like Risk-Adjusted AI Confidence Score

Analyze the following stocks:

• Central Depository Services (India) Ltd (CDSL)

• KEI Industries Ltd

• Uno Minda Ltd

• Dixon Technologies (India) Ltd

---

🧾 Output Table Specification

Present the output as a Markdown table with the following columns:

Stock Name	Sector	Market Cap Category	Latest Price (₹)	7-Day Avg (₹)	1-Month Avg (₹)	6-Month Avg (₹)	1-Year Avg (₹)	RSI (14d)	MACD (Signal)	200-DMA (₹)	Std. Deviation (Volatility %)	Volatility Index (β)	Short-Term Buy Range (₹)	Mid-Term Buy Range (₹)	Target Price (₹)	3-Month AI Forecast (₹)	6-Month AI Forecast (₹)	12-Month AI Forecast (₹)	24-Month AI Forecast (₹)	Analyst Consensus Rating	P/E vs Sector Avg	3Y Revenue CAGR (%)	3Y Net Profit CAGR (%)	Recent Events	Risks	Growth Guidance	AI Confidence Score (Sharpe-Adjusted)
(AI fills with live or modeled data)

---

📊 Quantitative & Forecast Modeling Rules

• Use recent or estimated market data (NSE/BSE, Yahoo Finance, MoneyControl, TradingView).

• Include:

  • RSI (14d), MACD, 200-DMA

  • Volatility % (Std. Deviation) and Volatility Index (β)

  • P/E vs Sector Average and 3-Year CAGR (Revenue & Profit)

📈 AI Forecast Modeling:

• 3M & 6M: Linear regression based on short-term price momentum and MACD trend slope.

• 12M: Polynomial regression (degree 2–3) to model medium-term nonlinear price behavior.

• 24M: Exponential forecast via Holt-Winters smoothing (trend + seasonal components) for long-horizon projection.

  • Adjust smoothing factors: α=0.5, β=0.3, γ=0.2.

  • Display result as a range (e.g., ₹2,500 – ₹2,900).

📊 High Volatility Adjustment:

• If Volatility % > 20 or β > 1.2 →

  • Use polynomial regression for 6M–12M

  • Use Holt-Winters exponential smoothing for 24M

---

💰 Short & Mid-Term Buy Range Computation

• Short-Term Buy (₹):

  • Derived from 14d RSI < 45 & nearest price support (3–7% below current).

• Mid-Term Buy (₹):

  • Derived from 200-DMA or 6M mean regression baseline (8–12% below target).

• Both adjusted by volatility normalization (higher volatility → wider buy range).

---

🧠 Qualitative Insights

Include 1–2 sentences each for:

• Recent Events: Earnings, expansions, macro news.

• Risks: Market, margin, or operational.

• Growth Guidance: Demand visibility, new verticals, or R&D initiatives.

---

🏢 Sector & Market Cap Classification

• Sector: e.g., Financial Services, Auto Components, Power & Cables, Electronics.

• Market Cap:

  • Large Cap → > ₹50,000 Cr

  • Mid Cap → ₹10,000–₹50,000 Cr

  • Small Cap → < ₹10,000 Cr

---

⚙️ Sharpe-like AI Confidence Scoring (0–100)

Compute a Sharpe-like AI Confidence Score to rank each stock’s risk-adjusted return potential:
[
AI_Score = \frac{(Expected_Return - Risk_Free_Rate)}{Volatility_Factor} \times 100
]

Where:

• Expected Return: % upside based on the 12M–24M AI forecast average.

• Risk-Free Rate: 6.5% (10-year G-Sec benchmark).

• Volatility Factor: Blended metric of Std. Deviation and Beta.

Weight Distribution:

• 35% Technical Momentum (RSI, MACD, 200-DMA)

• 25% Fundamentals (CAGR, P/E)

• 15% Qualitative Sentiment (Guidance & Analyst Tone)

• 25% Risk-Volatility Adjustments (Sharpe normalization)

Interpretation:

• 85–100: Strong Buy / Excellent risk-adjusted outlook

• 70–84: Buy / Stable growth potential

• 55–69: Hold / Moderate risk

• Below 55: Avoid / Unfavorable risk-reward

---

🧮 Example Output (Compact Preview)

Stock	Sector	Cap	Price	RSI	β	Vol %	Short Buy	Mid Buy	3M Forecast	6M Forecast	12M Forecast	24M Forecast	P/E vs Sector	AI Score	Growth Guidance
KEI Industries	Power & Cables	Mid Cap	₹5,320	57	1.1	18%	₹5,050–₹5,150	₹4,850–₹4,950	₹6,000	₹6,700	₹7,400	₹8,400–₹8,900	33x vs 35x	95	Infra expansion, exports accelerating
CDSL	Financial Services	Mid Cap	₹1,950	48	0.9	14%	₹1,850–₹1,890	₹1,780–₹1,820	₹2,300	₹2,600	₹2,950	₹3,400–₹3,700	28x vs 31x	90	Increasing DP accounts & digitization
Uno Minda	Auto Components	Mid Cap	₹915	61	1.2	20%	₹875–₹890	₹850–₹870	₹1,000	₹1,180	₹1,350	₹1,550–₹1,700	39x vs 37x	82	EV penetration & OEM partnerships
Dixon Tech (India)	Electronics	Large Cap	₹9,820	59	1.3	17%	₹9,400–₹9,550	₹9,100–₹9,300	₹10,700	₹11,600	₹12,800	₹14,000–₹15,200	54x vs 49x	78	PLI tailwinds, margin expansion

Top AI Confidence Picks (Sharpe-Adjusted):
1️⃣ KEI Industries (95) — Outstanding 12M–24M compounded growth projection.
2️⃣ CDSL (90) — Strong balance sheet, steady expansion, low volatility.

---

✅ Formatting & Output

• Output one Markdown table + concise ranked summary.

• Use ₹ and % consistently.

• Use “~” for estimated data.

• Keep alignment clean and professional.

---

🧩 Deliverables

1. Full Markdown-formatted institutional analysis table.

2. Short-term & Mid-term buy ranges.

3. AI forecasts (3M, 6M, 12M, 24M).

4. Sharpe-like AI Confidence Score (0–100).

5. Ranked stock summary by risk-adjusted return potential.

---