i am trying to fetch Fund and Bond data which are on both TR. and CF_ fields. I tested an app like the "Dex2samples" from the "Com Desktop Api" section and i manage to get only TR. fields. When i ask for CF_ i get nothing.
Is there a way to fetch both TR. and CF_ fields with one connection - Query? Some of CF_ fields does not exist in the TR. fields.
If you use Eikon COM APIs, you cannot commingle TR. fields and CF_ fields in the same request. With Eikon COM APIs you need to use DEX2 library for TR. fields and AdfinX Real-Time library for CF_ fields.
If you use Eikon Data APIs you can commingle TR. fields and CF_ fields in the same get_data method call.
I understand very clearly, thank you a lot, i believe i can use some other field for "last" date check.
I have one more question if you can help me. My client needs the fields TR.FundTotalReturnLipperRating, TR.FundConsistentReturnLipperRating, TR.FundPreservationLipperRating and also these with the paramater (TimeFrame = 10Y) after the field. On excel and on monitor when i choose to see this values for example for the fund Ric=LP60099969 i take one value for every field and show correctly, but when i try to fetch them from my Dex2 app it returns to me 20 rows for every Ric with the same results and in some rows different. Why these specific fields are treating different from the others? Can i tell the app with some parameter to fetch me only one row for every Ric when i need this fields?
Sorry if i confused you, i am available for any further information you may need, thank you.
On my end the following function returns 20 rows of data: =TR("LP60099969","TR.FundTotalReturnLipperRating"), so the experience I have in Excel is consistent with your experience with DEX2 library.
These Lipper ratings are country specific. If you add country to the output: =TR("LP60099969","TR.FundTotalReturnLipperRating","RH=Country"), you will see that the function returns one row per country. You can restrict the output to specific country, in which case the function will return only one row: =TR("LP60099969","TR.FundTotalReturnLipperRating","CtryOfReg=GBR"), and you can use the same parameters to restrict the output in DEX2.
I hope this helps.
Hello @Alex Putkov.
yes you helped me a lot, i manage to take these field prices. I have the same problem with 3 more fields and i hope to be the last ones :). I will be grateful to help me on these too. The fields are the below:
Again with these the api returns to me many empty or duplicate rows, for example i give 50 rics and i take 1000+ rows.
Hello @Alex Putkov. of course i can give an example and i can i guide you to help me because i understand the problem.
For example if i ask the field TR.FundHoldingName for the ric LP60099969 i will get the following list
LP60099969 OTHER ASSETS
LP60099969 SES SA DR
LP60099969 ROYAL DUTCH SHELL PLC B ORD
LP60099969 ORACLE CORP ORD
LP60099969 CITIGROUP INC ORD
LP60099969 ALLERGAN PLC ORD
LP60099969 BP PLC ORD
LP60099969 SAMSUNG ELECTRONICS CO LTD ORD
LP60099969 SINGAPORE TELECOMMUNICATIONS LTD ORD
LP60099969 TEVA PHARMACEUTICAL INDUSTRIES LTD DR
on the eikon product i will get only the first OTHER ASSETS, maybe this is the default. I would like also to take only one row by the api and not all ten. How i can get only the default with field parameter?
Another example for the same ric if i call the TR.FundAllocationName:
LP60099969 Equities LP60099969 Cash & Cash Equivalents LP60099969 Health Care LP60099969 Financials LP60099969 Communication Services LP60099969 Energy LP60099969 Industrials LP60099969 Consumer Staples LP60099969 Information Technology LP60099969 Consumer Discretionary LP60099969 Others LP60099969 Materials LP60099969 United States LP60099969 Others LP60099969 United Kingdom LP60099969 France LP60099969 Japan LP60099969 China LP60099969 Germany LP60099969 Switzerland LP60099969 Korea LP60099969 Netherlands LP60099969 Oracle LP60099969 Royal Dutch Shell LP60099969 SES SA LP60099969 Samsung Electronics LP60099969 Citigroup LP60099969 BP LP60099969 Singapore Telecommunications LP60099969 Roche Holdings LP60099969 Allergan Plc LP60099969 Standard Chartered
Again i need only the first "Equities".
I see now. If you just want the top entry for TR.FundHoldingName you can add EndNum=1 request parameter:
I don't see any way to restrict the output for TR.FundAllocationName to a single entry. To explore what parameters and output options are available for a given field use Parameters & Quick Functions tab in Formula Builder wizard in Eikon Excel or Parameters tab in Data Item Browser app in Eikon. See this thread for an illustration.