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

[Justin]

Originally Posted by mateescu

Hello

When I try to enter a new ticker in Excel, it gives me the result that you see in the attached screenshot:

Somehow only some of the data makes it to the Excel, i.e. the company description - but some of the numbers are not inserted into the cells, and for this reason the MOS price cannot be calculated.

That is a strange issue. Does it just happen on a few symbols? Does it happen every time with those symbols, and does it appear to happen with the exact same cells each time?

I can't say I've run into this myself, it seems that the queries are attempting to pull the data but something is interrupting that process. Do you have a stable connection?

Also noticed that you are using version 1.05, you might try updating to 1.06 which was released just last night.

In case you are still looking from the results from UNT, here is what I get on version 1.06, using office 2002 and windows xp service pack 2.

unt.GIF

Perhaps someone else here can offer more guidance on what may be causing your issue?

[pp4x4]

Originally Posted by Justin

The latest edition of our Automatic Margin of Safety Calculator can be downloaded from this location:
http://www.roicommunity.com/uploaded/mos_calc106.xls (Updated 6/26/2007)

Thanks for all of the suggestions and bug fixes folks!

Justin

Hi Justin,

Your tool is great and I appreciate the effort you have done. The question I have is in the Cash Flow tab. I quite often see highlighted row, but blank rows. I notice this quite often when I get negative numbers on the main page for MOS. i.e. - pvh

Thanks

Any thoughts?

[Doneal1]

Justin

I have used the older verion of the MOS calculator in the past and really found the "watchlist" portion of the spreadsheet useful. What format does everyone use now for their watchlist? Has anyone made a spreadsheet that can be linked to the latest MOS Calculator release?
Thanks for all your hard work.

DEO

[yougogirl]

Originally Posted by Justin

The latest edition of our Automatic Margin of Safety Calculator can be downloaded from this location:
http://www.roicommunity.com/uploaded/mos_calc106.xls (Updated 6/26/2007)

Thanks for all of the suggestions and bug fixes folks!

Justin

Justin,

I downloaded and have been using this version of the calculator. After entering the ticker symbol and pressing ENTER, several times I have gotten this message:

"This web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar."

What does this mean, and what do I do when this happens? I'm not very savvy with sophisticated Excel functions.

Thank you,

yougogirl

[nsxowner]

Well, I've never used a spreadsheet before but the automatic calculators look great. The problem may be that I am using a Mac. I am using a trial version of Office 2004 for Mac. I launch Excel and opened the calculators. As I said, they look great but when I try to input another stock symbol, nothing happens. So then I try to import data via web quiery and some data comes but overlays the spreadsheet.

Then I thought, maybe this doesn't work with the Mac version of Excel. Any hints or advise would be appreciated. Also any direction for us Mac users of other programs that would do the same.

Thanks

[capp53]

Originally Posted by yougogirl

Justin,

I downloaded and have been using this version of the calculator. After entering the ticker symbol and pressing ENTER, several times I have gotten this message:

"This web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar."

What does this mean, and what do I do when this happens? I'm not very savvy with sophisticated Excel functions.

Thank you,

yougogirl

I have the program on two separate computers and it was great on one but I was getting those same error messages on the other. So I knew it was in my computer. The one it didn't work on was running an older version of Firefox. I deleted and reinstalled using Internet Explorer and that solved the problem. Hope it helps!

[yougogirl]

Thanks for your suggestion. I'm not sure what Firefox is, but I don't think I run that on my computer.

yougogirl

[Money72]

Do you have any plans of updating the Margin of safety Calculator for MSN (Excel for Macintosh Based)?

[Justin]

Not at this time, however a solution for users who do not have Excel for Windows is in the works. Stay tuned!

[seabiscuit]

is there a calculator for an aaple mac book?...or could you explain how to run this thru parallels?