CVaR Portfolio Optimization

CVaR Portfolio Optimization


Get a Free Trial: https://goo.gl/C2Y9A5
Get Pricing Info: https://goo.gl/kDvGHt
Ready to Buy: https://goo.gl/vsIeA5
Create and optimize Conditional Value at Risk portfolios. For more videos, visit http://www.mathworks.com/products/fin...
Closed Caption:

in this video we will show conditional
value at risk portfolio optimization
in the financial tool box using the
portfolio see bar
object using these tools you can perform
your entire portfolio optimization
workflow
from defining the portfolio problem to
evaluating the efficient frontier
to setting up a record of purchase and
sales conditional value-at-risk
or CPR takes a look at the losses
and the tail and at the distribution of
scenarios for example
Cech's my part folio and calculate the
losses for several different scenarios
the losses might look something like
this: pot
where the scenarios with the highest
loss are on the right
redefine a probability level
here it's 95 percent and consider the
scenarios
whose losses exceed this level the
ninety-five percent mean
conditional value-at-risk is defined as
the average
up the losses in these scenarios now
let's see how the tools can be used
first will load in daily close prices
for some large-cap stocks small-cap
stocks
and body T acts the data is coming from
my yahoo connection
you can also connect to Bloomberg fax at
Thompson Reuters and others using the
debt a fee to a box
will convert the close prices to returns
data for our analysis
and then do a quick sanity check on the
returns to make sure everything looks
right
as expected the small-cap stocks have a
higher variance at the returns
well the bond ETF Sperry lasts will
combine all about
turns data into a single matrix to be
used in the analysis
everything I need for setting up the CVR
portfolio problem is right here
I start by creating a portfolio C var
object
and then use the methods that object to
specify the assets in my portfolio
the returns data the basic portfolio
weight constraints
and the probability level but defining
the probability level to be 0.95
rich using to minimize the average loss
in the five percent of portfolios with
the highest law sis
now we have everything to find
that we need for the CPR portfolio
optimization problem
so let's plot 10 portfolios along the
efficient frontier
here we have the CVR efficient frontier
which is the mean portfolio return
plotted against the mean conditional
value at risk
it's a good idea to compare the results
are different portfolio optimization
models
to see if they agree another common
portfolio optimization
formulation is mean variance if we look
at an example product portfolio returns
the mean variance risk is the variance
out one segment standard deviations
it's important to note that this method
assumes that the returns are well
approximated by a normal distribution
so let's calculate the mean variance
efficient frontier
and compare it to our CPR fronteer the
workflow is very similar to the CFR Part
fully a workflow
except that we use the estimate asset
moments method now
estimate the mean and covariance are
returned data
will calculate the efficient frontier
for this portfolio
but if I would like to compare this
result to my seat I result I need a way
to convert from one risk measure to the
other
well one way to do this is to calculate
the mean variance risk
up the CFR Part folios and then at the
converted frontier
to the mean variance pot as you can see
the frontiers are similar with some
differences in these areas
a different way to compare the results
is to look at the weights at the
efficient portfolios will visualize the
weights side by side using an area
lot this allows us to see where the
allocation differences are
in our efficient portfolios
while the
tears were somewhere for these two risk
measures the allocation of certain
assets
for example a GG various quite a bit
at this point we might want to do some
further investigation
to see whether results at the portfolio
optimization step for
let's look at a histogram at the returns
for our body T aP's
if we try to fit a normal distribution
to this data
it becomes evident that a normal
distribution may not be a good
assumption to make
this helps explain the difference
between army invariance portfolio
which assumes that returns are normally
distributed and RC car port folio
which uses simulations that don't
necessarily need to be normal
this demonstration showed some other
more commonly used features perceive our
portfolios
with the CVR portfolio object you can
also specify buy and sell costs per
individual assets
and sect group and turnover constraints
which allow you to place an upper bound
other purchases and sales for more
information
please select the link from this page or
return to the financial tool box page

Video Length: 05:38
Uploaded By: MATLAB
View Count: 6,837

Related Software Products
Portfolio Optimization
Portfolio Optimization

Published By:
Business Spreadsheets

Description:
The Portfolio Optimization model calculates the optimal capital weightings for a basket of financial investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions. The key features of the Portfolio Optimization ...


Related Videos
Portfolio Optimization in Excel.mp4
Portfolio Optimization in Excel.mp4

This is a video created by Dr. Colby Wright demonstrating how to use the matrix algebra and solver functions in Excel in order to optimize the weights within a portfolio comprised of more than two assets. Please note, this is limited to mean-variance optimization and does not consider higher moments (such as skewness and kurtosis). This method of optimizing portfolio weights also assumes that the distribution of past returns is reflective of the distribution of future returns, which is often ...
Video Length: 19:22
Uploaded By: Colby Wright
View Count: 202,178

