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 |
Downloading Multiple Pages of Get External Data from Yahoo
It appears to me that they are only feeding you 20 at a time, so the answer
is no. "Frank Hayes" wrote: 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 |
All times are GMT +1. The time now is 09:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com