Discussion of Karel's MrMarket approximation

[Kraut55]

Hi Karel,
thank you for all the work you have done. Great job!
I am running into a problem however and I hope you might be able to help me, being from the Netherlands where you might also use the "," instead of the "."
When I import the csv-file from yahoo into my spreadsheet, all values between .01 and .12 are converted to months. 18.50 will be 18.50 but 18.09 will change to 18. September.
I can't even user-define the cells (00.00) because all I get instead of
18. September is then 37.882.
Any help you can offer?
Thanks.
Hans

edit: I just realized that also values like 9.20 are changed to Sep 20.

another edit: I think I found a solution. I temporarily change the country settings from the comma to a dot before I open Excel and enter all the data. However I found another problem. The top twenty ranks only go to stocks in the upper part of the alphabet (like A to C). That could be a coincidence, but highly doubtful.
What info would you need (screenshots etc.) to check where I make a mistake?

[Kraut55]

Problem solved. It was an Excel input error.

Regards,
Hans

[Karel]

Sorry! I missed your question. Nice to see you have found the solution yourself. What kind of input error was it? Should it be mentioned in the guidelines text?

Regards,

Karel

[Jason Monette]

I ran this today 11-11-03 and this is what came up with

in order of RSM

ASFI
RSTI
GMR
USNA
CCRT
CRDN
DECK
CMTL
TASR
SCHN

any one else get these same results?

[mrmarket]

Re: I ran this today 11-11-03 and this is what came up with

in order of RSM

ASFI
RSTI
GMR
USNA
CCRT
CRDN
DECK
CMTL
TASR
SCHN

any one else get these same results?

They all look very familiar...you must be on the right track!

[Jason Monette]

SWEET!

Now from here I take the top 3 and check out earnings, news, reports, etc? Then make a judgement call on which one I think is the best company?

[mrmarket]

SWEET!

Now from here I take the top 3 and check out earnings, news, reports, etc? Then make a judgement call on which one I think is the best company?

whatever works for you....

[Jason Monette]

I am trying to follow your model, after you get your top three stocks, what do you do next?

[Jason Monette]

Ok, I made one change to Screen 3, 7, 8.

In screen 3 I changed the EPS to the Annual rate instead of the Qrt to Qrt rate. I asked MM and this is the rate he uses.

In screen 7 I added Technicle Rank >= A

In Screen 8 I added Fund Rank >= A

I think should be very close to the model MM uses on his web site, I am also working on a spread sheet that automates most of this process for you. When I get it done I will post it here.

These are the top 10 stocks I got with the screens and Spread sheet in order of RSQ from highest to lowest. Let me know if i am getting close:

ASFI
RSTI
GMR
USNA
CRDN
MTLG
CMTL
TASR
SCHN
NTE

[mrmarket]

Ok, I made one change to Screen 3, 7, 8.

In screen 3 I changed the EPS to the Annual rate instead of the Qrt to Qrt rate. I asked MM and this is the rate he uses.

In screen 7 I added Technicle Rank >= A

In Screen 8 I added Fund Rank >= A

I think should be very close to the model MM uses on his web site, I am also working on a spread sheet that automates most of this process for you. When I get it done I will post it here.

These are the top 10 stocks I got with the screens and Spread sheet in order of RSQ from highest to lowest. Let me know if i am getting close:

ASFI
RSTI
GMR
USNA
CRDN
MTLG
CMTL
TASR
SCHN
NTE

I didn't run my model today but I believe most of those stocks were in my database, so it looks like you are close enough for horseshoes and hand grenades.

[Jason Monette]

Ok that is great, Now I just need to figure out which one is the best.

[JrInvestor]

Karel,

Thank you for taking the time to put together these screens. I am using Excel. When I run a screen, I do a 'save as' and change it from a CSV format to an Excel format. I save each individual screening and then import into the mimic spreadsheet. I am having a difficult time determing exactly which columns to delete. The column headings I get for each screen I save are:

Symbol, Company Name, Rank, Fundamental Grade, Last Price, 52-Week High, Rating, % Price Change Last Year, P/E Ratio: Current, Forward Year P/E, Rev Growth Year vs Year

Which of these columns do I need to import into the mimic spreadsheet?

Thanks

JR.

[Karel]

Which of these columns do I need to import into the mimic spreadsheet?

Actually, the columns you get vary with each screen. You keep the ticker column and the last four: % Price Change Last Year, P/E Ratio: Current, Forward Year P/E, and Rev Growth Year vs Year.

Regards,

Karel

[Max Kern]

Screen approximations

Karel,
First, thanks for the great job of setting up the screens and the explanation of use, great job!

Will you discuss your logic for how screens 1,7 & 8 are approximations of Mr Market's screens. They involve IBD's ratings for EPS & RS. Rest assured my motive is learning not diubting.

Thanks,
Max Kern

[Karel]

Hello Max,

I used Moneycentral's Stockscouter Fundamental Grade (earnings growth) as a proxy for IBD's EPS grade, and the Stockscouter Technical grade for IBD RS. I also used a filter on the Stockscouter rating, because I wasn't too sure about the validity of the proxies and I wanted to pick stocks that had a bit more going for them. You are free to change the screens to your liking, of course! They seem to be doing reasonably well as they stand, but you will always have to make your own decisions.

Regards,

Karel