Login
Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
jimthomas@yahoo.com  
#1 Posted : Friday, November 23, 2007 8:09:10 AM(UTC)
jimthomas@yahoo.com

Rank: Advanced Member

Posts: 105

The stock Screener has two fields labeled "Hist 5-Year Sales Growth %" and "Hist 5-Year EPS Growth %".  However, both of these fields actually screen for growth over a four year time period.

Seems wrong to me.  If someone puts "15" in one of these fields, presumably they mean to screen for companies which have doubled (sales or EPS) over the past five years, but that's not what they'll get.  This same problem was reported years ago about Stock Prospector and, as I recall, there was agreement that it was an error.

The Screener's growth rate calculation also seems to have a problem.  If I screen for Sales Growth of exactly 15% (put "15" for both Min and Max) I get two companies.  DOM with a 15% *four* year growth rate (see Toolkit's Historical Growth Rate Change Graph) but also SNMB.  According to Toolkit, SNMB doesn't have 15% historical Sales growth (or anything close to it) no matter what the historical time period.

-Jim Thomas

Wanna join the discussion?! Login to your forum account. New Registrations are disabled.

jncraig  
#2 Posted : Friday, November 23, 2007 3:16:59 PM(UTC)
jncraig

Rank: Advanced Member

Posts: 561

Thanks for the comment and the (seeming) bug report, Jim. I do recall the discussion from a year or more ago. I agree that you need 5 yearly data points that follow the starting point to have a 5-year calculation.
Joe
daf323  
#3 Posted : Monday, November 26, 2007 6:54:24 AM(UTC)
daf323

Rank: Advanced Member

Posts: 126

Thanks Jim, we have a bug filed now and are investigating, i'll post here when it is corrected.
jimthomas@yahoo.com  
#4 Posted : Saturday, May 31, 2008 8:49:22 AM(UTC)
jimthomas@yahoo.com

Rank: Advanced Member

Posts: 105

Any progress on this?  The Screener is still screening based on 4-year growth rates (five data points) but the User Guide for the screener very explicitly says screening is based on 5-year growth rates (six data points).  The User Guide describes what the Screener *should* be doing ... not what it's *actually* doing.

"5 yr Sales Growth: The annualized growth rate over the past five years of Sales. This figure is derived by the least squares method, using six data points: a base year plus 5 subsequent annual data points."

Screening for Sales Growth today, with Min=15 and Max=15 shows three stocks: BLG, PONE and SNMB.

According to Toolkit, BLD does have 15% sales growth over the past FOUR years.  Over the past FIVE years the sales growth was 19.4%.

PONE has only three years of annual data, so the most it has is a two year growth rate.  It doesn't have a four or five year growth rate at all!

SNMB data shows *zero* sales for 2003 and 2004, so I don't know how the Screener is calculating any growth rate at all that includes that time period.

-Jim Thomas

jimthomas@yahoo.com  
#5 Posted : Saturday, May 31, 2008 8:58:31 AM(UTC)
jimthomas@yahoo.com

Rank: Advanced Member

Posts: 105

I see that the "mouse over" comment for "Hist Sales Growth % - 5 Years" does accurately describe what the Screener is attempting to do ... even though that is the wrong thing to do.

-Jim Thomas

Users browsing this topic
Guest (2)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.049 seconds.