Diseño de carteras de opciones con Excel

Authors

  • José Agustín Piñol-Espasa Universitat de València Spain

Keywords:

Cartera, opciones, estrategia, excel, finanzas

Abstract

An Excel® workbook, containing three worksheets, is presented. The file allows performing financial portfolios using incorporated functions and VBA code (Visual Basic for Applications). The user must select the basic positions he/she wants to combine, and the program will supply analytical and graphical information about the portfolio’s yield at maturity. The workbook, named Carteras_Opciones.xlsm, is useful for traders at option markets, for investors as simulation tool, for finance courses and for people who enjoy Excel® spreadsheets. It is possible to download the xlsm file from the author’s website at the University of Valencia: www.uv.es/pinyol.

Published

2013-12-31

How to Cite

Piñol-Espasa, J. A. (2013). Diseño de carteras de opciones con Excel. Revista Electrónica De Comunicaciones Y Trabajos De ASEPUMA, 14(2), 169–180. Retrieved from https://revistas.uma.es/index.php/recta/article/view/19966