InvestorsHub Logo
Followers 2
Posts 1185
Boards Moderated 0
Alias Born 07/15/2014

Re: OldAIMGuy post# 38623

Thursday, 11/20/2014 1:10:50 AM

Thursday, November 20, 2014 1:10:50 AM

Post# of 47072
Hi Tom, I'm not sure how to do what you suggest.

You could add another column or so to come up with the cumulative effect of the volatility to see how often the fund achieves the initial trades and subsequent trades. This could also help document how often reversal trades are generated. It could also document if there are more reversal trades than a standard inexpensive index fund tracking the same index.

Any suggestions? Or am I just brain dead and can't see what is in front of me?

Another problem that someone may have a solution to is how to auto insert the last cell of the % calculation of changes into the Excel formula =STDEV(D4:Dlast cell). I've tried several approaches and none seem to work. They either just barf or they tell me there is a circular reference. Clues, anyone?

Thanks,

Allen

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.