Import and Export Positions to Rebalance
Instructions
Clients 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
-
Click the Export button in the bottom left corner of the Rebalance Portfolio window.
-
Modify the location and file name if desired (leaving the .csv extension), and click OK. You may want to modify the generic file name to help identify it.
-
For example, you could change the default C:\jts\rebalance.csv to C:\clients\smithPortfolio.csv.
-
-
Click OK from the file export confirmation message.
Note: The directory path must exist for the Export functionality to work. You cannot create a new folder while exporting.
To Rebalance the Positions Percent of NLV from Excel
-
Open the exported .csv file in MS Excel.
Note: 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.
-
Change the current % of NLV to the new percent you want by clicking the field and updating. Do this for as many lines as needed and click Save.
-
Re-import the updated csv file back into TWS.
To Import a Rebalance Portfolio
-
Click the Import button in the bottom left corner of the Rebalance Portfolio window.
-
Navigate to the modified .csv file you want to import and click Open. You will see the new Rebal % values in the modified position lines.
-
To complete the rebalance, create and transmit the orders.
Additional Resources
Learn About Rebalance Portfolio Window in Trader Workstation at IBKR Campus