For a deeper look into our Eikon Data API, look into:

# question

Accepted
1 1 2 2

## API to get RIC price and for rights/warrants

Hi All,

May I know what APIs can I use to get the RICs and prices for warrants and rights? For example, SEDOL BMCDGP7 that is linked to RIC ACII_t.N. Are there any formulas we could use to get RICs and prices for multiple rights/warrants?

Currently for equities, we are using RSearch("EQUITY","Search:'Identifier' ExchangeName:'Exchange Name'","NBROWS:1") to get the RIC and tr(e15,"tr.priceclose","SDate=2021-01-14") to get the prices.

Thank you!

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

Accepted
15k 32 5 10

May I add that the Eikon Excel formula provided by my colleague can be converted to Python code with APIs below

1. Eikon Data API as below

```import eikon as ek

df, err = ek.get_data(['BMCDGP7', 'BMVF784']
, [ 'TR.CLOSEPRICE', 'TR.RIC'], {'SDate': '2021-04-28'})
df```

```import refinitiv.data as rd
rd.open_session()

rd.get_data(['BMCDGP7', 'BMVF784'], [ 'TR.CLOSEPRICE', 'TR.RIC'], {'SDate': '2021-04-28'})```

Hope this helps and please let us know in case you have any further questions

1657765288782.png (11.7 KiB)
1657765421163.png (10.8 KiB)

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

Upvote
83.6k 283 53 77

The TR function in Eikon Excel works with SEDOL codes. The formula looks like this:

`=@TR("BMCDGP7;BMVF784","TR.CLOSEPRICE;TR.RIC","SDate=2021-04-28 CH=Fd RH=IN",B31)`

The output is:

1657619703263.png (17.1 KiB)

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