Anyone got any excel or can come up with a macro(sorry I’m still learning though excel macro) about the historical volatility between S&P 500 and NIFTY 50 for the last 20 years. Then to calculate the ATR for 5 days, 1 month, 3 months, 1 year, 3 years, 5 years and so on on these two asset instrument.
Trying to figure out what should be a good time horizon for India Market now a days in my portfolio to make some money.
Thanks in advance if anyone got any suggestion or ideas…