ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can I update stock prices daily into excel (https://www.excelbanter.com/excel-discussion-misc-queries/61644-how-can-i-update-stock-prices-daily-into-excel.html)

tbwillis

how can I update stock prices daily into excel
 
I need to update stock prices into an excel spreadsheet on a dailt basis.

Vick

how can I update stock prices daily into excel
 
If the updates are coming from the web you can do the following:

Goto: Data- Import External Data - New Web Query

from here the process varies depending on your version of excel. In 2003 you
can simply type in your web address, such as www.msn.com. From there
highlight the table you want to import. And go from there. You can play with
the options to how often the information will refresh and how the data will
come in. It really depends on you want to work with the information.

Vick

"tbwillis" wrote:

I need to update stock prices into an excel spreadsheet on a dailt basis.


exceluserforeman

how can I update stock prices daily into excel
 
Try my web table import utility at:

http://www.geocities.com/excelmarksway


"tbwillis" wrote:

I need to update stock prices into an excel spreadsheet on a dailt basis.



All times are GMT +1. The time now is 08:54 PM.

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