Gents,
I’ve noticed some behavior with the Gr% function that I don’t understand. Given the syntax for the Gr% function as
Gr%(a,b,yrs)
I have noticed that Gr% returns N/A if the value of b>0 and the value of a<0. It is unclear to me why this is the case. If I evaluate the formula for Gr% manually I do not have this problem.
I have used the following screen to illustrate the issue.
https://www.portfolio123.com/app/screen/summary/285486?mt=1
Any P123 staff have an explanation?
Thanks,
Daniel
Gr% annualizes growth, which is impossible if growth is less than -100%.
That is true for yrs>1, but for yrs=1 the function should not return N/A when change is < -100.
A nice upside to this change would be that we could use Gr%(a,b) in our factors that calculate a rate of change. For example,
Gr%(EPSExclXorTTM,EPSExclXorPTM)
instead of
(EPSExclXorTTM-EPSExclXorPTM)/abs(EPSExclXorPTM)
(This is what I was attempting to do when realized it wasn’t working as intended).
-Daniel
Makes sense for yrs=1. Gr% was originally intended for annualizing growth, but it’s also handy to simplify formulas for 1Y growth rates. We’ll update it to treat yrs=1 differently. Thanks
Many thanks!
-Daniel
You can now use Gr% for yrs=1 with negative values that were previously evaluating to NA. Thanks.