Automatic MOS Calculator Watchlist for Microsoft Excel --- *Temporarily Offline*

[jcase4]

Check out the Excel web query feature: http://office.microsoft.com/en-us/ex...CH062528421033

I believe that is what the MOS spreadsheet uses.

[doriancollier]

I haven't been having any issues, however, I can't find any currernt instructions, descriptions, or screen shots.

[SeanieT]

I think the spreadsheet is great but I do have a few questions. Like for example. In the Spreadsheet, we get a Minumum Equity Growth rate from the past 10 years and then take the minumum out of Minumum (Equity) Growth rate and the Rate given to us by the experts on the Earnings Est page. I read in Phil's book that the Rule number one growth rate found by taking Equity Gr Rate which is derived from the Equity at the 10 year Mark RATE(9,,Intial*-1,Current). So then the Default PE is calculated by multiplying that by 2. Am I wrong? Please correct me on this issue.

[dennis]

is there anyone still using version 3.03b-beta 1/20/2007? i was using it until a week ago and it stopped working. can't find the thread this was tied to

[SeanieT]

Maybe you should try to download it again. Sometimes we change the formulas a bit to make things not work. Just a suggestion. It has happend to me.

[Chevy-SS]

Originally Posted by SeanieT

Wow, You see and I thought I was crazy. So, If I install this plugin, it will give me the oppurtunity to use this function that allows me to create a cell that pulls down information form the MSN site?

If you add the plug-in, then all you have to do is change the name of the stock (ticker symbol) on the "Main" page in cell D1, and everything will fill in automatically. Some stocks, perhaps because of limited info on MSN, do not fill in all the blanks. But overall, this is a beautiful spreadsheet.

There is a column for an alternate "Scenario #2" MOS. Perhaps someone could explain using that?

-

[docdestructo62]

If you would rather look at MOS with a different P/E or go with the analyst's numbers instead of with the lowest equity growth rate, etc. (or if you would rather go with the 9 year equity growth to figure out your rule #1 growth rate instead of using the lowest number from the 9 year, 5 year, 3 year, or TTM), you can plug in a different number or two in the salmon colored cells near the top right-hand corner and compare the two versions of MOS. This is an awesome feature, btw!

[lifetimelearner]

I can open this document with my mac (OS 10.4.9) with office '04, but i can't get it to pull the numbers from the internet. Any suggestions? Thanks

[Chevy-SS]

Originally Posted by lifetimelearner

I can open this document with my mac (OS 10.4.9) with office '04, but i can't get it to pull the numbers from the internet. Any suggestions? Thanks

Two suggestions:

1) "Enable" macros in Excel

2) Make sure you have the plug-in


I don't know of anything else...............

-

[txavi8or]

Questions for all you vetereans. The MOS calculator is working fine except for refreshing. How do we get the spreadsheet to refresh the numbers when we want a new look at the save company. I have all my watchlist saved to seperate files but if I try to refresh them nothing happens.

Thanks in advance.

Jim

PS What happened to the "Watchlist" tab from the example page?