Sync TRADE to a Book

Broker Connectivity
1

I’ve been a slow adopter, and recently switched one of my accounts from Folio to IB to use TRADE.

Is there an easy way to sync an entire IB account to a live book? I had to manually enter in about 80 positions in a new live book, before generating new orders via TRADE. It would be great if one could link a book to an entire IB account, to ensure everything ties out.

2

We’re going to add a way to import multiple trades to a portfolio/book, like from a comma delimited text file.

In IB you can generate a historical transaction text file by logging in to the Account Management (not WebTrader nor TraderWorkStatio) then go to Reports->Flex Queries. You need to create a new query and save it first. It’s a bit of work, and some fields are not useful, but I was able to produce the file below. The import function will use a similar format and recreate the whole portfolio performance, stats, etc. The import project should start soon.

Out of curiosity… It sounds like you did an account transfer from Folio. What does the FlexQuery produce?. Does it show “transafer” transactions? Hopefully it shows something.

Thanks

Symbol	Buy/Sell	Quantity	Price	Amount	Proceeds	Commission	TradeDate
AAPL	BUY	50	123.5	6175	-6175	-1	20150312
AMTG	BUY	15	16.76	251.4	-251.4	-1	20140530
3

Thanks Marco. It did take a while to figure it out, but I eventually found the category I needed, which was “Transfers (ACAT, Internal)”.

I was able to pull the following fields:

  • symbol
  • quantity
  • position amount
  • IB client account #
  • Folio transfer account #
  • direction (e.g., “IN”, “OUT”)
  • type (e.g., “ACATS”)