---
title: A Simulation Package in VBA to Support Finance Students for Constructing Optimal Portfolios
url: https://www.ml-quant.com/papers/arxiv/2305.12826/
site: ML-Quant (https://www.ml-quant.com)
updated: 2026-09-26
license: Summaries CC BY 4.0; links go to the original sources
index: https://www.ml-quant.com/llms.txt
identifier: arXiv:2305.12826
source_url: https://arxiv.org/abs/2305.12826
featured: 2023-05-24
citations: 2
topic: Portfolio & Allocation
---


# A Simulation Package in VBA to Support Finance Students for Constructing Optimal Portfolios

VBA software component for optimal portfolio creation using two methods demonstrated with real-time series data.

- Source: https://arxiv.org/abs/2305.12826
- Identifier: arXiv:2305.12826
- Released: 2023-05-22
- First featured: Quant Letter No. 1 (2023-05-24): https://www.ml-quant.com/issues/2023-05-24/
- Citations (Semantic Scholar): 2
- Published in: ITISE 2023
- Topic: Portfolio & Allocation

## Related

- [Risk Budgeting Allocation for Dynamic Risk Measures](https://www.ml-quant.com/papers/arxiv/2305.11319/): Risk budgeting allocation approach developed using dynamic risk contributions and deep learning.
- [Value-at-Risk-Based Portfolio Insurance: Performance Evaluation and Benchmarking Against CPPI in a Markov-Modulated Regime-Switching Market](https://www.ml-quant.com/papers/arxiv/2305.12539/): Study compares VaR-based and constant proportion portfolio insurance strategies in regime-switching framework.
- [Machine Learning for Socially Responsible Portfolio Optimisation](https://www.ml-quant.com/papers/doi/10-1145-3596947-3596966/): MV model amended to consider ESG scores for socially responsible investing.
- [Effective Experience Rating for Large Insurance Portfolios via Surrogate Modeling](https://www.ml-quant.com/papers/arxiv/2211.06568/): A surrogate modeling approach is proposed to compute Bayesian credibility premiums for a given model.
- [Change point detection in dynamic Gaussian graphical models: The impact of COVID-19 pandemic on the U.S. stock market](https://www.ml-quant.com/papers/arxiv/2208.00952/): A Bayesian model is developed to capture changes in dependence across US industry stock portfolios during COVID-19.
- [Green portfolio optimization: A scenario analysis and stress testing based novel approach for sustainable investing in the paradigm Indian markets](https://www.ml-quant.com/papers/arxiv/2305.16712/): Article discusses construction of environment-friendly green portfolio using ESG ratings and modern portfolio theory.