Median PE

Research
1

Hi

I cant seem to figure out how to calculate Median PE using the LoopMedian function. Any help I can get would be much appreciated

thanks!

~V

2

I am not sure how you would do it using PEE because there is no PEExclXor(CTR,ANN) function. You could try to use MktCap/ NetIncBXor but trying to find the exact Mktcap that corresponds to the NetInc at that moment in time is difficult. Maybe someone else has figured it out. Try using FHist maybe.

If you are trying to figure out the Median PE of the universe of stocks that you have selected for today, you can easily do it this way: FMedian(“PEExclXorTTM”)