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: 6
[Request a Feature] [Post new Thread]
[Add To My Favorites] [Watch this Thread]
Author
Previous Thread This topic has been viewed 434 times and has 5 replies Next Thread
hihint
Advanced Member


UNITED STATES
Joined: Feb 22, 2011
Posts: 20
Status: Offline

Ranks appear to be incorrect Reply to this Post
Reply with Quote

The rankings associated to my screener "Fundamental Rank Active" appear to be incorrect. According to my own calculation, PAAS, SVM, RIC should have lower ratings than BPI and CPLA, but currently the ranking system rate them higher. Please take a look. Thanks.
[Sep 26, 2011 11:17:59 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


UNITED STATES
Joined: Jan 1, 1970
Posts: 4059
Status: Online

Re: Ranks appear to be incorrect Reply to this Post
Reply with Quote

Looks like you are using Industry ratios in your ranking system. PLease see my latest post regarding problems with industry ratios.
----------------------------------------
Portfolio123 Staff
[Sep 26, 2011 11:25:37 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


UNITED STATES
Joined: Jan 1, 1970
Posts: 4059
Status: Online

Re: Ranks appear to be incorrect Reply to this Post
Reply with Quote

Still investigating.
----------------------------------------
Portfolio123 Staff
[Sep 26, 2011 11:40:05 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
hihint
Advanced Member


UNITED STATES
Joined: Feb 22, 2011
Posts: 20
Status: Offline

Re: Ranks appear to be incorrect Reply to this Post
Reply with Quote

Thx marco.

Were you referring to "Pr2BookQInd are N/A for all stocks" as your "latest post regarding problems with industry ratios"? The N/A problem was already fixed and all the data appear to be correct. I downloaded the data (supposedly to be correct) and run the calculation on my own but my calculation gives different ratings... In another post I noticed that the ranking system was "rearchitectured". Maybe it introduced some sort of glitches...
[Sep 26, 2011 11:46:39 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


UNITED STATES
Joined: Jan 1, 1970
Posts: 4059
Status: Online

Re: Ranks appear to be incorrect Reply to this Post
Reply with Quote

In trying to recover from reuters dropping several ratios we introduced a problem in ranking factors using industry ratios. Please try it now.

Please note that we are still not happy with the current situation of industry ratios. At the moment some are still coming from reuters and others are being calculated by us as medians (our quick fix when we found out). But for the ones that are still coming from reuters, the industries we use are being mapped to industries in their new taxonomy (as I explained in another post) therefore there's a historical dis-continuity.

We need to completely replace the industry ratios with our own methodology which we have developed but not yet released. This will ensure historical continuity and consistency.

It's a painful but necessary step, but it is an improvement. Our methodology was developed by our in-house analysts and it's a combination of market cap weighted averages (with some trimming for outliers) when the industry is large enough, and medians when it's not.

We tried very hard to reproduce reuters industry ratios unsuccessfully. The logic that calculated reuters industry average is done by some old legacy system and nobody at reuters knows exactly what was being done (the developers of that logic are long gone).

Rest assured that our algorithm is perfectly reasonable and we will explain it in detail shortly. But it will produce somewhat different results depending on your usage.

Marco
----------------------------------------
Portfolio123 Staff
[Sep 26, 2011 1:57:35 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
hihint
Advanced Member


UNITED STATES
Joined: Feb 22, 2011
Posts: 20
Status: Offline

Re: Ranks appear to be incorrect Reply to this Post
Reply with Quote

Thanks a lot marco. Now I see it producing similar results with my own calculation.

Industry ratios are a crucial component in my strategy. Also I believe continuity and consistency are crucial to any investment strategies. Your effort trying to provide consistent industry ratios is highly appreciated. It's understandable that there might be differences here and there. But it shouldn't be a problem as long as it's coherent. I'm looking forward to the new in-house ratio engine. Hopefully I can see it soon.

Best
[Sep 26, 2011 2:25:26 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
[Show Thread Printable Version] [Post new Thread]

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