Portfolio Analytics

Risk and return…


Author

Affiliation

N.F. Katzke

 

Published

Aug. 4, 2024

Citation

Katzke, 2024


In this practical we explore portfolio analytics, specifically calculating downside risk and performance measures.

DIY Section

See the following description, try it yourself and then go through my practical as a guideline. There’s some nice tricks in there too.


You’ve been asked to comment on whether active managers in the local ASISA General Equity universe are taking advantage of the opportunities available to them.

This is a difficult question, as one cannot simply directly compare their performance vs that of an index alternative. This follows as we need to assess what the active manager opportunity set has been over time - i.e. ask the question what the alpha opportunities were.

In order to answer this question, you recall the definition of dispersion to measure the average weighted difference in returns between constituents and a parent index.

Wi×(RiˉR))2

Where Ri is each individual stock’s return, and ˉR the relevant benchmark return.

Naturally, if dispersion is low (high) that means the alpha opportunity (ability to differentiate portfolios) is low (high).

You are tasked to calculate dispersion on a rolling monthly basis (using daily constituent returns series) - and calculate how dispersion has changed through time.

Then assess whether active managers have taken advantage of the opportunity sets available to them over time.

Data to Use

library(tidyverse)
# Constituents:

J200 <- fmxdat::J200

# Index Returns
Indexes <- fmxdat::LCL_Index_Returns %>% filter(Tickers == "J200")

Active_Funds <- fmxdat::ASISA %>% filter(!is.na(Returns))

Solution:

Footnotes

    Citation

    For attribution, please cite this work as

    Katzke (2024, Aug. 5). Financial Econometrics Course: Portfolio Analytics. Retrieved from https://www.fmx.nfkatzke.com/posts/2020-08-07-practical-2/

    BibTeX citation

    @misc{katzke2024portfolio,
      author = {Katzke, N.F.},
      title = {Financial Econometrics Course: Portfolio Analytics},
      url = {https://www.fmx.nfkatzke.com/posts/2020-08-07-practical-2/},
      year = {2024}
    }