Adjusting for downside risk: Calmar, Sterling, and Sortino (Excel)
HTML-код
- Опубликовано: 30 июл 2024
- Is the standard deviation the best measure for portfolio risk? Some would argue not, as it is taking into account the upside risk together with the downside risk. There are risk-adjusted return measures that improve upon Sharpe ratio in that regard. Today we are investigating the concepts of drawdown and semideviation as well as the portfolio performance measures that are built upon them, namely, Calmar, Sterling, and Sortino ratios.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Finance!
Please consider supporting NEDL on Patreon: / nedleducation
You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7
Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation
I couldn’t find what steering ratio was online. Great explanation!
I very much appreciate your videos and efforts to make these concepts understandable. Your spreadsheets are also excellent. Please keep up the great work
Hi Joe, and thanks so much for such kind words.
Excellent video. Keep it up! Thanks
Great Video! Keep it up.
Excellent and very usefull video. Thanks a lot
Good video. Thanks
very nice video
Great channel 💯👌🏻
MANY THANKS
Nice video
The videos are very helpful, thanks a lot.
Can we calculate portfolio weights that maximize the Calmar (Sterling-Sortino) ratio in Excel?
Hi Selim, and glad you liked the video! Yes, you can use Excel Solver to optimise the weights of a portfolio, referring to a preferred ratio as your objective function. I show how to implement Solver to calibrate portfolio weights, for example, here: ruclips.net/video/aBA3U1iNC7s/видео.html Hope it helps!
If you download the risk-free rate from FRED (such as the 3TBMS), Is the rate annualized even though the data frequency is monthly? Do i have to divide it by 12 to get the monthly rate? Lets assume i want to find the sharpe ratio and the sortino ratio for nasdaq, which risk free rate is appropriate from 2013 to 2022?
NEDL_DownsideRisk.xlsx the Spreadsheet still there? Cant find. TQ.
Hi Alex, have updated the portfolio evaluation file to include downside-risk adjusted measures. Hope it helps!
The way you calculated semivariance in the spread sheet is different to the way you explain here. Why is it?
sir may u sharing that file on google sheets?
I want to know the formula and how to do it. Thx :)
Hi Muhammad and thanks for the suggestion! All the spreadsheets are now uploaded to Google Drive. Please check out the pinned comments under each video. Hope it helps.