Question

Q: Excel 2010 stock quotes using MSN money central stopped working

Yesterday following an office update, the msn money central stock quotes stopped working in Excel 2010.

I attempted a feed in a new worksheet and just get a a link to the web page.  

How can I fix this????



* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

I also have this problem. The website now has a "pop-up" ad on it that must be closed before accessing the rest of the site--looks exactly like what the spreadsheet is downloading if you look at the "preview" pane for the query (when setting up the query). I suspect this may be the problem, the query can't get pat the popup. I don't know how to bypass the popup to get to the main content, there doesn't appear to be a different link for the popup, it's all the same page.. Looking for a different solution as Microsoft is unlikely to fix this. I've read online something about a Bing BETA "app" that may be replacing this.

Did this solve your problem?

Sorry this didn't help.


Hello,

Welcome to Microsoft Community and thank you for posting your query.

Let me assist you with Excel issue.

Few more details would help us to provide a better response.

How are you getting the stock quotes in Excel 2010?

Provide us the step by step information to reproduce the issue and help you better.

Thank you.

Did this solve your problem?

Sorry this didn't help.


Raju,

The stock quotes are part of the standard MSN Money add-in feature in excel.

You go to

Data

Add - A window pops up with Existing Connections. Select MSN MoneyCentralInvestor Currency Rates (as an example) and then click on Open.

Close the window Workbook Connections

Then again in Data click on Existing Connections You will see that connections in this workbook are MSNMoney Central Investor Currency Rates - select it and click Open, a window will pop up indicating where do we want to put the worksheet.

Now instead of getting the excel table what you get is a bunch of info like some sort of pop-up see below

Did this solve your problem?

Sorry this didn't help.


I have the same or maybe similar issue.   Using the imbedded MSN stock quote query, the table of stock prices is no longer returned.  Instead I get what appears to be the MSN homepage in my Excel sheet

Did this solve your problem?

Sorry this didn't help.


My research says it was a deliberate action by MS for some unknown reason.  Perhaps to get more people to look at MS Money, but more than a little irritating.  Given all the negative responses I can only hope they restore the function asap.

Anyway there is a somewhat cumbersome workaround using Yahoo! finance with the following URL:

http://finance.yahoo.com/quotes/"Put your call signs here with a comma after each."/view/fv

You can then set up a new Web Query using this, but you also get a slew of additional info but you can just link the data you want to your stock sheet.  Or more cumbersome, just copy the data you want from the Yahoo web site and paste to a separate sheet (which you can link).

Did this solve your problem?

Sorry this didn't help.


Raju, here is how I am getting the stock quotes into Excel 2007:

From the Ribbon: Data, Connections

Select MSN Money Central Investor Stock Quotes, ADD

Select MSN Money Central Investor Stock Quotes, OPEN, PROPERTIES

Under the Definition tab, here is what I get: (Edit Query)

Address: http://www.msn.com/en-us/money

this shows a preview of the pop-up ad currently on the website.

CANCEL

Under Parameters : Get Value from following cell (I am selecting a column of symbols)

OK, OK, CLOSE

 

Using these setting results in the pop-up data showing up, not the stock data.

Additional Info:

Connection File:

C:\Program Files(x86)\Microsoft Office\Office 12|QUERIES\MSN MoneyCentral Investor Stock Quotes.iqy (all one line)

Connection String:

http: //moneycentral.msn.com/investor/external/excel/queries.asp?SYMBOL=["QUOTE","Enter stock, fund, or other MSN Money Central Investor symbols separated by commas."]

Command text:

empty

 

Thanks for your help. I've been using this method of getting stock quotes for at least 2 years with no problems, so hopefully there is a fix.

Did this solve your problem?

Sorry this didn't help.


Raju:

This problem is caused by Microsoft relaying all  http://moneycentral.msn.com references to http://www.msn.com.

Try this ... enter http://moneycentral.msn.com into your browser's URL address bar and hit Enter. The page that comes up is http://www.msn.com

moneycentral.msn.com could be used by Excel to obtain stock quotes. However, since Microsoft is relaying all moneycentral.msn.com references to www.msn.com ... we customers cannot get stock quotes into our spreadsheets.

Support Engineers in this forum cannot fix this problem. You need to ESCALATE this to Microsoft. 

Did this solve your problem?

Sorry this didn't help.


Raju:

This problem is caused by Microsoft relaying all  http://moneycentral.msn.com references to http://www.msn.com.

Try this ... enter http://moneycentral.msn.com into your browser's URL address bar and hit Enter. The page that comes up is http://www.msn.com

moneycentral.msn.com could be used by Excel to obtain stock quotes. However, since Microsoft is relaying all moneycentral.msn.com references to www.msn.com ... we customers cannot get stock quotes into our spreadsheets.

Support Engineers in this forum cannot fix this problem. You need to ESCALATE this to Microsoft. 

Seems like we just need to find out the new link? How do we complain to Microsoft about this?

Did this solve your problem?

Sorry this didn't help.


This is their customer service phone number:  1 (800) 642-7676

Here is their address:

One Microsoft Way

Redmond, WA 98052-6399

Here is their "Contact Us" page:

http://support.microsoft.com/contactus/

Perhaps if enough people call, write, and post in these forums ... then Microsoft will fix the problem.

Did this solve your problem?

Sorry this didn't help.


I am experiencing the same problem...went to Yahoo Finance. 

Microsoft needs to know they cannot add pop-ups to their MSN money feed page.  Adding pop-ups to

the MSN page that linked with excel will force all advanced excel users to yahoo finance.

I've been using the MSN money feed for a decade...until now.

Did this solve your problem?

Sorry this didn't help.


* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
Question Info

Views: 3,271 Last updated: July 9, 2018 Applies to: