{"paper_id":"2305.12826","title":"A Simulation Package in VBA to Support Finance Students for Constructing Optimal Portfolios","authors":["Abdulnasser Hatemi-J","Alan Mustafa"],"paper_date":"2023-05-22","paper_type":"software-tool","paper_url":"https://arxiv.org/pdf/2305.12826v1","page_url":"https://thequant.space/flowcharts/a-simulation-package-in-vba-to-support-finance-students-for/","scores":{"empirical_rigor":3.5,"math_complexity":6,"quadrant":"Lab Rats"},"proposes":{"status":"available","statement":"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.","quote":"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.","summary":"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…","strategy":null},"assumptions":{"status":"available","items":[{"assumption":"Asset returns are normally distributed.","type":"model","stated":"explicit","quote":"Let us assume that ri is representing the rate of return for asset i, which is has a normal as 𝑟𝑖~𝛷(𝑟̅𝑖, 𝜎𝑖2)."},{"assumption":"Budget shares sum to one (full investment of capital).","type":"model","stated":"explicit","quote":"Bounded by the budget limitation expressed in equation (2): 𝐷(𝑤) = ∑𝑤𝑖 = 1"},{"assumption":"The number of assets to include can be endogenously determined by enumerating all possible combinations.","type":"other","stated":"explicit","quote":"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."}]},"datasets":{"status":"available","items":[{"name":"Real‑time series data for several assets (example: 10 assets with 65 price records)","provider":null,"kind":"market-prices","access":"unknown","period":null,"universe":"10 assets","quote":"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”."}],"known":[],"sample":{"start":null,"end":null,"market":null,"asset_class":null,"frequency":null},"data_resolution":"unclear"},"transaction_costs":{"status":"not_applicable","modeled":"n/a","headline_net_of_costs":null,"detail":null,"quote":null,"source":"evidence_card","rule":"R2","candidates":{"front_matter":"unclear","evidence_card":"n/a","evidence_card_quoted":false},"meaning":"the paper reports no trading or execution result"},"results":{"status":"available","evaluation_type":"unclear","findings":[{"finding":"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.","kind":"performance","quote":"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”."}],"reported_performance":null,"out_of_sample":{"method":"none","headline_out_of_sample":null}},"independent_evidence":{"status":"none_found","supports":[],"contradicts":[],"qualifies":[],"compared_with":5,"citations":{"cited_by_in_corpus":0,"by_independent_authors":0,"how_cited":{"used_as_baseline":0,"uses_method_or_data":0,"extends":0,"discusses_findings":0,"mentions":0,"unclassified":0},"independent_papers":[],"scope":"Citations between papers in this corpus only; citations from outside it are not counted."}},"implementation":{"status":"available","public":false,"code_url":null,"note":"No repository presented by the authors as their own was found in the paper. Absence here is not proof that no code exists."},"replication":{"status":"none_found","card":null,"note":"No replication of this paper has been run by thequant.space yet."},"extraction":{"text_source":"fulltext","model":"openai/gpt-oss-120b","version":1,"extracted_at":"2026-11-14T18:26:36Z"},"provenance":{"claims":"Everything here is what the authors state in the paper. Nothing was re-run or reproduced by the platform.","quotes":"Assumptions, datasets, cost detail and findings were extracted by a language model. Every quote is verbatim paper text. Where an item has `support`, \"full\" means every figure in it appears in the quoted sentences and \"partial\" means a figure is stated elsewhere in the paper; items with a figure found nowhere in the paper were discarded.","datasets_known":"datasets.known lists well-known vendors and public datasets by a stable id, found by a dictionary over the full text where the sentence says the data is used; it is independent of the model and covers only names in the dictionary.","flags":"transaction_costs.modeled, results.evaluation_type and results.out_of_sample.method are platform classifications (structured-decision models); see https://thequant.space/score-guide/#penalty-flags","comparisons":"supports / contradicts / qualifies are a language model's reading of two papers' quoted findings, restricted to closely related papers that share no author. They are pointers to read, not verified replications, and coverage is partial.","implementation":"code_url is a repository the paper itself presents as its own (rule-scored, ambiguous cases judged by a model), checked for liveness when it was recorded."},"docs":"https://thequant.space/agents/"}