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 Morningstar.com 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.
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
Showing posts with label Mutual Fund. Show all posts
Showing posts with label Mutual Fund. Show all posts
Wednesday, April 11, 2012
Mutual Fund Evaluation Tool (Morningstar.com)
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.
Subscribe to:
Posts (Atom)
Blog Archive
-
▼
2016
(60)
-
▼
April
(60)
- Fantasy Baseball Simulator - Brandon Soderquist
- Nutritious Meal Planner - Dain Berrett
- Equity Stock Ticker: Scraping The Web
- Events Report Automation - Cory Paxton
- Jinsook Lee - Personal Books Organizer: SMART LIBRARY
- Piano Academy Task Streamlining: Executive Summary...
- Riley Preslar MBA 614 Final Project Executive Summary
- Help Finding a Car Erik Berglund Executive Summ...
- Medicare Average Claims Report
- Abnormal Returns Tool - Haidyn Knuteson
- Finding Insurance Pricing Discrepancies
- Red River Medical Reporting
- Special Project P&L update for Business Firm - Col...
- Ben Olpin's Bank Account Tracker
- Kylie Wiser's Bond Charts and Lead List Generator
- Fantasy Baseball Draft Tool
- Clark Cannon Mortgage Rates
- Budget Vacation Dashboard My fiancé and I love...
- Real Estate VBA Project - KSL
- Find Your Dream House
- Networking Reminder Tool
- Daniel Oliveira: Current Events
- Tyler Ravsten Financial Tracker and Account Manager
- Lance Kohler: Foreclosure Analysis Tool
- Craig Goodman: Quick & Dirty Analysis on Rental Pr...
- Automation of Analysis for Quantitative Polymerase...
- Personal Budgeting System
- Label Release Log Entry
- Sherpa Tracking Sheet
- Customer Database
- Variance Analysis Executive Summary
- Property Management Tools: Using Excel VBA to Auto...
- Patient Reminders
- An Improvement on Y-Time For the Benefit of BYU St...
- Beneish M-Score
- Young Women's Lists & Reminder Texts
- Monte Carlo Simulation
- Around the World in a Bajillion Loops - Lee Chang ...
- Automated Freight Quoter for Mity-Lite
- Steve Washenko: Automating Studio Emails
- Allyson Woolsey: Qualtrics API Data Summary
- Dylan Eastman - Koko's Lunchbox Sales Report Autom...
- Walt Disney World Planning - Adam Larsen
- A.J. Bronson - KSL Car Finder
- Generating Month-end Reports
- Event Updates via Email
- John's Copart Scraper
- Personal Stock Tracking Tool
- Medical Services Summary and Payroll Calculator
- WF Credit Card Statement Analysis
- 10-Day Weather Forecast
- Inventory Management System for Home Kitchens
- Marketing ROI Calculator
- Handicap Calculator
- Hot Deals Finder
- Student Information Spreadsheet and Ledger
- Academic Information Gatherer
- Reconciliation Assistant VBA
- Statistical Record Linkage
- Comparing Salaries and Cost of Living based on Loc...
-
▼
April
(60)