Dear forum,
I’m very confused on how to set up my PP account, even after reading the manual.
I trade (in the Netherlands) on DeGiro and Rababank. At DeGiro I have 2 accounts. So, in total I have 3 portfolio’s over 2 trading platforms. I trade in multiple currencies on all these accounts.
How should my PP file be structured in terms of Deposit Account, Security Account, Offset Account and Currency for these 3 portfolio’s?
What confuses you?
First you setup one security account with one cash account. Usually in your home currency, which is literally your reporting currency.
For each currency you are trading with this account you create a corresponding cash account in foreign currency.
PP doesn’t care if you have one or more security accounts with the same broker.
You create as much ore less as you like. As closer you mimic reality as granular you can analyze.
Maybe use NL_nl as the interface language during setting PP up 
The fact that 5 types of accounts, including an cash account per currency, are mentioned confuses me . Am I allowed share here a dummy PP file to get my structure checked??
Screenshots are easier, feel free to share.
But keep in mind, we don’t know how you like to work.
setup.xml (535.9 KB)
Ok, maybe both? My setup file attached. Basically 3x portfolio’s with each 10k deposit. Added some trades in multiple currencies for each portfolio. Is the setup correct? (ALL EXAMPLE TRADES AND DEPOSITS!)
Now, there is this “offset account” table (see picture) which are actually the “securities accounts”?. Should I give the offset account (=security account?) the same name as my Deposit account? That confuses me, it would give a Deposit, Security and Offset account, all with the same name?
Feel free to modify my example, to your working method.
To be honest, I have no clue where you are struggling.
You created 3 cash accounts:
And you created 3 security accounts:
I don’t know whey you named them ?,??,???.
Further you didn’t folowed the instruction:
General setup based on your home currency here (EUR)
3 security acc and 3 corresponding cash accounts
Now the cash accounts, 3 in home currency and 8 in foreign currencies:
So now we start with 10K in each EUR cash account:
Now we transfer money from a EUR account to a foreign account (most common way)
I transfered 3 times 2.5K in Euro, to foreign currency cash accounts:
And from each account I can by stocks in every depot I created.
That’s it.
Thank you for all your effort!
Your example helps but I really did not expect a set up like that!
It means, every time you make a foreign trade, you ALSO need to make an internal money shift between your currency accounts (and vice-verse when sell).
That internal money shift needs to EXACTLY cover the foreign trade amount right?
In my example I do the foreign trade (USD) inside my EUR Deposit account, at the given exchange rate. Why is this wrong??
You can do what ever you like.
With your way you don’t see gain and looses due to currency change.
Your US stock might goes up but due to a falling dollar you‘re not making any provit, for example.
I just showed the most accurate way. As in reality you have to convert your EUR as well. And I did not expect you to calculate manually when you are using a performance measuring tool.
Nice that I can do what I like . I’m just trying to learn if what I like is any good.
On review, indeed, I cannot see how much I have invested in foreign.
On accuracy I think I am good, I do not calculate anything. I take the actual buy/sell price - not closing price -, exchange rate, and fees, my broker used for the trades. So, also the currency profit/loss will be included, just not very visible.
Do you keep your foreign currency balance at ZERO? Meaning, the money in below USD/CAD/LTL example is ALL invested in securities??
I don’t get this question. You need to have cash in order to buy securities. (not talking about a debt or a loan). A buy without cash would result in a negative cash account balance.
If you don’t want to work with cash accounts, you need to work with deliveries (in/out) instead of buy/sell.
No, this is just cash in foreign currencies. That’s why I wrote:
