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

  1. Click the Export button in the bottom left corner of the Rebalance Portfolio window.

  2. 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.

    The export positions to rebalance in TWS.

  3. Click OK from the file export confirmation message.

    The export positions to rebalance confirm in TWS.

    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

  1. 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.

  2. 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.

    The Rebalance the Positions Percent of NLV from Excel.

  3. Re-import the updated csv file back into TWS.

To Import a Rebalance Portfolio

  1. Click the Import button in the bottom left corner of the Rebalance Portfolio window.

  2. 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.

    The Import a Rebalance Portfolio in TWS.

  3. To complete the rebalance, create and transmit the orders.

    The Import a Rebalance Portfolio complete in TWS.

 

Additional Resources

Learn About Rebalance Portfolio Window in Trader Workstation at IBKR Campus

Visit the Trader Workstation Website