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??
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??
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.
Hi @abdiat,
Yes, it's possible to get RICs for the given mnemonics. Please find the code below:
import DatastreamDSWS as DSWS ds = 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.
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: