Issue with SecAvg Function

Hello everyone. I’m attempting to add a factor in one of my ranking systems which considers the return of a stock’s sector over the last 20 trading days. To do this, I’m using the formula below:

SecAvg(“((Close(0) - Close(20))/Close(20))”)

When I try to use the above formula, I get an error that says:

Error near ‘SecAvg’: Invalid command ‘SecAvg’

Any idea what is going on here?

Thanks,
Graham

Does the function “SecAvg” really exist? I couldn’t find it …

Why don’t you try something along the lines of …

FRank(“close(0)/close(20)”,#Sector,#Desc)

… to identify stocks with 20 day returns above sector average?

Graham - I believe you want to use the Aggregate function under stock formulas.
Steve