Ryan O'Connell, CFA, FRM explains how to calculate Sharpe Ratio in excel. This ratio helps to measure the investment performance of a stock or stock portfolio.
🎓 *Get 25% Off CFA Courses (Featuring My Videos!) — Use code RYAN25 here:*
👉 https://ryano.finance/cfa
💾 Download the file created in this video free here: https://ryanoconnellfinance.com/product/sharpe-ratio-in-excel/
Chapters:
0:00 - Download Stock Price Data with Yahoo Finance
0:40 - Calculate Daily Stock Price Returns
1:46 - Calculate Annual Returns of a Stock
2:54 - Calculate Standard Deviation of a Stock
3:54 - Calculate Sharpe Ratio 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.