Combining two stocks in a portfolio in Excel / Analyzing stock returns / Episode 8

We show how to plot the combinations of two stocks in a portfolio using Excel.

Visit the page below to download the Excel template used in this tutorial:
https://www.initialreturn.com/excel-t...

You might find our tutorial on downloading data from Yahoo! Finance interesting as well:
   • Downloading stock price data / Analyz...  

0:00 Intro
0:11 Step 1: Prepare the data.
1:13 Step 2: Compute the average realized return for each stock.
2:25 Step 3: Compute realized volatility for each stock.
4:11 Step 4: Portfolio return.
10:32 Step 5: Plot the combinations of two stocks.

Enjoying our content?

Click the link below to subscribe to our channel:
   / @initialreturn  

You can also follow us on X (Twitter):
https://x.com/initial_return

And, visit our website for free courses, tutorials, and more:
https://www.initialreturn.com/

#tutorial #investing #finance #risk