Greetings ,
since I can't manage a PAMM account without a money manager license in my country I want to open a joint account (me + 1 other person) but I want to setup a PAMM-like allocation so we can identify how much of the money belongs to who of us and I thought about making an excel sheet for it.
I will be the only person trading it but both of us will fund the account. I will get 100% of the profit of my own capital and a 50% share of the profits on his capital , but I'm not sure how to change the percantage shares of each person when losses occur and I don't know how to set up all the formulas in excel in a simple way. Since I'm not very experienced with excel I hope someone in this forum can help me set up a sheet where I can simply put in the current balance (including profits & losses) & deposits / withdrawals on the first day of each month while the sheet automatically calculates the % share of the balance for each person.
I really hope someone can help me set up the sheet or maybe give me a better idea to create a fair allocation method without being able to open a pamm account
Best regards
since I can't manage a PAMM account without a money manager license in my country I want to open a joint account (me + 1 other person) but I want to setup a PAMM-like allocation so we can identify how much of the money belongs to who of us and I thought about making an excel sheet for it.
I will be the only person trading it but both of us will fund the account. I will get 100% of the profit of my own capital and a 50% share of the profits on his capital , but I'm not sure how to change the percantage shares of each person when losses occur and I don't know how to set up all the formulas in excel in a simple way. Since I'm not very experienced with excel I hope someone in this forum can help me set up a sheet where I can simply put in the current balance (including profits & losses) & deposits / withdrawals on the first day of each month while the sheet automatically calculates the % share of the balance for each person.
I really hope someone can help me set up the sheet or maybe give me a better idea to create a fair allocation method without being able to open a pamm account
Best regards