How to get data of this kind of RIC?
Hi all,
I'm using python to get data from Reuter, normally, with RIC which have its chart like ".DXY", It's been got easily by using eikon.get_timeseries(). However, some other RIC like "SBVOMO2022" or "VNOMO=SBVN", I cannot get the data by using eikon.get_timeseries(). So how to get all these ind of data?
Note: I have tried with eikon.get_data(), but it just work if the field is available, and I need to search for exist field (just work with "VNOMO=SBVN" but not "SBVOMO2022")
Thank you for your help!
Best Answer
-
SBVOMO2022 contains a list of page records.
First, we need to get the underlying RICs in SBVOMO202, and then subscribe to the ROW80_1 to ROW80_25 fields from those RICs.
The code looks like this:
#Define getUnderlying() function
def getUnderlying(baseRic):
LONGNEXTLR = baseRic
#For LONGLING1 to LONGLINK15 and LONGNEXTLR fields
fields = ['LONGLINK{}'.format(x) for x in range(1, 15)]
fields.append('LONGNEXTLR')
all_underlying_rics = []
#if LONGNEXTLR is not empty, try to retrieve the data fields
while LONGNEXTLR!='':
df,e = ek.get_data(LONGNEXTLR,fields)
LONGNEXTLR = df.iloc[0]['LONGNEXTLR'] if pd.notnull(df.iloc[0]['LONGNEXTLR']) else ''
#print(df)
#If LONGLINK<x> field is not null, append its value to all_underlying_rics list
for x in range(1, 15):
currentField = 'LONGLINK{}'.format(x)
all_underlying_rics.append(df.iloc[0][currentField]) if pd.notnull(df.iloc[0][currentField]) else None
#delay between each API call for 1 second
time.sleep(1)
return all_underlying_rics
ricList = getUnderlying('SBVOMO2022')
df, err = ek.get_data(
instruments = ricList,
fields = ['ROW80_1','ROW80_2','ROW80_3','ROW80_4','ROW80_5','ROW80_6','ROW80_7','ROW80_8','ROW80_9','ROW80_10',
'ROW80_11','ROW80_12','ROW80_13','ROW80_14','ROW80_15','ROW80_16','ROW80_17','ROW80_18','ROW80_19','ROW80_20',
'ROW80_21','ROW80_22','ROW80_23','ROW80_24','ROW80_25'])
for index, row in df.iterrows():
display(row.transpose())The output is:
Instrument SBVOMO2022-1
ROW80_1 17:26 16AUG22 SBV OPEN MARKET AUCTION DATA ...
ROW80_2 Open Market Auction Data ...
ROW80_3 ...
ROW80_4 Session Auction Transaction Term ...
ROW80_5 No. Date Mode (Days) ...
ROW80_6 ...
ROW80_7 ======= ======== ================ ======= ...
ROW80_8 195 16/08/22 Sell Outright 14 ...
ROW80_9 194 16/08/22 Sell Outright 7 ...
ROW80_10 193 16/08/22 Reverse Repo 7 ...
ROW80_11 192 15/08/22 Sell Outright 7 ...
ROW80_12 191 15/08/22 Reverse Repo 7 ...
ROW80_13 190 12/08/22 Sell Outright 7 ...
ROW80_14 189 12/08/22 Reverse Repo 7 ...
ROW80_15 188 11/08/22 Reverse Repo 7 ...
ROW80_16 187 10/08/22 Reverse Repo 7 ...
ROW80_17 186 09/08/22 Reverse Repo 7 ...
ROW80_18 185 08/08/22 Reverse Repo 7 ...
ROW80_19 184 05/08/22 Reverse Repo 7 ...
ROW80_20 183 04/08/22 Sell Outright 14 ...
ROW80_21 182 04/08/22 Reverse Repo 7 ...
ROW80_22 181 03/08/22 Reverse Repo 7 ...
ROW80_23 180 02/08/22 Reverse Repo 7 ...
ROW80_24 179 01/08/22 Reverse Repo 7 ...
ROW80_25 178 29/07/22 Reverse Repo 7 ...
Name: 0, dtype: object
Instrument SBVOMO2022-2
ROW80_1 17:26 16AUG22 SBV OPEN MARKET AUCTION DATA ...
ROW80_2 177 28/07/22 Reverse Repo 7 ...
ROW80_3 176 27/07/22 Reverse Repo 7 ...Otherwise, you need to contact the content support team directly via MyRefinitv and ask for other RICs that are not page records and can provide the same data.
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 中文论坛