Once again, it was some ETFs that have declined strongly showing major positive CAGR instead of a negative CAGR, while all other tickers showed the correct values.
There were three that had sorted to the top on that basis. When I brought up the Columns dialog, looked to see that the back data was long enough, made no changes, and then clicked OK all got recalculated, but only the first one got corrected. Then I did F5 and the other two I had noticed also got corrected.
I wish I knew what triggers the bad values, but I am very worried that I cannot trust what I see in MA -- in all cases, the value of the indicator on the chart is OK and most things in MA are OK. I guess that, for any I really care about, I just need to cross-check the MA values against the same indicator on a chart.
This unreliability of the values in MA is a pretty serious concern. I do not understand it, and therefore I do not know either how to prevent it or what (if anything) I am doing wrong. I find it alarming that F5 fixes it. I find it alarming that only a few values are wrong (and they all have one obvious thing in common -- they are all in a serious downtrend). If the only problem was that it was showing yesterday's values and had to be updated to show the latest bar I could understand -- but the wrong value is big-time wrong, not just off by a bar or two.
Frustrated,
EV

Comment