Stock Values in Excel

  • Thread starter Thread starter Maurice
  • Start date Start date
M

Maurice

I write to inquire if there is an efficient way to get stock values into
excel 2007? Additionally, I would like to be able to get dividends into the
same file as well. I know this can be done by hand but perhaps there is some
companion app or macro around.
 
In Excel 2007, you can import web data by creating a Web Query

1. Data tab, From Web.
2. Type web address URL
3. Select the tables you want to import.
4. Import Data
5. Place where you want to import to.
6. Click OK

For addition info, read the help for "Get external data from a Web page"
 
I forgot to mention how to Refresh the data.

1. To refresh the data, click inside the imported data range. (this will
unghost the Refresh).
2. Data tab, in the Connections group, click the arrow under Refresh All,
and then click Refresh.

If you have several data sheets, click Refresh All.
 
Back
Top