There have been many queries about the service on Technet forums - Excel IT Pro Discussions and this one MSN Central stock quotes not working indicates
Talk about poor customer relations, end users having to rely on third parties to find out a service has been discontinued.After a great deal of time on the phone with Microsoft Level two support (Mr. Mir Azhar), has told me today (12/31/2014) that the stock quote service has been discontinued from the MSN server and will not be available in the future.
I'm actually very disappointed in Microsoft for the way they've handled this. There are many articles on Microsoft's sites indicating how to use http://moneycentral.msn.com/investor/ex ... quotes.asp to get quotes. At the very minimum they could have used common courtesy and announced the upcoming decommissioning of this service. I'm left to wonder if they've really thought this decision through. If so, will they be updating all the references to it on Microsoft websites. Will they issue an Excel update to remove the .iqy files that come with their product and use this functionality? I'm guessing not.
Workarounds are being posted on various sites, for example Free Stock Quotes in Excel | Vertex42 indicates using GOOGLEFINANCE - Docs editors Help, but unfortunately
so getting TSX quotes becomes problematic.Google wrote:GOOGLEFINANCE is only available in English and does not support most international exchanges.
Looks like I'm going to have to rewrite my spreadsheets to use finance.yahoo.com again.