how to use eikonapi fetching Bond data in R?

Bob Dylan

hi ,

I'm using eikonapir package and function get_timeseries

it works perfect with equity (RIC) until I want to fetch bond data such as OAS or close.

for example

get_timeseries("BE0002234038",list("*"),"2019-07-04T00:00:00","2019-10-24T00:00:00","daily")

get_timeseries("BE0002234038",list("OAS.Timestamp;OAS.Value"),"2019-07-04T00:00:00","2019-10-24T00:00:00","daily")

gives no result.

Is this an identifier issue?

=RHistory("BE0002234038"&"=","OAS.Timestamp;OAS.Value","INTERVAL:1D",,"TSREPEAT:NO CH:Fd","time") works

Thanks for help and don't hesitate if you need more information

Find more posts tagged with

python

eikon

api

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

eikon-data-api-r

Accepted answers

Jirapongse

You can use the get_data function instead in order to get the OptionADJUSTEDSPREADBID value.

The function's parameters are:

data_frame2 <- get_data("BE0002234038", 
                        list("TR.OptionADJUSTEDSPREADBID.Date, TR.OptionADJUSTEDSPREADBID"),
                        list("Frq"="D","SDate"="0D","EDate"="-1Y"))

The output is:

To find other fields, you can use Data Item Browser or Eikon Excel Formula Builder. Please find fields that can be used with the =TR function.

All comments

Jirapongse

You can use the get_data function instead in order to get the OptionADJUSTEDSPREADBID value.

The function's parameters are:

data_frame2 <- get_data("BE0002234038", 
                        list("TR.OptionADJUSTEDSPREADBID.Date, TR.OptionADJUSTEDSPREADBID"),
                        list("Frq"="D","SDate"="0D","EDate"="-1Y"))

The output is:

To find other fields, you can use Data Item Browser or Eikon Excel Formula Builder. Please find fields that can be used with the =TR function.

Bob Dylan

many thanks for the response. How do i find other field name such as ("Frq"="D","SDate"="0D","EDate"="-1Y")? is there a field dictionary ? or use the excel formula builder?

" Please find fields that can be used with the =TR function." what do you mean by = TR function ? does it mean that only fields start with "TR.XXXX" work?

thank you

EXPLORE OUR SITES