Home > Money > Question
Need Expert Advice?Our Gurus Can Help
Ramalingam

Ramalingam Kalirajan  |9412 Answers  |Ask -

Mutual Funds, Financial Planning Expert - Answered on Apr 05, 2024

Ramalingam Kalirajan has over 23 years of experience in mutual funds and financial planning.
He has an MBA in finance from the University of Madras and is a certified financial planner.
He is the director and chief financial planner at Holistic Investment, a Chennai-based firm that offers financial planning and wealth management advice.... more
Asked by Anonymous - Apr 05, 2024Hindi
Listen
Money

How to track a mutual fund by plotting its 6 month's SMA and 12 month's SMA based on its daily NAV? Where from can I get these parameters?

Ans: To track a mutual fund by plotting its 6-month SMA (Simple Moving Average) and 12-month SMA based on its daily NAV (Net Asset Value), you can follow these steps:

Collect Daily NAV Data: You need to collect daily NAV data of the mutual fund for the past 6 months or more. This data is typically available on the website of the mutual fund company, financial news websites, or financial data providers.

Calculate 6-Month and 12-Month SMA: Once you have the daily NAV data, calculate the 6-month and 12-month SMAs. To calculate the SMA, you need to sum up the NAV values for the respective periods (6 months or 12 months) and then divide by the number of days in the period.

Plot the Data: Use a spreadsheet software like Excel or Google Sheets to plot the NAV data along with the 6-month and 12-month SMAs on a line chart. This will help you visualize the trend of the mutual fund over time.

Analyze the Chart: Analyze the chart to understand the direction of the trend and any potential crossovers between the 6-month and 12-month SMAs. A crossover, where the shorter-term SMA crosses above or below the longer-term SMA, can indicate a change in trend.

Monitor Regularly: Update the NAV data regularly and recalculate the SMAs to keep track of the mutual fund's performance and trend over time.

As for where to get the NAV data and parameters, you can obtain them from various sources:

Mutual Fund Company Websites: Most mutual fund companies provide daily NAV data on their official websites.
Financial News Websites: Financial news websites often provide daily NAV data and other performance metrics for mutual funds.
Financial Data Providers: There are several financial data providers like Bloomberg, Morningstar, Yahoo Finance, etc., that offer comprehensive data on mutual funds, including NAV history and SMA calculations.
Trading Platforms: Some trading platforms and investment apps also provide NAV data and tools for technical analysis, including SMA plotting.
By following these steps and utilizing the available resources, you can track a mutual fund using its daily NAV and plot its 6-month and 12-month SMAs to analyze its performance and trend.
DISCLAIMER: The content of this post by the expert is the personal view of the rediffGURU. Users are advised to pursue the information provided by the rediffGURU only as a source of information to be as a point of reference and to rely on their own judgement when making a decision.
Money

You may like to see similar questions and answers below

Ramalingam

Ramalingam Kalirajan  |9412 Answers  |Ask -

Mutual Funds, Financial Planning Expert - Answered on Jun 04, 2024

Listen
Money
How to see old data of asset allocation of mutual fund . As where to see HDFC flexi cap % large cap, mid cap and small cap for say last 10yrs
Ans: Accessing Historical Asset Allocation Data of Mutual Funds
To view the historical asset allocation of mutual funds, such as the HDFC Flexi Cap Fund's percentage in large-cap, mid-cap, and small-cap over the last 10 years, follow these steps:

1. Mutual Fund Distributor (MFD)
Contact Your MFD:

Professional Guidance: Reach out to your Mutual Fund Distributor (MFD). They can provide detailed historical data and analysis.
Detailed Reports: MFDs have access to comprehensive tools and resources to generate historical asset allocation reports.
Personalized Assistance: MFDs can offer insights tailored to your investment needs.
2. Mutual Fund Websites
Visit the Fund House Website:

Fund Factsheets: Fund houses often publish monthly factsheets on their websites. These documents provide asset allocation details, though historical data might be limited.
Annual Reports: Check annual reports for detailed historical performance and asset allocation data.
3. Financial Websites and Portals
Use Financial Websites:

