Hello,
Are we really restricted to 50 stocks view/day? This is really not that much.
On a side note is there a way to exclude ETN from a ETF universe? I’ve looked but can’t find a way.
The aforementioned limit is enforced on account of data provider restrictions.
You can exclude an ETF from a custom ETF universe by using the ‘Ticker’ function (e.g., [font=courier new]!Ticker(“QQQ”)[/font]).
But ETN doesn’t appear to be an ETF, so perhaps you meant something else?
Hello,
ETN= Exchange Traded Notes. They represent nothing but a promise, unlike ETF which actually purchases the securities being tracked. I try to stay very far away from ETN. But when creating ETF universes I get ETF and ETN mixed up.
The data provider’s restriction is ridiculous if you don’t mind me saying. These guys charge a lot already. When I’m sifting through stocks and I have to finish the day on yahoo finance or on nasdaq.com, it’s a little ironic seeing as these are free and unlimited but the data at P123 is not. A paying service ought to provide superior capabilities. Please let them know.
Understood; currently there’s no easy way to filter all ETNs.
You will have to do something like this:
!ETFFamilySet(DEUBANK, ELEMENTS, IPATH) And !Ticker("AMJ BARL BDCL BDCS CNY CSLS CSMA CSMB CVOL DGAZ ...")Regarding the panels, we’re considering revising the page’s behavior to whitelist a selection of panels that can always be loaded independent of the imposed limit.
To clarify, the symbols I listed in [font=courier new]Ticker[/font] needs to be provided to weed out the ETNs from everything meeting the criterium [font=courier new]ETFFamily=MISCL[/font].
As far as I can tell, here’s the full list of ETNs currently in the MISCL family:
AMJ BARL BDCL BDCS CNY CSLS CSMA CSMB CVOL DGAZ DGLD DRGS DRR DSLV DVYL DWTI FBG FUD FUE GRU GSC INR IVOP LSC MLPG MLPI MLPL MLPN MLPS MLPW MLPY PTM RJA RJI RJN RJZ RWXL SDYL SPGH TBAR TCHI TNDQ TRND TRNM TVIX TVIZ TWTI UAG UBC UBG UBM UBN UCI UGAZ UGLD URR USLV USV UWTI VIIX VIIZ XIV XVIX XVZ ZIVSave that to a custom list named MISCL_ETN, then you can do the following in custom universe:
!ETFFamilySet(DEUBANK, ELEMENTS, IPATH) And !InList(“MISCL_ETN”)
This is really helpful, thank you.
I’ve revised our ETF taxonomy to now list all ETNs under a new ‘Exchange Traded Notes’ family.
You must now filter them out using the rule [font=courier new]ETFFamily!=ETNS[/font].
This is a breaking change, as DEUBANK, ELEMENTS, and IPATH are now empty ETF families.
Thanks Aaron.