Portfolio Rebalance in Excel

Balances your portfolio of stocks, ETFs, etc. (anything with a ticker symbol in Excel) with a single click. Easy peasy.

How Does It Work?

The Portfolio Rebalance tool uses integer linear programming to calculate the whole number of shares to buy or sell to bring the individual positions as close as possible to their desired (or "target") weights.  The objective is to 1) reduce the number of transactions (minimize fees paid) and 2) maximize amount of capital employed (have maximum funds invested). The Excel macros are tied to simple buttons to make rebalancing and portfolio management super simple.

No portfolio? Design one!

ADD a stock, ETF, currency pair, etc. to the portfolio.

REMOVE a stock, ETF, currency pair, etc. to the portfolio.

Re-weight the elements of the portfolio to be equal.

Reset the calculation and start fresh!

Get Up & Running Fast

Only a few inputs are required to rebalance your portfolio:

• Company name or symbol
• Desired portfolio weights
• Amount of cash available to invest
• Broker transaction cost (many are $0!)

​

You'll be up and running in minutes!

Clear Actions to Move Forward

Take clear, decisive action!  The Trades column plainly summarizes what needs to happen to bring the portfolio to your desired allocation.  The Transaction column shows the debit or credit amount to your account as a result of taking the action (including commissions).  This is to confirm where your $$ is moving, providing CONFIDENCE!

By purchasing you agree to be added to an email contact list for Engineered Workflows (unsubscribe anytime).

Investment Disclaimer

I am not an investment or financial advisor.  The tools and strategies discussed here are not recommendations for action, but rather starting points for your own research.  You should take independent financial advice from a certified professional.  Our financially-related tools are intended to empower you to do your own research and investigations so you can have a better, more informed conversation with your financial advisor or tax professional.