How do extract symbols that fulfil regex criteria in datastream?
For instance, when I type SPXw, I can see a list of options RIC/ Mnemonic in DFO Navigator.
I want this to an output from a python function.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
You can DS.SYMBOLLOOKUP with the DataStream.
ds.get_data(tickers="SPXw", fields=["DS.SYMBOLLOOKUP(Count=50)"], kind=0)
The output is:
To retrieve RICs instead of mnemonics, you need to send another request.
df1 = ds.get_data(tickers="SPXw", fields=["DS.SYMBOLLOOKUP(Count=50)"], kind=0)
DS.SYMBOLLOOKUP(Count=50) // I try to set it as 1000, in anticipation of a result of similar size (1000); but it returns only 25 rows
Plus, DS.SYMBOLLOOKUP(Count=50) seems to return valid RICS/Mnemonic but not the dead ones.
Navigator is the tool that DSWS clients are advised to use.
The symbol lookup was created for quick search, has limited search functionality, and doesn’t cover all content sets.
How can I download data from DataStream API knowing the Mnemotic which has not a corrispondent RIC?
how to convert rics or symbols to mnem for dsws?
Converting Mnemonic to RIC and getting timeseries data (RI and NR) with EIKON Data API
Oas History for security on DSWS
multiple reuters code for one branch