Download Instructions for Interactive Brokers

Interactive Brokers makes available both "Generic" and "PortfolioCenter" formatted files for download in their advisor accounts. (Non-advisor accounts can download/import an OFX formatted file for individual accounts.) These files contain data for all your client's accounts and can be imported into Fund Manager Advisor, or used to reconcile your accounts. You can choose which format to use. Instructions are available for each format:

Generic Format:

This is Interactive Broker's own format, and the one they recommend. You must have an advisor account with Interactive Brokers, and then e-mail reportingintegration@interactivebrokers.com with your account # and request the Fund Manager Software feed. You can also request a historical file set to get past transactions. You will receive instructions back from IB on how to download your daily files, and any requested historical files. The download is done through FTP, and the files will be PGP encrypted for security. Before importing into Fund Manager the files must be decrypted. Email us for instructions on how to decrypt the IB Generic data files. The following data files are utilized by Fund Manager:

Transactions (<Account #>_Activity_<Date>.csv)

Position, Price, and Reconciliation (<Account #>_Position_<Date>.csv)

Security (<Account #>_Security_<Date>.csv)

PortfolioCenter Format:

You must have an advisor account with Interactive Brokers, and then ask them to make the PortfolioCenter file format available for download in your account. Once your account has been enabled for this feature, log into Interactive Broker's website and go into the Report Management / Activity Downloads section to download your PortfolioCenter formatted files. The following PortfolioCenter files are utilized by Fund Manager Advisor:

Security (.SEC)
Price (.PRI)
Transaction (.TRN)
Reconciliation (.POS)

Position (*.INI)

Each file has a base name of ADyymmdd, where yy is the year, mm is the month, and dd is the date.

The *.INI position file has the same format as the *.TRN file, and can be imported using the menu command File / Import / Transactions / Interactive Brokers.... You would only ever import this file at most one time to get started with some initial positions as of a certain date. If you have all *.TRN transaction files back to account inception it is not necessary to import the *.INI position file. If you do import the *.INI position file, you would start import transaction files from the following day forward.

See Also