I thought it would be interesting to try to develop an Excel-based portfolio tracking tool. This tool will allow the user to input trade details, aggregate the trade positions, and track the performance of the portfolio via intra-day pricing being pulled from a web-source. With its user-friendly interface screens, adding new trades is very simple and easy. Buttons allow for market prices to be refreshed at the user’s command. Note: it is not the purpose of this application to execute trades in the real world (although additional coding likely would allow for this) and is only designed to be used for tracking purposes – either tracking of a real or fictitious portfolio.
http://files.gove.net/shares/files/10w/jml68/Stock_Portfolio_Tracker.xlsm
http://files.gove.net/shares/files/10w/jml68/Portfolio_Tracking_Tool.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
-
▼
2010
(150)
-
▼
April
(71)
- Using Excel as a Music Player
- Experimental Design and Conjoint Analysis
- ITunes Playlist Comparer
- Comparable Company Automation Project
- Text file manipulation with VBA
- Bryce Newbold's VBA Project
- Calculating and Graphing the Efficient Frontier f...
- Gift Card Reconciliation
- Personal Budget Spreadsheet
- BLS PPI Database Query to Analyse Year-to-Year Cha...
- ReportFileExecutive SummaryThe purpose of my VBA p...
- Home Salon Management System
- New York City Apartment Complaint ListingExecutive...
- Personal Finance Tool
- Sales Agent Scorecard Generation for Integra Telecom
- The Matchmaker
- Numerical Heat Transfer Optimizations in VBA
- Web Table Converter
- CRM Data Entry Segmenation - Chris Brasher
- Report System for The Pendulum Court
- ScheduAll Report Automation - Karl Rosengren - Win...
- Farr Appraising Market Conditions Report
- Portfolio Tracker
- Luke's Automated SWA Boarder
- Sync Department Data
- A First Step Towards User-Defined Financial Ratios
- Business Charge Entry / Invoice Manager
- Awesome Adobe Automation
- Textbook List Price Aggregator by Adam Cuppett
- Money Allocator
- Minchin Timesheet v1.0.25059
- A more accurate bid
- Kingdom of Loathing Market Dashboard
- CALLING ALL CATTLE! AUTOMATING SWA’S ON-LINE RESE...
- Business Broker Searches
- Cowtail Biomechanics Analysis
- Crime in Cities data compilation
- Sudoku Solver
- Report Generator for a Legacy System
- Ward Directory Creator
- Fraud Analyzer
- Valuation of a company. Calculation of NPV and Pri...
- Daily Sales and Inventory Control for Costco Retai...
- Customer Relationship Management & Analysis Progra...
- JJ Webb - FDIC data generation
- Generating iTunes Related-Artist Playlists
- ZIltch!
- Byron Mackay - Mariner Add-ons
- Option Pricing
- Potential Project Portfolio by Erik Wenzel
- Appointment Reminders Program - Micah Lorenc
- US Army APFT score calculator and automated Counse...
- Martech Computers Invoice Scraper
- iSYB Budget - Dustin Skinner (Winter 2010)
- Tory Betts Final Project
- U.S. Treasury TARP Report Generator - Ryan Wood - ...
- Copy Report Automation - Shauna Call, Winter 2010
- Easycache - a time saving tool for Geocaching.com ...
- Inventory Optimizer - Andrea Cordani, Winter 2010
- Get a Room! - Mark Tuttle - Winter 2010
- MyData info parser - Jeff Baxter - Winter 2010
- Whisk Recipe Organizer - Brandon Anderson - Winter...
- http://files.gove.net/shares/files/10w/kdl22/VBA_...
- Day Planner - Howard Kuan - Winter 2010
- Carman Violin Studio - Jesse Carman - Winter 2010
- MyComfort Product Tracker and Serial Number Genera...
- Financial Markets Update Service - Jason Merrill, ...
- MemoSend - Danny Patterson, Winter 2010
- Cinema Data Aggregator - Adam Solter, Winter 2010
- AutoRegister - John Wilson - Winter 2010
- VDC Requests - Kevin Brinkerhoff - Winter 2010
-
▼
April
(71)
No comments:
Post a Comment