Ask a new question

PROBLEM WITH EXCEL STOCK QUOTE UPDATES -- THE QQQQ PRICING INFORMATION NO LONGER UPDATES, ALSO THE OPTOINS FOR THIS SYMBOL NO LONGER UPDATE

I HAVE MY STOCK PORTFOLIO ENTERED INTO EXCEL 2007 AND THIS USED TO WORK PERFECTLY.  THE QQQQ SYMBOL FOR THE TOP 100 STOCKS IN THE NASDAQ HAS JUST STOPPED UPDATING PRICING INFORMATION AS WELL AS FOR LONG TERM OPTIONS (CALLED LEAPS) STOPPED  SOMETIME EARLIER THIS YEAR.  WHEN I FIRST SET UP THE SHEET LAST YEAR IT WORKED PERFECTLY.  I LOST THE OPTION UPDATES EARLIER THIS YEAR AND NOW I HAVE LOST THE ABILITY TO UPDATE THE QQQQ STOCK ITSELF.  I CONTACTED MSN MONEY WHERE THE STOCK QUOTES ARE ORIGINATED AND THEY SAID THEY WOULD LOOK INTO IT MONTHS AGO BUT THE PROBLEM REMAINS AND I HAVE NEVER GOTTEN A SECOND RESPONSE.  REENTRYING THE SYMBOLS IS NOT WORKING.  HOW IS THIS PROBLEM REMEDIED?
I HAVE MY STOCK PORTFOLIO ENTERED INTO EXCEL 2007 AND THIS USED TO WORK PERFECTLY.  THE QQQQ SYMBOL FOR THE TOP 100 STOCKS IN THE NASDAQ HAS JUST STOPPED UPDATING PRICING INFORMATION AS WELL AS FOR LONG TERM OPTIONS (CALLED LEAPS) STOPPED  SOMETIME EARLIER THIS YEAR.  WHEN I FIRST SET UP THE SHEET LAST YEAR IT WORKED PERFECTLY.  I LOST THE OPTION UPDATES EARLIER THIS YEAR AND NOW I HAVE LOST THE ABILITY TO UPDATE THE QQQQ STOCK ITSELF.  I CONTACTED MSN MONEY WHERE THE STOCK QUOTES ARE ORIGINATED AND THEY SAID THEY WOULD LOOK INTO IT MONTHS AGO BUT THE PROBLEM REMAINS AND I HAVE NEVER GOTTEN A SECOND RESPONSE.  REENTRYING THE SYMBOLS IS NOT WORKING.  HOW IS THIS PROBLEM REMEDIED?
Try this. I have been using the plugin below for quite some time. Works great for me. It use Yahoo API and integrate it seamlessly with Excel as exposed custom functions. This is a good alternative to MSN plugin

http://www.technitya.com/content/stock-quotes-excel

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

CBOE doesn't want people to pay for the data if it's accesss via api. the third party api are just access the data viat html data mining not from api access to the server.  and is very slow.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Try using "QQV" instead of "QQQQ"

 

HTH,

 

Eric

If this post is helpful or answers the question, please mark it so.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated January 30, 2024 Views 541 Applies to: