fbpx
Your 'Go To' for Custom Excel Solutions

Interactive Broker Upload Trade feature not working

Our Services Forums Share Trade Tracker Report a Problem Interactive Broker Upload Trade feature not working

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #2200

    skate
    Participant

    Share Trade Tracker v3.1.6 includes fixes for the Interactive Brokers upload trade feature that addresses the issues being experienced by some users

    See here for the release notes on this release.

    Release v3.1.6 – Fix to Interactive Brokers Upload Trades not loading Exchange

    Access to the upgrade is available through the “Upgrade” option on the ribbon.

    Regards
    Scott Lindsay
    Development Manager, XLAutomation
    Buderim, Queensland
    Australia

    #2191

    Scott Lindsay
    Keymaster

    Included to the most recent release of Share Trade Tracker v3.1.4 was a new feature to upload trade data directly from an Interactive Broker CSV file download.

    That feature is not working for some users as the format of the CSV file is not as expected by the upload trade routine in Share Trade Tracker.

    The expected file format should include 13 columns, but for some users on 12 columns were being exported which results in an upload error.

    The CSV file should contain the following column headings for a valid upload
    Security Type
    Currency
    Action
    Quantity
    Symbol
    Price
    Time
    Date
    Exch.
    Account
    Order Ref.
    Commission
    Clearing

    The last column was being automatically included for some users and not others.
    The XLAutomation support team is working on a resolution to this issue and should release a fix soon

    As a workaround users can edit the CSV file and included the expected columns in the order listed above and the upload will work
    The final column “Clearing” that is missing for some users does not need to have any values.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.