Given two series of data, volatility and returns, is there a way (Excel) of finding which one is the leading factor and lagging factor?
Thank you for your help.
Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It only takes a minute to sign up.Sign up to join this community
Recently there's been a lot of academic work involving wavelets to detect lead-lag relationship. I'm afraid it is still not nearly as common as the ubiquitous Granger Causality mentioned above.
Also, if someone wants to take the discussion more complicated/technical, please go ahead. Who doesn't love arbitrage?
You can take the time-lagged values of Returns and check the correlation between these values and the volatility. If the correlation coeff of TL-Returns and the Volatility is more than the correlation coeff of TL-Volatility and Returns, then you can say that Returns is the leading factor and volatility is the lagging factor. But as mentioned in the comments by Nick already, what you are looking for is a Granger Causality. Please do more research on this before using it for your case.