My favorite quotes

By J. Carlton Collins, CPA

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):

techqa1


WEB
1
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.

techqa2


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.

techqa3


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.

techqa4


4. This action will return current stock price and related information for each stock ticker symbol you entered in step 3.

techqa5


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.  

techqa6


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 jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TAX PRACTICE CORNER

More R&D tax help

"Can I use the R&D credit?" PATH Act enhancements make the credit more attractive to a wider range of taxpayers.

QUIZ

News quiz: Tax-related data breach explained

News about a data breach that affected about 100,000 people, the IRS’s budget for the fiscal year, and the 2018 health spending account limits received attention recently. See how much you know with this short quiz.