Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
I am trying to do a simple query for the symbols FAS,FAZ and want the fields:
TR.InstrumentDescription,TR.CommonName,TR.FundTotalNetAssets
The first two return values, but the last one is empty, and that is the one I really need.
I found this question which says it should be available:
In the Data Item Browser, the field is available and has the proper value in it.
How can I get this to work with the C# Data API?
Thanks.
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text on the left side of the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
Thanks for reaching out to us.
I can retrieve the data properly by using the following code.
var fields = new List<string>
{
"TR.InstrumentDescription","TR.CommonName","TR.FundTotalNetAssets"
};
var json = eikon.GetDataRaw(new List<string> { "FAS","FAZ" }, fields);
json
The output is:
Then, I compared the result with the output from Eikon Excel. I used the following formula in Eikon Excel.
=@TR("FAS;FAZ","TR.InstrumentDescription;TR.CommonName;TR.FundTotalNetAssets","CH=Fd RH=IN",E2)
I hope that this information is of help.
I've found the problem. Doing the raw query like you suggested works. Originally, I had been doing a query using the fundamental reference like so:
await FundamentalAndReference.Definition().Universe(filterstr) .Fields(fields) .GetDataAsync();
and for some reason, that field was coming back blank. I can just use the raw query from now on.
Thanks.
