Re: Are Gains and yields still wrong for short sales?

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on May 21, 2007 at 13:59:41:

In Reply to: Are Gains and yields still wrong for short sales? posted by Luca on May 20, 2007 at 10:53:52:

: Hi,
: I'm trying out the program. I have plenty of short sales in my accounts and I cannot make sense of the %gain and yield fields in the reports.

: I read http://www.fundmanagersoftware.com/q3q103/messages/5011.html which seems to describe the same problem.

: Is this fixed/going to be fixed somehow?

: Thanks,
: .luca

Hi Luca,

Unfortunately, yields/gains on short positions are still not correct. The standard yield equations are always applied, and in the case of short transactions, these equations do not work. I've attempted to research how these calculations are supposed to be done in the case of short positions, but have not been able to find a solution. For example, if you had a simple case where you had a short position that started with a -$1000 balance, and went up to -$900, the standard yield equations would give:

-1000(1+i)^term = -900

This will give a negative value for 'i', which is wrong, since you gained value.

Until we can find a definite answer on the right way to do these calculations, I think the best solution is to simply report them as N/A, and not support these cases. All of the valuations and capital gains reports do correctly support short positions, but not yields/% gains. I do wish I had a better answer...

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies:

• Re: Are Gains and yields still wrong for short sales? Luca 15:15:37 05/21/07 (4)
  • Re: Are Gains and yields still wrong for short sales? Mark 18:45:05 05/21/07 (3)
    • Re: Are Gains and yields still wrong for short sales? Luca 19:12:43 05/21/07 (2)
      • Re: Are Gains and yields still wrong for short sales? Mark 20:37:06 05/21/07 (1)
        • Re: Are Gains and yields still wrong for short sales? Luca 22:24:29 05/21/07 (0)