Page 1 of 1
Spreadsheet to backtest the HBPP.
Posted: Wed Nov 28, 2018 9:35 am
by Pierre8r
Hello,
I'm looking for a spreadsheet to backtest the HBPP.
Re: Spreadsheet to backtest the HBPP.
Posted: Wed Nov 28, 2018 9:43 am
by ochotona
portfoliovisualizer.com
portfoliocharts.com
Re: Spreadsheet to backtest the HBPP.
Posted: Wed Nov 28, 2018 9:55 am
by Pierre8r
ochotona wrote: ↑Wed Nov 28, 2018 9:43 am
portfoliovisualizer.com
portfoliocharts.com
Hello ochotona,
Thanks.
I know portfoliovisualizer.com, it's great.
But I wish to have access to the source code of the backtest engine.
Re: Spreadsheet to backtest the HBPP.
Posted: Wed Nov 28, 2018 12:32 pm
by Tyler
If you're looking to experiment on your own, try
Simba's Backtesting Spreadsheet.
Or if you have any questions about Portfolio Charts, I'm happy to help.
Re: Spreadsheet to backtest the HBPP.
Posted: Thu Nov 29, 2018 7:05 am
by Pierre8r
Tyler wrote: ↑Wed Nov 28, 2018 12:32 pm
If you're looking to experiment on your own, try
Simba's Backtesting Spreadsheet.
Or if you have any questions about Portfolio Charts, I'm happy to help.
Hello ochotona,
Thanks for your link.
At first sight Simba's Backtesting Spreadsheet seems too sophisticated for what I want to do.
I will try to develop mine.
For this first version of the Google Sheets backtest,
https://docs.google.com/spreadsheets/d/ ... sp=sharing
I do not get the same results as those from
http://www.portfoliovisualizer.com
$19130.98 vs $24,915
https://www.portfoliovisualizer.com/bac ... tion4_1=25
I am French, I would like to know if another user will have no problem of decimal separator with my sheet Google Sheets.
Can someone from non-French speaking tell me if everything is displayed correctly?
https://docs.google.com/spreadsheets/d/ ... sp=sharing
Thank you in advance.
Re: Spreadsheet to backtest the HBPP.
Posted: Fri Nov 30, 2018 12:16 am
by InsuranceGuy
[deleted]
Re: Spreadsheet to backtest the HBPP.
Posted: Fri Nov 29, 2019 9:24 pm
by vnatale
Tyler wrote: ↑Wed Nov 28, 2018 12:32 pm
If you're looking to experiment on your own, try
Simba's Backtesting Spreadsheet.
Or if you have any questions about Portfolio Charts, I'm happy to help.
Tyler,
You continuing to recommend "Simba's Backtesting Spreadsheet"?
The above seems to be one of the last times it has been discussed anywhere here?
Vinny
Re: Spreadsheet to backtest the HBPP.
Posted: Sat Nov 30, 2019 11:08 am
by Tyler
vnatale wrote: ↑Fri Nov 29, 2019 9:24 pm
Tyler,
You continuing to recommend "Simba's Backtesting Spreadsheet"?
The above seems to be one of the last times it has been discussed anywhere here?
Vinny
Absolutely. The guy who currently maintains it goes by "Siamond" on the Bogleheads forum. I correspond with him all the time about data sources, and I have a huge amount of respect for his knowledge on the topic. It's a great tool.