Downloading Multiple Pages of Get External Data from Yahoo

  • Thread starter Thread starter Frank Hayes
  • Start date Start date
F

Frank Hayes

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&pemax=30&pegmin=0&pegmax=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
 
It appears to me that they are only feeding you 20 at a time, so the answer
is no.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Downloading historical stock data from MSN Money to Excel via VBA 2
Looping: Search Range in Multiple Selected Worksheets, Copy/Paste 6
OnTime Application Newbie Question 1
Get data from web site - hyperlinks in divs in html table 1
Yahoo + "Get External Data" 1
excel to sql server (frequently) 4
Correct a Stock Option Download Script 1
How do I pull multiple queries of external data from the Internet into Excel? 1

Back
Top