Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 1 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!

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.

@angelalock

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

@angelalock

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

Upvotes
Accepted
14.2k 30 5 10

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
78.8k 250 52 74

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

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.