workspace API

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

Find more posts tagged with

workspace

#product

Accepted answers

jonathan.legrand

Hi @sreedhanya.kavunkara,

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.

All comments

jonathan.legrand

Hi @sreedhanya.kavunkara ,

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, ...)

sreedhanya.kavunkara

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

jonathan.legrand

Hi @sreedhanya.kavunkara,

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.

sreedhanya.kavunkara

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

jonathan.legrand

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.

sreedhanya.kavunkara

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?

jonathan.legrand

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.

sreedhanya.kavunkara

Hi,

Sorry for late response. I remember trying to load the screenshot twice, both the times it failed. here it is.

jonathan.legrand

Hi @sreedhanya.kavunkara;

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.

EXPLORE OUR SITES