Importing Bond Trades & Holdings - Interactive Brokers

[introvest]

When I import the .qfx file from Interactive Brokers, the bond comes in at face (par) value. When multiplied by the imported price the total value is 100x overstated. I can manually change the decimal point but is there a way to fix this import? I have too many positions and trades to manually edit each price.

[Mark]

Hello introvest,

Are you using a recent Fund Manager version? Bonds should come in with a share balance of 1/100th face value, and a price near 100. Maybe IB is not formatting the transaction as "DEBT" type of investments, so Fund Manager is treating them like a stock or mutual fund. If you'd like to email me a sample QFX file, I can take a look. You can go to our email contact form:

http://www.fundmanagersoftware.com/email.html

and just fill out any simple message. When you're done, you'll see a regular email address where you can send an attachment.

[introvest]

I am evaluating Fund Manager Advisor 10.0 Beta. I will email you IB qfx file. Thank you!.

[Mark]

Thanks for the files. Please see my email reply.

[Mark]

Just an update to the status on this... Interactive Brokers is formatting bond transactions as BUYOTHER and SELLOTHER instead of BUYDEBT and SELLDEBT. It is also listing them as STOCKINFO instead of DEBTINFO in the security description list. The transaction's total value is also incorrect (~100X too high). There is no good workaround for this from Fund Manager's point of view, as the bond transactions are not being recorded properly. We will try to contact IB to see if this can't be corrected from their end.

Example transaction:

Code: Select all

     <BUYOTHER>
      <INVBUY>
      <SECID>
       <UNIQUEID>38141GFM1</UNIQUEID>
       <UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
      </SECID>
      <UNITS>7000</UNITS>
      <UNITPRICE>99.7620</UNITPRICE>
      <COMMISSION>7.00</COMMISSION>
      <TOTAL>-698341.00</TOTAL>
      <CURRENCY>
       <CURRATE>1.0</CURRATE>
       <CURSYM>USD</CURSYM>
      </CURRENCY>
      <SUBACCTSEC>CASH</SUBACCTSEC>
      <SUBACCTFUND>CASH</SUBACCTFUND>
      </INVBUY>
     </BUYOTHER>


Example security listing:

Code: Select all

   <STOCKINFO>
    <SECINFO>
     <SECID>
      <UNIQUEID>38141GFM1</UNIQUEID>
      <UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
     </SECID>
     <SECNAME>GS 6.15 04/01/18 GS 6.15 04/01/18</SECNAME>
     <TICKER>GS 6.15 04/01/18</TICKER>
     <FIID>50271671</FIID>
    </SECINFO>
   </STOCKINFO>


[introvest]

Seems IB has fixed problem with bond formating in their QFX export. I got a mssg yesterday from IB customer service:

"Thank you very much for bringing this to our attention. We have since corrected the issue so please re-download the statement to get the correct format.
Thank You
-IB TAC"

Based on several trade and position imports that I ran, bonds now seem to be importing correctly to FM from IB QFX file....

[Mark]

Hi introvest,

Excellent, glad they were able to correct that. Thanks for the follow up.