hallo community,

i´m new in using wld 5. so i like the CAN SLIM scan from william o´neil´s book "how to make money in stocks".

CAN SlIM is a Stock Scanner that uses fundamental data for looking a stock thats can be skyrocket in the next few months.

so i wanna build the first can slim screener in wealth lab. please help me!

i saw that we can use fundamental data from msn, so i think it no problem.

1. First we need the S ov Canslim

S =

S is for Supply and Demand. When a company with low number of shares outstanding starts to get noticed, it requires less buying power than a large cap to start to skyrocket. O'Neil therefore prefers companies with less than 25 Millions shares outstanding. This basically means small/mid cap unless you buy companies at 1,000$/share. If, you're like most people, buying shares between 10$ and 100$, that means market cap between 250 Millions and 2.5 Billions.

In addition, always make sure liquidity is adequate not to lose everything to high Bid-Ask spread.

Earning per Share EPS Rank: the C and A of CANSLIM
O'Neil found that most successful stocks had Earning Growth Acceleration before their most impressive price increase.

The Earning Per Share Rank (EPS Rank) measures a company's EPS Growth relative to the entire market. An EPS Rank of 80 means that a company has an EPS growth better than 80% of all other companies. The ranking usually takes into account growth over the last 5 years and last few quarters with higher weights assigned to recent data.

Because of higher weights assigned to recent growth, it is a prime criterion for screening for Earning Growth Acceleration.

C means Current Quarterly Earnings and A means Annual Earnings. O'Neil wants 20% annual growth over the last 5 years and recent acceleration in the quarterly growth. Using EPS Rank>80, you will likely meet the C and A criteria.

Note: not many stock screeners provide the EPS Rank. You may build a series of Growth tests to approximate.


Relative Strength Rank: the L of CANSLIM

Relative Strength Rank measures a stock's price performance relative to the entire market over a period (e.g. 1 month, 3 months, 1 year). A Relative Strength of 70 means that a stock has outperformed 70% of all other stocks during the period under consideration.

L is for Leaders: 0'Neil wants companies that have a leadership in their industry. A 12 months Relative Strength >80 ensures you're buying leading companies, not laggards.

a man from msn stock screener deluxe uses this criterium for can slim:

http://www.mechanical-investing.com/canslim.html


can we use this as a wealth lab "extensions" to implement the fundamental data in weatlh lab to scan for these stocks?

greetings from germany.

simbald

I'm afraid that MSN doesn't supply enough fundamental items for you to succeed with this. Although there are EPS and shares outstanding, their data is missing institutional ownership, annual earnings and trailing earnings growth rate.

and what is with yahoo, or google:

we need are:

shares aoustanding, annual earnings, growth rate.

--> owner ship is not so important.

There are no Yahoo! or Google fundamental providers because these vendors only supply the last item but not the entire historical data series i.e. impractical for backtesting fundamental ideas.

Here's the list of items possible to have from Yahoo!: Stock quote and chart from Yahoo in C#. As far as I understand, shares outstanding is the different name for "float" which we have already have in Community.Components: see GetFloat. As to the other two, I'm having trouble finding them in the list above.

We can get most of CANSLIM with Fidelity-provided fundamentals except for I = Institional Sponsorship, or, N = New products, New Management... but we could look for N = New Highs. How about a CAnSLM screener?

and how we can create a can slim screener with use the date wie have ahte the moment?

i mean wie take the date from msn?

its that possible?

While it probably won't help simbald, I would love to see a CAnSLM Fidelity data screener.

so have someone an idea to coda a wealth lab "extension" to import fundamental data
and the code a screener for the data?

possible?


who-one would help me?

The data we have at the moment is not completely suitable for your task. Unless you have a good pointer to a source of free online fundamental data (or at least snapshot values for the missing links i.e. the A and I), the resulting CnSLM script will have limited value.

why limited value?

Because it's an approximation i.e. partial implementation?