Buy-Sold in formula(s)

[LibreOffice]

Hey folks!
I have made allot already but i'm stuck quite along time now, maybe you could help me out?


Cell H3 in this example should calculate the total net (bought - sold) of only the row coin on tab ledger but then in %. I want to know how much % of that type of coin i currently hold.

Cell G3 works only half way, right now it only takes the the price from ledger tab of only bitcoin but it should first look for net total (bought bitcoin - sold bitcoin) and then use that number to calculate how many coins i should buy based upon the % given in cell i3.

Then colomn M, N, P, Q should act the same way.
The point is to delete colomn J and K, marked in red and still have these M,N,P,Q work.

[AliGW]

How is this any different to your other thread?

[LibreOffice]

This message has been removed.

[JeteMc]

Again, I am not sure what values you expect in cells H3:H12 however the following formula in H3 and then copied down will yield values that sum to 100%:

Please Login or Register  to view this content.

Let us know if that helps and perhaps someone will then be able to propose a solution for the rest of the request.
Let us know if you have any questions.

[LibreOffice]

This message has been removed.