Abstract
The purpose of this article is to provide finance instructors an example of how to teach students to integrate Visual Basic for Application (VBA) into a modern portfolio theory application. Using tactical asset allocation as an example, we show how to teach students to use Excel to (1) collect refreshable data, (2) organize the data into input, (3) construct an efficient frontier, and (4) use VBA to automate the process. Our step-bystep methodology is intuitive and can be used for teaching how to integrate VBA into other dynamic and integrative financial models.
Recommended Citation
(2026)
"A VBA Solution to Modern Portfolio Theory,"
Journal of Economics and Finance Education: Vol. 19:
Iss.
1, Article 3.
Available at:
https://scholarship.rollins.edu/jefe/vol19/iss1/3
