IDEAS home Printed from https://ideas.repec.org/p/zbw/hawdps/12.html
   My bibliography  Save this paper

Performancemessung: Theoretische Maße und empirische Umsetzung mit VBA

Author

Listed:
  • Seitz, Franz
  • Auer, Benjamin R.

Abstract

Neben einer theoretischen Analyse ausgewählter klassischer und moderner Performancemaße präsentieren wir in diesem Papier eine speziell zum Zweck der Performanceanalyse entwickelte Erweiterung des Funktionsumfanges von MS-Excel. Der vorgestellte VBA-Quellcode ermöglicht es, die beschriebenen Maße über neuartige MS-Excel-Funktionen aus vorliegenden Renditezeitreihen zu berechnen, um diese dann z.B. für das Ranking von Fonds zu verwenden.

Suggested Citation

  • Seitz, Franz & Auer, Benjamin R., 2008. "Performancemessung: Theoretische Maße und empirische Umsetzung mit VBA," Weidener Diskussionspapiere 12, University of Applied Sciences Amberg-Weiden (OTH).
  • Handle: RePEc:zbw:hawdps:12
    as

    Download full text from publisher

    File URL: https://www.econstor.eu/bitstream/10419/56439/1/589023306.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. William F. Sharpe, 1965. "Mutual Fund Performance," The Journal of Business, University of Chicago Press, vol. 39, pages 119-119.
    2. Roll, Richard, 1977. "A critique of the asset pricing theory's tests Part I: On past and potential testability of the theory," Journal of Financial Economics, Elsevier, vol. 4(2), pages 129-176, March.
    3. Fama, Eugene F, 1991. "Efficient Capital Markets: II," Journal of Finance, American Finance Association, vol. 46(5), pages 1575-1617, December.
    4. Dowd, Kevin, 2000. "Adjusting for risk:: An improved Sharpe ratio," International Review of Economics & Finance, Elsevier, vol. 9(3), pages 209-222, July.
    5. William F. Sharpe, 1964. "Capital Asset Prices: A Theory Of Market Equilibrium Under Conditions Of Risk," Journal of Finance, American Finance Association, vol. 19(3), pages 425-442, September.
    6. Gibbons, Michael R & Ross, Stephen A & Shanken, Jay, 1989. "A Test of the Efficiency of a Given Portfolio," Econometrica, Econometric Society, vol. 57(5), pages 1121-1152, September.
    7. Treynor, Jack L & Black, Fischer, 1973. "How to Use Security Analysis to Improve Portfolio Selection," The Journal of Business, University of Chicago Press, vol. 46(1), pages 66-86, January.
    8. Antonio E. Bernardo & Olivier Ledoit, 2000. "Gain, Loss, and Asset Pricing," Journal of Political Economy, University of Chicago Press, vol. 108(1), pages 144-172, February.
    9. Jobson, J D & Korkie, Bob M, 1981. "Performance Hypothesis Testing with the Sharpe and Treynor Measures," Journal of Finance, American Finance Association, vol. 36(4), pages 889-908, September.
    10. Eling, Martin & Schuhmacher, Frank, 2007. "Does the choice of performance measure influence the evaluation of hedge funds?," Journal of Banking & Finance, Elsevier, vol. 31(9), pages 2632-2647, September.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Keith Cuthbertson & Dirk Nitzsche & Niall O' Sullivan, 2004. "UK Mutual Fund Performance: Genuine Stock-Picking Ability or Luck," Money Macro and Finance (MMF) Research Group Conference 2004 55, Money Macro and Finance Research Group.
    2. Dimson, Elroy & Mussavian, Massoud, 1999. "Three centuries of asset pricing," Journal of Banking & Finance, Elsevier, vol. 23(12), pages 1745-1769, December.
    3. To, Minh Chau & Assoé, Kodjovi Gakpo, 1995. "Performance et commission de souscription des fonds mutuels canadiens," L'Actualité Economique, Société Canadienne de Science Economique, vol. 71(1), pages 27-52, mars.
    4. Committee, Nobel Prize, 2013. "Understanding Asset Prices," Nobel Prize in Economics documents 2013-1, Nobel Prize Committee.
    5. Zakamouline, Valeri & Koekebakker, Steen, 2009. "Portfolio performance evaluation with generalized Sharpe ratios: Beyond the mean and variance," Journal of Banking & Finance, Elsevier, vol. 33(7), pages 1242-1254, July.
    6. Teresa Garcia & Daniel Borrego, 2017. "Markowitz Efficient Frontier And Capital Market Line – Evidence From The Portuguese Stock Market," Portuguese Journal of Management Studies, ISEG, Universidade de Lisboa, vol. 22(1), pages 3-23.
    7. Motohiro Yogo, 2006. "A Consumption‐Based Explanation of Expected Stock Returns," Journal of Finance, American Finance Association, vol. 61(2), pages 539-580, April.
    8. Enrique Sentana, 2009. "The econometrics of mean-variance efficiency tests: a survey," Econometrics Journal, Royal Economic Society, vol. 12(3), pages 65-101, November.
    9. Kaserer Christoph & Hanauer Matthias X., 2017. "25 Jahre Fama-French-Modell: Erklärungsgehalt, Anomalien und praktische Implikationen," Perspektiven der Wirtschaftspolitik, De Gruyter, vol. 18(2), pages 98-116, June.
    10. Massimiliano Caporin & Grégory M. Jannin & Francesco Lisi & Bertrand B. Maillet, 2014. "A Survey On The Four Families Of Performance Measures," Journal of Economic Surveys, Wiley Blackwell, vol. 28(5), pages 917-942, December.
    11. Babalos, Vassilios & Caporale, Guglielmo Maria & Philippas, Nikolaos, 2012. "Efficiency evaluation of Greek equity funds," Research in International Business and Finance, Elsevier, vol. 26(2), pages 317-333.
    12. Renault, Éric & Rochet, Jean-Charles, 1997. "Les techniques quantitatives de la gestion de portefeuille," L'Actualité Economique, Société Canadienne de Science Economique, vol. 73(1), pages 265-310, mars-juin.
    13. Kajtazi, Anton & Moro, Andrea, 2019. "The role of bitcoin in well diversified portfolios: A comparative global study," International Review of Financial Analysis, Elsevier, vol. 61(C), pages 143-157.
    14. Lu Zhang, 2017. "The Investment CAPM," European Financial Management, European Financial Management Association, vol. 23(4), pages 545-603, September.
    15. Lu Zhang, 2019. "Q-factors and Investment CAPM," NBER Working Papers 26538, National Bureau of Economic Research, Inc.
    16. Chen, Qi-An & Li, Huashi & Lin, Jianyi & Yan, Youliang, 2023. "Asset pricing with two types of heterogeneous consumption volatilities in mind: Evidence from China," Pacific-Basin Finance Journal, Elsevier, vol. 77(C).
    17. García Iborra, Rafael & Howden, David, 2016. "Uses and Misuses of Arbitrage in Financial Theory, and a Suggested Alternative," MPRA Paper 79802, University Library of Munich, Germany.
    18. Shafiqur Rahman & Matthew J. Schneider, 2019. "Tests of Alternative Asset Pricing Models Using Individual Security Returns and a New Multivariate F-Test," Review of Pacific Basin Financial Markets and Policies (RPBFMP), World Scientific Publishing Co. Pte. Ltd., vol. 22(01), pages 1-34, March.
    19. Trabelsi, Mohamed Ali, 2010. "Choix de portefeuille: comparaison des différentes stratégies [Portfolio selection: comparison of different strategies]," MPRA Paper 82946, University Library of Munich, Germany, revised 01 Dec 2010.
    20. Bosch-Badia, Maria Teresa & Montllor-Serrats, Joan & Tarrazon-Rodon, Maria-Antonia, 2014. "Unveiling the embedded coherence in divergent performance rankings," Journal of Banking & Finance, Elsevier, vol. 42(C), pages 154-165.

    More about this item

    Keywords

    Performancemaße; Fonds; Ranking; Excel; VBA;
    All these keywords.

    JEL classification:

    • G11 - Financial Economics - - General Financial Markets - - - Portfolio Choice; Investment Decisions
    • C60 - Mathematical and Quantitative Methods - - Mathematical Methods; Programming Models; Mathematical and Simulation Modeling - - - General
    • C88 - Mathematical and Quantitative Methods - - Data Collection and Data Estimation Methodology; Computer Programs - - - Other Computer Software

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:zbw:hawdps:12. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: ZBW - Leibniz Information Centre for Economics (email available below). General contact details of provider: http://www.oth-aw.de/ .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.