Median 10 year Return on Equity

Research
1

Hi all,

How can I calculate median return on equity as a free form rule in a screen (or any other fundamental parameter for that matter)? I cant seem to figure it out.

thanks
V

2

We can do average right now using the Avg() function in MISC->SET. Here’s the avg for past 5 annual ROE’s

[font=courier new] Avg( ROE%(0,ANN) , ROE%(1,ANN) , ROE%(2,ANN), ROE%(3,ANN), ROE%(4,ANN) )[/font]

Avg() throws out NA’s . If the # of NA’s is a problem you can add this filter to exclude stocks with any NA’s in the past 5 years:
[font=courier new]
LoopSum(“ROE%(CTR,ANN)!=NA”,5)=5 [/font]

PS. We need to add a Median() function in MISC->SET. Should not take long.

3

I second this request.

4

If you’re going to add a Median function, why not make it LoopMedian? There’s no reason for a user to manually provide all the terms.

Walter

5

LoopMedian() is a feature that’s long overdue. It’s easy to implement and it’s useful.

6

It would be very nice if the current ‘set’ functions Avg, Min, Max, StdDev, StdDevP, Higher and Lower had Loop versions.

Best,
Walter

7

We’ll add a full set of Loop functions later (today I think) . Thanks

8

Thank you!

9

Excellent, thank you!

10

Please see latest post about LoopMedian

11

Thanks for the quick turnaround … the feature works beautifully!