Custom Industry Factors: Why only predefined available?

Research
1

I’m wondering what would prevent us from making our own industry factors? So far only predefined ones are available. Is there a reason we cannot have the same flexibility as with stocks? I will give a random example is there a reason why I couldn’t get Working Capital / Total Assets by industries? I just think we could make more with what we have of we were allowed to make our own. Unlock the functionality, in the worst case it returns not available in the best case we get new industry factors.

2

We were working on exposing the function that we use to calculate our pre-built ‘Ind’ factors, but demand waned off. Maybe because FMedian is a pretty good approximation of our pre-built Industry benchmarks which we call “thick median” : https://www.portfolio123.com/doc/IndustryBenchmarks-Methodology.pdf

3

FMedian is good for most of the factors but some need “Average”. For example I was trying to approximate average yield for each sector. Using FMedian the result is 0 for some sectors since in some sectors (like Tech) most companies have no yield.

4

Try this

FMedian(" Eval(Yield , Yield , NA) " , #Sector)

When Yield is NA or 0 the above will give NA to FMedian , which it ignores

5

Thanks Marco. It works lot better.

6

That’s awesome thanks for the information it will be useful.