Pull stock quotes in Excel using MoneyCentral Investor Stock Quotes built-in collection. Learn how to get Stock Quotes in Excel without using any add-ons. Oct 30, 2009 Finance in Excel 1 - Live Stock Quotes in Microsoft Excel - MSN MoneyCentral Investor Stock Quotes. Jan 30, 2018 MSN Money is the hub for your financial life. Be informed and ahead with our real-time stock quotes, deep tools and calculators, and breaking news and. Dust An Elysian Tail Pc more. How to restore the stock quote query functionality in MSN MoneyCentral Stock Query.

I have been experiencing the same thing, although it is sporadic. I get the message when I try to refresh, so I opened a new workbook and actually got the first two spreadsheets to populate with new data, the third sheet failed with the same message that you provided above and refreshing any of them failed????? Like yourself, I have been doing this for years - but I can't figure out why I can get connected on some tries but not others. I have just installed Excel 2013 and the 'Existing Connections' are not even there. Apparently the link to 'moneycentral.msn.com' is down (permanently??) and the query is redirected to the MSN Money homepage.

I used the link 24/7 with only occasional misfeeds over the past 15 years, but have never encountered this problem of being redirected. One can hope that Mr. Softee will return the link to its original condition shortly, but be prepared to face the fact that the 3 built-in ExCel data sources may be gone for good.

God does not explain his movements to us, nor does Mr. Wait, maybe they are one in the same? Create Your Own!

First, navigate yourself to c:/program files/microsoft office/officeXX/queries. The XX is either 12, 13, 14depending on system. Then copy the MSN Stock Quote file and paste. Rename it YahooQuotes. It will be an.iqy file (inquiry) Open it with Notepad and put this in it. WEB 1 stock, fund or other symbols separated by commas.' ]/view/fv Selection=2 Formatting=All PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False Save it.

This will allow you to get the same data as from the old moneycentral into a table. From there, you're on your own. BTW, you can play with the '/view/fv' to get different columns. BTW, I know just enough to be dangerous. I am using a crude workaround at this point.

Use the following URL and replace my stock tickers with yours. Bte.to,chw.to,efn.to,fly.v,euo,fax,ge,ma,mdlz,mpel, tbt,utx,yum /view/v1 Go to that WEB site and when your stock list appears, highlight and copy the results to somewhere in your spreadsheet. Point your spreadsheet calculations to this downloaded data.

Unfortunately this method requires the 'reference and copy' process each time, but it is a lot easier than full manual entry of all stock data. I have tried a direct query to the above URL but have not been successful in getting any data back.