Bucketing in SERIES

Research
1

Hello all,

I’m trying to bucket groups within SERIES using FRank or something equivalent. For example, I’d like to answer a question like:

What has the p/e of the highest 10% in a given universe been over time?

Plotting the mean of the population seems pretty straight forward (UnivMedian(“1”,“PEExclXorTTM”)), but I can’t figure out how to break out the data into buckets.

Any help is appreciated. Thanks!

2

Because of the restriction on nesting quoted strings you need to do this in custom universes.

Create a custom universe with the definition of your bucket:

FRank("MktCap")>90

for example. Save your universe and then create a series and select that custom universe.

Then use your rule as written in the series. Note that you can pretty much just keep copying the series over and over – new universe, save as, new universe, save as, new universe, save as, etc.

3

Thanks Paul. How would I combine two universes? What I really want to do is for example to generate the ratio between the p/bv of the highest 10% and the median of the entire market. And if i have to switch universes then I wouldn’t be able to do this. Or??

4

OK, create the custom universe as described earlier.

Then, create the series as described before. View the chart with weekly raw data and save as a name of your choice, for example, “Example”. Viewing the chart will save the series in a usable form.

Then create a screen. Use the base universe of the series. Then you’d use this rule:

Close(0,GetSeries("Example"))/FMedian("Pr2BookQ")

That should give you the ratio of the median of the selected stocks to that of the whole universe.