Houston Excel SIG Past Meetings Index

Oct. 4, 2004 - Lists: Find Unique elements. Find elements shared between lists. Find what is in list A and not in B.: Agenda is subject to change.
Sept 8, 2004 - Analyze Signals and Prices from the Aug and July Web Queries: Load Excel Data into Access with Get External Data.; Create queries to compare signals with historical prices.; Create Pivot Table Chart to analyze the average gain or loss on each of the signals by date and days from signal.
Aug 11, 2004 - Web Query from Yahoo Historical Prices.: Build automation to cycle through a list of 200+ ticker symbols, retrieve the web query, save the data to an excel database.

July 14, 2004 - Web Query to barcharts.com signals pages.: Process text dates to Excel dates. Save date to an Excel Database sheet. VBA to automate the WebQuery for several pages and appending to the database.

June 9, 2004 - Pivot Tables on 6 months of Stock Data.: Organize by Industry Pages. Take Snapshots. VBA Macro to open workbooks, create sheets, Copy and Paste values and formats. Code posted.

May 5, 2004 - First Wednesday, low turn out. Pivot Tables carried over to June.

April 14, 2004 - Pivot Tables.: Source data was risk economics of projects named for Hall of Fame Baseball players.

Mar. 3, 2004 - Pivot Tables (Meeting cut short by scheduling conflict)

Feb. 11, 2004 - Aggravations, Pivot Tables, Multiple Sheets

Jan. 14, 2004 - String and Text functions: Ideas for Recording Buys and Sells of Stocks.
Left(), Mid(), Right(), Len(), Find(), Replace(), Search(), Substitute(), Trim()