How to get Instruments for NYSE, AMEX and NASDAQ from 2007 until today?

Question

Question by veyrejulien · Jun 11, 2019 at 03:17 AM · eikon eikon-data-api workspace python workspace-data-api refinitiv-dataplatform-eikon historical symbology

How to get Instruments for NYSE, AMEX and NASDAQ from 2007 until today?

Hi, can anyone please help me get ALL the Instruments+RIC+Ticker that have been quoted (including existing, delisted and new added) in NYSE, NASDAQ and AMEX from 2007 till today?

I'm using python Eikon API

1

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-06-11T05:58:49Z

REFINITIV

Best Answer

Answer by marcin.bunkowski · Jun 11, 2019 at 05:58 AM

Hi @veyrejulien

We do not have chain RIC codes that would hold the whole universe of an exchange and allow you to look it up on a historical date.
However, I would recommend to check the main indices like .DJI, .SPX, .IXIC and parse their constituents at a certain date. Here is a good example how you can do it.

However If you are interested in the current universe you may check RIC 0#UNIVERSE.US and it subchains. Please note, that it has no possibility of retrieving the data on a past date.

ahs.jpg (91.9 KiB)

1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2019-06-17T16:21:49Z

Answer by veyrejulien · Jun 17, 2019 at 04:21 PM

Hi @marcin.bunkowski, thank you for the answer, i'll try it.

Just to understand, what do you mean with "it has no possibility of retrieving the data on a past date"?

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

REFINITIV

Alex Putkov.1 ♦♦ · Jun 17, 2019 at 05:11 PM 0

Share

It means you can only retrieve the current universe of stocks trading on a given stock exchange. Eikon does not provide capability to retrieve the universe of stocks trading on a stock exchange as of a given date in the past.

Answer 3 · 2019-09-11T16:48:52Z

Answer by armandnaude · Sep 11, 2019 at 04:48 PM

Greetings Marcin

How would you use Eikon data API to get the list of RICs associated to the sub chain eg 0#NYSEPRIM.N?

Is there a way of pulling this list of subchain RIC codes with eikon API i.e. can you use the RIC 0#UNIVERSE.US to get the list of subchains as shown on the screenshot or do I need to view them in the Quote app?

Regards,

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

REFINITIV

marcin.bunkowski · Sep 13, 2019 at 12:21 PM 0

Share

Hi @armandnaude

Try with the example code:

ek.get_data('0#.UNIVERSE.US','DSPLY_NAME')

How to get Instruments for NYSE, AMEX and NASDAQ from 2007 until today?

3 Replies

Watch this question

Related Questions