Excel Array Formula Series #14.2: Beginning Stock Analysis

See how to create array formulas for Portfolio Return & Standard Deviation. See how to calculate individual stock return and standard deviation given different assumed states of the future economy.

See how to use probability, stock weights and assumed stock returns to calculate individual stock return and standard deviation and Portfolio Return & Standard Deviation.

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.

Category:

Science & Technology

Tags:

• Excel
• Array
• Formulas
• functions
• Stock
• Portfolio
• Return
• Standard
• Deviation
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[krmvinod]

Dude you have done an awesome job here. this is the best video i have ever seen on portfolio analysis. I request you to upload more videos on portfolios analysis, investment analysis, Discounted Cash Flow and Financial Modeling.

please give me you Email id for clarifying my doubts

Regards,

Kumar

Bangalore, India

[ExcelIsFun]

I am glad that the video was of use for you. I may post more this fall, but they will be basic Finance videos. This will be probably the mots advanced video that i will do.

[ExcelIsFun]

Dear manixxxo,

Yes, Bricklin and Frankson must have had a lot of fun creating the first spreadsheet, VisiCalc!!!! They completely changed the world becasue of it!!

--ExcelIsFun

[manixxxo]

I don´t know anything about porfolios, returns, etc, but it´s a starting point and since learning it in excel is fun, welcome!

Excelisfun, just imagine if using excel can be very complex, ¿How complex was it for guys like Simony, Bricklin and the rest to create this marvelous tools called spreadsheets!?