hi,
I wanted to pull data for the below RICs from workspace when I checked the API library, I can find 5 APIs for workspace. Can someone please guide me to know which one I should use to pull data for these RICs?
LRLN01068=RIMILRLN01001=RIMILRLN01002=RIMILRLN01028=RIMILRLN01029=RIMILRLN01062=RIMILRLN01063=RIMIACERDESLNGNWEACERDESLNGSEACERLNGBM
Thanks,
Sree
May I ask: (i) what language are you using to try and connect to LSEG's APIs? (e.g.: Python) (ii) What kind of data are you interested in, regarding those RICs? (e.g.: streaming, historical, tick data, daily data, ...)
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thank you,
AHS
In this case, I would suggest using RD (and the DIB to find the fields you are after). For info on how you can authenticate yourself to LSEG services for use of this API, please don't hesitate to read this article and this article. I suggest using get_history, as data from this function is normalized for ease of use in Python, but get_data is useful in your case:
import refinitiv.data as rd # !pip install refinitiv-data
import datetime
rd.open_session()
gt_hst = rd.get_history(
universe=["LRLN01068=RIMI", "LRLN01001=RIMI", "LRLN01002=RIMI", "LRLN01028=RIMI", "LRLN01029=RIMI",
"LRLN01062=RIMI", "LRLN01063=RIMI"],
fields=["TRDPRC_1", "HIGH_1", "LOW_1"],
# end=datetime.datetime.now().strftime("%Y-%m-%d"),
# start = datetime.datetime.now().strftime("%Y-%m-%d")
)
gt_dtd = rd.get_data(
universe=["LRLN01068=RIMI", "LRLN01001=RIMI", "LRLN01002=RIMI", "LRLN01028=RIMI", "LRLN01029=RIMI",
"LRLN01062=RIMI", "LRLN01063=RIMI"],
# fields=["TRDPRC_1", "HIGH_1", "LOW_1"],
)
The RD library for Python is similar to the Eikon Data API (EDAPI), I would therefore suggest having a quick look at the EDAPI training videos here.
I am using Python as the language.
And for the RIMI RICs I need to pull Last and basis price. ( LRLN01068=RIMI, LRLN01001=RIMI, LRLN01002=RIMI, LRLN01028=RIMI, LRLN01029=RIMI, LRLN01062=RIMI, LRLN01063=RIMI)
For Acer RICs, High, Last and Low Price. (ACERDESLNGNWE, ACERDESLNGSE, ACERLNGBM)
Thanks,
Sree
Hi Jonathan,
Will I be able to use my Refinitiv workspace credentials and APPKey to pull data using this API?
I prefer to access using 'Platform' access. My understanding is that using 'Platform' access I will be able to mention the creadentails using config file and proceed with out opening desktop App of Workspace - Is this correct?
Also there is host, Port etc to be also added in the config file. i am not sure what I should add there. Can you please help me?
Thanks, Sree
Hi, for such information, I would adviser reading this article.
If you would like to use the Platform Session, you only need to fill details in the folowing 3 lines, nowhere else:
For more details on the configuration proccess, pelase read this article.
You can indeed use the same credential details for the Eikon Data API and the Refinitiv Data Library & Refinitiv Data Platform.
Please note taht you need a refinitiv license that allows for Platform Sessions to use them. Please check with your Account Manager (e.g.: on my.refinitiv.com) if your license allows for Platform Sessions.
One more follow up question. For the set of RICS which is given below, the FIDs "HST_CLOSE","PR_FREQ","PRICE_LOC","CURRENCY","TRADE_DATE"
all have value in workspace chart and quote page. But the values are missing when I pull it from the RDP API using rd.get_history() or rd.get_data(). Where can I find data for the above fields using this API?
Hi @sreedhanya.kavunkara, Would you mind sharing with me a screenshot of the quote AND chart page where the data shows up? I'm asking to verify the exact fields populated on the front end.
Hi,
Sorry for late response. I remember trying to load the screenshot twice, both the times it failed. here it is.
I was able to return data on one of these fields on my end:
rd.get_data( universe=["ACERDESLNGNWE"], fields="HST_CLOSE")
Which fits the data shown in the Quote App
Making me believe that you may not be permissioned for programatic access to these data points for these instruments.
Please reach out to my.refinitiv.com to ask about your permissions and possible entitlement enhancements.
