Spreadsheet to backtest the HBPP.

General Discussion on the Permanent Portfolio Strategy

Moderator: Global Moderator

Post Reply
Pierre8r
Junior Member
Junior Member
Posts: 3
Joined: Wed Nov 28, 2018 8:18 am

Spreadsheet to backtest the HBPP.

Post by Pierre8r »

Hello,
I'm looking for a spreadsheet to backtest the HBPP.
Top
User avatar
ochotona
Executive Member
Executive Member
Posts: 3354
Joined: Fri Jan 30, 2015 5:54 am

Re: Spreadsheet to backtest the HBPP.

Post by ochotona »

portfoliovisualizer.com

portfoliocharts.com
Top
Pierre8r
Junior Member
Junior Member
Posts: 3
Joined: Wed Nov 28, 2018 8:18 am

Re: Spreadsheet to backtest the HBPP.

Post 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.
Top
User avatar
Tyler
Executive Member
Executive Member
Posts: 2066
Joined: Sat Nov 12, 2011 3:23 pm
Contact:
Contact Tyler

Re: Spreadsheet to backtest the HBPP.

Post 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.
Top
Pierre8r
Junior Member
Junior Member
Posts: 3
Joined: Wed Nov 28, 2018 8:18 am

Re: Spreadsheet to backtest the HBPP.

Post 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.
Top
User avatar
InsuranceGuy
Executive Member
Executive Member
Posts: 425
Joined: Sun Mar 29, 2015 1:44 pm

Re: Spreadsheet to backtest the HBPP.

Post by InsuranceGuy »

[deleted]
Last edited by InsuranceGuy on Mon Mar 08, 2021 8:04 pm, edited 1 time in total.
Top
User avatar
vnatale
Executive Member
Executive Member
Posts: 9461
Joined: Fri Apr 12, 2019 8:56 pm
Location: Massachusetts
Contact:
Contact vnatale

Re: Spreadsheet to backtest the HBPP.

Post 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
Above provided by: Vinny, who always says: "I only regret that I have but one lap to give to my cats." AND "I'm a more-is-more person."
Top
User avatar
Tyler
Executive Member
Executive Member
Posts: 2066
Joined: Sat Nov 12, 2011 3:23 pm
Contact:
Contact Tyler

Re: Spreadsheet to backtest the HBPP.

Post 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.
Top
Post Reply

Return to “Permanent Portfolio Discussion”