none
problem with 'MSN MoneyCentral Investor Stock Quotes' in Excel

    Question

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

    PLEASE HELP

    Thursday, January 08, 2015 11:17 PM

All replies

  • MSN MoneyCentral Investor Stock Quotes IS NOT working.

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

    PLEASE HELP

    Thursday, January 08, 2015 11:13 PM
  • 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


    It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.



    Friday, January 09, 2015 6:46 AM
    Moderator
  • 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

    Friday, January 09, 2015 5:41 PM
  • 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!

    Friday, January 23, 2015 7:00 PM
  • 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

    Sunday, February 01, 2015 4:34 PM