Тёмный

How to calculate portfolio risk and return in Excel / Analyzing stock returns / Episode 7 

Initial Return
Подписаться 1,1 тыс.
Просмотров 19 тыс.
50% 1

Опубликовано:

 

8 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 14   
@mahmoodabdulla7161
@mahmoodabdulla7161 9 месяцев назад
You're Amazing and i love you and i hope you succedd in life
@GLEEKY-zv8yk
@GLEEKY-zv8yk 9 месяцев назад
Clutch asf for uploading these🤞🙏
@nuche3931
@nuche3931 6 месяцев назад
prof are you able to do this for 3 stocks and compute the matrices of returns and standard deviation to graph the efficient frontier please?thank you
@initialreturn
@initialreturn 5 месяцев назад
hi there, we're planning to make a video about tracing the efficient frontier, but that'll be coming later on. the best thing to do is to turn notifications on so you'd know when it comes out.
@z1ng449
@z1ng449 8 месяцев назад
Can I use var.p?
@initialreturn
@initialreturn 7 месяцев назад
The short answer is "yes". Especially if you're sample is large using var.p vs var.s would have little practical impact on your results. The reason to focus on var.s is that it gives an unbiased estimator if you're interested in forecasting variance.
@lsbong382
@lsbong382 4 месяца назад
Hi, how could i obtain stock returns data?
@initialreturn
@initialreturn 4 месяца назад
Hi there, we have a tutorial on that here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ulYfFTBuEsQ.html
@CreativeuTuberIndia
@CreativeuTuberIndia 2 месяца назад
HOW MANY DAYS DATA WE NEED TO TAKE ?
@initialreturn
@initialreturn 2 месяца назад
Hi there, it depends on your objectives. For example, if you'd like to compute portfolio risk & return to evaluate performance over a specific period, you'd use daily returns covering that entire period. Or, if it's for forecasting future returns, you'd typically need at least one year's worth of daily data.
@CreativeuTuberIndia
@CreativeuTuberIndia 2 месяца назад
Thank You so much for your response..
@CreativeuTuberIndia
@CreativeuTuberIndia 2 месяца назад
Can i take data from the day that i have made investment ??
@initialreturn
@initialreturn 2 месяца назад
Daily returns are typically small. So, starting your sample period one day before or after would normally make very little practical difference in your results. Ideally, you'd like to use the price you paid as the starting point. So, if you bought your shares, say, on Jan 1 you can use either the closing price on that day or the exact price you paid during that day as your starting point.
@CreativeuTuberIndia
@CreativeuTuberIndia 2 месяца назад
@@initialreturn 🙏🏻🙏🏻
Далее
Portfolio Optimization in Excel: Step by Step Tutorial
15:26
Самый БОЛЬШОЙ iPhone в МИРЕ!
00:52
Просмотров 257 тыс.
Portfolio Optimization in Excel
19:35
Просмотров 30 тыс.
Portfolio Optimization using Solver in Excel
17:02
Просмотров 64 тыс.
Calculate Annualized Returns for Investments in Excel
5:15
Markowitz Portfolio Optimization
25:06
Просмотров 242 тыс.