Ryan O'Connell, CFA, FRM explains stock and investment performance evaluation in Excel. Including the three most common measures of stock performance, Sharpe Ratio, Treynor Ratio & Jensen's Alpha.
👨💼 Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: [ Ссылка ]
🔑 Join this channel to get access to perks & support my work: [ Ссылка ]
🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
► Join me for personalized finance tutoring tailored to your goals: [ Ссылка ]
💾 Download the file created in this video free here: [ Ссылка ]
Chapters:
0:00 - Intro
0:18 - Download Stock Price Data with Yahoo Finance
0:56 - Calculate Daily Stock Price Returns
2:01 - Calculate Sharpe Ratio In Excel
4:49 - Calculate Treynor Ratio In Excel
6:42 - Calculate Jensen's Alpha In Excel
Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC. Some of the links above are affiliate links, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.
