Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

avatar image
Question by Peter.Winkler3 · Dec 16, 2020 at 11:30 AM · eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikon

Python command to get RICs associated with a chain of contracts

I am using the following command in the Refinitiv-Excel interface in order to get all the RICs associated with a certain set of contracts.

=@TR("0#LCOG1+";"";"CH=Fd RH=IN";$A$1)

How would this command look like in Phyton (is it possible to get the result applying the "get_data" function)?

Or more generally, is there a way to translate commands from one "language" to the other?

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jason.ramchandani01 · Dec 16, 2020 at 11:48 AM

@Peter.Winkler3 Yes you can try this which will give you the RICs in the chain:

df, err = ek.get_data('0#LCOG1+', 'BID')
df

In terms of general translation - the python functions eg get_data generally involve some kind of instrument(s), then some kind of field(s) and perhaps a set of parameters (such as date and/or field specific settings.

The best way to familiarise yourself is to use either the Data Item Browser app (type DIB into the eikon search bar) or by using the Code Creator app (type codecr into eikon search bar). The you can add an instrument and select fields and have the app create the correct field/parameter settings for you (in the case of DIB app) or create the whole python code for you including the full API call which you can launch in a codebook instance or copy and paste into your Jupyter notebook or similar.

I hope this can help.


1608118874023.png (52.2 KiB)
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Peter.Winkler3 · Dec 16, 2020 at 02:45 PM 0
Share

Many thanks for the hint, Jason! Worked perfectly!

avatar image
Answer by Peter.Winkler3 · Dec 16, 2020 at 02:45 PM

@jason.ramchandani Many thanks for the hint, Jason! Worked perfectly!

Comment
jason.ramchandani01

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

Trying to fetch Close Bid Price for CMO tranche from Python

Company trees don't match in Eikon online tool and the Eikon Proxy API

How to get all investors for a list of stocks, historically with the python API

What other parameters can be used with the statement pertaining to Corporate Actions data such as Stock Splits?

Download API Proxy Python for Windows.

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • FX Venues
    • FX Trading – RFQ Maker
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • Yield Book Analytics
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges