Add Interactive Brokers

I would like to suggest that you add Interactive Brokers (Australia): https://www.interactivebrokers.com.au...
72 people like
this idea
+1
Reply
next » « previous
  • 1
    Team Sharesight, I understand the issues that may cause this to be a slow burner with IB and their API......however as my email is constantly peppered with +1's to this thread, the team need to find a suitable workaround in the interim.

    At the very least can you not build a custom import based on the trade report that IB spits out? Or even more rudimentary, can you please create an Excel macro or something to convert the IB report into a Sharesight friendly format? Maybe even a web link I can submit the file to and have it modified and uploaded into my portfolio.

    I just went through the process manually for about 10 trades, converting the IB output to the Sharesight template and it's a bloody headache and took me at least 20 minutes.

    Let's get cracking with the MVP Lean Startup version of the solution, Team Sharesight!
    • view 2 more comments
    • Thanks Duncan,

      As per my direct message, using the files you have provided I will see what we can do as a MVP integration.
    • I have been in this industry for over 25 years. IB data feed is the most difficult one that I have come across. If you know what you are doing then it will be simple plus your platform has to be designed to accomodate this feed?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • 1
    In addition to my earlier post, is there any reason you couldn't use the flex web service that IB support?

    It appears I could customise a flexi report in IB with the field structure setup as Sharesight requires.

    Video tutorial here for a guy setting up the webservice to his custom database: https://www.youtube.com/watch?v=wVM_y...

    IB Information:
    https://www.ibtweet.com/en/software/e...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • Hello IB Users, Its not easy and as IB doesn't provide contract notes it is difficult, unless you know what you are doing and others have achieved this with ease.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • Hi Ben

    Any update on the Flexi query import as I've seen other portfolio apps use these to get trade data out of IB

    Regards
    Stuart
    • view 4 more comments
    • Hi Duncan,

      Many thanks for responding to those assumptions.

      The FTP option is problematic from a security perspective and unfortunately not really an option at scale.
    • Log into your IB Account and you will find platform providers for Australian Investors https://www.interactivebrokers.com.au...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • Hi all,
    Yahoo Finance now allows linking to US brokers such as Interactive Brokers. It doesn't allow linking to AU brokers such as CMC markets though.
    Almost all of my portfolio is with IB, so it appears Yahoo Finance can fulfil my needs for free. If you use primarily AU brokers, Yahoo Finance isn't as useful.
    Hope this helps at least one other person out there.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • Francis,
    May I ask what needs of yours are fulfilled by Yahoo Finance? I am also with IB.
    • I've only just found out about the linking. I've since realised Yahoo Finance doesn't appear to track dividends or other types of reporting, although I could be wrong. I'm actually still waiting for the IB data to sync with YF, it initially takes up to 2 business days.
      It may be that YF simply makes it easier to import data into Sharesight, as I find the manual IB reports time-consuming to run and put into a format able to be read correctly by Sharesight. Exporting YF reports appear to be faster and simpler.
      I'll have a play and update any info I found useful.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • For those seeking to find portfolio management software that allows automatic import of trades from IB check out:

    https://www.tradingdiarypro.com/featu...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • If you are looking for Platform providers for Interactive, log into your account and go to Investors market place https://www.interactivebrokers.com.au...

    you will find proviers for australian invetors.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • I’m sad
    How long has this conversation has been going on for?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • Hi All,

    I'm well overdue to provide an update on our investigation into an IB integration.

    In large part because of the feedback and suggestions provided on this topic and directly via our support address we have settled on an IB solution.

    We eventually investigated around seven different approaches, but all had draw backs in one form or another.

    The solution we will implement requires no direct customer support by us, nor does it require configuration on your part.

    If you are interested in having your ongoing IB trade history automatically synced with Sharesight you would need to do the following:

    1. Send an email to a dedicated IB address (which I will provide when the feature is ready), include your account # and request the 'ShareSight feed'.

    2. Within 2-3 working days IB will provide you with dedicated user and password credentials specific to this integration.

    3. You will need to enter those credentials into a form we will develop in Sharesight.

    4. We will run a daily sync job that will retrieve your day's trading from IB using the credentials provided and process the trades into Sharesight.

    This integration will require some fairly extensive development on our part. We will look to begin work once some pressing work relating to the end of the Australian tax year has been completed.

    I will post another update when work is under way.

    A big thanks to all those who have provided example files and suggestions.

    Regards
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • Thanks Ben, great news.

    Any idea roughly of what the development time will be?
    • Once we start actual development I think things will progress fairly quickly. The delay really at this stage is just juggling those end of year tasks which we do need to prioritize.

      Within a few weeks I should have a better idea as to when work can commence.

      I will certainly post an update on this topic when I know.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • picked a good time to revisit this - was going to check last night but ran out of time and would have missed the good news! hopefully it doesn't take too long to implement, though guessing not much progress before EOFY...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • 1
    Hi Ben

    Can you please consider the following when looking at the daily sync of data between Sharesight and IB with regards to 'Custom Investments' (ie a long Call Option position)

    At the moment Sharesight offers a limited ability to track non-share positions but this requires two pieces of data to be manually added into Sharesight.

    1. The buy, sell, qty data of each trade
    2. Periodic manual updates to price to track the open P&L

    Given this limitation I currently choose not to track the Option positions I have in my IB account in Sharesight

    With the daily IB Sync I assume you be looking to bring all trade transactions into Sharesight including non-standard positions and assign them as a 'Custom Investments' (IB can provide the data required to populate what's required in Sharesight) - doing this would fix 1 above

    For 2 Sharesight will still not have any pricing data for the Custom Investments but IB does - is it possible for the daily sync logic to also grab the daily close price of any
    Custom Investments imported into Sharesight. Whilst the sync is checking for new open or closed positions grabbing the close price is hopefully relatively straight forward integration?

    Thanks
    Stuart
    • Hi Stuart,

      At this stage we will import BUY and SELL transactions for the following Asset Types:
      Mutual Funds
      Structured Products
      Stocks (includes ADR, ETF)
      Warrants

      That's not to say we can't look to map holdings in IB to custom investments in Sharesight, but we'd prefer to tackle that separately.

      As to your second request, I have just taken another look at the data available and we can retrieve market prices from IB. To do so would involve some additional work on our part.

      So both suggestions are certainly possible and we can explore these ideas further after our core integration is up and running.

      Regards
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

next » « previous