How to Create a 2-Stock Portfolio: Expected Return, Standard Deviation & Efficient Frontier
In this video, we'll guide you through the process of creating a 2-stock portfolio and calculating its expected return and standard deviation. You'll learn how to analyze risk and return for two stocks and build a portfolio that balances them effectively. We will also explore the concept of the Efficient Frontier to help you understand the trade-off between risk and return.
What You Will Learn:
How to select two stocks for a portfolio
Calculating expected returns for each stock and the portfolio
Determining portfolio standard deviation (risk)
Plotting the Efficient Frontier to identify the optimal portfolio
Understanding risk-return trade-offs for better investment decisions
Whether you're a beginner or an experienced investor, this video will simplify complex concepts in portfolio management. The video will be taught in Urdu/Hindi, catering specifically to audiences in Pakistan, India, and Bangladesh.
Don’t forget to like, subscribe, and hit the notification bell for more financial education videos!
"How to Create a 2-Stock Portfolio: Calculate Expected Return & Standard Deviation"
"Building a 2-Stock Portfolio: Expected Return, Standard Deviation & Efficient Frontier"
"2-Stock Portfolio Explained: Calculate Expected Return, Risk & Efficient Frontier"
"Step-by-Step Guide: 2-Stock Portfolio, Expected Return, Standard Deviation & Efficient Frontier"
"Efficient Frontier & Risk Analysis: Creating a 2-Stock Portfolio#Investment #PortfolioManagement #StockPortfolio #EfficientFrontier #ExpectedReturn #StandardDeviation #FinanceEducation #Urdu #Hindi #India #Pakistan #Bangladesh #Investment
#PortfolioManagement
#StockPortfolio
#EfficientFrontier
#ExpectedReturn
#StandardDeviation
#RiskManagement
#FinanceEducation
#Urdu
#Hindi
#Pakistan
#India
#Bangladesh
#FinancialPlanning
#TwoStockPortfolio
#InvestmentStrategy
#StockMarket
#PortfolioOptimization
#RiskAndReturn
#ExcelForInvestors
#HowToInvest
#BeginnerInvestors
#FinanceInUrdu
#FinanceInHindi
In this video, we'll guide you through the process of creating a 2-stock portfolio and calculating its expected return and standard deviation. You'll learn how to analyze risk and return for two stocks and build a portfolio that balances them effectively. We will also explore the concept of the Efficient Frontier to help you understand the trade-off between risk and return.
What You Will Learn:
How to select two stocks for a portfolio
Calculating expected returns for each stock and the portfolio
Determining portfolio standard deviation (risk)
Plotting the Efficient Frontier to identify the optimal portfolio
Understanding risk-return trade-offs for better investment decisions
Whether you're a beginner or an experienced investor, this video will simplify complex concepts in portfolio management. The video will be taught in Urdu/Hindi, catering specifically to audiences in Pakistan, India, and Bangladesh.
Don’t forget to like, subscribe, and hit the notification bell for more financial education videos!
"How to Create a 2-Stock Portfolio: Calculate Expected Return & Standard Deviation"
"Building a 2-Stock Portfolio: Expected Return, Standard Deviation & Efficient Frontier"
"2-Stock Portfolio Explained: Calculate Expected Return, Risk & Efficient Frontier"
"Step-by-Step Guide: 2-Stock Portfolio, Expected Return, Standard Deviation & Efficient Frontier"
"Efficient Frontier & Risk Analysis: Creating a 2-Stock Portfolio#Investment #PortfolioManagement #StockPortfolio #EfficientFrontier #ExpectedReturn #StandardDeviation #FinanceEducation #Urdu #Hindi #India #Pakistan #Bangladesh #Investment
#PortfolioManagement
#StockPortfolio
#EfficientFrontier
#ExpectedReturn
#StandardDeviation
#RiskManagement
#FinanceEducation
#Urdu
#Hindi
#Pakistan
#India
#Bangladesh
#FinancialPlanning
#TwoStockPortfolio
#InvestmentStrategy
#StockMarket
#PortfolioOptimization
#RiskAndReturn
#ExcelForInvestors
#HowToInvest
#BeginnerInvestors
#FinanceInUrdu
#FinanceInHindi
Category
📚
LearningTranscript
00:00In the name of Allah, the most Gracious, the most Merciful
00:03In the name of Allah, the most Gracious, the most Merciful
00:04Peace be upon you
00:07In today's video, I will tell you how to make a two-star portfolio
00:10We will arrange the data
00:13and then we will
00:15calculate the daily return
00:18then we will
00:21analyze the return
00:24then we will make the portfolio weights and then the monthly portfolio
00:26and at the end we will
00:29calculate the return
00:32So this is today's task and I will go over the data
00:35I have already downloaded the data
00:38from two companies
00:41one is AMD and the other is
00:44Alibaba Express
00:47So I will open AMD's data
00:50first
00:53If you don't know how to download data
00:56I have already made videos on this
00:59You can check them and download the data
01:02So here we have AMD's data
01:05and you can see
01:08there are different values
01:11and you can see their headings
01:14this is the opening price of the day
01:17and then the high price
01:20and then the lowest price
01:24and the closing price
01:27and this is the adjusted close
01:30we take this value
01:33and all the variations of the day
01:36are given in the final price
01:39and this is called the adjusted close
01:42we only take the adjusted close
01:45and delete the rest
01:48and then we will change the name
01:52so this is AMD
01:55and then we have to save this file
01:58and for that we will go to save as
02:01and where we want to save
02:04I will make a 2 star portfolio
02:07and I will change the name
02:102 star portfolio
02:16and the name of the company is AMD
02:20and the other one is
02:23on 5 years data
02:26I will keep the name of this file
02:29and we have to change it from below
02:32instead of CSV we have to change it to Excel
02:35I will click ok
02:38and then we will take the data of the other company
02:41I will open it
02:44and after opening it
02:47it will take some time
02:50you can check it from above
02:53we will check the date
02:56you can see it is 2018-2023
02:59I will change the name
03:02I will write the name of the company
03:05I will copy it from here
03:08and I will paste it in this file
03:11you can check it
03:15now we will calculate the daily return
03:18we will calculate the daily return
03:21daily return
03:24I will put the heading of both the companies
03:27AMD and then
03:30UBAPA
03:33the way to calculate it
03:36this is the price
03:39which is the second rate of our data
03:42we will take the return of AMD
03:45and we will divide it with the return of the first date
03:48and we will make it minus 1
03:51so we have the return of AMD
03:54I will click on it
03:57and I will select this corner
04:00and I will put it in the second column
04:03so it has calculated the returns of both
04:06you can check it
04:09after selecting both
04:12I will double click it
04:15you can see all the calculations are done
04:18after selecting it
04:21I will select all the values
04:24and then I will change it to percentage
04:27and after percentage we will take 2 values
04:30so we have the return
04:33daily return
04:36this is the data of 5 years
04:39so if we take the data of 5 years
04:42then what will be the return
04:45we are going to do the prediction for the future
04:48daily expected return
04:51so
04:54daily
04:57we will get the heading of daily
05:00and we will get the expected return
05:03and after this
05:06we will calculate the standardization
05:09and
05:12I will increase the size
05:15here we will get the names of both the companies
05:18I will copy the name
05:21of both the companies
05:24I will copy the name of both the companies
05:27I will copy the name of both the companies
05:30after this
05:33we will calculate the average
05:36we will write the formula for average
05:39and we will select the expected return of daily
05:42we have the data of one company
05:45I will drag it
05:48so we have the data of both the companies
05:51in which Alibaba was the base of daily
05:54it is 0.19
05:57so the return of Alibaba is 0
06:00it has standard deviation
06:03so the formula for standard deviation is
06:06STDEV standard deviation
06:09after this we will select all the stocks of AMD
06:12so we have AMD's daily expected standard deviation
06:15so we have AMD's daily expected standard deviation
06:18and similarly
06:21we will calculate the standard deviation of another company
06:24so we have the standard deviation of both the companies
06:27on the basis of daily
06:30we will change it in percentage
06:33so the standard deviation of both the companies is same on the basis of daily
06:36now we will analyze it
06:39so
06:42to analyze both the returns
06:45I will select them
06:48we will board it
06:51so this is the formula
06:54we will select the expected return
06:57and we will take the power of it
07:00because it is the data of daily
07:03so in one year the working days are 252
07:06so 252
07:09we will take the power of it and make it minus 1
07:12so we have
07:15AMD's yearly expected return
07:18and the other company's expected return
07:21so the expected return is
07:2461%
07:27and the other one is
07:30minus
07:33now we will calculate the standard deviation
07:36so the formula for standard deviation is
07:39we will take the standard deviation of daily
07:42and multiply it
07:45and the working days
07:48are 252
07:51so we have
07:54the square root
07:57I will drag it
08:00so we have
08:03the square root
08:06so we have
08:09the expected return
08:12so we have the standard deviation
08:15now we have to calculate the correlation
08:18so what is the relationship
08:21so the formula for correlation
08:24will be CORREL
08:27for correlation
08:30we will select one of the staff
08:33and then
08:36we will select the staff of the other company
08:39and we will press the enter button
08:42so we have the relationship
08:45in both the stocks
08:48now we have to make the portfolio
08:51and we have to see
08:54how to invest
08:57so that the return is maximum
09:00and the risk is minimum
09:03so for that
09:06we have to check
09:09which one will be better for us
09:12I have given the heading of the portfolio
09:15and we will take the name of the stock
09:18AMD
09:21and we will select the second stock
09:24and now we have to do
09:27we have to invest some money in it
09:30and if we will minus it, it will come
09:33so we will make the portfolio
09:36with the difference of 5
09:39so first I will select
09:42100%
09:45and I will minus 5
09:48out of it
09:51so first we will
09:54invest 100% and then 95%
09:57and then we will drag it down to 0
10:00so
10:03this will be our investment
10:06in AMD
10:09and in the other company it will be opposite
10:12so if we invest 100% in this
10:15then we will have nothing in the portfolio
10:18so I will
10:21select this
10:24and I will drag it down
10:27so you can see
10:30this has 95% and this has 5%
10:33so when we will drag it down, it will be equal
10:36so in the end
10:39the first company has 0 investment
10:42and in the other company
10:45we will have 100% investment
10:48so if you can see
10:51it is 100%
10:54so after this we will make the portfolio
10:57I will give the heading
11:00of the portfolio
11:03and we will write the expected return
11:06and
11:09standard deviation
11:12so this is the chart of standard deviation
11:15I will write it here
11:18after this we will select it and bold it
11:21after this
11:24we have to calculate the expected return of the portfolio
11:27so for that we have to
11:30take the weight
11:33and multiply it
11:36so this is our annual return
11:39after this we have to fix the annual return
11:42so in all the portfolios
11:45the annual return will be the weight change
11:48so how to fix it
11:51we select whatever we want to fix
11:54and then press F4
11:57now for the second chart
12:00we will take the weight
12:03and multiply it
12:06with the expected return
12:09this is the name of i column
12:12and 7 is the number
12:15so after selecting it
12:18I will select it
12:21and press F4
12:24in some keyboards
12:27we press F4 with shift
12:30and in some we press F4
12:33so we have the expected return
12:36I will press ok
12:39and I will reduce the values
12:4215
12:45so I will reduce it
12:48so we have the expected return of the portfolio
12:51which is 61%
12:54we will drag it
12:57or if I double click it
13:00it will calculate it all
13:03after this we have to calculate the standard deviation
13:06so for standard deviation
13:09after writing the scale root
13:12we have to put a bracket
13:15and we have to take the return of the first stock
13:18and the scale of it
13:21we have to multiply it
13:24with the standard deviation of the stock
13:27we will take the scale of it
13:30the standard deviation
13:33will be same in all the portfolios
13:36so we will fix it
13:39after selecting it
13:42I will press F4
13:45so we have the dollar sign
13:48so whenever I will do the calculation
13:51it will not change the value
13:54we will close the bracket
13:57we will write plus and start the bracket again
14:00now we will take the weight of the second stock
14:03we will take the scale of it
14:06and we will multiply it
14:09with the standard deviation
14:12so we have to fix the standard deviation
14:15so we will put F4
14:18otherwise we can put dollar sign
14:21with the value of the column
14:24and we will take the scale of it
14:27we will close the bracket
14:30we will start the bracket
14:33and we will multiply it
14:36the weight of the first stock
14:39then we will multiply it
14:42with the weight of the second stock
14:45then we will multiply it with the standard deviation
14:48and we have to fix it
14:51because it will be same in all the portfolios
14:54then we will multiply it with the standard deviation
14:57and we have to fix it
15:00and we have to multiply it with the correlation
15:03and we have to fix it with F4
15:06I will close the bracket
15:09so we have the standard deviation
15:12now I can drag it
15:15or I can double click it
15:18and it will calculate the standard deviation
15:21so I double clicked it
15:24then I will come here
15:27and I will change it in percentage
15:30after changing it in percentage
15:33after changing it in percentage
15:36we took two values
15:39and we have it
15:42so we have two main important things
15:45according to our portfolio
15:48I will bold it
15:51and after bolding it
15:54we will put it in brackets
15:57so we have it
16:00now after this
16:03we have to make a table
16:06in which we will check
16:09which portfolio is best for us
16:12so I will select both of them
16:15I will go to insert
16:18so here we have to make a chart
16:21so this is the chart Excel is giving us
16:27and we take scatter chart
16:30but
16:36we don't want to take line chart
16:39we will take
16:42scatter plot
16:45and in scatter plot
16:52we select it like this
16:55now we have it
16:58sorry
17:01now I will set it
17:04and here we will go to edit
17:07after going to edit
17:10we will give it a name
17:14Efficient Frontier
17:17Efficient Frontier
17:20now we will select the data
17:23we will take standard deviation in X axis
17:26and in Y axis
17:29we will take returns
17:32so we have it
17:35Efficient Frontier
17:38because our standard deviation is very high
17:42so we will change it
17:45you can see the value
17:50maximum 60
17:53so we will start it
17:56we will start it
17:59from 30
18:02sorry
18:05from 0.3
18:08if we increase it to 0.4
18:11so we have it
18:14so we have
18:17Efficient Frontier
18:20and you can see
18:23if we invest in one stock
18:26this point
18:29so you can see
18:32here
18:35the return is very less
18:38it is minus 13%
18:41so we are going to last
18:44and 100% is investment in other stock
18:47and if we come here
18:50so our return is maximum
18:53but the standard deviation
18:56is very high
18:59so we will give it a name
19:03so we have standard deviation
19:13and we have
19:16factory return
19:19so we have
19:22portfolio
19:25in this video
19:28I will explain more
19:31in next video
19:34I will explain minimum
19:37and maximum portfolio
19:40I hope you like it
19:43take care
19:46Allah Hafiz