If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Stock Values in Excel
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. |
#2
|
|||
|
|||
Stock Values in Excel
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" -- Kevin "Maurice" wrote: 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. |
#3
|
|||
|
|||
Stock Values in Excel
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. -- Kevin "Maurice" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|