Index | Recent Threads | Who's Online | Search

New Thread
This topic has been viewed 56 times and has 2 replies
jmh
Unexpected behavior: non-primary issues in a a list do not appear in a Universe containing this list

Hi P123,

To reproduce:
- Create a list e.g. "MyList" with {GOOG, FOX}
- Create a Universe with "all stocks" and only one line inlist("MyList")
- Run the screen -> it has 0 stock

Is that expected?

If expected, can I suggest the following improvement:
when a list is saved, it currently checks if the tickers are valid. This is good. But can we also make it replace non-primary issues by primary issues pls?

Otherwise we have a list that is not really usable. When it has 200 stocks it is easy to miss that 2 or 3 got eliminated from the universe as non-primary issues

Thank you,

Jerome

Aug 15, 2019 12:20:25 PM       
marco
Re: Unexpected behavior: non-primary issues in a a list do not appear in a Universe containing this list

That won't work well because primary & non-primary can change (BRKA was primary, now its BRKB)

Since only 1 stock is active for us in a simulation the easiest workaround is to expand the list . For example your "FOX GOOG" becomes "FOX FOXA GOOG GOOGL" regardless of which FOX or GOOG you used.

Portfolio123 Staff.

Aug 16, 2019 1:33:42 PM       
jmh
Re: Unexpected behavior: non-primary issues in a a list do not appear in a Universe containing this list

Thank you Marco.

I am actually using inlist as a base to generate a live universe for live ports (not simulations). I generate the list from various ETFs holdings then upload it into P123 prior to the next rebalance. I automated that as much as I can (VBA) but it turns out that sometimes the holdings in the ETFs are not the primary issues.
I understand the constraints and your suggested workaround.

There is another (better?) workaround you could help me with: where do you source the info to know which is the current primary issue?

This way, when I generate my list, I can also check on whatever website that it is the primary issue (checking on P123 via VBA / IE / scraping the website is not really convenient since P123 is not designed for that).
At the moment, I use http://oatsreportable.finra.org/OATSReportableSecurities-EOD.txt for tickers but it does not state which is primary...

Many thanks in advance.

Jerome

Aug 17, 2019 8:27:44 AM