• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

SanzProphet

DYI Investing, Quant tools and thoughts on the market

  • Start Here
  • Crypto Management
  • About
  • Contact
  • Disclaimer

Day of month effect on rebalancing a portfolio

May 22, 2016 by sanz prophet 4 Comments

In this post we will:

  1. Take a look at a simple, momentum based, monthly rebalanced Equity/Bond portfolio consisting of two ETFs: SPY and TLT.
  2. Search for what has been the optimal dates in the month to rebalance such a portfolio.

Each month we allocate to SPY and TLT.

If SPY has outperformed  TLT we rebalance to 60% SPY – 40% TLT.

If TLT has outperformed  SPY we rebalance to 20% SPY – 80% TLT.

For the first run we will re-balance on the first of the month and close at the last day of the month.

Rebalancing portfolio 1st day

Now will try different combinations of entry and exit days.

We will try to purchase x days before or after the month and instead of exiting at the end of the month we will exit after y days.

Rebalancing portfolio days

Rebalancing portfolio best day CAR/MDD

The top chart is optimized for Net Profit while the second one for annual return/max drawdown. They are similar in this case but will will use the second one.

According to the chart the best combinations have been:

Buy 3-7 days after the month and hold for around 10-18 days.

The BuyDayRefToMonth variable refers to when we buy relative to the turn of the month. For example -5 means we buy five days after the turn of the month (i.e., the 6th trading day). +5 means we buy 5 days before the month ends. The BarsnStop variable  refers to how many days later we sell the positions.

Looking at the charts more closely we see that buying after (not before) the 1st of the month gives consistently better results when set between 2 and 7 days.635995120684418456

 

How many days we hold the investment is less obvious and seems to work across the given range:

635995120944245069

Let’s run this again but now only for 2012-May 2016:

2012-2016

Similar results. The only difference is that the holding times are shorter.

Let’s now input the optimized numbers and run the backtest. Obviously we will get something that looks good since it has been fit to the data. We buy 6 days after the month and hold 10 trading days.

Rebalancing portfolio SPY TLT Buy 6 days after hold 10

 

Conclusion:

There are many variables that affect how we run a dynamic Equity/Bond portfolio. We optimized only two of them, namely when to rebalance relative to the turn of the month and how many days to hold the investment.

In terms of entry it was  better to wait 3-6 days after the month changes to enter the trade. When it comes to this bond/equity portfolio, rebalancing late is better.


Looking for a smart bond/equity portfolio?  Read  about the Universal Investment Strategy @ Logical-Invest.

Filed Under: Seasonal, SPY Tagged With: bond, day of the month, equity, etf, investment, portfolio

Reader Interactions

Comments

  1. Larry Panos says

    May 30, 2016 at 10:29 pm

    OMG, this blog is alive! Welcome back.

    Reply
    • sanz prophet says

      May 31, 2016 at 6:54 am

      Thank you Larry. Glad someone is watching 🙂

      Reply
  2. Alexander Horn says

    June 12, 2016 at 4:04 pm

    Welcome back Sanz Prophet!!

    Have been missing your posts, and like the new look & feel.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Keep in touch

Managed Crypto Funds

via TokenSets.com

Categories

Archives

Footer

RSS Portfolios from Logical-Invest.com

  • Bond ETF Rotation Strategy: Low-volatility portfolios for smart investors from Logical Invest
  • BUG Permanent Portfolio Strategy: Quantitative investment models from Logical Invest
  • Crypto & Leveraged Top 2 Strategy: Risk-adjusted investment portfolios from Logical Invest
  • Dow 30 Strategy: Quantitative investment models from Logical Invest

Pages

  • About
  • Contact
  • Disclaimer
  • Start Here

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2023 · @SanzProphet.com· Log in