Hi everyone,
so I am stuck with this problem of Cyclic of Dependencies. I want to create an app where I put an ‘Opening Balance’ of a day. Then Investors put some Capital In or Withdraw their Capital. Through that I calculate their Closing Balance and the percentage of each balance.
Now for example we start with 1st January 2023 which is the very first day of trade.
January 1st 2023 - Opening Balance is $ 0
3 Investors come in and invest their capital:
Mark: $500
James: $1000
John: $1500
Total investment for 1st January is: $3000.
That means:
Marks share = 16.67%
James share = 33.33%
John share = 50%
Their closing balance is:
Mark: $500
James: $1000
John: $1500
January 1st 2023 closing balance will also be: $3000.
Now on 14 February I update the balances.
I check the balance and found out that last times $3000 has become $6000 in the trade. So I open my sheet and update the Opening Balance of 14 February to $6000.
Now what should happen is:
based on the % of share from last trade, I should be able to calculate the investors opening balance.
In this case:
I know from 1st January 2023 my investors closing share % was:
Marks share = 16.67%
James share = 33.33%
John share = 50%
So on 14th February when I input the new opening balance of $6000, the opening balance of each investor should be as following:
Mark: 16.67% * $6000 = $1000
James: 33.33% * $6000 = $2000
John: 50% * 6000 = $3000
I hope I am making sense 
but if I am not feel free to look at the attached spreadsheet to have a better idea.
The only thing that is stopping me to achieve this on glide is Cyclic Dependencies which totally makes sense. Just can’t get my head over it.
The only manual entries in the app should be:
- Opening balances of the day
- Capital in by investors
- Capital out by investors
Any help would be deeply appreciated.