I need to update stock prices into an excel spreadsheet on a dailt basis.
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
quot;tbwillisquot; wrote:
gt; I need to update stock prices into an excel spreadsheet on a dailt basis.
Try my web table import utility at:
www.geocities.com/excelmarkswayquot;tbwillisquot; wrote:
gt; I need to update stock prices into an excel spreadsheet on a dailt basis.
- Aug 14 Mon 2006 20:08
how can I update stock prices daily into excel
close
全站熱搜
留言列表
發表留言