Now this is where this gets weird, the referenced Standard Deviation calculation,Īlthough it never changes in the cell where the above formula resides, the sharpe ratio calculation changes and it should not because these are static numbers nothing is changing. Now, on the first sheet where I want to experiment, I used =INDIRECT(C$1&$B27) where C1 references the name of the sheet and B27 represents the cell on each sheet. I then calculated the annualized returns and standard I took monthly stock data from 1985 to present for Microsoft and Apple each on their own sheet within the workbook. I have a spreadsheet that I created for experimenting with a finance class I am attending.
0 kommentar(er)
