RIC based on ISIN and Currency - Fund Pricing Frequency

joan.serfaty

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

jonathan.legrand

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.