Portfolio Management

Optimize your investment strategy with AI-powered portfolio optimization using a smart spreadsheet tool! In this video, you’ll learn how to set up an AI spreadsheet, retrieve historical stock prices, and calculate key portfolio metrics like returns, standard deviations, and the Sharpe ratio. Follow along as we install the necessary libraries, select an AI model, and perform portfolio optimization to maximize risk-adjusted returns. Whether you’re a beginner or an experienced investor, this step-by-step guide will help you automate data-driven investment decisions. Sign up for free, download the prompts, and start optimizing your portfolio today!

🤖 *Sign Up For Free AI-Spreadsheet Software:* https://www.quadratic.ai/ryan
Use Code RYANFINANCE for $10 Off Your Subscription

📝 *Download The AI Prompts Used In This Video:* https://drive.google.com/uc?export=download&id=19TrfBGYL-OHlUOksdWSJbv1UfeKXTqHG

💾 *Copy Free File Created In This Video:* https://www.quadratichq.com/templates/asset-allocation-calculator

📊 *Get a Free FRED API Key:* https://fred.stlouisfed.org/docs/api/api_key.html

Chapters
0:00 – Intro to Portfolio Optimization With AI-Powered Spreadsheet
0:21 – Sign Up For Free AI Spreadsheet Software Account
0:39 – Create a New File
0:51 – Download Prompts Used Throughout Video
1:13 – Select AI-Model
2:17 – Install Necessary Libraries
3:06 – Retrieve Historical Stock Prices
5:29 – Calculate Daily Stock Returns
9:10 – Annualize Returns And Standard Deviations
11:33 – Equally Weight the Portfolio
12:37 – Calculate Portfolio Standard Deviation
16:23 – Calculate Portfolio Return
18:25 – Retrieve the Risk Free Rate
21:15 – Measure Risk-Adjusted Return: Sharpe Ratio
22:56 – Perform a 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. 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.

Learn how to perform a Maximum Drawdown Calculation in Excel and understand its significance in portfolio risk analysis. In this video, we cover the Maximum Drawdown Meaning, step through the Maximum Drawdown Explained section, and demonstrate how to compute it using Maximum Drawdown Excel techniques. You’ll also see a Maximum Drawdown example with real-world data to help you apply this key risk metric to your own investments. Whether you’re a trader, investor, or finance professional, mastering Maximum Drawdown is essential for evaluating downside risk and protecting your portfolio. Maximum Drawdown is also known as Max Drawdown and is a downside risk measurement.

📈 *The Broker That Calculates Max Drawdown For You:* https://ryano.finance/ibkr-overview

💾 *Download Free Excel File Here:* https://ryanoconnellfinance.com/product/max-drawdown-calculation/

Chapters:
0:00 – Maximum Drawdown Definition & Formula
0:39 – Maximum Drawdown Explained
1:47 – Maximum Drawdown Calculation in Excel
4:00 – Real World Example of Maximum Drawdown

*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.

This content is provided by a paid Influencer of Interactive Brokers. Influencer is not employed by, partnered with, or otherwise affiliated with Interactive Brokers in any additional fashion. This content represents the opinions of Influencer, which are not necessarily shared by Interactive Brokers. The experiences of the Influencer may not be representative of other customers, and nothing within this content is a guarantee of future performance or success.

None of the information contained herein constitutes a recommendation, promotion, offer, or solicitation of an offer by Interactive Brokers to buy, sell or hold any security, financial product or instrument or to engage in any specific investment strategy. Investment involves risks. Investors should obtain their own independent financial advice and understand the risks associated with investment products and services before making investment decisions. Risk disclosure statements can be found on the Interactive Brokers website.

Interactive Brokers is a FINRA registered broker and SIPC member, as well as a National Futures Association registered Futures Commission Merchant. Interactive Brokers provides execution and clearing services to its customers. For more information regarding Interactive Brokers or any Interactive Brokers products or services referred to in this video, please visit www.interactivebrokers.com.

The projections or other information regarding the likelihood of various investment outcomes generated by the Tools mentioned in this video are hypothetical in nature, do not reflect actual investment results, and are not guarantees of future results. It is important to understand that these projections are based on certain assumptions and models, and actual outcomes may differ significantly. Please note that results may vary over time.

Any trading symbols, entities or investment products displayed or named in this podcast are for illustrative purposes only and are not intended to portray recommendations.

Is margin trading & leverage a smart strategy, or is it just added risk? In this video, Ryan O’Connell, CFA, FRM, breaks down the real impact of margin trading on portfolio returns using a data-driven Excel analysis and Monte Carlo simulation. You’ll learn how margin works, leverage ratios, and margin interest rates affect investment growth—and whether the potential higher returns outweigh the risks.

