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
action	shares	price	total	date
buy
sell
balance
Annualized XIRR
YTD XIRR
Gain/Loss YTD $ ??			?

<tbody>
[TD="bgcolor: #CACACA, align: center"]1[/TD]

[TD="bgcolor: #CACACA, align: center"]2[/TD]

[TD="align: right"]1500[/TD]
[TD="align: right"]9.49[/TD]
[TD="align: right"]14235[/TD]
[TD="align: right"]12/31/2012[/TD]

[TD="bgcolor: #CACACA, align: center"]3[/TD]

[TD="align: right"]-1000[/TD]
[TD="align: right"]6.52[/TD]
[TD="align: right"]-6520[/TD]
[TD="align: right"]5/8/2013[/TD]

[TD="bgcolor: #CACACA, align: center"]4[/TD]

[TD="align: right"]500[/TD]
[TD="align: right"]6.62[/TD]
[TD="align: right"]-3310[/TD]
[TD="align: right"]9/16/2013[/TD]

[TD="bgcolor: #CACACA, align: center"]5[/TD]

[TD="bgcolor: #CACACA, align: center"]6[/TD]

[TD="bgcolor: #CACACA, align: center"]7[/TD]

[TD="align: right"]-0.5355[/TD]

[TD="bgcolor: #CACACA, align: center"]8[/TD]

[TD="bgcolor: #CACACA, align: center"]9[/TD]

[TD="align: right"]-0.41964[/TD]

[TD="bgcolor: #CACACA, align: center"]10[/TD]

[TD="bgcolor: #CACACA, align: center"]11[/TD]

[TD="bgcolor: #CACACA, align: center"]12[/TD]

</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