Automatic Interactive Brokers XML update

GOEKAY_TUNA · March 29, 2020, 9:13am

Dear All,

I am not sure if this topic has been discussed earlier. Apologies if you already did.

There is a possibility in interactive brokers to activate a service called Flex Web service and this gives you a token ID. With this token id a request can be made to a URL with the activity XMLK query ID and XML activity results can be downloaded with this query ID.

I am not a developer myself, so i can not contribute but if this is integrated into PP, this will ease so many peoples’ lives. the report can then be executed as per last business days and can be parsed with PP automatically with the given query ID and token ID.

details to use this service can be found here.
https://www.interactivebrokers.com/en/software/am/am/reports/flex_web_service_version_3.htm

is this something somebody can integrate in quickly?

thanks for all your help.

best, Goekay

turbodackel · March 30, 2020, 8:19am

Hello Gokay,

take a look at

Its the discussion about importing FlexQeury from IB. Sorry discussion is in german. Maybe you could try to translate using deepl or google.

GOEKAY_TUNA · March 30, 2020, 11:17am

Hi turbodackel,

I have checked the interactive brokers discussion. My request is not about creating a Flex Query. It is very easy to do so with the information we have in the forum.

My goal is to automate this. At the moment everybody manually extracts and imports the data from IB to PP with flex query. Think about it. You create in IB the flex query once and it gets automatically pulled by PP without you interfere every day with updated values, even maybe couple times a day.

You make a call to a URL with flex query ID and your API ID, this generates a key then you use this key and your API Key again, then all XML is created. If your flex query generates it daily, PP can import this automatically.

Please let me know your thoughts. This will save significant amount of time for so many.

Best, Goekay

GOEKAY_TUNA · March 30, 2020, 11:21am

Hi @turbodackel and All,

there is already a python project on this if this would be a help

github.com

alexpung/IB_Flex/blob/master/xml_downloader.py

import time
import urllib.parse
import urllib.request
import xml.etree.ElementTree as ET

REQUEST_VERSION = '3'
XML_VERSION = '3'
INITIAL_WAIT = 5  # Waiting time for first attempt
RETRY = 7  # number of retry before aborting
RETRY_INCREMENT = 10  # amount of wait time increase for each failed attempt


def make_xml_request(token, report_number, version):
    """Step 1 : Request IB to generate the flex query file by giving a request with the token
        note that the server is not always up and sometimes it is down on Sat/Sun"""
    url_values = urllib.parse.urlencode({'t': token, 'q': report_number, 'v': version})
    base_url = 'https://gdcdyn.interactivebrokers.com/Universal/servlet/FlexStatementService.SendRequest'
    full_url = base_url + '?' + url_values
    with urllib.request.urlopen(full_url) as xml_request_response:
        root = ET.fromstring(xml_request_response.read())

This file has been truncated. show original

Best, Goekay

turbodackel · March 31, 2020, 10:11am

Hello Goekay,

really nice idea. Will take a look at this.

Ulrich

kyuparskim · October 10, 2022, 2:06pm

Hi, I am sorry, I am new to this and couldn’t find information anywhere. Can someone please explain how to set up the Interactive Brokers Flex Web Service in PP? I have activated in IBKR but how do I actually make it work?

Many thanks,
Momchil

segi · October 20, 2022, 9:23am

Try this Portfolio Performance – Unified Theory