Re: Interactive Brokers transaction Import

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Interactive Brokers transaction Import posted by Mark on August 06, 2005 at 14:26:52:

: : Mark,

: : It works like you described, the transactions are always to and from the USD cash investment from the portfolio. I also defined other investments for other currencies.
: : The problem is, if I made a 5000 USD cash deposit it goes to the USD as 5000, if I made a 5000 CHF cash deposit, it also goes as 5000 USD in the default cash, defined for the portfolio.
: : Did I miss something? I have to say that it is not perfectly clear how I should structure my portfolios and sub portfolios and different cash investments so that everything works smoothly.

: : For example, in Swissquote, I have a main portfolio and three sub portfolios, each has a different account number and an own default cash investment, for CHF, USD, EUR. This is the way it works at SQ, each currency is a different account number. Anyway, I retrieve the transactions manually from an excel table, so I do more or less what I want.

: : For IB, it’s different, I have only one account number, when I import, everything goes into the same pot. I did not define sub portfolios yet for IB. I have to find out how to handle the cash first, with the different currencies.

: : Thanks for your time.

:
: Hi Didier,

: Do you have multiple cash accounts in IB, or do you have just one? What really happens when you deposit 5000 USD and when you deposit 5000 CHF? I would track your portfolio the same way as IB has it organized, keeping in mind that FM can only have 1 default cash account per sub-portfolio.

: If you have multiple cash accounts in IB, one for each currency, how do they determine which cash account is debited when you make a sell?

: One point to note is that all transactions are always assumed to be made in the investment's native currency, so if your cash account is assigned as USD and you record or import a purchase with a value of 5,000, it will treat it as 5,000 USD. There is no option to say "this is a purchase of 5,000 CHF into my investment with a native currency of USD".

: If you haven't already seen this, it may be of some help too:
: http://www.fundmanagersoftware.com/help/dlg_currency.html

: Thanks,
: Mark
: --
: Mark Beiley
: Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP/2003
:

Mark, I think there is one sub-account for each currency, although I can see nowhere a separate number for such sub-account. If I send a certain amount in CHF it goes to the line CHF.
For purchase of a stock, it will debit the corresponding default line, if I buy something on the Canadian market, it removes the amount and the fees from the CAD cash, if there was NO CAD, then this line becomes negative.
Anyway, there is no problem with stock purcase, as the cash source is set as default for the sub portfolio. The problem is only with "pure cash" operations.

Finally, I found a good example on Aug 3rd: I have only cash movements between different currencies on this day. Example between CAD and SFR.
Everything is handled to and from USD cash by the import. Moreover the fees are just added to the settled amount.
I had a look in the OFX file, there are indications of the origin and target currencies in such operations, but I am not enough familiar with this to be sure how it should be interpreted. I could send you this OFX file if you want to have a look.

Replies:

• Re: Interactive Brokers transaction Import Mark 13:53:34 08/07/05 (0)