Thanks! This does seem similar to what I was doing - adding those 1 to 2 days trades. Didn't seem to have a problem when I was doing it in Excel though..
when u have multiple trades over multiple days, XIRR will average out to a more realistic number.
on excel, you try
16 nov, -$10,000
19 nov, +$11,000
XIRR for only these 2 rows should yield what I have mentioned.


