question

Upvotes
Accepted
1 1 3 4

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

workspace#product
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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

Upvotes
Accepted
5.3k 21 2 4

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"],
    )


1701175596255.png


1701175621924.png


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.


1701175596255.png (57.7 KiB)
1701175621924.png (25.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 3 4

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 3 4

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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:

1706605401795.png
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.

1706605401795.png (194.2 KiB)
Upvotes
1 1 3 4

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?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.

Upvotes
1 1 3 4

Hi,


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


wsacer.png (36.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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")

1709026440276.png


Which fits the data shown in the Quote App


1709026491901.png

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.


1709026440276.png (9.9 KiB)
1709026491901.png (33.7 KiB)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.