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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
joan.serfaty avatar image
1 ●0 ●0 ●0

RIC based on ISIN and Currency - Fund Pricing Frequency

Hello team,

Hope you are doing well.

I have two questions regarding the Eikon API for Python.

1- Would it be possible to find the appropriate RIC Code based on the ISIN and Currency as an instrument can be traded in various regions. It seems there is not any parameters to specify it in the "get_data" or "get_symbology" functions.

2- Is there any way to identify the frequency that a fund reports pricing data to Reuters. Namely are we expecting a daily, weekly or monthly price from them.


Thanks for your assistance

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
jonathan.legrand avatar image
1.4k ●6 ●2 ●2

Hi @joan.serfaty,


1. I believe the answer to your first question can be found here. Please don't hesitate to revert to this chain if it doesn't so that we may dig deeper if needed.

2. What price data are you looking at exactly? If looking at the NAV, I would advise the following Python code using our Eikon API that will provide price at the highest frequency available, you may then look and use the data in the outputted 'Date' column:


df, err = ek.get_data(instruments = ['VOO'],
                      fields = ["TR.FundNAV(EDate=-1AQ,Curn=GBP).date",
                                "TR.FundNAV(EDate=-1AQ,Curn=GBP)"])
df


You may want to look at 'FundMid' or other such data that you may find in the Data Item Browser with code such as:


df1, err = ek.get_data(instruments = ['VOO'],
                       fields = ["TR.FundMid(SDate=0CY,AllowEst=NO).date",
                                 "TR.FundMid(SDate=0CY,AllowEst=NO).date"]
df1


Note arguments such as 'AllowEst' that, for instance, allows Estimates. Most funds should price daily but the NAV field also allows for estimates, so you may have NAV data at different frequencies. Such arguments can also be found in the Data Item Browser in the 'Parameters' tab on the top right.


P.S.: You can search for fields such as 'NAV' on Eikon/Workspace here too.

icon clock
10 |1500

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

Click below to post an Idea Post Idea