Computer Help

These online tutorials explain various software and programs that we use throughout the class.

To view a tutorial, first download the Camtasia Player (324 KB -- right click and choose "Save Target As") to your computer.  Then download the tutorial to your computer, and run the tutorial avi file using Camtasia Player.  The avi files will play in other media players (such as Windows Media Player), but the video will be somewhat blurry.  In Camtasia, the video will be very crisp.  (I apologize for the awkwardness and difficulty of this procedure.)

Tutorials

1.  Setting up your investment game portfolio using MSN Investor's portfolio tracking software (77 MB -- 16 minutes)
          Sample printout of the initial portfolio holdings of this tutorial (pdf file)

2.  Retrieving stock price data from Yahoo!, putting it into Excel, and computing standard deviation and returns (63 MB -- 7 minutes)

3.  Running regressions using Excel (68 MB--11 minutes)
          Powerpoint presentation of basics of regressions 

4.  Using Microsoft's Deluxe Stock Screener  (46 MB--6 minutes)
         Click here to go to Microsoft's stock screener.

5.  Additional instructions for the optimizer project (173 MB--26 minutes) 

MSF 1.  Some tips for Investment Analytics Homework #1--portfolio optimizer. (230 MB -- 42 minutes)

MSF 2.  Some tips for Investment Analytics Homework #2--portfolio optimizer (224 MB --  39 minutes)

MSF 3.  Tutorial for how to use the Camtasia Recorder (46 MB --  4 minutes)
   

 Contents written by Jason Karceski
Last modified on January 08, 2007.