The XIRR function seems to want an array of values where the first element
is always negative, and the rest are positive. So I model a stock purchase
and sale as the first number being negative, and the sale being positive.
But what about if you have a short sale of stock, where you receive funds
before you buy and pay funds? That makes the first cell of the value array
positive. XIRR freaks out and gives a #NUM! result. Why can't XIRR deal
with a positive followed by negatives? It is weird to have to distort every
financial transaction to make it look like something XIRR can work with.

Is there any third party software the implements an XIRR that is more
powerful and can take more realistic inputs?

--
W