Quantitative Finance

Join Ryan O’Connell, CFA, FRM, as he delves deep into the fascinating world of log returns in finance, shining a spotlight on Euler’s number (e) and the intricacies of continuous compounding. From understanding the basics of simple annual compounding to mastering the complexities of logarithmic returns in Excel, this comprehensive guide has you covered. Whether you’re a finance professional, student, or enthusiast, this video is your key to unlocking the power of ‘e’ in the financial realm. Don’t miss out on this essential tutorial on continuous compounding and the magic of log returns!

🎓 *Get 25% Off CFA Courses (Featuring My Videos!) — Use code RYAN25 here:*
👉 https://ryano.finance/cfa

💾 Download Free Excel File:
► Grab the file from this video here: https://ryanoconnellfinance.com/product/log-returns-introductory-excel-toolkit/

Chapters:
0:00 – Simple Annual Compounding of Interest
2:26 – Monthly Compounding of Interest
4:37 – Continuous Compounding (Euler’s Number – e)
7:36 – Logarithmic Returns Explained
9:57 – Logarithmic Returns 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.

Join Ryan O’Connell, CFA, FRM, as he dives deep into Calculating Macauley, Modified, and Effective Bond Durations using Excel. Starting with the basics of calculating the present value of a semi-annual bond, this tutorial will guide you step-by-step through the intricacies of bond duration calculations. Bond duration is a key concept for understanding interest rate risk. Whether you’re a finance professional or just keen to learn, this video offers valuable insights and hands-on techniques. Don’t forget to like, share, and subscribe for more expert finance tutorials!

💾 Purchase the file created in this video here: https://ryanoconnellfinance.com/product/excel-bond-duration-calculator-macauley-modified-and-effective/

🎓 *Get 25% Off CFA Courses (Featuring My Videos!) — Use code RYAN25 here:*
👉 https://ryano.finance/cfa

Chapters:
0:00 – Intro to Calculating Bond Durations in Excel
0:13 – Calculating the Present Value of Semi-Annual Bond
2:37 – Calculate Macauley Duration
4:05 – Calculate Modified Duration
5:21 – Calculate Effective Duration

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.

Get ready to dive deep into financial modeling with ‘Black Scholes Option Pricing Model Explained In Excel’. This step-by-step tutorial will take you through the entire process, from declaring the Black Scholes inputs, to calculating the critical D1 and D2 values, all the way to valuing both Call and Put options. Plus, we’ll delve into the crucial implications of the Black Scholes Model to give you a comprehensive understanding of this invaluable tool. Join us and enhance your skill set, whether you’re a beginner or just need a refresher on the Black Scholes model in Excel

🎓 *This Video Is Part of My Full Options Trading Course:*
Go deeper with step-by-step lessons, paper trading practice, and downloadable resources.
👉 https://ryano.finance/options-course

📈 *See Why I Recommend This Broker For Options:* https://ryano.finance/ibkr-options

📚 *Get 25% Off CFA Courses (Featuring My Videos!) — Use code RYAN25 here:*
✅ https://ryano.finance/cfa

💾 *Download Free Excel File Here:* https://ryanoconnellfinance.com/product/black-scholes-option-pricing-model-excel-workbook/

Chapters:
0:00 – Declare the Black Scholes Inputs
1:46 – How to Calculate D1
2:54 – How to Calculate D2
3:24 – Value a Call Option
5:36 – Value a Put Option
7:51 – Implications of the Black Scholes Model

*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

Delve into the world of portfolio optimization with our step-by-step guide on ‘Efficient Frontier Explained in Excel: Plotting a 3-Security Portfolio.’ Learn to calculate expected returns and standard deviation for individual securities, assign random weights, and effectively use the Sharpe Ratio and Covariance Matrix for risk management. We conclude with plotting the Efficient Frontier using Monte Carlo Simulation, helping you identify the optimal portfolio.

💾 Purchase the file created in this video here: https://ryanoconnellfinance.com/product/efficient-frontier-mastery-excel-workbook-for-multiple-security-portfolio/

🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
► Join me for personalized finance tutoring tailored to your goals: https://ryanoconnellfinance.com/finance-tutoring/

👨‍💼 My Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: https://ryanoconnellfinance.com/freelance-finance-services/

Chapters:
0:00 – Intro to “Efficient Frontier Explained”
0:41 – Calculate Expected Returns: Individual Securities
3:30 – Calculate Standard Deviation: Individual Securities
4:31 – Assign Random Weights
5:40 – Calculate Total Portfolio Expected Return
6:13 – Create Covariance Matrix
8:31 – Calculate Total Portfolio Standard Deviation
9:29 – Calculate Sharpe Ratio
10:42 – Plot Efficient Frontier Using Monte Carlo Simulation
12:17 – Find the Optimal Portfolio: Portfolio Optimization

