Add Data using CSV

Instructions
  1. Select the Configuration tab populating across the PortfolioAnalyst page.

  2. Select Offline Account under External Accounts and press Continue

  3. Fill out the required information. Then select Upload CSV under How do you want to enter your data?

    Image of the PortfolioAnalyst add offline account values panel.

  4. Add information about the historical date and starting balance, then click Choose a File.

    • The date is the date of the oldest line of historical data included in the CSV file.

    • The Cash Balance is the account balance as of the date you entered.

    • Click Add Another Balance to for additional cash balances.

  5. From the File Manager, navigate to the .csv file that contains historical data for the selected account and click Open.

  6. Confirm that the correct file appears in the Choose a File box, then click Upload.

    Image of the PortfolioAnalyst add data using CSV panel.

  7.  

  8. If the uploaded file is valid you will receive a "File was uploaded successfully" message.

  9. Click Continue to upload data for another account or complete a new task.

 

Additional Resources

Learn About PortfolioAnalyst External Accounts at IBKR Campus

Visit the PortfolioAnalyst Website

Navigate to External Accounts