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 very much appreciate your videos and efforts to make these concepts understandable. Your spreadsheets are also excellent. Please keep up the great work
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?
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.
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 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.
Nicely presented
I couldn’t find what steering ratio was online. Great explanation!
Excellent video. Keep it up! Thanks
Great Video! Keep it up.
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!
very nice video
Great channel 💯👌🏻
Good video. Thanks
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?
MANY THANKS
Nice video
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.