Morningstar: Morningstar offers detailed analysis, including historical asset allocation. Create an account and search for HDFC Flexi Cap Fund to access detailed reports.
Value Research Online: Value Research provides comprehensive mutual fund data, including historical asset allocation. Search for the specific fund and check the "Portfolio" or "Holdings" sections.
4. SEBI and AMFI Websites
Regulatory Websites:

SEBI: The Securities and Exchange Board of India (SEBI) regulates mutual funds and may have historical data.
AMFI: The Association of Mutual Funds in India (AMFI) provides information and links to fund house websites where you can find relevant data.
5. Direct Contact with Fund House
Contact HDFC Mutual Fund:

Customer Service: Reach out to HDFC Mutual Fund's customer service for historical data requests. They can provide detailed information or guide you to the relevant resources.
Email Requests: Send an email request for historical asset allocation data.
6. Investment Research Tools
Subscription-Based Services:

Bloomberg Terminal: Provides in-depth historical data and analysis, including asset allocation.
Reuters Eikon: Another professional tool offering detailed historical mutual fund data.
Steps to Request Data from MFD
Identify Your MFD: If you don't already have an MFD, choose one based on recommendations or online reviews.

Provide Fund Details: Share the specific mutual fund name and the type of historical data you need.

Request Reports: Ask your MFD to generate and share reports showing the historical asset allocation percentages.

Discuss Insights: Review the data with your MFD to understand trends and make informed investment decisions.

Conclusion
Historical asset allocation data is crucial for evaluating a mutual fund's consistency and strategy. Contacting your Mutual Fund Distributor (MFD) is the most reliable way to get detailed and accurate information. Utilize online resources and financial portals for additional insights.

Best Regards,

K. Ramalingam, MBA, CFP,

Chief Financial Planner,

www.holisticinvestment.in

..Read more

Ramalingam

Ramalingam Kalirajan  |9412 Answers  |Ask -

Mutual Funds, Financial Planning Expert - Answered on Nov 21, 2024

Asked by Anonymous - Nov 20, 2024Hindi
Money
Hello sir, Am doing sip following in following mutual funds and time horizon is 15 - 17 years. Please analyse. 1. Motilal Oswal midcap fund 2400/- 2. Quant smallcap fund 2400/- 3. Motilal Oswal microcap fund 3600/- 4. Parag parikh flexicap fund 2000/-
Ans: Investing with a 15–17 year horizon is a wise decision, as it allows compounding to work effectively. Let’s assess your portfolio with insights to optimise it further.

