Subject: Re: No rankings
I could, but it's a hassle and I'm lazy.
I get it : )
My spot check went like this:
I have all my files for a given year in a given directory exported as tab delimited .txt files.
I use Unix command "cut -f4,13,20,184-189 *.txt | grep MSFT"
4=ticker, 13=price, 20=P/E, 184-190 are total returns 1 week through 1 year with the little used YTD figure in the middle.
That gives me the stock price, P/E, and a bunch of total return fields for Apple, week by week.
Any file that gives blank total returns will jump out. Second most common is that multiple lookbacks on a given row have identical numbers, which is essentially impossible.
Microsoft is handy because when the prices are wrong, they are wrong by a mile, being two digits instead of three, and the P/E ratio falls to single digits.
There may be other fields which are garbage from time to time, of course. My list of bad weeks up thread shows the ones that (by the process above) are known bad...the rest might be good, or might have other types of errors that I haven't discovered.
I'm not actually using the data except for statistical analysis these days, having shut down my MI portfolio in March. I keep it up more just by habit, and because I paid for multiple years of subscription in advance. I'm a data pack rat.
Jim