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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

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!

eikon-data-apiapiexcelwarrants
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
Accepted
8k 15 5 8

Hi @angelalock

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
ek.set_app_key('### YOUR APP KEY ###')

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

1657765288782.png

Here's the Eikon Data API - Quick start guide, which can help you getting start with using an API.

2. RD Library for Python

import refinitiv.data as rd
rd.open_session()

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

1657765421163.png

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

Upvote
56.1k 145 45 65

@angelalock

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


1657619703263.png (17.1 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.