Retrieving pricing data using Python eikon.time_series for mutual funds and ETFs
I have a variety of mutual funds and elf that I would like to retrieve pricing data for. I use TR Eikon API Proxy - Data Item Browser to search for TR Codes. It turns out that in some cases I can easily find a RIC code for the mutual fund (1) whereas in other cases I can find a RIC code but no pricing data using 'get_timeseries'. (2)
Example 1 - The mutual Fund 'BNP Paribas OBAM' has ISIN NL0006294035. If I type this into the Data Item Browser I get "OBAMb.AS", and henceforth I am able to insert this into a Python ek.get_timeseries statement and retrieve prices. Works fine.
Example 2 - The mutual Fund 'Fidelity Funds - European Dynamic Growth Fund Y-DIST-EUR' has ISIN LU0936577138. If I type this ISIN into the Data Item Browser it shows the name of the fund correctly and I have a choice out of two. The first RIC LP86229468 shows no data in the Data Item Browser. The second RIC A1W4TZX.DX only shows a value for 'Last' or 'CF_LAST' (of 17.15) in the Data Item Browser (and no values for 'OPEN', 'CLOSE', 'HIGH', 'LOW', 'VOLUME'). When I insert this RIC into a Python ek.get_timeseries statement to retrieve pricing data, I merely get 'nan'.
df_tr = ek.get_timeseries(symbols[y], fields=['OPEN', 'CLOSE', 'HIGH', 'LOW', 'VOLUME', 'LAST'],start_date=startdate, end_date=enddate)
When symbols[y] = 'A1W4TZX.DX' the above statement yields 6 x nan.
Question: How do I find RIC codes for mutual funds that give me correct pricing data when using the Python ek.get_timeseries statement?
Best Answer
-
Hi @vanderkroon
You can retrieve the timeseries for funds with the syntax using Net Asset Value that is associated with the funds pricing. That can be retrieved directly from an ISIN.
ek.get_data(['NL0006294035','LU0936577138'], 'TR.NETASSETVAL',
{'SDate':'-1M', 'EDate':'0D'})If you want to find RIC you can use the field for the Lipper RIC codes which should contain the NAV timeseries.
ek.get_data(['NL0006294035','LU0936577138'], 'TR.LipperRICCode')
If you have more questions about the data availability, please open a ticket with your local Refinitiv helpdesk team.
0
Answers
-
Very helpful. However, how do I retrieve the date that goes with the NAV value?
0 -
Hi @vanderkroon
You can do it with the same field together with suffix ".date"
ek.get_data('NL0006294035',['TR.NETASSETVAL.date','TR.NETASSETVAL'] ,
{'SDate':'-1M', 'EDate':'0D'})0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 162 App Studio
- 4 Block Chain
- 5 Bot Platform
- 17 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
- 370 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
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