# Case Study: Estimation of CVaR through Explanatory Factors with Mixed Quantile Regression

Back to main page

Case study background and problem formulations

Instructions for optimization with PSG Run-File, PSG MATLAB Toolbox, PSG MATLAB Subroutines and PSG R.

PROBLEM 1: problem_ro_err_Mixed_Percentile_Regression

Minimize Rockafellar Error Function (ro_err)
——————————————————————–
ro_err = Rockafellar Error Function
——————————————————————–
Dataset 9 1,264 0.015412 0.01 # of Variables # of Scenarios Objective Value Solving Time, PC 3.14GHz (sec) Environments Run-File Problem Statement Data Solution Matlab Toolbox Data Matlab Subroutines Matlab Code Data R R Code Data
PROBLEM 2: problem_pm_Mixed_Percentile_Regression
Minimize Rockafellar Error Function (weighted average of Pm_pen and Pm_pen_g)
subject to
Linear = 0 (constraint on additional variables)
——————————————————————–
Pm_pen = Partial Moment Penalty for Loss
Pm_pen_g = Partial Moment Penalty for Gain
——————————————————————–
Data and solution in Run-File Environment

Problem Datasets # of Variables # of Scenarios Objective Value Solving Time, PC 2.66GHz (sec)
Dataset1 Problem Statement Data Solution 9 1,264 0.015412 0.02
Data and solution with PSG MATLAB Subroutines

Problem Datasets # of Variables # of Scenarios Objective Value Solving Time, PC 3.50GHz (sec)
Dataset1 Matlab code Data Solution 9 1,264 0.0154118 0.04
Data and solution with PSG R Subroutines

Problem Datasets # of Variables # of Scenarios Objective Value Solving Time, PC 3.50GHz (sec)
Dataset1 R code Data 9 1,264 0.0154118 0.04
PROBLEM 3: problem_multiple_percentile_regression_in_one_shot_kb_err
Minimize Error Function (weighted average of kb_err)
subject to
Linearmulti = 0 (constraint on additional variables)
——————————————————————–
kb_err = Koenker and Basset error function
——————————————————————–

Data and solution in Run-File Environment

Problem Datasets # of Variables # of Scenarios Objective Value Solving Time, PC 2.66GHz (sec)
Dataset1 Problem Statement Data Solution 9 1,264 0.015317 0.03
Data and solution with PSG MATLAB Subroutines

Problem Datasets # of Variables # of Scenarios Objective Value Solving Time, PC 3.50GHz (sec)
Dataset1 Matlab code Data Solution 9 1,264 0.015317 0.05
PROBLEM 4: problem_multiple_percentile_regression_in_one_shot_pm
Minimize Error Function (weighted average of Pm_pen and Pm_pen_g)
subject to
Linearmulti = 0 (constraint on additional variables)
——————————————————————–
Pm_pen = Partial Moment Penalty for Loss
Pm_pen_g = Partial Moment Penalty for Gain
——————————————————————–

Data and solution in Run-File Environment

Problem Datasets # of Variables # of Scenarios Objective Value Solving Time, PC 2.66GHz (sec)
Dataset1 Problem Statement Data Solution 9 1,264 0.015317 0.05
Data and solution with PSG MATLAB Subroutines

Problem Datasets # of Variables # of Scenarios Objective Value Solving Time, PC 3.50GHz (sec)
Dataset1 Matlab code Data Solution 9 1,264 0.0153171 0.14

CASE STUDY SUMMARY

This case study applies Mixed Percentile Regression for the estimation of Conditional Value-at-Risk (CVaR) of return distribution of a mutual fund.
The approach is similar to the percentile regression used by Bassett and Chen (2001) for the estimation of the tail percentile of the return distribution of the mutual fund. Bassett and Chen (2001) regresses the percentile of the fund return by several indices. The estimated coefficients represent the fund’s style with respect to each of the indices, and therefore the procedure is called “style classification.”
We regresses CVaR of the return distribution of the Fidelity Magellan Fund on the Russell Value Index (RUJ), RUSSELL 1000 VALUE INDEX (RLV), Russell 2000 Growth Index (RUO) and Russell 1000 Growth Index (RLG). We want to calculate coefficients for the explanatory variables of the tail of the distribution of residuals (these coefficients may differ from the regression coefficients for the mean and the median of the distribution). 0.9-CVaR with confidence level 0.9 is approximated by the weighted average of four Value-at-Risks (VaRs) with confidence levels 0.92, 0.94, 0.96, 0.98 .
We regressed CVaR of the return distribution by minimizing Rockafellar Error Function (which is a standard PSG function named, roerror), see, Optimization Problem 1. We have also minimized Rockafellar error function by using the PSG Partial Moments Functions, see, Optimization Problem 2.
The case study “Style Classification with Quantile Regression” estimates quantile with some confidence level by minimizing Koenker and Basset error function (which is a standard PSG function named, kberror).
One can run several quantile regressions for different confidence levels (by minimizing Koenker and Basset error function with these confidence levels). Then, these quantiles can be summed up with some weights to estimate CVaR. Alternatively, as shown by Harsha, Natarajan, and Subramanian (2013), one can solve just a single optimization problem and the resulting solution vector will be equal to the weighted average of quantiles obtained with individual quantile regressions, see Optimization Problem 3 and Optimization Problem 4, in this case study.

References

• Bassett, G.W., and H-L. Chen (2001): Portfolio Style: Return-based Attribution Using Quantile Regression. Empirical Economics 26, 293-305.
• Rockafellar, R.T. and S. Uryasev (2013): The Fundamental Risk Quadrangle in Risk Management, Optimization, and Statistical Estimation. Surveys in Operations Research and Management Science, 18 (to appear).
• Harsha, P., Natarajan, R., and D. Subramanian (2013): A Data-driven Approach for the Price-setting Newsvendor Problem with Applications. Paper draft, January 25, 2013.