Simba’s backtesting spreadsheet

Link: Simba’s backtesting spreadsheet

The backtesting tool is a spreadsheet to backtest portfolio returns from 1970 to present [1985 to present if you want to include certain Sector/Tax-Exempt funds that started after 1985] of various Vanguard Mutual Funds. This tool is customizable and you can add the returns for any mutual fund.

The spreadsheet calculates various metrics such as CAGR/Std Dev/Sharpe Ratio/Sortino Ratio. The tools also provides rolling returns [both nominal and real] for 3, 5, 10 and 15 years. It lets you compare up to 5 different portfolios [both 1970-present and 1985-present].

See also :

About

Barry Barnitz, administrator of both the Bogleheads® wiki and of Financial Page, a Bogleheads® blog

Posted in
June 2018
M T W T F S S
« May    
 123
45678910
11121314151617
18192021222324
252627282930  
Archives
Categories
Follow Financial Page on WordPress.com
%d bloggers like this: