YTD Stock Gain/Loss dollars

[farsider]

I'm trying to duplicate a report that gives the YTD dollar gain for a stock holding. I'm using XIRR to determine the percentage, however I'm interested in understanding what that is in dollars (value). For this example the report provider shows a YTD (Sept 16th) loss of -195.03. I'm not sure of the method, but maybe someone can help me determine what the dollar value is for the loss.

	A	B	C	D	E
1	action	shares	price	total	date
2	buy	1500	9.49	14235	12/31/2012
3	sell	-1000	6.52	-6520	5/8/2013
4	balance	500	6.62	-3310	9/16/2013
5
6
7	Annualized XIRR			-0.5355
8
9	YTD XIRR			-0.41964
10
11	Gain/Loss YTD $ ??			?
12

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D2 =+C2*B2 D3 =+C3*B3 D4 =-(+C4*B4) D7 =XIRR(D2:D4,E2:E4) D9 =SUM(((1+XIRR(D2:D4,E2:E4,10%))^(((DATE(2013,9,16)-(DATE(2012,12,31)))/365))-1)) <tbody> </tbody>

<tbody>
</tbody>

Thanks