Paper: arXiv 2305.12826

Authors: Abdulnasser Hatemi-J, Alan Mustafa

Abstract

This paper introduces a software component created in Visual Basic for Applications (VBA) that can be applied for creating an optimal portfolio using two different methods. The first method is the seminal approach of Markowitz that is based on finding budget shares via the minimization of the variance of the underlying portfolio. The second method is developed by El-Khatib and Hatemi-J, which combines risk and return directly in the optimization problem and yields budget shares that lead to maximizing the risk adjusted return of the portfolio. This approach is consistent with the expectation of rational investors since these investors consider both risk and return as the fundamental basis for selection of the investment assets. Our package offers another advantage that is usually neglected in the literature, which is the number of assets that should be included in the portfolio. The common practice is to assume that the number of assets is given exogenously when the portfolio is constructed. However, the current software component constructs all possible combinations and thus the investor can figure out empirically which portfolio is the best one among all portfolios considered. The software is consumer friendly via a graphical user interface. An application is also provided to demonstrate how the software can be used using real-time series data for several assets.

Complexity vs Empirical Score

  • Math Complexity: 6.0/10
  • Empirical Rigor: 3.5/10
  • Quadrant: Lab Rats — high math complexity, limited empirical testing

Why this score: The paper presents advanced mathematical optimization formulations (Markowitz and a new risk-return objective) with matrix algebra and determinants, but its empirical component is a VBA simulation tool for teaching purposes, using a single real-time series example without robust backtesting or data-heavy validation.

Research Flowchart

  flowchart TD
  A["Research Goal: Develop VBA tool for<br>optimal portfolio construction"] --> B["Data Input:<br>Historical asset return time series"]
  B --> C{"Two Optimization Methods"}
  C --> D["Method 1: Markowitz<br>Minimize Portfolio Variance"]
  C --> E["Method 2: El-Khatib & Hatemi-J<br>Maximize Risk-Adjusted Return"]
  D --> F["Compute all possible<br>asset combinations"]
  E --> F
  F --> G["User-friendly GUI<br>enables comparison & selection"]
  G --> H["Key Outcomes:<br>1. Portfolio optimization tool created<br>2. Empirical asset number selection<br>3. Real-time data application demonstrated"]

Evidence Card

What the authors claim, on what data, and who has checked it. Read from the paper's own text by a language model: every quote is verbatim, nothing was re-run. How to read this card

Proposes

The paper proposes a VBA software component that constructs optimal portfolios using both the Markowitz minimum‑variance method and the El‑Khatib‑Hatemi‑J risk‑adjusted return method, including endogenous selection of the number of assets.

Source sentence
This paper introduces a software component created in Visual Basic for Applications (VBA) that can be applied for creating an optimal portfolio using two different methods.

Assumes 3

  • Asset returns are normally distributed. model
    Source sentence
    Let us assume that ri is representing the rate of return for asset i, which is has a normal as 𝑟𝑖~𝛷(𝑟̅𝑖, 𝜎𝑖2).
  • Budget shares sum to one (full investment of capital). model
    Source sentence
    Bounded by the budget limitation expressed in equation (2): 𝐷(𝑤) = ∑𝑤𝑖 = 1
  • The number of assets to include can be endogenously determined by enumerating all possible combinations. other
    Source sentence
    Our software takes this issue into account by constructing all possible combinations and providing the portfolio that is optimal even with regards to the number of assets also.

Data

  • Real‑time series data for several assets (example: 10 assets with 65 price records) market-prices unknown
    10 assets
    Source sentence
    For example, by running a set of 10 assets with 65 records (that results in 1013 different portfolios), it takes around 100 seconds to process the data using the option “without details”.

Costs

Not applicable The paper reports no trading or execution result.

Finds 1

  • Processing 10 assets with 65 price records (1013 portfolios) takes about 100 seconds without detailed step‑by‑step output, but more than 15 minutes with detailed output. performance
    Source sentence
    For example, by running a set of 10 assets with 65 records (that results in 1013 different portfolios), it takes around 100 seconds to process the data using the option “without details”. Comparatively, it takes more than 15 minutes to implement the same calculations with the option “with details”.

Checked by others

No other paper in the archive has been found to support or contradict these findings (compared with 5 related papers). Coverage is partial, so this is neither replication nor refutation.

Code

No repository by the authors found in the paper.

Extracted 2026-11-14 · same card as JSON · A language model chose these items: check the source sentence before relying on one.