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