In case you frequently look up historical prices or volumes for stocks or indexes (or some U.S. mutual funds) and want to chart or calculate annual returns or year-to-date return or ... >So? So here's a useful spreadsheet:
See Distribution stuff
Aargh! Yahoo has (again!) changed the format of its data so (thanks to e-mail from Roger)
I fiddled with this spreadsheet so (hopefully) it'll work ... again.
It also gives the Mean and Standard Deviation of all returns,
positive returns and negative returns (and the distribution of returns).
|