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

[phideaux]

I simply imported my list from a prior incarnation of the spreadsheet, and it worked just fine.

phi

[jminderlein]

Hi, Great site! I'm new to the forum and just downloaded the MOS calculator, enabled macros and changed my setting to medium. I'm getting a red ''bad data'' in F1...I have a broadband connection. When I enter a stock symbol in B1 in the watch list tab it looks like it's trying to do something but it doesn't populate. Can anyone please direct me to a section of the forum that might address my problem.

Thanks!!!!!!

[jminderlein]

Please disregard my last post...I figured it out. Thanks!~

[Xyvern]

How do you import the data which contains the watch list from the previous version to the new one ?

[mgroeber]

To import you need to have both your old MOS calculator and the new MOS calculator auto_ msn303a you just downloaded open. On 303a click on cell A1on the watchlist tab.

[mgroeber]

Originally Posted by mgroeber

To import you need to have both your old MOS calculator and the new MOS calculator auto_ msn303a you just downloaded open. On 303a click on cell A1on the watchlist tab.

oops, I meant you need to click on the "Import Watch List" tab in A1

[chrisrah]

Hi Justin,

Thanks for the spreadsheet. This is great! I am getting this error when I type in a ticker symbol. It states: "ExecutionQueries Subroutine: Error 1004 was generated by MoS_Calculator Application-defined or object-defined error." Any ideas with this one? Thank!

[Justin]

Hrrm - I haven't seen that one before. Hopefully someone else here has and knows what would be causing it..

[Mike Campbell]

Justin

Thank you for the update, I am having some problems w/303a I load it start import from 303 to 303a runs blank, then I started update for all 114 tickers runs maybe half then rest blank,tried individual, runs blank,tried to reload several times came back with Error notes.

Critical Error

Unrecoverable error during query execution. Please save and reload spread sheet.

Error 600 was generated by MOS_calculation.Execute queries excel capability needed to continue to execute web queries in the current copy of the spread sheet is no longer responding

AND

Error not all queries completed successfully
( 1 Failures out of 1 queries considered retrying w/sheet upgrades query failed status was unable to attempt

Any help here would be great

Mike

[mikewu915]

Thank you guys, this is awesome.