Open topic with navigation
Customers who prefer to work in Excel can export the Rebalance file and modify the current percentage to reflect the percent of net liquidation they want to their positions to have, then import the modified file back into Rebalance Portfolio.
Advisors can also use this feature to import a modified file to a new account to easily bring this account to the new percentages.
To export a portfolio
For example, you could change the default C:\jts\rebalance.csv to C:\clients\smithPortfolio.csv.
The directory path must exist for the Export functionality to work. You cannot create a new folder while exporting.
To rebalance the position’s percent of NLV from Excel
Note that each line of the spreadsheet represents a position. The last column represents the current percent of Net Liquidation Value that the position holds. This exported value is equivalent to the value in the Current % field of the Rebalance Portfolio window.
For example, if you want to rebalance your portfolio so that AAPL STK holds 5% of NLV instead of 16.20478 as shown above in line 2, you would change 16.20478 to 5.0. This modified value is imported in the Rebalance Portfolio as the new Rebal % value.
To import a rebalance portfolio
To complete the rebalance, create and transmit the orders.