pulling info from internet

[bfont]

Hi. I have a column of stock tickers, and the next column is their share
price. Is there a way to automatically pull their prices when I open the
workbook from the Internet? Say from Yahoo!Finance?

 

[Crystal Lee]

Data -> Import External Data -> New Web Query -> enter the address (such as:
http://finance.yahoo.com)