Portfolio123 - View Thread

Home Ready-2-Go Portfolio Ranking Screener Stock ETF Tools Community Help

Forums Email User Polls Feature Requests Groups

Index | Recent Threads | Who's Online | User List | Search

Portfolio123 » List all forums » Forum: Ranking Systems and Factors/Functions » Thread: Pr2SalesQ

Thread Status: Normal
Total posts in this thread: 11

[Request a Feature] [Post new Thread]
[Add To My Favorites] [Watch this Thread]

Author

This topic has been viewed 1535 times and has 10 replies

o806
Advanced Member

CANADA
Joined: May 8, 2006
Posts: 492
Status: Offline

Re: Pr2SalesQ

Reply to this Post
Reply with Quote

Macro said: Some stocks have a Pr2SalesQ = 0, which is totally meaningless. These get the highest rank since Pr2Sales ranks better lower and you end up with buckets with 1 or 2 stocks, which increases the chances of abnormal returns...

Marco,
Thank you for pointing out how to use the Eval solution to the Pr2Sales problem.
Is Pr2Sales the only factor that has this problem?
Or should we be using the Eval( x > 0, x, NA) for other factors to avoid problems?
If so, which factors need it.

[Mar 5, 2007 11:48:24 AM]

[Link]

[Show Thread Printable Version] [Post new Thread]

Free Trial / Log In