The project centers on the needs of SW Asset Management, a small hedge fund based in Newport Beach, CA. The fund actively trades bonds, equities, options, currency, and credit default swaps. A routine task for the fund is to fill out a trade blotter each time a trade is done, along with a trade ticket. Currently this is done manually in excel. The project sets up a robust user interface to enter trades, to record those trades to the trade blotter, and to fill in the trade ticket. Because good analytics depends on clean data up front, my goal for the project was to create a system that is easy to use, pulls the necessary data to run analytics, and saves the firm time by not having to manually enter trade details.
http://files.gove.net/shares/files/11w/pboehme/Peter_Boehme_VBA_Final.xlsm
http://files.gove.net/shares/files/11w/pboehme/Peter_Boehme_VBA_Final.pdf
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
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2011
(153)
-
▼
April
(88)
- 10 Steps to True Value Investing
- Tracking Inventory for the Romney Institute
- VBA Web Analytics Dashboard
- Grocery List Builder
- Service Assistant
- Approximate Find - Jason Whiting
- Email & Text Message Sender
- Real Estate Agent Email Capture
- Appraisal Reports
- Read It (reading practice for elementary school ch...
- VBA and MySQL - Recipe Manager
- Bomberman for Excel
- Church Reading Assignment Reminder
- Wall Street Excel
- Winder Farms Daily Dairy Report Macro
- What-If Calculator
- Mint.com Transaction Aggregator
- Money Tracker
- Parking Business Program
- Chase Banking Tool
- DSM IV: Diagnosis Helper
- Hourly Employee Roster
- Merrill Madsen's Fall 2011 VBA project- Automating...
- Mutual Fund Analyzer
- SocializeMe - Social Media Reputation Monitor
- Relief Society Meal Coordinator
- Nick Sullivan Summary
- Contact List Program
- Wildfire Content Generator
- Isysguy - Grading Helper
- MSDNAA
- Deal-a-Day Price Comparison
- personal budgeting made easy
- Project Scheduler
- Mango Properties Expenditure Report
- Final Project - Kale Cabrinha
- Home Affordability Calculator
- Media Maven - Keeping Track of Your Books, CDs, an...
- Aggregate and Organize from Multiple Files
- Scraping BYU Book List
- Invoice System
- E*Trade Stock Screener Gadget
- Dynamic MBA Student Directory
- Investment Portfolio Dashboard
- Dealership Customer Management
- Rocket Town - awesome VBA Game, + Outlook to Excel...
- Roy Peckham -- Bird Hardwood Floor Solution
- Aflac Report Generator
- BYUIS Shipping Template
- Journal Entry Wizzard
- Auto register and RateMyProfessor.com
- Transaction Register
- Indexer
- Recipe Organizer By Eli Trejo
- Trade Entry
- US Bank Financial Form
- Beginning a “Good Faith Effort”
- buyCheap (Craigslist)
- Linear Model Selector: Forward Selection Algorithm
- US Paralympics Scheduling Spreadsheet
- Bank Account Balances, SpringerLink Books, and His...
- @font-face { font-family: "Cambria"; }p.MsoNorma...
- ProQuest Dissertation Search and Save
- Conway's Game of Life for Excel
- Craigslist Job Meta-Search
- Recipe Shopping List Creator
- Daily Transaction Emailer
- Automate Creation of Google Calendar Events
- Flight Status Updates
- Wedding Planner App
- NBA Fantasy Forecaster
- Syllabus Synthesizer
- The Budgetation Spreadsheet
- Managing Clients and Insurance Forms
- Ward Emailer
- Blog Manager
- Mountain America Credit Union to Budget Automation
- VBA program that automatically updates your social...
- My Client Dashboard
- Traffic Jam
- Prosper Exports
- NCAA Basketball Tournament Simulator
- Zions Bank Budget Tool
- MBA 614 Project
- VBA Flash Card System
- Eastside Harley-Davidson
- Craigslist Apartment Search
- Media Library Tracking
-
▼
April
(88)
No comments:
Post a Comment