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 Didier on August 06, 2005 at 14:03:09:

: 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

Replies:

• Re: Interactive Brokers transaction Import Didier 03:49:47 08/07/05 (1)
  • Re: Interactive Brokers transaction Import Mark 13:53:34 08/07/05 (0)