Hi,
I am trying to create a custom universe of all stocks in the “All Fundamentals - USA” that have a market cap greater than the average of those stocks in the “All Fundamentals - USA” universe.
I have created a custom series to calculate the average market cap of the universe like this:
setvar(@avgMktCap,UnivSum(“1”,“MktCap”)) = 3807768.00 as of 7/19/2015
If I then try and create a custom Universe using this series like this:
MktCap>getseries(“AvgMktCap”)
it does not work. If I click “Total”, I get that there are 6657 stocks in the “All Fundamentals - USA” and using the above rule there are still 6657 stocks which pass. What am I doing wrong?
Many Thanks
Paul