Figure Profit/Loss according to User %

[gtd526]

Hello,
Trying to figure the Gain/Loss$(F17:F20) for a specific symbol(A9:A13), for a specific user (A17:A20), using their % of dollar input (D17:D20).

thx

The Whole Enchilada.xlsm
	A	B	C	D	E	F	G	H	I	J	K
8	Symbol	Shares	Cost	CURRENT	MAX Value	MIN Value	Cost Value	Market Value	Gain/Loss	G/L %
9	TRIRX	11.266	$ 44.38	$ 45.01	$ 45.01	$ 44.38	$ 499.99	$ 507.08	$ 7.10	1.42%
10	AAPL	10	$ 12.00	$ 14.00	$ 14.00	$ 12.00	$ 120.00	$ 140.00	$ 20.00	16.67%
11			$ -	$ -	$ -	$ -	$ -	$ -	$ -
12			$ -	$ -	$ -	$ -	$ -	$ -	$ -
13			$ -	$ -	$ -	$ -	$ -	$ -	$ -
14							$ 619.99	$ 647.08	$ 27.10	4.37%
15
16	User	Symbol	Amt $	Amt %	Total $	G/L$	G/L%	OutPut $
17	User 1	TRIRX	$ 500.00	75%	$ 375.00	need			User 1	User 2
18	User 2	TRIRX	$ 500.00	25%	$ 125.00	need			TRIRX	TRIRX
19	User 1	AAPL	$ 120.00	65%	$ 78.00	need			75%	25%
20	User 2	AAPL	$ 120.00	35%	$ 42.00	need			$7.10	$7.10
21									$5.33	$1.78	$7.10
Ameritrade

Cell Formulas
Range	Formula
E9:E13	E9	=IF($D9=0,0,MAX($D9,$E9))
F9:F13	F9	=IF($F9=0,$D9,MEDIAN($F9,$D9,0))
G9:G13	G9	=$B9*$C9
H9:H13	H9	=$B9*$D9
I9:I13	I9	=H9-G9
J9:J14	J9	=IFERROR((I9/G9),"")
G14:I14	G14	=SUM(G9:G13)
E17:E20	E17	=C17*D17
I21:J21	I21	=I20*I19
K21	K21	=I21+J21

 

[gtd526]

Hello,
Trying to figure the Gain/Loss$(F17:F20) for a specific symbol(A9:A13), for a specific user (A17:A20), using their % of dollar input (D17:D20).

thx

The Whole Enchilada.xlsm
	A	B	C	D	E	F	G	H	I	J	K
8	Symbol	Shares	Cost	CURRENT	MAX Value	MIN Value	Cost Value	Market Value	Gain/Loss	G/L %
9	TRIRX	11.266	$ 44.38	$ 45.01	$ 45.01	$ 44.38	$ 499.99	$ 507.08	$ 7.10	1.42%
10	AAPL	10	$ 12.00	$ 14.00	$ 14.00	$ 12.00	$ 120.00	$ 140.00	$ 20.00	16.67%
11			$ -	$ -	$ -	$ -	$ -	$ -	$ -
12			$ -	$ -	$ -	$ -	$ -	$ -	$ -
13			$ -	$ -	$ -	$ -	$ -	$ -	$ -
14							$ 619.99	$ 647.08	$ 27.10	4.37%
15
16	User	Symbol	Amt $	Amt %	Total $	G/L$	G/L%	OutPut $
17	User 1	TRIRX	$ 500.00	75%	$ 375.00	need			User 1	User 2
18	User 2	TRIRX	$ 500.00	25%	$ 125.00	need			TRIRX	TRIRX
19	User 1	AAPL	$ 120.00	65%	$ 78.00	need			75%	25%
20	User 2	AAPL	$ 120.00	35%	$ 42.00	need			$7.10	$7.10
21									$5.33	$1.78	$7.10
Ameritrade

Cell Formulas
Range	Formula
E9:E13	E9	=IF($D9=0,0,MAX($D9,$E9))
F9:F13	F9	=IF($F9=0,$D9,MEDIAN($F9,$D9,0))
G9:G13	G9	=$B9*$C9
H9:H13	H9	=$B9*$D9
I9:I13	I9	=H9-G9
J9:J14	J9	=IFERROR((I9/G9),"")
G14:I14	G14	=SUM(G9:G13)
E17:E20	E17	=C17*D17
I21:J21	I21	=I20*I19
K21	K21	=I21+J21

I had the solution, but lost it. I re-created it again, so im good. i think.
thank you.

The Whole Enchilada.xlsm
	A	B	C	D	E	F	G	H	I	J	K
8	Symbol	Shares	Cost	CURRENT	MAX Value	MIN Value	Cost Value	Market Value	Gain/Loss	G/L %
9	TRIRX	11.266	$ 44.38	$ 45.01	$ 45.01	$ 44.38	$ 499.99	$ 507.08	$ 7.10	1.42%
10	AAPL	10	$ 12.00	$ 14.00	$ 14.00	$ 12.00	$ 120.00	$ 140.00	$ 20.00	16.67%
11	MSFT	20	$ 15.00	$ 20.00	$ 20.00	$ 15.00	$ 300.00	$ 400.00	$ 100.00	33.33%
12			$ -	$ -	$ -	$ -	$ -	$ -	$ -
13			$ -	$ -	$ -	$ -	$ -	$ -	$ -
14							$ 919.99	$ 1,047.08	$ 127.10	13.82%
15
16	User	Symbol	Amt $	Amt %	Total $	G/L$	G/L%	OutPut $
17	User 1	TRIRX	$ 500.00	75%	$ 375.00	$ 5.32			User 1	User 2
18	User 2	TRIRX	$ 500.00	25%	$ 125.00	$ 1.77			TRIRX	TRIRX
19	User 1	AAPL	$ 120.00	65%	$ 78.00	$ 13.00			75%	25%
20	User 2	AAPL	$ 120.00	35%	$ 42.00	$ 7.00			$7.10	$7.10
21	User 1	MSFT	$ 300.00	85%	$ 255.00	$ 85.00			$5.32	$1.77	$7.10
22	User 2	MSFT	$ 300.00	15%	$ 45.00	$ 15.00			User 1	User 2
23									AAPL	AAPL
24									65%	35%
25									$20.00	$20.00
26									$13.00	$7.00	$20.00
27									User 1	User 2
28									MSFT	MSFT
29									85%	15%
30									$100.00	$100.00
31									$85.00	$15.00	$100.00
Ameritrade

Cell Formulas
Range	Formula
E9:E13	E9	=IF($D9=0,0,MAX($D9,$E9))
F9:F13	F9	=IF($F9=0,$D9,MEDIAN($F9,$D9,0))
G9:G13	G9	=$B9*$C9
H9:H13	H9	=$B9*$D9
I9:I13	I9	=H9-G9
J9:J14	J9	=IFERROR((I9/G9),"")
G14:I14	G14	=SUM(G9:G13)
E17:E22	E17	=C17*D17
F17:F22	F17	=VLOOKUP($B17,$A$9:$I$13,9,0)*VLOOKUP(A17,A17:D20,4,0)
I19	I19	=D17
J19	J19	=D18
I20	I20	=I9
J20	J20	=I9
I31:J31,I26:J26,I21:J21	I21	=I20*I19
K21,K31,K26	K21	=I21+J21
I24	I24	=D19
J24	J24	=D20
I25	I25	=I10
J25	J25	=I10
I29	I29	=D21
J29	J29	=D22
I30	I30	=I11
J30	J30	=I11