Re: % Gain - I Calculation

[ Q1-Q3 99 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: % Gain - I Calculation posted by Melody on April 01, 1999 at 10:41:50:

: Mark -

: Oh yes !! we need that second option !! heck, you don't have to deal with my boss !!! but seriously, these reports are very important to our business.

: also, does the date synchronization cause the % Gain figures to be NA if beginning value is 0? This did not happen in the previous version. For instance a client has 4 funds he's invested in yet each was started at a different time. (this is where I'm having major difficutly with the reports) When I choose the start date from his very first investment I only get calcualtions on that investment since the others are showing a 0 beginning value.

: If I choose a later date to include all the funds, then the numbers on the earlier ones are incorrect.

: If I run the report individually for each fund, then there is no clear picture of the entire portfolio.

: sorry to be so lengthy but I hope it is clear.

: thanks so much...

: Melody

Hi Melody,
Actually, there isn't a date synchronization
problem, as I originally thought. The problem
is with the new formula, it divides by the
beginning value. If the beginning value is 0,
you will get NA, which is different than the way
it worked before. You only had to have a
beginning value OR some purchases during the time
period, because it divided by this total. After
thinking about it some more, I think the best
is to just switch it back to the way it worked
before.

Thanks,
Mark
--
Mark Beiley

Fund Manager for Windows 3.1x/95/98/NT

Replies: