How to Calculate Expected Return, Variance, Standard Deviation in Excel from Stocks/Shares

In this video I will show you how to calculate Expected Return, Variance, Standard Deviation in MS Excel from Stocks/Shares or Investment on Stocks for making portfolio.
Download File:
www.mediafire....
If you have any question please feel free to ask.
Don't forget to SUBSCRIBE
Tags ignore:
Finace excel tutorials, how to calculate Expected Return in excel,
how to calculate Variance in excel,how to calculate Standard Deviation in excel,
Calculate return on investment in excel, how to calculate standard deviation of a portfolio with 2 stocks
portfolio standard deviation in excel, standard deviation on stocks excel,
compare two companies stocks standard deviation,How can you calculate volatility in Excel

[@natalieweishuhn521]

Hey I just met you and this is crazy, but you just saved me 5 hours in homework maybe.

[@ninamokhtar1591]

thank u so much for this honestly you stopped me from crying

[@InnoRative]

Pleasure 😊

[@mrom544]

Same

[@NhiThai-kd3pi]

same

[@parthmalik1]

Can also use =(new/old)-1 instead of ln

[@lawrencerepko5352]

Ah. had a total brain fart with calculating return inside excel with using LN function. Very simple but this helped out a lot. Thank you Sir!

[@SonuGupta-dw3mc]

Excellent sir , great sir , u r genius

[@mohammadasaduzzaman5844]

Thank you very much ....
One more things that is could you please show us how to calculate Cross Sectional Standard Deviation with stock index data....🙂

[@anjus625]

Thankyou so much... god bless you

[@anjus625]

Does we have to calculate return on closing price or adjusted closing price

[@muskanbhatnagar1598]

Sir is this the average return that u have calculated...??? Return means what I didn't get it sir pliz tell me

[@stefififi]

Thank you so much 🙏🙏

[@ahmed007Jaber]

Thank u so much for this
How would u factor in dividends?

[@ToToToTo-pp6lc]

Adjusted close includes dividends paid

[@olya151]

Fantastic 🤩

[@ahmermajeed6038]

sir plzz tell me how to find risk and return of a industry for last 10yrs

[@sumairakausar165]

sir do upload a video on converting monthly stock prices into annual prices

[@dr.sureshbk6524]

Dear Sir, .. How to calculate when opening and closing BSE sensex values are given

[@munirasaleem8409]

What we will do then if there is 2 companies and they having different closing entries like stock A is 19 entries and stock B 22 so then how we calculate?

[@koolrajjo]

how to calculate SD Levels for stocks before start of the week? so trading can be done based on it

[@adarshmehta5184]

How to find Expected return and Variance for long term?

[@bhumikaajain1998]

If u will convert daily returns into % results may be manipulated while finding STDEV

[@anandreddypandillapalli2098]

Sir i want expected return using previous close and close price for portfolio management

[@farooqhayat]

HOW CAN COLLECT THESE DATA

[@janija7238]

How to calculate risk pls explain

[@taqwavision5003]

Dear sir when i calculate variance and s.d then give error plz help me

[@rogjerr]

Can you explain what is returns? Do you mean the percentage the stock price changes in 1 day?

[@rammalmudassar2826]

aoa sir expected return hamesha ase he calculate ho ga

[@AdamELclon]

thanks

[@DownloadingVirus101]

What is the noise at 1:12?

[@maxontoast]

Joe Charuy a bird it sounds like

[@vivekbhatia7058]

Crow

[@sonnguyenthanh9774]

This is E(R) for day, how about Expected Return for a year

[@mrom544]

Son Nguyen Thanh it would be the same mechanic. You would take the sum return of all the months within that year/12

[@taqwavision5003]

Salam