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

[rharmelink]

Originally Posted by jkruer01

Any suggestions for my problem? I am running XP with Office XP (2002) SP 3.

Sorry, but I don't really use the WatchList feature, just an infrequent single analysis, so I'm not up on problems that occur there.

[jkruer01]

Originally Posted by rharmelink

Sorry, but I don't really use the WatchList feature, just an infrequent single analysis, so I'm not up on problems that occur there.

What about this error from the Rule #1 tab:
Not all queries completed succesffully (7 failures out of 10 queries) - consider retrying

ExecuteQuerires subRoutine: Error 1004 was generated by MoS_Calculator Application-defined or object-defined error

Status for the attempted queries:
Key Ratios Inv Ret - Successful - Completed
Key Ratios Inv Ret - Successful - Completed
Price Ratios - Successful - Completed
FreeCash - Failed - Completed
Statements Ten Yr - Failed - Completed
Quote - Failed - Unable to Attempt
Quote - Failed - Unable to Attempt
Key Ratios 10yr(B) - Failed - Unable to Attempt
Signals - Failed - Unable to Attempt
Short Signals - Failed - Unable to Attempt

[rharmelink]

Originally Posted by jkruer01

What about this error from the Rule #1 tab:
Not all queries completed succesffully (7 failures out of 10 queries) - consider retrying

That's one reason I ended up writing my own add-in to interface with the Internet -- in the past, I've found Web Queries to be unreliable. They usually work well as a single entity, but there appear to be timing problems when you do a number of them. I didn't write the Watchlist version, so I'm not familiar with its coding.

[joeym4130]

I think someone said earlier that yahoo or whoever changed something on the site so the spreadsheet might not work.

Cause mine was working fine all along and now (Tonight) I can't connnect to retreive the data automatically, it gives me the 1004 error. Did yahoo always have that java chart? I never really use yahoo's but I just used the link from the spreadsheet

[jkruer01]

Originally Posted by rharmelink

That's one reason I ended up writing my own add-in to interface with the Internet -- in the past, I've found Web Queries to be unreliable. They usually work well as a single entity, but there appear to be timing problems when you do a number of them. I didn't write the Watchlist version, so I'm not familiar with its coding.

Do you mind sharing your work?

Could you post it here?

[rule1queen]

My spreadsheet is no longer working. I have been successfully updating it every day until now. Is this the Yahoo problem mentioned in a previous post?

[Nick]

I have the same problem and I'm not experienced with excel.
Anybody find a solution?

Thanks for your effort.

[jkruer01]

Somewhere I read that they were almost finished with a permanet solution to the problem with the webqueries. Does anyone know anything about this? Can anyone say approximately how long it will be until the new product is available?

Thanks!

P.S. I have a programming degree but have 0 experience with exel programming. Still willing to help in any way I can.

[cowensmi]

Mine went down too, same errors. One or more of the links for the web queries must have changed so when Excel goes to the site to get the data it isn't there.

Rats, I was right in the middle of some decisions when it went down. Any idea on when it might get fixed? I might have to do the anlysis the old fashioned way. Boy are we spoiled

[fth]

Justin,
I have downloaded the new version and I keep getting an error in updating the stocks in the watch list. Is is only me or are there any complaints of error in updating of info?

Felipe