it is possible if you have codes by yahoo finance. there are some files with
macros  already parked in xltrades (GET YAHOO DATA")
search in this url
http://groups.yahoo.com/group/xltraders/files/

the same can be modified to suity you and even if the scrip prices need to
be dowloaded from some source other than yahoo finance.
venkat

Get a stock quote  
Show All
Hide All
Make sure smart tags (smart tags: Data recognized and labeled as a
particular type. For example, a person's name or the name of a recent
Microsoft Outlook e-mail message recipient is a type of data that can be
recognized and labeled with a smart tag.) are turned on.
How?

Click AutoCorrect options on the Tools menu.
Click the Smart Tags tab, and select the Label data with smart tags check
box.
Type a recognized U.S. financial symbol (for example, MSFT) in a cell. Type
the symbol in capital letters.
Click outside of the cell.
Move your mouse cursor over the purple triangle in the lower-right of the
cell, and then click the arrow next to Smart Tag Actions  to see a list of
options.
Click Insert refreshable stock price.
In the Insert Stock Price dialog box, choose whether to insert the stock
price on a new worksheet or in a specific area of your current worksheet.
The data that is returned may fill a large portion of your worksheet.

Note  You can also use an add-in to insert a function that retrieves stock
quotes and stock data. For more information, see the Microsoft Office Web site

I have several symbols on my sheet and can refresh data to update quotes.
I then copy the quotes to other sheets to chart data because once I was
keeping the data on that sheet and all of a sudden the sheet grew (from MSNs
site) and messed up my data.