*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

Join Ryan O’Connell, CFA, FRM, in “Value at Risk (VaR) In Python: Historical Method,” as he explores financial risk management. The tutorial covers setting up Python, selecting stock tickers, downloading Adjusted Close Prices from yFinance, and calculating daily log returns for individual stocks. You’ll also create an equally weighted portfolio and compute its total daily returns. Finally, O’Connell guides you through calculating VaR and plotting the results on a bell curve. This tutorial is perfect for financial analysts and Python enthusiasts.

📈 *See Why I Recommend This Broker:* https://ryano.finance/ibkr-overview

💻 *Find the Code Written In this Video Here:* https://ryanoconnellfinance.com/value-at-risk-analysis-using-python/

🎓 *Columbia AI for Business & Finance Certificate Program* 🎓
► *Use code RYAN for up to $500 Off:* https://ryano.finance/columbia-ai

Chapters:
0:00 – Intro to “Value at Risk (VaR) In Python”
0:19 – Installing Necessary Libraries
0:48 – Set Time Range of Historical Returns
1:59 – Choose Your Stock Tickers
2:39 – Download Adjusted Close Prices from yFinance
4:19 – Calculate Individual Stock Daily Log Returns
6:11 – Create an Equally Weighted Portfolio
7:15 – Calculate Total Portfolio Daily Returns
8:10 – Find Portfolio Returns for a Range of Days
9:23 – Calculate Value at Risk (VaR)
11:44 – Plot the Results on a Bell Curve

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.

“Portfolio Optimization in Excel: Step by Step Tutorial” is your ultimate resource for mastering portfolio management techniques using Excel. This tutorial will walk you through step-by-step instructions on how to maximize returns and minimize risk, leveraging data-driven strategies for smarter investment decisions. Whether you’re a novice investor or a seasoned portfolio manager, this video will provide you with the tools and insights needed to optimize your portfolio effectively.

💾 *Purchase the file created in this video here:* https://ryanoconnellfinance.com/product/investment-portfolio-optimizer-excel-workbook/

📈 *Checkout my preferred broker for Portfolio Management:*
https://ryano.finance/ibkr-overview

Chapters:
0:00 – Intro to “Portfolio Optimization in Excel”
0:48 – Inputs Required to Find the Optimal Portfolio
1:18 – Calculating the Expected Return of Individual Securities
5:30 – Calculating the Standard Deviation of Individual Securities
6:57 – Assigning Minimum & Maximum Weights
7:43 – Creating the Covariance Matrix
10:10 – Calculate Portfolio Standard Deviation
11:17 – Calculate Portfolio Expected Return
11:51 – Find the Risk-Free Rate of Return
12:16 – Find the Optimal Portfolio 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

Discover the power of Python for risk analysis in our tutorial ‘Value at Risk (VaR) In Python: Monte Carlo Method.’ We delve deep into the world of financial risk, breaking down the complex Monte Carlo method and its application in calculating VaR. Whether you’re a financial analyst, data scientist, or Python enthusiast, this video will provide you with practical, actionable knowledge. Get ready to master the art of risk prediction using Monte Carlo simulations in Python!

📈 *See Why I Recommend This Broker:* https://ryano.finance/ibkr-overview

💻 *Find the Code Written In this Video Here:* https://ryanoconnellfinance.com/monte-carlo-value-at-risk-python/

🎓 *Columbia AI for Business & Finance Certificate Program* 🎓
► *Use code RYAN for up to $500 Off:* https://ryano.finance/columbia-ai

Chapters:
0:00 – Intro to “Value at Risk (VaR) In Python”
0:15 – Installing Necessary Libraries
0:43 – Set Time Range of Historical Returns
1:54 – Choose You’re Stock Tickers
2:34 – Download Adjusted Close Prices from yFinance
4:14 – Calculate Daily Log Returns
6:06 – Calculate Portfolio Expected Return
7:52 – Calculate Portfolio Standard Deviation
10:11 – Create an Equally Weighted Portfolio
11:35 – Determine Z-Scores Randomly
12:25 – Calculate Scenario Gains & Losses
14:20 – Run 10,000 Simulations (Monte Carlo Method)
15:35 – Specify Confidence Interval Level & Calculate VaR
17:49 – Plot the Results on a Bell Curve

*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