Diseño de carteras con Excel®
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 graph...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
ASEPUMA. Asociación Española de Profesores Universitarios de Matemáticas aplicadas a la Economía y a la Empresa
2013-12-01
|
| Series: | Rect@ |
| Subjects: | |
| Online Access: | http://urls.my/c1BEGS |
| _version_ | 1828315695770763264 |
|---|---|
| author | Piñol Espasa, José-Agustín |
| author_facet | Piñol Espasa, José-Agustín |
| author_sort | Piñol Espasa, José-Agustín |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-04-13T17:03:32Z |
| format | Article |
| id | doaj.art-a92ee723ede04831a3481f6d8ca522e8 |
| institution | Directory Open Access Journal |
| issn | 1575-605X |
| language | English |
| last_indexed | 2024-04-13T17:03:32Z |
| publishDate | 2013-12-01 |
| publisher | ASEPUMA. Asociación Española de Profesores Universitarios de Matemáticas aplicadas a la Economía y a la Empresa |
| record_format | Article |
| series | Rect@ |
| spelling | doaj.art-a92ee723ede04831a3481f6d8ca522e82022-12-22T02:38:34ZengASEPUMA. Asociación Española de Profesores Universitarios de Matemáticas aplicadas a la Economía y a la EmpresaRect@1575-605X2013-12-01142169180Diseño de carteras con Excel®Piñol Espasa, José-Agustín0Universidad de ValenciaAn 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.http://urls.my/c1BEGSportfoliooptionsstrategyexcelfinance |
| spellingShingle | Piñol Espasa, José-Agustín Diseño de carteras con Excel® Rect@ portfolio options strategy excel finance |
| title | Diseño de carteras con Excel® |
| title_full | Diseño de carteras con Excel® |
| title_fullStr | Diseño de carteras con Excel® |
| title_full_unstemmed | Diseño de carteras con Excel® |
| title_short | Diseño de carteras con Excel® |
| title_sort | diseno de carteras con excel r |
| topic | portfolio options strategy excel finance |
| url | http://urls.my/c1BEGS |
| work_keys_str_mv | AT pinolespasajoseagustin disenodecarterasconexcel |