Optimal Portfolio Selection: A Note with a VBA Solution

Ignacio Velez-Pareja () and Pedro F. Castilla

No 10723, Proyecciones Financieras y Valoración from Master Consultores

Abstract: Usually in financial textbooks and courses the theory of portfolio selection is taught in a strictly theoretical way. There is a model (Markowitz) that stipulates that an investor has preferences and that she will choose the best portfolio, given her preference curves and an efficient frontier. On the other hand, the Capital Asset Pricing Model (CAPM) is presented as it is: a genial idea that served to simplify and to make operative the Markowitz setup.Most students and practitioners conclude that those models are just inapplicable theory. This is the most rational behavior one can expect. What can an investor do with the textbook recipes to configure an optimal portfolio? Very little. We show through an example how the portfolio is obtained manually" and how to use the add-in developed showing the efficient frontier in the example. "

Keywords: CAPM; efficient frontier; portfolio selection; capital market line; optimal portfolio; add-in; VBA (search for similar items in EconPapers)
JEL-codes: G11 G12 (search for similar items in EconPapers)
Pages: 16
Date: 2012-10-13
References: Add references at CitEc
Citations:

Downloads: (external link)
http://papers.ssrn.com/sol3/papers.cfm?abstract_id=2161479

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:col:000463:010723

Access Statistics for this paper

More papers in Proyecciones Financieras y Valoración from Master Consultores
Bibliographic data for series maintained by Ignacio Velez ().