Nov. 2001
Home Up Past Meetings Notes Tips Directory Links of Interest Site Map FAQs

Our Next Meeting: Wednesday, November 7,  2001

6:30-7:00 pm 

General Questions and Problems from the Audience

Puzzler:   Given two columns: a list of Names and a List of Scores.    Print out the Names of the 1st Place, 2nd Place, and 3rd Place.    Ties are possible.    Think of different ways to do this.

7:00-8:00 pm One Hour AppBusiness Question: "Suppose I think I should follow a given set of rules for when to invest in a Mutual Fund.   Before I invest real money, how well would those rules have worked over the past two or three years?" 

We will build an application where we get historical data for a stock or fund.  We create formulas for the critical metrics (like MACD and N-day moving averages) that the buy and sell rules depend upon. More fromulas that will signal and execute the buys and sells. according to the rules.   We analyze how we did over time.    Finally, we use Data Table sensitivity analysis to find the best trigger levels to improve our returns.

8:00-8:10 pm

(Break) 
8:10-9:00 pm Tentative: Web Sites and Resources for getting Help, Ideas, Functions and Subroutines for Excel.

What is the One Hour App?

One of the members put a very good question to me at the last meeting.   "We've see a lot of tools and commands you can do in Excel, but what can you USE Excel FOR?"  

Our mission says:  ... each SIG meeting will be designed around starting and finishing a problem within the meeting. ...  We have not done this lately; time to return.

Introducing the "One Hour App": a section of the meeting where we build a simple, real world application from scratch. starting with some basics.

I need some ideas from members for projects that are 
     a) well defined, 
     b) have non-proprietary data that can be published 
     c) can be made workable in 60 minutes, and
     d) are interesting, non-trivial, real-world problems.

Ideas that I am kicking around are:

bullet

Investing in Stock or Funds:  If I follow a rule for when to get in and when to get out, how well would that have worked over the last 3 years?

bullet

Time Sheets: to track time by Project, Task, and Person.   Consolidate by Project and Client.   Link to related documents.

bullet

Surveys:  Create an Excel based questionnaire form.    Use drop down boxes,  and tests for completeness.   Have people fill it out via Email.   Add their completed questionnaire to a "database" for analysis.   Analyze the results graphically.    Use Pivot Tables to compare results demographically. 

Please forward other ideas to me and we will get them on the schedule.

 

 

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 .