In Excel's datastream plugin, I have to look up data by datastream mnemonics, and as part of the information available I see the RIC as well. Is there a way to programmatically grab a RIC for a given mnemonic using pydatastream, or another package??
Hi @abdiat,
Yes, it's possible to get RICs for the given mnemonics. Please find the code below:
import DatastreamDSWS as DSWSds = DSWS.Datastream(username ="*****", password='*****')ds.get_data (tickers="S&PCOMP,CBOEVIX,VIX050810C,CVX0206", fields=['RIC'], kind=0)
Below is the output of the above code:
Let me know if this is what you are looking for and feel free to reach out if any more queries.
Let me see if I can be of any help, would you mind sharing a few mnemonics for which I should look for corresponding RICs?
Thank you for your help. Some examples are S&PCOMP, CBOEVIX, VIX050810C, and CVX0206.
Also, please note for VIX050810C we don't have any RIC in the above output, I checked and can't find any match for it on DataStream Portal as well. Below is the attached screenshot: