Combining two stocks in a portfolio in Excel / Analyzing stock returns / Episode 8
Автор: Initial Return
Загружено: 2023-12-04
Просмотров: 5982
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 / Analyzing s...
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?
Become a member for exclusive videos & posts and early access to upcoming content:
/ @initialreturn
Click the link below to subscribe to our channel:
/ @initialreturn
You can also follow us on X (Twitter):
https://x.com/initial_return
And, here are our official Facebook, Instagram, and Pinterest pages:
/ initialreturn
/ initialreturn
/ initialreturn
And, visit our website for free courses, tutorials, and more:
https://www.initialreturn.com/
#tutorial #investing #finance #risk
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: