View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Hayes Frank Hayes is offline
external usenet poster
 
Posts: 18
Default Downloading Multiple Pages of Get External Data from Yahoo

I am using the "Get External Data" function to download a stock screen from
Yahoo. The current Get External Data will only download the first 20
results (out of a population of 494). Is there a parameter I can set to
download all 494 at once?

The external data screen I am using is:

http://screen.yahoo.com/b?&pemin=0&p...ax=1&db=stocks

Thanks for any advice.

PS - This screen downloads stocks with Price to Earnings Ration between 0
and 30 & PEG Ratios between 0 and 1

Frank