We start by explaining the fundamentals of leverage and margin trading, followed by a step-by-step portfolio growth model comparing leveraged vs. non-leveraged strategies. I used Interactive Brokers’ margin rates for this analysis, but you can apply the same approach using Fidelity, Robinhood, or Binance margin rates as well.

📊 *Margin Rate Calculator →* https://ryano.finance/ibkr-margin

💾 *Download Free Excel File Here:* https://ryanoconnellfinance.com/product/margin-trading-return-simulator/

Chapters:
0:00 – What Is Leverage?
0:50 – Setting Expectations: Return & Risk
2:05 – Margin Trading Explained: How It Works & Costs
4:18 – Understanding Leverage Ratios & Their Impact
4:57 – Predicting Portfolio Growth With Margin Trading
9:22 – Comparing Portfolio Growth: With & Without Margin
10:15 – Monte Carlo Simulation: Testing Margin Trading Performance
11:49 – Is Using Margin Worth It?

*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.

This content is provided by a paid Influencer of Interactive Brokers. Influencer is not employed by, partnered with, or otherwise affiliated with Interactive Brokers in any additional fashion. This content represents the opinions of Influencer, which are not necessarily shared by Interactive Brokers. The experiences of the Influencer may not be representative of other customers, and nothing within this content is a guarantee of future performance or success.

None of the information contained herein constitutes a recommendation, promotion, offer, or solicitation of an offer by Interactive Brokers to buy, sell or hold any security, financial product or instrument or to engage in any specific investment strategy. Investment involves risks. Investors should obtain their own independent financial advice and understand the risks associated with investment products and services before making investment decisions. Risk disclosure statements can be found on the Interactive Brokers website.

Interactive Brokers is a FINRA registered broker and SIPC member, as well as a National Futures Association registered Futures Commission Merchant. Interactive Brokers provides execution and clearing services to its customers. For more information regarding Interactive Brokers or any Interactive Brokers products or services referred to in this video, please visit www.interactivebrokers.com.

The projections or other information regarding the likelihood of various investment outcomes generated by the Tools mentioned in this video are hypothetical in nature, do not reflect actual investment results, and are not guarantees of future results. It is important to understand that these projections are based on certain assumptions and models, and actual outcomes may differ significantly. Please note that results may vary over time.

Any trading symbols, entities or investment products displayed or named in this podcast are for illustrative purposes only and are not intended to portray recommendations.

Margin Trading:
Trading on margin is only for sophisticated investors with high risk tolerance. You may lose more than your initial investment. For additional information regarding margin loan rates, see ibkr.com/interest

Any discussion or mention of an ETF is not to be construed as a recommendation, promotion or solicitation. All investors should review and consider associated investment risks, charges and expenses of the investment company or fund prior to investing. Before acting on this material, you should consider whether it is suitable for your particular circumstances and, as necessary, seek professional advice.

Should you buy leveraged ETFs for the long term? In this video, Ryan O’Connell, CFA, FRM, explains leverage decay and how it impacts the performance of leveraged ETFs over time. Using Excel, you’ll learn to calculate expected returns, randomize daily returns, and analyze leveraged portfolio outcomes through examples and Monte Carlo simulations. Discover whether leveraged ETFs are a viable long-term investment strategy or better suited for short-term trading.

📈 *This Broker Has The Best Margin Rates For Leverage:* https://ryano.finance/ibkr-overview

💾 *Download Free Excel File Here:* https://ryanoconnellfinance.com/product/leveraged-etf-leverage-decay-simulator/

Chapters:
0:00 – Definition of Leverage Decay
0:36 – Expected Return & Standard Deviation in Excel
2:07 – Randomizing Daily Returns on Index
4:34 – Calculating Leveraged Returns
5:12 – Leveraged Portfolio Outcome Examples
5:54 – Monte Carlo Simulation of Leveraged Portfolios
9:24 – Volatility Decay of Leveraged ETFs Explained

*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.

Explore the world of Long/Short investing strategies with Ryan O’Connell, CFA, FRM, as he breaks down Long/Short Portfolios, including Long Extension and Market Neutral strategies. Learn the benefits and drawbacks of these advanced portfolio construction methods and how they can optimize your returns while managing risk. This video is perfect for finance professionals, CFA and FRM candidates, and anyone looking to deepen their understanding of long/short strategies. Watch now to master the principles of Long Extension and Market Neutral portfolios!

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

Chapters:
0:00 – Long/Short Portfolios Explained
1:50 – Long Extension Portfolios Explained
3:53 – Market Neutral Portfolios Explained
4:52 – Benefits of Long/Short Strategies
6:38 – Drawbacks of Long/Short Strategies

*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.

