These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 11, 2012

Mutual Fund Evaluation Tool (

This final project was created for the BYU BUSM 418 Financial Planning class that is taught by Dr. Bryan Sudweeks.  In this course, a number of financial teaching tools have been made available for the students to help them both in the course and throughout their lives.  Each tool is focused on providing assistance in some area of personal finance.

Under the direction of Dr. Sudweeks, an excel VBA spreadsheet was developed to be used in the investing section of the course to assist students in evaluating the historical and ongoing performance of mutual funds.  The developed solution uses VBA code to connect via the internet to from which fund data is gathered and assembled into customized reports based upon selections made by the user.  The tool only works on PCs, requires Internet Explorer, and an active internet connection.

No comments:

Post a Comment

Blog Archive