When Joseph has a lump sum to invest and asks how to allocate it across his existing portfolio. This covers TWO sub-workflows:
1. MF evaluation โ selecting which mutual funds to invest in (see section below)
2. Stock capital deployment โ allocating lump sums across individual stock positions
Also distinct from:
indian-stock-analysis) โ evaluating a single stock's fundamentalsportfolio-analysis) โ analyzing what you already ownWhen Joseph asks about evaluating or selecting mutual funds (not deploying lump sums into stocks), use this workflow. Reference: references/mf-evaluation.md for data sources and screening criteria.
1. Groww.in โ category comparison tables (AUM, returns, expense, ratings). URL: groww.in/mutual-funds/category/best-{category}-mutual-funds
2. INDmoney โ detailed fund pages (portfolio holdings, sector allocation, risk metrics, peer comparison). URL: indmoney.com/mutual-funds/{fund-slug}
3. Morningstar India โ analyst ratings, Sharpe/Sortino/drawdown. URL: morningstar.in/mutual-funds/{fund-id}
4. Value Research Online โ portfolio overlap, holdings. โ ๏ธ Cloudflare-blocked for bot access; use web_extract as fallback.
5. Screener.in โ check underlying stocks the fund holds (apply stock-level analysis on holdings)
Write research files to wiki/wealth/invest/mf/research/{fund-slug}.md with: basic info, performance table vs benchmark/category, risk metrics, portfolio holdings, sector allocation, overlap analysis, and verdict (DEEP DIVE / WATCH / PASS). Write comparison summary to wiki/wealth/invest/mf/research/{category}-mf-comparison.md.
Read these files from wiki/wealth/invest/:
| File | Purpose |
|---|---|
portfolio/tracking/holdings.csv |
Raw holdings (qty, cost price, asset class) |
portfolio/tracking/YYYY-MM-DD-portfolio.md |
Latest snapshot (values, P&L, allocation %) |
portfolio/analysis/YYYY-qN/report.md |
Quarterly analysis (tier classification, assessments) |
portfolio/analysis/YYYY-qN/forward-strategy.md |
Existing strategy (SIP allocation, trim/hold/add decisions) |
research/watchlist.md |
Active positions + watchlist + S-curve candidates |
research/growth-candidates.md |
Growth compounder screening results |
From the forward strategy and report, extract:
Underweight positions โ holdings that are small relative to their target allocation:For each stock receiving allocation, run a quick technical check using TradingView:
URL pattern:https://www.tradingview.com/symbols/NSE-{TICKER}/technicals/
Extract from the page:
wiki/wealth/invest/research/frameworks/technical-indicators-reference.md):
| Technical State | Action |
|---|---|
| Price > 50 DMA > 200 DMA + MACD Buy | Deploy full amount โ trend confirmed |
| Price < 50 DMA but MACD Buy + RSI neutral | Deploy partial (50-60%), park rest for dip |
| Price < 50 DMA < 200 DMA + MACD Sell | Wait โ park in arbitrage/liquid, set price alert |
| Ex-dividend date within 1 week | Flag prominently โ buy before for dividend, or wait for post-ex-date dip |
Output format:
| Allocation | Amount | Rationale |
|-----------|--------|-----------|
| Stock A | โนXX,XXX | Why this amount (underweight, technical signal, etc.) |
| Stock B | โนXX,XXX | ... |
| Parking (arbitrage) | โนXX,XXX | Default for unallocated |
| Cash (wait) | โนXX,XXX | Why waiting (technical not ready) |
Include a "What NOT to do" section โ positions that should NOT receive new money (overallocated, pending trim, redundant funds).
If the technical check shows one or more target stocks are in bearish alignment:
1. Follow the existing strategy first โ the forward strategy was built with full context. Don't reinvent allocation from scratch.
2. Technical timing is secondary โ fundamentals determine WHAT to buy, technicals determine WHEN. Never skip a fundamentally sound position entirely because of technicals; defer it instead.
3. Underweight positions get priority โ new money should flow to positions that are small relative to their target, not to positions already at target.
4. Don't add to overallocated positions โ if a stock is flagged for trim, it should NOT receive new money.
5. Park unallocated capital โ money waiting for better entries should be in PP Arbitrage Fund (equity taxation, ~7-8% return) or Axis Liquid Fund, not idle in savings account.
6. Flag ex-dividend dates โ they affect entry timing. Buy before ex-date to capture dividend, or wait for post-ex-date dip.
7. Scale SIP proportionally โ if monthly SIP is โน1L and lump sum is โน2L, roughly double each bucket. Adjust based on technical signals.
When Joseph asks to design or review his overall portfolio architecture (not just deploy a lump sum), use this framework. Reference: wiki/wealth/invest/barbell-strategy.md for the current live strategy.
1. Arbitrage Fund โ Emergency fund (1 year) + deployment pool. Move liquid fund money here. Earns ~7-8% with equity taxation. When opportunities arise, sell from here and deploy.
2. Dividend Arm โ 5-7 high-yield stocks (Coal India, ONGC, Power Grid, etc.). Target: โน6L/year in dividends. Reinvest for 3-4 years, then use for retirement/expenses. Capital preservation is primary.
3. Growth Arm โ 5-7 mid/small cap stocks. High risk/high reward. Exit triggers: 30% drawdown, fundamental break, or management failure. "If they win, they win big. If they lose, it's ok."
4. Flexi Cap โ Primarily PPFAS Flexi Cap. Core stabilizer. Review annually โ switch if underperforming for 1+ year.
5. Gold/Silver โ Small hedge allocation (3-5%). Non-correlated to equity.
When building or reviewing the dividend arm, use this methodology:
screener.in/screens/2093/large-cap-high-dividend-yield (no login needed)etmoney.com/stocks/market-data/high-dividend-yield-stocks/36smallcase.com/lists/high-dividend-yield-stockstickertape.in/stocks/collections/highest-dividend-paying-stocks-in-nifty-50Target annual dividend รท average yield = capital needed
Before adding a new MF or stock, check for overlap with existing holdings:
1. Pull top 10 holdings of the new fund (INDmoney or Groww)
2. Pull top 10 holdings of existing funds (PPFAS Flexi Cap, etc.)
3. If 3+ stocks appear in both, flag overlap percentage
4. If overlap > 30%, the new fund is redundant โ skip it
1. Check if the MF holds stocks you already own directly
2. Example: PPFAS holds Coal India (4.91%) โ if you also hold Coal India directly, your effective exposure is higher than it looks
3. This is usually fine for dividend stocks (you want the exposure), but flag it
When evaluating individual stocks for the dividend arm, use this workflow:
Navigate to https://www.screener.in/company/{TICKER}/consolidated/ and extract via browser_console:
Key questions:
File: wiki/wealth/invest/research/tickers/{slug}/{slug}.md
Include: Summary table, business overview, quarterly results, annual P&L, balance sheet, cash flow, dividend analysis (with year-by-year payout table), pros, cons, and verdict.
Target annual dividend รท average yield = capital needed
1. Don't fight the chart โ if all technical indicators say "Sell", don't deploy just because the amount is burning a hole. Park and wait.
2. Ex-dividend dates matter โ ONGC ex-date Sep 4 means price drops by dividend amount on that date. Flag this, don't let the user miss it.
3. Coal India โน370 dip may not come โ the strategy may have a "buy below โน370" target, but if the stock has held โน390-400 support, adjust the target rather than waiting forever.
4. PPFAS Flexi Cap is already 58% of MF portfolio โ never recommend adding more. The forward strategy explicitly says "stop fresh SIPs."
5. ICICI Direct MFs are for car EMI winding down โ don't recommend new investment into those funds.
6. Boys' education is already funded โ PP Flexi Cap has โน12L each, university costs ~โน6L. No additional allocation needed.
7. TradingView daily timeframe โ for investment timing (not trading), always use the "1 day" tab. Intraday signals are noise.
8. Two of three confirming = signal โ don't require all 3 (DMA + MACD + volume) to deploy. But if ZERO are confirming, definitely wait.
9. Screener.in custom screens require login โ can't use for MF screening without auth. Use pre-built screens (no login) or Groww/INDmoney instead.
10. Value Research Cloudflare-blocked โ bot detection blocks browser access. Use web_extract as fallback, or rely on Groww/INDmoney for the same data.
11. Headline yield vs sustainable yield โ a stock showing 12.5% yield may only sustain 8-9% if payout normalizes. Always calculate sustainable yield using median payout ratio, not the current year's headline number.
12. Subsidiary overlap โ Hindustan Zinc is a Vedanta subsidiary. Owning both doubles promoter risk. Check corporate family tree before adding "diversified" positions.
13. PSU NBFC cash flow is negative by design โ don't judge REC/PFC/IRFC by CFO like a manufacturing company. Lending companies disburse more than they collect in growth years. Judge by ROE consistency and NPA trends instead.
14. User prefers to think through strategy collaboratively โ don't just present recommendations. Ask "what do you think?" and let them shape the approach. They want to own the decisions, not receive a fait accompli.