Unlock the secrets of Financial Leverage and discover how borrowed money can amplify your returns—or increase your risks. In this video, Ryan O’Connell, CFA, FRM, explains when financial leverage works, provides a simple financial leverage example, and demonstrates the formula to calculate leveraged returns. Perfect for students and professionals, this guide highlights the power of leveraging and its impact on investment strategies. Watch now to deepen your understanding of financial leverage and how to use it effectively!

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

Chapters:
0:00 – When Financial Leverage Works
0:26 – Simple Financial Leverage Example
2:50 – Formula to Calculate Leveraged Returns

*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.

Learn how to create a Correlation Matrix in Excel quickly and easily in just 4 minutes! This step-by-step tutorial covers everything from enabling the Analysis ToolPak Add-in to building a colored correlation heatmap and correlation table for better data visualization. Understand what a correlation matrix tells us, how to fill in the blanks for missing data insights, and how to interpret the values in your correlation table. Perfect for anyone looking to enhance their Excel skills and analyze data with precision!

💾 Download Free Excel File:
► Grab the file from this video here: https://ryanoconnellfinance.com/product/correlation-matrix-in-excel-file/

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

*Seeking Alpha Deals:*
💰 *Get $50 OFF Alpha Picks:* https://ryano.finance/alpha-picks
📈 *Get $159 OFF Seeking Alpha Premium and Alpha Picks Bundle:* https://ryano.finance/seeking-alpha-bundle
🔥 *Get $30 OFF Seeking Alpha Premium:* https://ryano.finance/seeking-alpha

Chapters:
0:00 – Overview of Data
0:18 – Enable Analysis ToolPak Add-in
0:46 – Create a Correlation Matrix in Excel
1:50 – What Does Correlation Matrix Tell Us?
2:32 – Fill in the Blanks
3:21 – Create a Colored Correlation Heatmap

*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.

Discover the crucial concept of Beta in Finance in just 5 minutes! This video breaks down beta explained for stocks, from zero beta to high and negative beta securities. Perfect for investors and finance enthusiasts, you’ll learn how beta measures a stock’s volatility relative to the market. Whether you’re new to investing or looking to refine your knowledge, this concise explanation of beta in finance will equip you with essential insights for smarter investment decisions.

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

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

Chapters:
0:00 – Definition of Beta In Finance
1:54 – 0 Beta Stock
2:39 – Stock W/ Beta of 1
3:11 – Very High Beta Stock
4:01 – Negative Beta Stock

*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.

In this video, Ryan O’Connell, CFA, FRM, provides an in-depth explanation of the Capital Asset Pricing Model (CAPM) and the Security Market Line (SML). Learn how to calculate the expected return of a security (E(r)), understand the risk-free rate (R(f)), and explore the concept of Beta (B) and systematic risk. Ryan breaks down the CAPM formula and demonstrates how to determine if a stock is overvalued or undervalued in finance. By the end of this video, you will have a comprehensive understanding of the CAPM explained and the significance of the SML in investment analysis. Perfect for finance professionals and students alike, this video covers all essential aspects of the Capital Asset Pricing Model explained.

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

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

Chapters
0:00 – Introduction to the Capital Asset Pricing Model (CAPM)
0:16 – Expected Return of a Security (E(r))
0:40 – Explanation of the Risk-Free Rate (R(f))
1:26 – Understanding Beta (B) and Systematic Risk
2:33 – Expected Return on the Market (R(M))
3:19 – Explanation of the CAPM Formula
4:51 – Understanding the Security Market Line (SML)
6:28 – Determining if a Stock is Overvalued or Undervalued

*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.

In this comprehensive video, “Efficient Frontier and Portfolio Optimization Explained | The Ultimate Guide,” Ryan O’Connell, CFA, FRM, breaks down the essentials of efficient frontier and portfolio optimization, with modern portfolio theory explained in detail. Starting with an overview of risk and return for a single stock, the video then explores risk and return in a two-asset portfolio. Ryan explains the efficient frontier for a two-asset portfolio and dives into the intricacies of portfolio optimization. The Sharpe Ratio and Capital Allocation Line (CAL) are also thoroughly explained, providing a complete guide to optimizing your investment strategy. Whether you’re a beginner or an experienced investor, this ultimate guide will enhance your understanding of efficient frontier and portfolio optimization.

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

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

Chapters:
0:00 – Risk & Return: Single Stock
1:50 – Risk & Return: Two Asset Portfolio
4:16 – Efficient Frontier: Two Asset Portfolio
5:09 – The Efficient Frontier Explained
7:53 – Portfolio Optimization Explained
9:35 – Sharpe Ratio Explained
10:20 – Capital Allocation Line (CAL) Explained

*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.