HomeReady-2-GoPortfolioRankingScreenerStockETFToolsCommunityHelp
ForumsEmail UserPollsFeature RequestsGroups


  Index  | Recent Threads  | Who's Online  | User List  | Search
  Search  
Quick Go »
Thread Status: Normal
Total posts in this thread: 12
Posts: 12   Pages: 2   [ Previous Page | 1 2 ]
[Request a Feature] [Post new Thread]
[Add To My Favorites] [Watch this Thread]
Author
Previous Thread This topic has been viewed 1330 times and has 11 replies Next Thread
marco


UNITED STATES
Joined: Jan 1, 1970
Posts: 3980
Status: Offline

Re: Compare the Reuters data to the Compustat data with the same stocks in a Custom List Reply to this Post
Reply with Quote

Please see http://www.portfolio123.com/mvnforum/viewthread?thread=5377

Thanks
----------------------------------------
Portfolio123 Staff
[Jul 6, 2012 8:47:03 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
DennyHalwes
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 28, 2004
Posts: 1532
Status: Offline
sad   Re: Compare the Reuters data to the Compustat data with the same stocks in a Custom List Reply to this Post
Reply with Quote

All,

Marco is correct. I checked a dozen S&P 500 stocks and even IBM has zeros for open prices prior to 8/26/2004. P123’s workaround of filling in the zeros with the average of Hi & Low allows Sims that use Next Open to be run without “no data” prior to 8/26/2004. This does explain the differences in the above Sims since they are “Price Only” comparisons and do not have fundamental factors in either the ranking system or the buy / sell rules.

However, I (and we all) wish that they would have told us this a week ago so we would not have had the anxiety we have felt with the big differences in out tests. From what we have found to date (and now P123 has told us), I think that we can make reasonable comparisons only for large caps that have no zero volume days, and only for dates after 8/26/2004. After comparing my larger cap Sims for dates after 8/26/2004, I feel that my current real Ports will behave pretty much the same after the switch to Compustat as they did before.

But for me, I will wait until P123 has corrected the open price data before I try to develop any new Sims or ranking systems (the open price data effects ranking systems that use TA factors also).

Denny cool
----------------------------------------
"The significant problems we face cannot be solved at the same level of thinking that we were at when we created them". Albert Einstein
[Jul 6, 2012 10:36:21 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
Posts: 12   Pages: 2   [ Previous Page | 1 2 ]
[Show Thread Printable Version] [Post new Thread]

Free Trial  /  Log In
Username or Email
Password
Stay logged in
Can't remember username or password?