Optimal portfolios with Excel Solver
Optimal portfolios with Excel Solver

This is an instuction video on how to use Excel's solver for calculating efficient portfolios hr / bClosed Caption:/b this is alkyl planta and i'm going to show you in this movie how to calculate the portfolio and short sales constraint and i'm using an example with five different assets ABC and D and E and have the expected returns and standard deviations in the columns B and C and here we have the covariance ...
Video Length: 06:23
Uploaded By: Auke Plantinga
View Count: 163,688

Generating the Variance-Covariance Matrix
Generating the Variance-Covariance Matrix

This is a follow-up video to a video posted previously by Dr. Colby Wright explaining how to execute mean-variance portfolio optimization in Excel. This video demonstrates how to generate the variance-covariance matrix, which is necessary in order to calculate the portfolio standard deviation. Dr. Wright also demonstrates how to transform the var-cov matrix into the correlation matrix. hr / bClosed Caption:/b hello everyone this is dr. right again a couple months ...
Video Length: 18:42
Uploaded By: Colby Wright
View Count: 156,335

Tutorial: Constructing Efficient Frontier using Markowitz model
Tutorial: Constructing Efficient Frontier using Markowitz model

This tutorial shows how to calculate portfolio efficient frontier comprised of common stocks. It relies on Markowitz model and mean-variance optimization. All calculations are performed in Microsoft Excel with the help of Solver add-in in MS Excel. The data and examples are posted here: http://valexeev.yolasite.com/teaching.php hr / bClosed Caption:/b hello everyone the tutorial on constructing the portfolio efficient frontier using the workers model thebr ...
Video Length: 15:48
Uploaded By: Vitali Alexeev
View Count: 34,738

Efficient Frontier
Efficient Frontier

In this video, Dr Paul Docherty from The University of Newcastle (Australia) describes the portfolio optimisation and the efficient frontier. The video includes a demonstration of how Microsoft Excel's Solver addin can be used to derive the efficient frontier. hr / bClosed Caption:/b I'm going to this instructional video on how to derive the efficient frontier using Microsoft XO this video has been created for students and portfolio management ...
Video Length: 24:06
Uploaded By: Paul Docherty
View Count: 26,347

Portfolio Construction using R
Portfolio Construction using R

Create a portfolio of stocks using stock price histories downloaded from Yahoo. We create an efficient frontier for a long-only portfolio and show how to graphically display the risk-return tradeoff and the allocations. We next show how to compare frontiers created with other constraints and compare them to the original long-only frontier the R code is available on http://wp.me/pTp8L-3j hr / bClosed Caption:/b in this video we'll look at portfolio construction ...
Video Length: 07:58
Uploaded By: Elliot Noma
View Count: 17,719

Getting Started with Portfolio Optimization
Getting Started with Portfolio Optimization

Get a Free Trial: https://goo.gl/C2Y9A5 Get Pricing Info: https://goo.gl/kDvGHt Ready to Buy: https://goo.gl/vsIeA5 Create and optimize portfolios of assets using the portfolio object in Financial Toolbox, together with Datafeed Toolbox. For more videos, visit http://www.mathworks.com/products/fin... hr / bClosed Caption:/b this video will show you how to use the portfolio object to formulate and solve a range of asset allocation problemsbr ...
Video Length: 13:36
Uploaded By: MATLAB
View Count: 13,224

Portfolio Optimization
Portfolio Optimization

www.vosesoftware.com. ModelRisk is the most advanced risk modeling software in the world. To download your 30 day free trial, please visit: www.vosesoftware.com/trial.php hr / bClosed Caption:/b during this tutorial we will be highlighting it AP portfolio optimization model as a vehicle for highlighting several features model risk in particular the optimization functionality built into model riskbr ...
Video Length: 09:47
Uploaded By: ModelRisk
View Count: 10,430

Value at Risk - based Portfolio Optimization
Value at Risk - based Portfolio Optimization

Dr. Emanuele Canegrati explains the future of Portfolio Optimization Techniques which respects Basle II Protocol to manage the market risks of banks and financial institutions hr / bClosed Caption:/b hello everybody and I want to discuss today the value at risk the spur for the optimization which he is and may appear in very useful to which in the future as whose will be a sort of benchmarks for four you up to ease ...
Video Length: 10:44
Uploaded By: quantsfinance
View Count: 7,225

Investment Science: Portfolio Optimization
Investment Science: Portfolio Optimization

Tucker Balch, Ph.D., Lucena's CTO describes the science and algorithms behind portfolio optimization. hr / bClosed Caption:/b Hall hot of of home of I am after soccer ball with him soon research and in this video minute tell you about portfolio optimization now this video is about the science a portfolio optimization there's another video that tells you how to use the portfolio optimizer ...
Video Length: 18:09
Uploaded By: Tucker Balch
View Count: 7,087

Copyright © 2025, Ivertech. All rights reserved.