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

[man1]

I am also not able to use the spreadsheet since last few days. The error message is "Not all queries completed successfully (10 failres out of 10 queries) - consider retrying".

Tried downloading fresh copy of the add-in as well as the spreadsheet. But did not work. Manual "data refresh" of web queires in individual data tab fetches no data. Please help ! This is a really wonderful tool and I am feeling completely powerless after it has stopped working.

[chrisrah]

I too will be excited to see this up and running again! Great program. Chris

[Justin]

Hi everyone,

First and foremost - yes the spreadsheet is down, and yes we are aware of it. Nearly 100% of the errors mentioned in the previous posts are directly or indirectly caused by something beyond our control. We can't prevent it, but we can compensate for it by paying constant attention to the spreadsheet and making the necessary adjustments as often as required.

Those who have followed the evolution of the MOS Calculator for any length of time have no doubt noticed the countless features and additions to the spreadsheet. We've come a LONG way from the beginning! Heck one of these day's I'll post some pictures of the earlier days of the calculator just for laughs :) Most, if not all of these have been incredibly useful to many of us here in the community.

The problem is many of these additional features require the spreadsheet to use complex calculations which are based on the results of another complex calculation, and so on and so forth. This requires absolute perfect harmony with the data site it is attempting to extract the data from. If MSN Money changes the layout of any one of their pages even the slightest bit it wreaks havoc on the spreadsheet and nearly all of its calculations.

The last handful of releases to the spreadsheet were actually little more than adjustments to reflect the latest changes to the data site. Some are major, and some are minor. But they all have one thing in common: they take massive amounts of time to complete. To top it off, lately MSN Money has been making changes every week or two, and in some cases every few days.

Our volunteers have spent unfathomable amounts of time in trying to keep the spreadsheet up to date. Each has generously volunteered countless hours of personal time to keep this thing "running" as often as possible. Unfortunately, maintaining the spreadsheet has become a part time job at the very least. It has become increasingly difficult to reach the select few who actually understand the spreadsheet enough to work on it, and I simply can not place any further burden on these volunteers by asking them to continue making these nearly constant updates.

We’ve gotten TONS of positive feedback on the spreadsheet, both for its concept and its execution. I know it has saved me hundreds if not thousands of hours by letting me mow through entire stacks of symbols in no time at all. I am confident I am not alone in this regard. While I in no means advocate the use of any single source for data, I believe this has got to be one of the best preliminary research and analysis tools I have ever come across, especially for Rule #1 Investing.

I want to help maintain the spreadsheet - but as I mentioned above, there have been nearly a dozen programmers who have had a hand in developing the calculator. During the excitement of watching all of these additional features get plugged into the spreadsheet, I lost sight of what was really important here: Speed, Simplicity and Standardization.

My solution is to completely rebuild the spreadsheet from the ground up. The tool is going to better resemble its earlier days of calculation, using formulas that I do understand. Once I've finished this initial rebuild, and considering the amount of time I already spend on here I should be able to release the necessary future updates almost immediately.

I do have a full time job operating a family business, and we are heading into our busiest time of the year. Please understand that a complete rebuild of the spreadsheet is going to be a massive undertaking for me. If I work on it nightly I should be able to have it within a week or two.

Thank you for your continued patience and support everyone, I promise to make it worth your while.



Sincerely,

Justin Brand

[jkruer01]

Justin, huge thanks to you and all the other programmers working on it. Unfortunately I just found this site within the past week when it wasn't working. However, I can see the huge benefit that it could provide!

In the mean time I downloaded the advfn version and it seems to be working fine for me. Of course it doesn't have the watchlist update feature but I can at least get the data that I need for each individual stock. Using this is still a whole lot faster than looking up the numbers individually.

Does advfn's site get changed less frequently than MSN's? If so has there been any thought to using it when the spreadsheet is rebuilt?

Thanks again!

[fth]

Justin,
We really appreciate what you are doing and have done for us. Your efforts and the efforts of others involved has made life so much easier for novice like myself. We are now able to concentrate more on studing the company than spending long hours gathering data, which in turn gives us an even better chance of successful investing. More power to you! I salute you all!

Felipe

[Justin]

We had tried that in the past but the general consensus seemed to be that most preferred to use MSN Money as the data site, and as rharmelink mentioned, the ADVFN spreadsheet also required a separate file to work properly, which went against the "simplicity" factor.

[jkruer01]

Originally Posted by Justin

We had tried that in the past but the general consensus seemed to be that most preferred to use MSN Money as the data site, and as rharmelink mentioned, the ADVFN spreadsheet also required a separate file to work properly, which went against the "simplicity" factor.

I wasn't talking about using the seperate file I was talking about using the webqueries to query data from advfn instead of MSN.

I haven't gotten into the backend so I don't know how difficult this would be to do.

However, if everyone prefers MSN to ADVFN then I guess it doesn't really matter. Keeping it with MSN will probably make it easier anyways.

Thanks.

[Beagle]

I appreciate your hard work, but I just downloaded the file and I am getting the same errors as before: Error 1004, Not all queries complete successfully.

Thanks.

[geedee01]

Hi Justin,

That is wonderful...
I greatly appreciate your hardwork in writing a new code for the spreadsheet.
I dont know how else I can say THANK YOU!

- Geedee

[jkruer01]

Originally Posted by Beagle

I appreciate your hard work, but I just downloaded the file and I am getting the same errors as before: Error 1004, Not all queries complete successfully.

Thanks.

READ what he typed!

He said it is broken.
He said he is going to rebuild it from scratch.
He said it is going to take several weeks.