Contents
With ‘Plan By %’ checked as highlighted in the screenshot you can rebalance your portfolio. Under the ‘Planned Value %’ column, you can enter in the desired percentage for each position in your portfolio. See the screenshot below.
Once the percentages are entered, rebalancing will highlight the changes. A green row indicates you would need to add shares to get to the target percentage. A red row indicates that you would need to reduce shares. Uncheck the ‘Highlight Changes’ box if you’d like to remove row coloring. In either case the Planned Quantity and the Planned Trade columns will indicate the new quantity needed and the amount to trade to get there.
Trade Planning can be done with the ‘Plan By %’ option unchecked (see screenshot below). This allows you to enter trades by new quantity and see the results. Trade planning creates an alternative version or model of your portfolio. The model allows you to test potential trades, and see their effect on the portfolio.
To begin trade planning, type in a quantity into the cells under the ‘Planned Quantity’ column highlighted in he screenshot below. If you have ‘Highlight changes’ checked, an increase in shares will cause the row to turn green, and an decrease in shares will cause the row to turn red. The ‘Planned Quantity’ starts with the same value as the ‘Current Quantity’ value. When you change the quantity, the ‘Planned Value ($)’ column will update with the Planned Quantity multiplied by the price (which is the current price.) You can see the Planned Trade and Planned cost in the last two columns. The ‘Planned Value (%)’ column will show the impact on portfolio of the trade by percentage.
To add a ticker to the planned portfolio, click .Add Ticker’ in the top right. To remove any tickers, you can click the ‘x’ next to the ticker name. See screenshot below.
This is the window that appears after clicking ‘Add Ticker’, here you can enter the ticker or bring up the search for a ticker by starting to type in the ticker box.
Under the More pull down there are options where you can make adjustments to multiple tickers in the portfolio. Change % Multiple Tickers allows you to make % changes to several tickers at a time.
Allocate Equal Weight to Each Position allows you to enter an equal weight to each position. See screenshots below.
Allocate Equal Weight with in Sectors allows you to enter a percentage to an entire sector. Within the sector, each position will have an equal weight. See screenshots below.
Change Cash % and Adjust Positions allows you to enter the cash percentage you desire for the portfolio. Then each position will be adjusted proportionally to achieve the desired cash position. See screenshots below.
In the top right hand corner of the Holdings tab, you do have the ability to Reset the Portfolio. Resetting the portfolio means the model will be deleted, which will result in the actual and planned values becoming the same.
The import option allows you to import holdings from a file. You also have the ability to print or export the planned portfolio.
With Multiple Portfolios checked you have the ability to select multiple portfolios and view the holdings. However no changes can be made as the quantities are aggregated across portfolios.
