Q. In the April 2011 JofA (“A Refreshing Change in Your Portfolio,” page 57), you described how to set up a stock portfolio using MSN MoneyCentral investor stock quotes. Following your advice, I set up a large portfolio using this procedure, which has served me very well. However, in December 2014 the portfolio update function stopped working; is there a solution to get the stock quote updates working again?
A. Several CPAs have written about this same problem. It appeared that in late 2014, Microsoft discontinued my favorite stock price quote tool—the MSN MoneyCentral Stock Query. However, as of February 2015, this stock quote query functionality can be restored by creating a new query, as follows.
1. Launch Microsoft Notepad by selecting Start, Programs (or All Programs), Windows Accessories (or Accessories), Notepad. Enter the following information exactly as pictured below (the required text is repeated below the image):
http://www.msn.com/en-us/money/quoteslookup?SYMBOL=["QUOTE","Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas."]
2. Save the Notepad file as MSN MoneyCentral Stock Quotes 2015.IQY into the My Data Sources folder as pictured below.
Note: The My Data Sources folder is in your Documents (or My Documents) folder, which may be hidden by default. If necessary, you can unhide your My Data Sources folder as follows: Launch File Explorer, navigate to the Documents folder icon, right-click the Documents (or My Documents) folder icon, select Properties, and on the General tab, uncheck the box labeled Hidden, as circled below.
3. To use this new query tool, from Excel’s Data tab, select Get External Data, Existing Connections, and then scroll to and launch the new stock price query tool you just created labeled MSN MoneyCentral Stock Quotes 2015. In the resulting Import Data dialog box, click OK. In the resulting Enter Parameter Value dialog box, as pictured below, enter the stock tickers you want to query (separated by commas with no spaces after the commas) in the Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas text box, check the box labeled Use this value/reference for future refreshes, and then click OK.
4. This action will return current stock price and related information for each stock ticker symbol you entered in step 3.
Thereafter, these query results will refresh instantly whenever you press the Data tab’s Refresh button. Of course, your resulting queried stock quotes could then be referenced to an Excel-based portfolio, an example of which is pictured below. This example can be downloaded at carltoncollins.com/port.xlsx.
J. Carlton Collins is a technology consultant, a CPE instructor, and a JofA contributing editor.
Note: Instructions for Microsoft Office in “Technology Q&A” refer to the 2013, 2010, and 2007 versions, unless otherwise specified.
Submit a question
Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to email@example.com. We regret being unable to individually answer all submitted questions.