Hi all,
I try to figure out where I can find the numerical values for various indices or universes. For instance, for the S&P500 or VIX I can get these values in the screener by using the following rule:
Ticker(“IBM”) And ShowVar(@x, GetSeries(“$SP500”)) …gives 16864
Ticker(“IBM”) And ShowVar(@x, GetSeries(“$VIX”)) …gives 43696
I tried to do the same for the Russell 3000 using these commands:
Ticker(“IBM”) And ShowVar(@x, GetSeries(“Prussell3000”))
Ticker(“IBM”) And ShowVar(@x, GetSeries(“$Prussell3000”))
In both cases, the screener returns the following error message:
“ERROR: Invalid criteria in Rule 1. Could not find series for $Prussell3000”
Any suggestions?
Sister -
PRussell3000 isn’t a series but a Universe. You will have to use an ETF. I can’t remember what Russell3000 is but Russell2000 is IWM. So run a screen with
ShowVar(@A,GetSeries(“IWM”))
I think that using the numerical value is playing with fire however. At some point in the future these numbers could change. You’ll have to confirm this with P123.
Steve
The universe ID’s are available in the html. Right click the universe dropbox and click “inspect” in either firefox or chrome. Next to the universe name that is displayed will be the id as the option value.
Gents,
thanks for your feedback. Using the neat inspector tool I got all the ID and have them assembled in the attached xlsx file for anyone to use.
These IDs can be used when calling a series within a custom series formula with quotes, e.g. for the S&P500
UnivCnt(“Correl(1,62,16864)>0.3”)
hth
Benchmark and Universe IDs.xlsx (9.48 KB)