Excel Array Formula Series #14.2: Beginning Stock Analysis
July 24th, 2009
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 …
Posted in 
Tags:
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!?
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