Flavio's app supportAll guides · Sign in

← All guides

How to use Rebalancing Calculator

Rebalancing Calculator

Work out the trades that bring a portfolio back to your target allocation: full rebalance, new cash only, or a withdrawal, across several accounts.

Bought Rebalancing Calculator? Sign in with the email you bought it with to download the latest version or ask me a question.

On this page

A calculator for your own numbers, not financial advice. You type the holdings, prices and targets. The app doesn’t fetch prices, connect to a broker or place trades.

Install

Rebalancing Calculator requires macOS 14 Sonoma or later, on Apple silicon or Intel. Download the ZIP from the order page or your Creem receipt. Unzip it and move the app to Applications.

The app checks for updates once a day. When a new version is ready, click Install and Relaunch. To check anytime, choose Rebalancing Calculator → Check for Updates….

Make a portfolio

The start screen has three buttons. New Portfolio makes an empty one. Import CSV… reads a positions file. Try the Sample adds a made-up three-fund portfolio across a Brokerage and an IRA account, to look around.

In the portfolio, click the name to rename it. The header has Cash in the accounts (cash already there, uninvested), the Drift band (± points) that decides when a holding shows in orange, Targets: Per holding / Per group, and the Currency of the portfolio.

Add one row per fund in each account with Add Holding (Shift-Command-H). The same fund in two accounts is two rows. Each row has ticker, name, asset class, account, shares, price, the Price as of date, and the target %. The value, the current percentage and the drift fill in as you type. Changes are saved as you type.

The ··· menu on a row has:

In Accounts, mark each account Taxable or Tax-advantaged. The app guesses from the name (IRA, 401k, Roth, HSA, ISA, SIPP, TFSA, RRSP, pension and similar are tax-advantaged). It’s only used by Don’t sell in taxable accounts.

With Per group targets you set a target for each asset class. The app splits it among the holdings in the group by their current value, or equally when the group is empty.

Import from a CSV or a spreadsheet

Import CSV… (File › Import Holdings from CSV…, Command-I) opens a sheet with a column picker for each field: ticker, name, asset class, account, account type, shares, price, value, price date, target %, currency and exchange rate. The app guesses each one from the header, and shows a sample value next to each choice. Uncheck The first row is the header if the file has none.

The preview lists the holdings it will import, and a sentence for each skipped row, like a total line or a cash line without shares. Rows without an account get the one you type in Account for rows without one. When there’s no price column, the price is worked out from value ÷ shares. Targets written as fractions (0.35) become percentages.

Paste from Spreadsheet… (File › Paste Holdings from a Spreadsheet…, Shift-Command-V) does the same with rows you copied from Numbers, Excel or Google Sheets.

The import doesn’t change the file. No particular broker’s export has been tested, so check the preview.

Calculate the trades

The Rebalance card has three modes:

Then:

These options are saved with the portfolio. Click Calculate Trades (Command-Return). If something is missing, the sentence next to the button and the orange banner at the top say what: a price of 0, a missing exchange rate, or targets that don’t add up to 100%.

Read the result

The result starts with a summary sentence, then:

The result of a full rebalance of a made-up portfolio, with two sales in the Roth IRA, two buys, the By account card and the allocation chart

Copy as Text (Shift-Command-C) copies the plan. Export CSV… (Command-E) saves the trade list and never replaces an existing file. Back to Holdings (Command-[) returns to the portfolio. Nothing in the portfolio changes until you update the shares after you trade. Plan › Set Every Price Date to Today marks all the prices as current after you update them.

Your data

Portfolios are saved in ~/Library/Application Support/Rebalancing Calculator/portfolios.json. Plan › Show the Portfolios File shows it in the Finder. The app uses the internet only to check for and download updates.

The plan doesn’t account for tax lots, cost basis, gains, wash sales or fees.

Rebalancing Calculator is $19, a one-time purchase.