Unfortunately, the MSN Stock Quote tool that I have been using for years in Microsoft Excel no longer works for fetching stock prices in Excel 2013. There are some alternatives out there -- namely this option to enable the PSQ function -- however, that solution doesn't seem to work in Windows 8.
Luckily, I have finally found a solution thanks to this blog and the little known WEBSERVICE function in Excel. Using the Yahoo Stock quote API, you can easily write a formula that can be copied (or "Filled Down") to adjacent cells.
Assuming your ticker symbol is in A1, to fetch a price, a basic formula would be:
Oddly enough, Excel returns this not as a number, but as text. We can fix this easily by rewriting the formulas as:
The parts to pay attention to are at the end. s="&A1&" tells it that the stock ticker is in A1.
&f=l1 tells it to return the last trade price.
To fetch the name of the stock, you would substitue l1 with n.
So for example, if you wanted to have 3 columns with ticker, name, price, you could accomplish this by doing the following.
So now just setup your spreasheet and use Fill Down (Control D) to fill the columns.
UPDATE: As of May, 2017, Yahoo changed the address. I have updated the address above. However, if you had it working previously, you may need to change the address in the formula from http://finance.yahoo.com to http://download.finance.yahoo.com. Thanks to a reader for figuring this out and posting the solution in comments.
If you already have your spreadsheet setup with the old method, you can do a 'replace all' by changing "/finance" to "/download.finance".