View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Crystal Lee[_2_] Crystal Lee[_2_] is offline
external usenet poster
 
Posts: 6
Default pulling info from internet

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

"bfont" wrote:

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?