July 2004
Home Up Tips Directory Links of Interest Site Map FAQs

 Wednesday, July 14,  2004   
 

6:30-7:00 pm 

General Questions and Problems from the Audience
Aggravations.

7:00 - 8:00 Getting Data from the Web into Excel.

Using a Web Query. 
(Data, Import External Data, New Web Query)

We will use the website:
http://www2.barchart.com/sigtop.asp?start=all&what=&ind=&date=

as an example.   

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
Design of this site by Cheryl D. Wise
Copyright © 2000-2004 by WiserWays. All rights reserved.
Revised: 2005-07-10 01:08 .