A simple way to achieve this is to use Excel and Access in MS Office 2002 or Office 2003.
Excel's Web Query feature allows a spreadsheet to be automatically updated by data from the Web each time you open the file. You can set up a Web query in a spreadsheet that will give you the latest stock prices from a web site:
- Open a blank worksheet and click in cell A1.
- From the Menubar click Data Import External Data New Web Query. Excel will then prompt you for an Internet connection if you're not already connected.
- In the Address box, enter the URL of the Web page that contains the stock statistics and then click Go. For example the live stock statistics on the freerealtime.com site are easily linked.
- Click the yellow boxes with arrows next to the blocks of text you want to import. When clicked, the yellow boxes turn into green boxes with check marks.
- Click the Import button.
- Right-click a blank area of the main toolbar and select External Data.
- Click the Data Range Properties button.
- In the Refresh Control section, select Refresh Data On File Open. Click OK.
- Add column headings (ie. field names) to each data column as needed.
If you need to take a snapshot of the data in Excel:
- Select the data you want to copy. From the Menubar click Edit Copy.
- Click on the cell where you want the snapshot of the data to appear.
- From the Menubar click Edit Paste Special.
- Click the Values And Number Formats checkboxes, and then click OK.
- From the Menubar click Edit Paste Special.
- Click the Column Widths checkbox and then click OK.
- From the Menubar click File Get External Data Link Tables...
- In the Link dialog, select Microsoft Excel (*.xls) from the Files of type combobox, and click Link.
- Follow the the Link Wizard to finish, and you will have a table linked directly to your spreadsheet.
No comments:
Post a Comment