This Project mainly deals with selecting mutual funds, an asset class that gives instant diversification to the average investor. For those taking BusM418, mutual funds are an integral part of building your Personal Financial Plan. Seeing as their are 1,000's of mutual funds, it can be hard to tell which is best for you. Students are encouraged to use Morningstar, a financial services data provider, to screen mutual funds by your personal criteria. This narrows your search substanstially. But what if you still have hundreds of mutual funds to choose from? Do you simply look through all of them and then choose randomly? No! You use this program to aggregate all of the data, and then filter and sort according to your desire. This project is designed to aggregate all of the mutual funds that have made it passed your screening process, and put in a spreadsheet so the user can manipulate what they like to see, what they don't like to see and sort according to their preferences. My goal of this project is to help students make a more well-informed investment decisions by being able to see all of the information together in hopes that they may earn a good return on their mutual fund investment.
Writeup:
http://files.gove.net/shares/files/10f/tmoody2/VBA_FInal_Project_Writeup.pdf
Project:
http://files.gove.net/shares/files/10f/tmoody2/Final_Project_Isys520_5.xlsm
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
Friday, December 10, 2010
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2010
(150)
-
▼
December
(76)
- Automated Web Stats Collection
- Add A Class
- <!--[if gte mso 9]> <![endif]--><!--[if ...
- End-of-Semester Reconciliation
- Discounted Cash Flow Model
- Classified Ads Deal Finder
- BYU Auto-Registration Program
- Analytic Hierarchy Automated Decision Making Process
- Rotation Recommendation
- Mutual Fund Assistance Model
- YSA Tracking Program
- Investment Analysis Calculator
- Comparable Company Analysis and the WACC
- Used Car Search
- Your Financial Dashboard
- Sales Batch Auditor
- Bloomberg Report Via Excel Userform
- Cougar Scheduler
- <!--[if gte mso 9]> <![endif]--><!--[if gte...
- VIN Decoder
- Financial Statement Ratio Builder
- Food Storage Tracker
- Financial Planner/Projector by Derek Parker
- Bookkeeping in Excel
- Football, Fast and Easy
- 360 Feedback Splitter
- Mutual Fund Manager
- Family Finance Application
- Competition Information
- Cell Phone Bill Calculator
- Creating Forward-Looking Personal Account Budgets ...
- Batch File System
- Buy and Sell Stocks
- Job Application Automator - Chris Fisher
- C-Clearly Customer Database
- CRE loans Autoformatter
- Employee Payroll Userform
- Benjamin Olson, Bank Access and Bill Pay
- The Olive Garden Scheduler!
- What a happy day when a bright-eyed college senior...
- REIC Membership Batch Report
- REIC Purchase Order
- Excel Scrabble
- Independent Film Distribution
- Pandora Playlist Creator
- Around the World: Cheapest Flights for Flexible D...
- EQProgram: Automating the Ministry
- The Food Storage Inventory Manager
- Downloading & Formating from Intrade
- Visual Sales Reports_Christian Jones
- Brian Wade - Final Project - PinsRUS Pricing and Q...
- Get me to the airport on time
- Stock Evaluator
- Personal Budget, Jeff Woodland
- Mint Analytics, Nathan Allred
- EFTPS Time Saver by Devin Davidson
- <!--[if gte mso 9]> Normal 0 f...
- Pick Me! The Application Selection Process Assista...
- Flash Card Machine, Brian Baugh
- Stock Performance Indices, Tommy Smith
- ArticleMaker by Dave Brown
- Survey Generator
- Expense Recorder & Analyzer
- Recurring Revenue Report - Steven Wilde
- Matt Blodgett VBA Project - Nibbles Game
- Executive Summary: Genealogy Worksheet
- Gathering Credit Card Data
- NPV calculation
- Executive Summary - Brent Ray
- Moneytrackin Expense Reports
- Executive Summary - Accounting Comission Automation
- UVFA Inventory Project
- Executive Summary: Health and Fitness Application
- Executive Summary: Rental Property Reconciliation
- Executive Summary: Stock Picker
- Executive Summary: Invoice Tracker
-
▼
December
(76)
No comments:
Post a Comment