How do we retrieve the FID values via EIKON API for Stock Futures like RELIX1:NS (RICs with ":") usi
Best Answer
-
Could you please also provide the code used?
I tried with the code below and it works
import eikon as ek
ek.set_app_key('#### EIKON APP KEY ####')
import pandas as pd
df = pd.read_csv('220104.csv')
rics = df['RIC'].tolist()
data, err = ek.get_data(rics, 'PRC_TICK')
datahere's the CSV file
0
Answers
-
@arun.mahabala You can use the Data Item Browser app (type DIB into eikon search bar) to check all fields available for any RIC. Please see below the output - you can see real-time FIDs as well as all other non-realtime fields - you can use the content classification filter on the left hand side to highlight only specific content sets to reduce the number of fields shown:
Another way is to open a quote window with the RIC and then right click and select Template ==> Display All Fields - this will display all real-time FIDs for any RIC.
I hope this can help.
0 -
Thanks for the suggestion. This is possible for Quote and DIB app.
However, using API if you want to extract data for some RICs and if your input RIC has ":" (sample RIC is <RELIX1:NS>), then it fails to extract the data from API. your query would just fail to move further.
0 -
<RELIX1:NS> may be delisted. I can use <RELIX1:NS^1> with the get_timeseries method.
data = ek.get_timeseries('RELIX1:NS^1',
start_date='2010-09-22',
end_date='2012-10-20',
interval='daily')
dataThe output is:
You can contact the content support team directly MyRefinitiv to verify if this RIC is still valid.
0 -
RICs with ":" can not just be imported (via CSV or XLSX) when using EIKON API. It accepts other special characters such as ".", "/" etc.
Example RIC: RELIF2:NS (RELIX1:NS is not expired)
Does anyone have any solution to this.
0 -
the code below can be used to get the data of RIC 'RELIF2:NS' properly
However, for RIC 'RELIX1:NS' the error message mentioned that it is invalid and it cannot be found on Eikon desktop too.
You can contact the content support team directly MyRefinitiv to verify if this RIC is still valid.
0 -
If you add Individual RICs to your API query, you can retrieve.. there is no problem with that.
Problem is only if you have the bunch of RICs in a csv/xlsx where the large number of RICs are there and your query is moving to that directory & when reading the file. if any RIC in the RIC list having <:>, then it would just fail and query is not executed further.
0 -
hi @arun.mahabala
could you please provide an example of the csv/xlsx file that could be used to replicate this problem?
0 -
Below is the content from my input file
RIC
NIFF2
NIFG2
RELIF2:NS
RELIH2:NS
Output is generated as below:
0,RF.SD.PRC_TICK
"'NIFF2','NIFG2','RELIF2:NS','RELIH2:NS'",
I tried to snap - PRC_TICK
And, without special character, below is the data:
RIC
NIFF2
NIFG2
My output is fine:
Instrument,PRC_TICK
NIFF2,0.05
NIFG2,0.05
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