ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Downloading stock prices automatically (https://www.excelbanter.com/new-users-excel/161548-downloading-stock-prices-automatically.html)

crossfool

Downloading stock prices automatically
 
How can I download stock prices automatically (say from Yahoo) into Excel
2002? Thanks.


Mike H

Downloading stock prices automatically
 
Hi,

Select a cell where you want the table to start and then

Data|Import external data|New web query.

Paste the address of the Yahoo site into the window that's appeared and
click GO.
Select the table you want to import and click Import.

Back on the worksheet right-click the table to set up the refresh frequency.

Mike

"crossfool" wrote:

How can I download stock prices automatically (say from Yahoo) into Excel
2002? Thanks.



All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com