Questions on Mr Market Stock Picking Model

[spider_pig]

I'm stuck on step no. 6. (i.e., ranking the stocks) with price appreciation. My 1st problem is that I need a clear definition. My thought is the % increase of the stock price over the past year. Where specifically can I get this data? I have MSN, Yahoo, IBD, etc. but I'm really not sure how to get this data.

Ideally, I'd like to export the symbols from Excel to a website and have it plug in the price appreciation & trailing p/e and then export back to Excel, but I can't even figure out how to find the price appreciation of a single stock!

Any assistance would be appreciated.

Spider Pig - the rookie

[billyjoe]

Spider,
You could go to bigcharts.marketwatch.com and look up any stock for any time period and figure it out. Good luck.

--------------billy

[mrmarket]

I'm stuck on step no. 6. (i.e., ranking the stocks) with price appreciation. My 1st problem is that I need a clear definition. My thought is the % increase of the stock price over the past year. Where specifically can I get this data? I have MSN, Yahoo, IBD, etc. but I'm really not sure how to get this data.

Ideally, I'd like to export the symbols from Excel to a website and have it plug in the price appreciation & trailing p/e and then export back to Excel, but I can't even figure out how to find the price appreciation of a single stock!

Any assistance would be appreciated.

Spider Pig - the rookie

Hey spidey,

Take the 52 month low, and take today's price...divide the difference in price by the 52 month low and you have the percent price appreciation.

Good luck!

[spider_pig]

Thank You Mr. Market!!!

[peanuts]

Spider Pig,
Spider Pig
got more money than an oil rig
stocks to cash
in a flash
makes bulls into corn beef hash
buys on a fly
then sells them high
financial planners just want to die
end of the day
he makes them pay
Mr. Market's forum he's gonna stay!

Watcha looking at Spider Pig? Give us a stock

[spider_pig]

Wow - I now have my own theme song! thank you

I'm not sure if you want to take advice from me, but I'm looking at (not buying just yet) --

CALM
OFI
SDA
GHM
PMFG
EBIX

[IIC]

Spider Pig,
Spider Pig
got more money than an oil rig
stocks to cash
in a flash
makes bulls into corn beef hash
buys on a fly
then sells them high
financial planners just want to die
end of the day
he makes them pay
Mr. Market's forum he's gonna stay!

Watcha looking at Spider Pig? Give us a stock

You got too much time on your hands...I guess being a World Traveler isn't all that interesting

[peanuts]

You got too much time on your hands...I guess being a World Traveler isn't all that interesting

Please Doug, how can I answer all of your posts with how busy and important I am? Can you limit yourself to just the things which matter.... sheesh!

Wow - I now have my own theme song! thank you

I'm not sure if you want to take advice from me, but I'm looking at (not buying just yet) --

CALM
OFI
SDA
GHM
PMFG
EBIX

Outstanding!!! Great charts on all of these. But which one will go 15% higher?

[hags]

Outstanding!!! Great charts on all of these. But which one will go 15% higher?

EBIX did +13% today.....some awesome charts spider pig....

hags

[spider_pig]

Thank you! I didn't invest in any of them. I'm going to wait 4-6 weeks (just like Mr. Mkt suggests) to see how they end up. I'll run the model again at that time, do my DD, and then I'm in. I'll post them.