Portfolio Overview
You are investing Rs 10,400 monthly across four funds.
The portfolio includes mid-cap, small-cap, micro-cap, and flexi-cap categories.
These investments reflect a growth-oriented strategy.
A well-diversified portfolio can potentially meet your long-term financial goals.
Key Strengths of Your Portfolio
1. Diversification Across Market Caps
Exposure to mid-cap, small-cap, and micro-cap ensures high growth potential.
The flexi-cap fund adds stability by diversifying across all market caps.
2. Long Investment Horizon
A 15–17 year horizon allows you to absorb market volatility.
It enables compounding to enhance your returns over time.
3. Growth-Focused Allocation
Small-cap and micro-cap funds can deliver substantial returns in the long run.
Mid-cap funds provide balanced growth and moderate risk.
Areas That May Need Attention
1. High Allocation to Smaller Market Caps
Nearly 80% of your portfolio is allocated to small, micro, and mid-cap funds.
This creates higher risk, as these funds can be volatile in the short to medium term.
2. Sectoral or Stock Concentration Risk
Some funds in your portfolio may have concentrated sectoral bets.
Over-concentration can increase risk during sector-specific downturns.
3. Flexi-Cap Allocation Is Low
Flexi-cap funds provide diversification and stability, especially during market corrections.
A low allocation to this category may reduce your portfolio’s balance.
4. Taxation Implications
Long-term capital gains above Rs 1.25 lakh are taxed at 12.5%.
A high-growth portfolio may result in significant taxable gains.
Recommendations for Portfolio Optimisation
1. Rebalance Market Cap Allocation
Increase exposure to large-cap or flexi-cap funds to stabilise your portfolio.
A balanced allocation reduces risk while retaining growth potential.
2. Limit Micro-Cap Allocation
Micro-cap funds carry significant risk and longer recovery periods.
Restrict micro-cap allocation to 10%-15% of your portfolio.
3. Increase Flexi-Cap Allocation
Flexi-cap funds provide adaptive strategies across market conditions.
Raise this allocation to 25%-30% of your portfolio for better risk management.
4. Review Sectoral Exposure
Check if any fund has high exposure to a single sector.
Diversify to avoid dependence on specific industries.
5. Continue Investing Regularly
SIPs are the best way to handle market volatility.
Continue disciplined investing, even during market corrections.
Tactical Steps for Long-Term Wealth Creation
1. Set a Clear Corpus Goal
Estimate the corpus needed for your post-retirement lifestyle.
Account for inflation and your expected life span.
2. Increase SIPs Over Time
Gradually increase your SIPs as your income grows.
This helps you build a larger corpus by leveraging the power of compounding.
3. Monitor Performance Periodically
Review your portfolio every six months to ensure alignment with your goals.
Retain funds that consistently outperform their benchmarks and peers.
4. Adopt a Debt Allocation Near Retirement
Begin shifting a portion of your portfolio to debt funds 5–7 years before retirement.
This safeguards your corpus against equity market volatility closer to your goal.
Addressing Direct Funds and Regular Plans
Benefits of Investing Through Regular Plans
Direct plans may lack professional guidance and personalised advice.
Regular plans offer curated fund selection based on your risk profile.
A Certified Financial Planner ensures better alignment with your financial goals.
Why Active Funds Outperform Index Funds
Active funds capture opportunities in undervalued sectors and stocks.
Index funds lack the flexibility to capitalise on market changes.
For long-term investors, active funds offer superior potential returns.
Tax Planning Insights
Equity gains above Rs 1.25 lakh annually are taxed at 12.5%.
Consider redeeming investments in phases to minimise tax liability.
Plan withdrawals strategically to manage tax efficiency during retirement.
Final Insights
Your portfolio is growth-focused and aligned with your long-term goals. However, reducing micro-cap exposure and increasing flexi-cap allocation will optimise it further. Regularly review and rebalance your portfolio to manage risk and maximise returns. Stay disciplined with SIPs and increase investments periodically for a larger retirement corpus.

A structured approach ensures you achieve financial independence post-retirement.

Best Regards,

K. Ramalingam, MBA, CFP

Chief Financial Planner

www.holisticinvestment.in
https://www.youtube.com/@HolisticInvestment

..Read more

Latest Questions
Dr Nagarajan J S K

Dr Nagarajan J S K   |1593 Answers  |Ask -

NEET, Medical, Pharmacy Careers - Answered on Jul 06, 2025

DISCLAIMER: The content of this post by the expert is the personal view of the rediffGURU. Investment in securities market are subject to market risks. Read all the related document carefully before investing. The securities quoted are for illustration only and are not recommendatory. Users are advised to pursue the information provided by the rediffGURU only as a source of information and as a point of reference and to rely on their own judgement when making a decision. RediffGURUS is an intermediary as per India's Information Technology Act.

Close  

You haven't logged in yet. To ask a question, Please Log in below
Login

A verification OTP will be sent to this
Mobile Number / Email

Enter OTP
A 6 digit code has been sent to

Resend OTP in120seconds

Dear User, You have not registered yet. Please register by filling the fields below to get expert answers from our Gurus
Sign up

By signing up, you agree to our
Terms & Conditions and Privacy Policy

Already have an account?

Enter OTP
A 6 digit code has been sent to Mobile

Resend OTP in120seconds

x