Wednesday,
July 14, 2004
|
6:30-7:00 pm |
General Questions and Problems from the Audience |
| 7:00 - 8:00 |
Getting Data from the Web into Excel. Using a Web Query.
We will use the website: |
| 8:00 | (Break) |
| 8:10 - 9:00 |
Create a macro to save data from a results sheet and paste to a table that
is a "Log of results" We will use the web query above. Everyday we run the query, we save the results so that we can compare its results over a period of time. Next month, we will see if the signals from the web page were profitable. |
NEW: The workbook we created in the session can be downloaded
here:
PastMtgs/0407/webQuery2.xls -- 257KB Excel
2003 (compatible with Excel 2000 and Excel XP)
For questions or comments concerning content on this
website: Stephen Rasey |