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 13, 2011

Trade Entry

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

No comments:

Post a Comment

Blog Archive