NEW Prediction Market Simulator 
Open Navigation
Close Navigation
ARC Campus

Reporting Integration

Arclight Capital Reporting Integration Tool Guide
Copy Location

This guide provides information for Arclight Capital clients requesting a reporting data feed from the ARC generic reporting interface for purposes of integrating that data with third-party software. We provide, on request, reporting data for the following, each in a separate file:

  • P&L
  • Position
  • Security
  • Account
  • Activity
  • Cash Report
  • NAV

    Reporting Integration Process
    Copy Location

    Integrating your IB reporting data with third-party software includes the following steps:

    • Request a reporting data feed from Arclight Capital by sending an email to reportingintegration@arclightcapital.cc.
    • Arclight Capital prepares the requested files.
    • The data files are transmitted to the customer via FTP. See Transmitting Files for detailed instructions.
    • You integrate the reporting data files with third-party software.

    Reporting File Types
    Copy Location

    You can choose to receive any of the following types of reporting files.

    Start of day (SOD) reporting file types:

    • Account – Contains general account information, including Account ID, Title, etc.
    • Activity – Contains all trade activity, transfers, dividends, etc. as of the report date.
    • Cash Report – Contains cash balances in total, and for the securities and futures segments of your account.
    • NAV Report – Contains the Net Asset Value (NAV) of all positions by asset class (stock, securities options, warrants and bonds), cash and accruals.
    • P&L  – Contains mark-to-mark and short-term (ST) and long-term (LT) realized and unrealized profit and loss information for your account.
    • Positions – Contains positions (including cash and accrual balances) as of the report date.
    • Securities – Contains detailed security information for all assets traded or held.

    End of day (EOD) reporting file types:

    • Trade Confirms – Contains trade activity.

    See File Layouts for detailed descriptions of the contents of each type of file.

    Requesting a Reporting Data Feed
    Copy Location

    When you request a reporting data feed from Arclight Capital, your email must contain the following information:

    • Include the text “I would like to integrate my Arclight Capital reporting data with _______.” Fill in the blank with the name of the software vendor.
    • The software vendor’s contact information.
    • Your Arclight Capital Account ID.
      If you are a Master Account User (for example, a Financial Advisor), include the Account IDs of all of the client and/or sub accounts for which you would like reporting data.
    • The Reporting File Types you are requesting.
    • Delivery information: Tell us how you want the files delivered. IB can host the files on our FTP/sFTP site, can upload them to your FTP/sFTP site, or can make them available for download. Include your PGP Public Key for file encryption. See Transmitting Files for detailed instructions.
    • Selected options. See Configuring Reporting Data Files for detailed instructions.

    Note that the date of the reporting data is always the last business day. Typically there is no data available for New Year’s Day.

    File Naming Convention
    Copy Location

    By default, all reporting data files are text files (*.txt). You can use a different file name extension (for example, *.csv) as long as you include it with your configuration options. Regardless of the type of reporting file you choose to receive, the file name follows this convention:

    <AccountID>_<FileType>_<AsOfDate:yyyyMMdd>.txt

    where:

    • <AccountID> is your Arclight Capital Account ID. This can be replaced by a Third-Party Account Reference, if provided. See Configuring Reporting Data Files for more information on including a Third-Party Account Reference.
    • <FileType> is the type of reporting file: Account, Activity, Positions, or Securities.
    • <AsOfDate:yyyyMMdd> is the “as of” reporting date, in the format yyyymmdd. This is always the last business day.

    Examples
    Copy Location

    U000000_Activity_20100317.txt

    This example uses an IB Account ID (U000000), Activity as the file type, and a reporting date of March 17, 2010 (20100317).

    XYZCorp_Bookkeeping_20100317.txt

    This example uses a Third Party Account Reference (“XYZCorp”) instead of your IB Account ID, a custom value of “Bookkeeping” for the file type (instead of Activity), and a reporting date of March 17, 2010 (20100317)

    Configuring Reporting Data Files
    Copy Location

    When you request IB reporting data, you can configure the features listed below. You must include your configuration options in your request email so that we can create the files correctly.

    • File Type: You can choose one or more of these file types: Account, Activity, Cash Report, NAV, P&L, Positions, Securities, and Trade Confirms.
      If you choose the Activity file, you can also include summarized trade data. You can summarize trade data by symbol – for each symbol, there will be one record for buys and one record for sells, if applicable. For advisors and brokers, client fees are also summarized at the account level.
    • If you choose the Positions file, you can choose additional levels of detail called Tax Lots and/or Open Dividend Accruals.
    • Preferred Version – This is the version of the report fields. The default is 1.0. As we update our report fields, the Version will also be updated (for example, 1.0 will be updated to 1.1).
    • Field Delimiter – Specify pipe or comma. If a data field contains a delimiter character, the data will be wrapped in double quotes. This option is required.
    • Date Format – Indicates how dates will appear in the report data. The default date format is yyyymmdd but you can specify whatever date format you prefer. For example, you could request that the date format be mmddyyyy.
    • Number Format – Indicates how numbers will appear in the report data. The default number format is ###0.#########.
    • Third Party Account Reference – If you provide this information, it will be used in the file names and header records instead of your IB Account ID. This option is not required.
    • Include Header/Trailer Records – Specify whether or not you want header and trailer records included in the report data. If you want header and trailer records, they will be included in ALL reporting file types.
    • Include Column Header – Specify whether or not you want column headers included in the report data files.
    • Use PGP Encryption for FTP/sFTP- Required for the reporting data files. You must provide ARC with your Public Key and files will be encrypted using the key.
    • File name extension – Specify the file name extension of your data files. For example, *.csv. The default value is *.txt.

    You do not have to request all of the above configuration options. The default value will be used for any configuration option you do not request.

    Use line feed (LF) as the end-of-line character.

    Transmitting Files
    Copy Location

    Report data files can be delivered via FTP or sFTP (or Web Service is alternatively available), options outlined below:

    • ARC hosted Plain FTP (port 21 with PGP encryption)
      • IB will provide host, username, password.
      • You will provide IB with a PGP public key.
    • IB hosted sFTP (port 22 with PGP encryption)- uses key-based authentication
      • IB will provide host, username, and directory
      • You will provide IB with RSA key for key-based authentication and IP address(es) you will be connecting from.
    • Third-party hosted Plain FTP (port 21 with PGP encryption)
      • You will provide host, username, password, directory.
      • You will provide IB with PGP public key.
    • Third-Party hosted sFTP (with PGP encryption). You will provide ARC with-
      • Host, username, directory, port.
      • IB will provide RSA key (for key-based authentication) and IP address to white-list.
    • Web Service
      • We will provide additional details via email.

    Tell us in your request email to reportingintegration@arclightcapital.cc your delivery preference and we will assist with setting up the configuration.

    If you request delivery of report data files as downloadable files, the files will be available from the Activity Downloads page, which you access from the Third-Party Reports menu in Client Portal.

    File Layouts
    Copy Location

    This chapter describes the layout of each reporting file. The following topics are included:

    Start of day (SOD):

    End of day (EOD):

    The Version column in the file layout tables indicates the version number when a field first appeared.

    See Sample Files in the next chapter for samples of reporting files.

    Account File Layout
    Copy Location

    Some items in the Account file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

    Header Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0H
    Acct RefAlphanumeric1.0The IB account number (configurable)
    File TypeAlphanumeric1.0Account (configurable)
    Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
    Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
    As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
    VersionNumeric1.0Version of the file layout used.

    Account Record

    ColumnTypeVersionComments
    TypeAlphanumeric1.0D
    AccountIDAlphanumeric1.0Account number
    AccountTitleAlphanumeric1.0Full account title
    StreetAlphanumeric1.0Street address
    Street2Alphanumeric1.0Additional street address
    CityAlphanumeric1.0City
    StateAlphanumeric1.0State
    ZipAlphanumeric1.0Postal code
    CountryAlphanumeric1.0Country
    AccountTypeAlphanumeric1.0Values will be one of:
    – Individual (Single)
    – Institution Master
    – Institution Client
    – Advisor Master
    – Advisor Master Consolidated
    – Advisor Client
    – Broker Master
    – Broker Master Consolidated
    – Broker Client
    – Fund Advisor (also known as Fund Investment Manager)
    CustomerTypeAlphanumeric1.0Values will be one of:
    – Individual
    – Joint
    – Trust
    – IRA
    – Corporate
    – Partnership
    – Limited Liability Corporation
    – Unincorporated Business
    – IRA Traditional Rollover
    – IRA Traditional New
    – IRA Traditional Inherited
    – IRA Roth New
    – IRA Roth Inherited
    – IRA SEP New
    – IRA SEP Inherited
    BaseCurrencyAlphanumeric1.0Base Currency of the account
    MasterAccountIDAlphanumeric1.6 
    VanAlphanumeric1.6Virtual Account Number
    CapabilitiesAlphanumeric1.7Account Capabilities: Cash, Margin, Portfolio Margin
    TradingPermissionsAlphanumeric1.7Asset class Note: Excluded from versions 1.98 and above.
    AliasAlphanumeric1.8Account alias
    PrimaryEmailAlphanumeric1.9Email address
    DateOpenedAlphanumeric1.92Date account was opened (date format configurable)
    DateClosedAlphanumeric1.92Date account was closed (date format configurable)
    DateFundedAlphanumeric1.98Date account was funded (date format configurable)
    IBExecutionAlphanumeric1.97 
    IBPrimeAlphanumeric1.97 
    AccountRepresentativeAlphanumeric1.98Account Representative
    DefaultTaxBasisElectionAlphanumeric1.992DefaultTaxBasisElection
    Values are:
    – FI (First In, First Out)
    – LIFO (Last In, First Out)
    – ML – Maximize Losses
    – HC – Highest Cost tax lot-matching method
    – MLG – Maximize Long-Term gain tax lot-matching method
    – MLL – Maximize Long-Term loss tax lot-matching method
    – MSG – Maximize Short-Term gain tax lot-matching method
    – MSL – Maximize Short-Term loss tax lot-matching method
    – SL – Specific Lot tax lot-matching method
    IBKREntityAlphanumeric1.992 

    Trailer Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0T
    Record CountNumeric1.0Including header and trailer

    Activity File Layout
    Copy Location

    Some items in the Activity file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

    Header Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0H
    Acct RefAlphanumeric1.0The IB account number (configurable)
    File TypeAlphanumeric1.0Activities (configurable)
    Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
    Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
    As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
    VersionNumeric1.0Version of the file layout used.

    Activity Record

    ColumnTypeVersionComments
    TypeAlphanumeric1.0D
    AccountIDAlphanumeric1.0Account number
    ConIDNumeric1.0Internal unique identifier for all asset types.
    Full asset information can be found in the Security File Layout. Empty for Asset Type CASH.
    SecurityIDAlphanumeric1.0ISIN for US and nonUS securities
    SymbolAlphanumeric1.0Empty for Asset Type CASH
    BBTickerAlphanumeric1.91Bloomberg ticker
    BBGlobalIDAlphanumeric1.94Bloomberg Global ID. Note: Limited to 1.94-1.993
    FIGIAlphanumeric1.994Bloomberg Global ID. Note: Limited to 1.994 and greater
    SecurityDescriptionAlphanumeric1.9Description of the security
    AssetTypeAlphanumeric1.0For more information, see Asset Types.
    CurrencyAlphanumeric1.0Currency of the asset
    BaseCurrencyAlphanumeric1.0Base currency of the account
    TradeDateAlphanumeric1.0CCYYMMDD (date format configurable)
    Note: Clearing trade date (per local exchange) in versions 1.993 and greater
    TradeTimeAlphanumeric1.9Time of the trade, in HH:mm:ss format Note: Limited to version 1.9-1.992
    DateTimeAlphanumeric1.993The Execution Date and Time (CCYYMMDD HH:mm:ss)
    SettleDateAlphanumeric1.0CCYYMMDD (date format configurable)
    OrderTimeAlphanumeric1.99 CCYYMMDD HH:mm:ss (date format configurable)
    TransactionTypeAlphanumeric1.0For more information, see Transaction Type.
    ImpactsCashAlphanumeric1.994Values will be Y or N
    QuantityNumeric1.0Note the following regarding sign:
    If buy 100 = 100
    If sell 100 = -100
    If cancel buy = 100
    If cancel sell = -100
    UnitPriceNumeric1.0 
    GrossAmountNumeric1.0Quantity * Price (V1.1 or earlier)
    -Quantity * Price (V1.2 or later) 
    Note that this is a general formula and does not consider multipliers or notional price (futures), bond pricing (/100), etc.
    SECFeeNumeric1.0 
    CommissionNumeric1.0Negative amount indicates commission charged.
    Positive amount indicates commission rebate.
    For Forex trades, the commission is reported in base currency.
    TaxNumeric1.0 
    NetNumeric1.0Total cash received or delivered.
    Not included on Forex trades.
    For Futures and CFDs, this is the transaction MTM.
    NetInBaseNumeric1.0Total cash received or delivered.
    For Futures and CFDs, this is the transaction MTM.
    RealizedPLNumeric1.994Realized profit or loss in local currency
    RealizedPLInBaseNumeric1.994Realized profit or loss in base currency
    TradeIDAlphanumeric1.0Trade ID, unless cancel or correction, then it is the original Trade ID
    TaxBasisElectionAlphanumeric1.0For trades, represents the tax basis election.
    Values are:
    – FI (First In, First Out)
    – LIFO (Last In, First Out)
    – ML – Maximize Losses
    – HC – Highest Cost tax lot-matching method
    – MLG – Maximize Long-Term gain tax lot-matching method
    – MLL – Maximize Long-Term loss tax lot-matching method
    – MSG – Maximize Short-Term gain tax lot-matching method
    – MSL – Maximize Short-Term loss tax lot-matching method
    – SL – Specific Lot tax lot-matching method
    DescriptionAlphanumeric1.0Activity description
    FXRatetoBaseNumeric1.1Conversion rate from asset currency to base currency.
    ContraPartyNameAlphanumeric1.2For DVP records that represent the contra broker.
    ClrFirmIDAlphanumeric1.3For DVP records, the contra broker’s ID.
    ExchangeAlphanumeric1.5Included for trades.
    MasterAccountIDAlphanumeric1.6The Account ID of the master account.
    VanAlphanumeric1.6Virtual Account Number
    AwayBrokerCommissionNumeric1.93The away broker’s commission charge.
    OrderIDAlphanumeric1.93The IB Order ID.
    ClientReferenceAlphanumeric1.95Client note entered by cashiering.
    TransactionID 1.96The IB TransactionID.
    ExcecutionIDAlphanumeric1.99The IB ExecutionID.
    CostBasisAlphanumeric1.99The basis of an opening trade is the inverse of proceeds plus commission and tax amount. For closing trades, the basis is the basis of the opening trade.
    FlagAlphanumeric1.99For more information, see Flag Codes
    ActionIDAlphanumeric1.992The IB ActionID
    LevelofDetailAlphanumeric1.992Executions, Symbol Summary, Orders
    OrderTypeAlphanumeric1.994
    OrderReferenceAlphanumeric1.994
    BrokerageOrderIDAlphanumeric1.994

    Trailer Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0T
    Record CountNumeric1.0Including header and trailer

    Cash Report File Layout
    Copy Location

    This optional file type contains cash balances in total, and for the securities and futures segments of your account. This information is similar to what is displayed in the Cash Report section of activity statements.

    Header Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0H
    Acct RefAlphanumeric1.0The IB account number (configurable)
    File TypeAlphanumeric1.0Account (configurable)
    Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
    Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
    As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
    VersionNumeric1.0Version of the file layout used.

    Cash Report Record

    ColumnTypeVersionComments
    TypeAlphanumeric1.0D
    AccountIDAlphanumeric1.0Account number
    ReportDate 1.96CCYYMMDD (date format configurable)
    CurrencyAlphanumeric1.0Currency
    BaseSummaryAlphanumeric1.0Is this your base currency (Y or N)
    Change in Insured Bank DepositNumeric1.0Changes in amount swept in Insured Bank Deposit Program by currency.
    LabelAlphanumeric1.0Description of the item. This matches the line labels in an activity statement.
    TotalNumeric1.0Total cash balance of your account.
    SecuritiesNumeric1.0Cash balance in the Securities segment of your account.
    FuturesNumeric1.0Cash balance in the Futures (Commodities) section of your account.
    IBUKLNumeric1.0Cash balance in your IB-UKL account.
    PAXOSNumeric1.991Cash balance in your account held at Paxos.

    Trailer Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0T
    Record CountNumeric1.0Including header and trailer

    Position File Layout
    Copy Location

    Some items in the Positions file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

    Header Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0H
    Acct RefAlphanumeric1.0The IB account number (configurable)
    File TypeAlphanumeric1.0Positions (configurable)
    Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
    Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
    As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
    VersionNumeric1.0Version of the file layout used.

    Position Record

    ColumnTypeVersionComments
    TypeAlphanumeric1.0D for position summary, or
    L for tax lot
    O for Open Dividend Accruals
    AccountIDAlphanumeric1.0Account number
    ConIDNumeric1.0Internal unique identifier for all asset types. Full asset information can be found in the Security File Layout.
    Empty for Asset Type CASH, INTACC and DIVACC.
    SecurityIDAlphanumeric1.0ISIN for US and nonUS securities
    SymbolAlphanumeric1.0Empty for Asset Type CASH, INTACC and DIVACC
    BBTickerAlphanumeric1.91Bloomberg ticker
    BBGlobalIDAlphanumeric1.94Bloomberg Global ID Note: Limited to 1.94-1.993
    FIGIAlphanumeric1.994Bloomberg Global ID Note: Limited to 1.994 and greater
    SecurityDescriptionAlphanumeric1.9Description of the security
    AssetTypeAlphanumeric1.0For more information, see Asset Types.
    CurrencyAlphanumeric1.0Currency of the asset
    BaseCurrencyAlphanumeric1.0Base currency of the account
    QuantityNumeric1.0Note the following regarding sign:
    If Long 100=100
    If Short 100=-100
    QuantityInBaseNumeric1.0Applies only for Asset Type CASH
    As of Trade Date. Positive quantity indicates long; negative quantity indicates short.
    CostPriceNumeric1.0Average cost price in currency of the asset
    CostBasisNumeric1.0Cost basis in the currency of the asset
    CostBasisInBaseNumeric1.0Cost basis in the base currency of the account
    MarketPriceNumeric1.0Current market price in the currency of the asset
    MarketValueNumeric1.0Current market value in the currency of the asset
    MarketValueInBaseNumeric1.0Current market value in the base currency of the account
    UnrealizedPLNumeric1.994Unrealized profit or loss in local currency
    UnrealizedPLinBaseNumeric1.994Unrealized profit or loss in base currency
    OpenDateTimeAlphanumeric1.0For tax lot rows, the open date and time. Only applies to tax lot rows.
    FxRateToBaseNumeric1.1Conversion rate from asset currency to base currency.
    ReportDateAlphanumeric1.4CCYYMMDD Data On Record As-Of Date (date format configurable)
    SettledQuantityNumeric1.5Populated for cash records only.
    SettledQuantityInBaseNumeric1.5Populated for cash records only.
    MasterAccountIDAlphanumeric1.6Account ID of the master account.
    VanAlphanumeric1.6Virtual Account Number
    AccruedIntNumeric1.93The amount of interest accrued on bonds. Populated for the BOND asset category where available.
    OriginatingOrderIDNumeric1.94Order ID of the originating order
    MultiplierNumeric1.96Multiplier of position
    ActionIDAlphanumeric1.994

    Trailer Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0T
    Record CountNumeric1.0Including header and trailer

    P&L File Layout
    Copy Location

    This optional file includes mark-to-mark and short-term (ST) and long-term (LT) realized and unrealized profit and loss information for your account.

    Header Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0H
    Acct RefAlphanumeric1.0The IB account number (configurable)
    File TypeAlphanumeric1.0PL
    Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
    Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
    As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
    VersionNumeric1.0Version of the file layout used.

    PL Record

    ColumnTypeVersionComments
    AccountIDAlphanumeric1.0Account number
    InternalAssetIDNumeric1.0Internal unique ID for the asset type.
    SecurityIDAlphanumeric1.0ISIN for US and nonUS securities
    SymbolAlphanumeric1.0Empty for asset type CASH
    BBTickerAlphanumeric1.91Bloomberg ticker
    BBGlobalIDAlphanumeric1.94Bloomberg Global ID Note: Limited to 1.94-1.993
    FIGIAlphanumeric1.994Bloomberg Global ID Note: Limited to 1.994 and greater
    SecurityDescriptionAlphanumeric1.0Security name
    AssetTypeAlphanumeric1.0For more information, see Asset Types. 
    CurrencyAlphanumeric1.0Currency of the asset
    ReportDateAlphanumeric1.0CCYYMMDD (date format configurable)
    PositionMTMNumeric1.0Position mark-to-market profit or loss in local currency
    PositionMTMInBaseNumeric1.0Position mark-to-market profit or loss in base currency
    TransactionMTMNumeric1.0Transaction mark-to-market profit or loss in local currency
    TransactionMTMInBaseNumeric1.0Transaction mark-to-market profit or loss in base currency
    RealizedSTNumeric1.0Realized short-term profit or loss in local currency
    RealizedSTInBaseNumeric1.0Realized short-term profit or loss in base currency
    RealizedLTNumeric1.0Realized long-term profit or loss in local currency
    RealizedLTInBaseNumeric1.0Realized long-term profit or loss in base currency
    UnrealizedSTNumeric1.0Unrealized short-term profit or loss in local currency
    UnrealizedSTInBaseNumeric1.0Unrealized short-term profit or loss in base currency
    UnrealizedLTNumeric1.0Unrealized long-term profit or loss in local currency
    UnrealizedLTInBaseNumeric1.0Unrealized long-term profit or loss in base currency
    FXRatetoBaseNumeric1.992Conversion rate from asset currency to base currency.

    Trailer Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0T
    Record CountNumeric1.0Including header and trailer

    Security File Layout
    Copy Location

    Some items in the Security file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

    Header Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0H
    Acct RefAlphanumeric1.0The IB account number (configurable)
    File TypeAlphanumeric1.0Securities (configurable)
    Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
    Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
    As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
    VersionNumeric1.0Version of the file layout used.

    Security Record

    ColumnTypeVersionComments
    TypeAlphanumeric1.0D
    ConIDNumeric1.0Internal unique identifier for all asset types.
    AssetTypeAlphanumeric1.0For more information, see Asset Types.
    SecurityIDAlphanumeric1.0ISIN for US and nonUS securities
    SymbolAlphanumeric1.0Empty for Asset Type CASH
    CUSIPAlphanumeric1.99 
    BBTickerAlphanumeric1.91Bloomberg ticker
    BBTickerAndExchangeCodeAlphanumeric1.91Bloomberg ticker + exchange code
    BBGlobalIDAlphanumeric1.94Bloomberg Global ID. Note: Limited to 1.94-1.993
    FIGIAlphanumeric1.994Bloomberg Global ID Note: Limited to 1.994 and greater
    DescriptionAlphanumeric1.0Security Name
    UnderlyingSymbolAlphanumeric1.0For derivatives
    UnderlyingCategoryAlphanumeric1.97For derivatives
    UnderlyingSecurityIDAlphanumeric1.97For derivatives
    UnderlyingPrimaryExchangeAlphanumeric1.97For derivatives
    UnderlyingConIDAlphanumeric1.98For derivatives
    MultiplierNumeric1.0 
    ExpirationDateAlphanumeric1.0CCYYMMDD Option or Future expiration date (date format configurable)
    OptionTypeAlphanumeric1.0P for Put, C for Call
    OptionStrikeNumeric1.0Strike price
    MaturityDateAlphanumeric1.0Bond maturity date
    IssueDateAlphanumeric1.0Note issue date
    PrimaryExchangeAlphanumeric1.96The exchange the security is listed on (stocks only).
    CurrencyAlphanumeric1.96Currency of the asset
    SubCategoryAlphanumeric1.97Available for stocks
    IssuerAlphanumeric1.98Security issuer
    Delivery MonthAlphanumeric1.99 
    PrincipalAdjustFactorAlphanumeric1.992IB calculated principal adjustment for bonds

    Trailer Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0T
    Record CountNumeric1.0Including header and trailer

    Trade Confirms File Layout
    Copy Location

    Some items in the Activity file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

    Header Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0H
    Acct RefAlphanumeric1.0The IB account number (configurable)
    Trade ConfirmsAlphanumeric1.0Activities (configurable)
    Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
    Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
    As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
    VersionNumeric1.0Version of the file layout used.

    Activity Record

    ColumnTypeVersionComments
    TypeAlphanumeric2.0D
    AccountIDAlphanumeric2.0Account number
    ConIDNumeric2.0Internal unique identifier for all asset types. Full asset information can be found in the SOD Security File Layout.
    Empty for Asset Type CASH.
    SecurityIDAlphanumeric2.0ISIN for US and nonUS securities
    CUSIPAlphanumeric2.0 
    SymbolAlphanumeric2.0Empty for Asset Type CASH.
    BBTickerAlphanumeric2.0Bloomberg ticker
    FIGIAlphanumeric2.0Bloomberg Global ID
    SecurityDescriptionAlphanumeric2.0Security Name
    AssetTypeAlphanumeric2.0For more information, see Asset Types.
    CurrencyAlphanumeric2.0Currency of the asset
    BaseCurrencyAlphanumeric2.0Base currency of the account
    MultiplierAlphanumeric2.0 
    StrikeNumeric2.0Strike price
    ExpirationAlphanumeric2.0CCYYMMDD Option or Future expiration date (date format configurable)
    PutCallAlphanumeric2.0P for Put, C for Call
    TradeDateAlphanumeric2.0CCYYMMDD (date format configurable)
    TradeTimeAlphanumeric2.0Time of the trade, in HH:mm:ss format
    SettleDateAlphanumeric2.0CCYYMMDD (date format configurable)
    TransactionTypeAlphanumeric2.0For more information, see Transaction Type.
    QuantityNumeric2.0Note the following regarding sign:
    If buy 100 = 100
    If sell 100 = -100
    If cancel buy = 100
    If cancel sell = -100
    UnitPriceNumeric2.0 
    GrossAmountNumeric2.0Quantity *Price* Multiplier
    CommissionNumeric2.0Negative amount indicates commission charged.
    Positive amount indicates commission rebate.
    For Forex trades, the commission is reported in base currency.
    BrokerExecutionCommissionNumeric2.0The total amount of IB execution charge applied to the trade.
    BrokerClearingCommissionNumeric2.0The total amount of IB clearing charge applied to the trade.
    ThirdPartyExecutionCommissionNumeric2.0The total amount of third party execution charges applied to the trade.
    ThirdPartyClearingCommissionNumeric2.0The total amount of third party clearing charges applied to the trade.
    ThirdPartyRegulatoryCommissionNumeric2.0The total amount of third party regulatory charges applied to the trade.
    OtherCommissionNumeric2.0The total amount of other charges applied to the trade.
    CommissionCurrency 2.0The currency denomination of the commission.
    TaxNumeric2.0 
    ExchangeAlphanumeric2.0Exchange trade was executed
    TradeIDAlphanumeric2.0Trade ID, unless cancel or correction, then it is the original Trade ID
    OrderIDAlphanumeric2.0The IB Order ID.
    DescriptionAlphanumeric2.0Activity description
    ClrFirmIDAlphanumeric2.0For DVP records, the contra broker’s ID.
    ContraPartyNameAlphanumeric2.0For DVP records that represent the contra broker.
    BrokerAccountAlphanumeric2.0For DVP records that represent the contra broker account.
    DirectionAlphanumeric2.0For DVP records
    TransferredCommissionAlphanumeric2.0For DVP records
    TransferredSECFeesAlphanumeric2.0For DVP records
    MasterAccountIDAlphanumeric2.0The Account ID of the master account.
    VanAlphanumeric2.0Virtual Account Number
    ExecutionIDAlphanumeric1.992IB ExecutionID
    NetCashAlphanumeric1.992Total Cash received or delivered

    Trailer Record

    ColumnTypeVersionComments
    Record IDAlphanumeric1.0T
    Record CountNumeric1.0Including header and trailer

    Activity Codes
    Copy Location

    Transaction Type: The following table lists all of the transaction type codes referenced in the Activity file layouts.

    CodeVersionDescription
    ADJ1.0Adjustments, including:
    – Client Fees
    – Commission Adjustments
    – Option Cash Settlements
    – Position MTM (Futures, CFDs)
    – Price Adjustments (Futures, CFDs)
    ASSIGN1.0Assignment
    BUY1.0Buy
    CA1.0Cancel
    CADJ1.994Commission adjustment
    CCRE1.994Commission Credits (promotions)
    CFD1.0CFD Interest and Fees
    CFEE1.994Client fees
    CINT1.0Credit Interest on cash balances
    CO1.0Correct
    CORP1.0Corporate Actions including splits, mergers, acquisitions, etc.
    Summary of the corporate action will be included in the Description field
    COVER1.0Cover Short
    CSET1.994Cash settlements (i.e. options)
    DCARD1.0Debit/Prepaid Card Activity
    DEL1.0Transfer of Securities (outgoing)
    DEP1.0Deposit of Funds (including cash transferred in)
    DEPH1.0Deposits on Hold
    DINT1.0Debit Interest on cash balances and hard to borrow fees
    DIV1.0Dividends
    DIVACC1.1Dividend Accrual Activity
    DIVR1.0Dividend Reinvestment
    DVPCA1.2Cancelled DVP
    DVPIN1.2Incoming DVP
    DVPOUT1.2Outgoing DVP
    EXE1.0Exercise
    EXP1.0Expire
    FRTAX1.0Foreign Tax Withholding
    GEA1.0Expiration or Assignment resulting from offsetting positions
    IBGN1.994IBG Notes
    INSDEP1.97Insured Bank Deposit Interest
    INSDEPACC1.97Insured Bank Deposit Interest Accrual
    INSDEPXFR1.97Insured Deposit Transfer
    INTACC1.1Interest Accrual Activity
    INTP1.0Investment Interest Paid (from Bonds, Notes)
    INTR1.0Investment Interest Received (from Bonds, Notes)
    IPOSUB1.0IPO Subscription Activity
    MFEE1.0Management Fee
    OFEE1.0Other Fees including market data, order cancellations, etc.
    PADJ1.994Price adjustments (i.e., futures, CFDs)
    PIL1.0Payment in Lieu of Dividends
    PMTM1.994Position MTM (i.e. futures, CFDs)
    REC1.0Receipt of Securities (incoming)
    SCOM1.0Settled Commission
    SELL1.0Sell
    SHORT1.0Sell Short
    STAX1.0Sales Tax (Canada PST/GST/HST)
    TTAX1.0Transaction tax records that are reported separately from trades (i.e., daily trading charges).
    WITH1.0Withdrawal of Funds (including cash transferred out)

    Flag Codes
    Copy Location

    Flag related to Corporate Action transaction type (CORP) and Unbooked Trades referenced in the Activity file layouts.

    Flag CodesDescription
    ORAsset Purchase
    BCBond Conversion
    BMBond Maturity
    CDCash Dividend
    HDChoice Dividend Delivery
    HIChoice Dividend Issue
    CCContact Consolidation
    CAContract Soulte (a type of cash settlement)
    COContract Spin Off
    CSContract Split
    CIConvertible Issue
    CPCoupon Payment
    DWDelist Worthless
    DIDividend Rights Issue
    EDExpire Dividend Right
    FAFee Allocation
    FSForward Split
    GVGeneric Voluntary
    ICIssue Change
    FIIssue Forward Split
    TCMerger
    PCPartial Call Issue
    RSReverse Split
    PIShare Purchase Issue
    SOSpin Off
    SDStock Dividend
    RISubscribable Rights Issue
    SRSubscribe Rights
    TMTbill Maturity
    TITender Issue
    UBUnbooked Trades
    UEUnknown Event
    TOVoluntary Conversion

    Asset Types
    Copy Location

    The following table lists all of the asset types referenced in the Activity, Positions, and Securities file layouts.

    CodeVersionDescription
    BILL1.0Treasury Bills
    BOND1.0Bonds (includes corporate and municipal)
    CASH1.0Forex
    CFD1.0Contracts for Differences
    CMDTY1.0Gold or silver (Metals)
    CRYPTO1.0Cryptocurrency
    DIVACC1.1Dividend Accrual Balance
    EVENT_FORECASTX1.0Forecast Contracts
    FOP1.0Future Options
    FSFOP1.0Options on Futures (Futures Style)
    FSOPT1.0Options (Futures Style)
    FUND1.0Mutual Funds
    FUT1.0Futures
    FXCFD1.0Contract for Difference on forex
    FXFWD1.0FX Forwards
    IBGNOTE1.0IB Notes
    INTACC1.1Interest Accrual Balance
    IOPT1.0Structured Products
    OPT1.0Equity and Index Options
    STK1.0Stocks (includes ADR, ETF)
    WAR1.0Warrants

    Currency
    Copy Location

    Available currencies that can populate in data files:

    Currency FieldDescription
    AUDAustralian Dollar
    GBPBritish Pound
    CADCanadian Dollar
    CNHChinese Offshore Yuan
    CZKCzech Koruna
    DKKDanish Krone
    EUREuro
    HKDHong Kong Dollar
    HUFHungarian Forint
    ISLIsraeli Shekel
    JPYJapanese Yen
    KRWKorean Won
    MYRMalaysian Ringgit
    MXNMexican Peso
    NZDNew Zealand Dollar
    NOKNorwegian Kroe
    PLNPolish Zloty
    SARSaudi Riyal
    SGDSingapore Dollar
    ZARSouth African Rand
    SEKSwedish Krone
    CHFSwiss Franc
    TRYTurkish Lira
    AEDUnited Arab Emirates Dirham
    USDUnited States Dollar

    Sample Files
    Copy Location

    Please reach out to reportingintegration@arclightcapital.cc to request the latest sample files.

    ARC Campus Newsletters

    This website uses cookies to collect usage information in order to offer a better browsing experience. By browsing this site or by clicking on the "ACCEPT COOKIES" button you accept our Cookie Policy.