Try this software.
Stock Quotes in Excel 2010 or any version | Google Translate for Excel, Time-saving plugins (Add-ins) for Microsoft® Excel®
This gets quotes from Yahoo in your Excel workbook. Adds more than 80 functions for everything that you can think of. Takes the Symbol as an argument...