MSN MoneyCentral Investor Stock Quotes IS NOT working.

Press the "Refresh All" button in "DATA" and you get this - "Data not available"

PLEASE HELP

• Merged by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, January 09, 2015 2:49 AM duplicate

Press the "Refresh All" button in "DATA" and you get this - "Data not available"

PLEASE HELP

Hi Sir,

Based on my tested again this afternoon, MSN MoneyCentral Investor Major Indicies and MSN MoneyCentral Investor Stock Quotes iqy files are supported and working as they used to be. However, MSN MoneyCentral Investor Currency Rates has been deprecated.

We could use both of the two connection URL:

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

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False

WEB
1
http://www.msn.com/en-us/money/quoteslookup?SYMBOL=["QUOTE","Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas."]

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False

Please see the below image:

Then, we also could access the URL with browser directly.

http://www.msn.com/en-us/money/quoteslookup?SYMBOL=MSFT,APPLE,GOOGLE,yahoo

Thus, I recommend use the above string of the IQY to test.

Or the issue still exists, do you mind telling us your IQY file and steps? I'd like to reproduce it.

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

Hi,

Thank you for your STANDART answer.

B U T

It is NOT working.

If you open a new page and 1 - ONE ticker it might work (not always) but if you have an  EXISTING file it does NOT.

I can semd you the file and you can see.

THANKS,

Shai

I agree with Shai,  This link only works part of the time but not like the old way.  You might enter one quote and it'll work, but sometimes it might not depending on the ticker symbol.  (ex: if you enter skywork solutions ticker SWKS....it does not bring up anything). 

Also, just to make matters more interesting, I have canadian investments and when I enter my quotes like I used to do to it, it does not work.  (for Ex I want to get my quote for Bank of Montreal on the Toronto stock exchange.  I used to enter CA:BMO but it no longer brings up anything) 

Over and above this, I have some investments that have Class A and Class B shares on the Toronto Stock Exchange.  This works no longer. Ex:  I have Brookfield Asset Managment Class A shares and I used to enter CA:BAM.A ...it no longer works)

This new link does not completely replicate what the old link used to do.....anything you could help would be appreciated!

Partial solution here:

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx