Hi, I have an excel spreadsheet which successfully fetches certain data from Eikon. I would like to convert all of the functionality from the sheet to a .NET application.

I am using ThomsonReuters.Desktop.SDK.DataAccess.Signed and basic functions work (CF_NAME), but some more specialized functions don't and I'm not sure how to convert them to work with .NET. My initial assumption was that the Excel fields were directly usable with the .NET API.

A simple example that works:

In excel (works):

=TR("GOOG.O","CF_NAME")
=TR("GOOG.O","PCTCHNG")

In .NET (works, RawValue is not null):

DataServices.Instance.Realtime.Request("GOOG.O", "CF_NAME", DataReceived, ErrorReceived);
DataServices.Instance.Realtime.Request("GOOG.O", "PCTCHNG", DataReceived, ErrorReceived);

However, there are some that work in Excel that I don't think I have a good idea how to adapt them for .NET

In excel (works):

=TR("GOOG.O","TR.PricePctChg5D")
=TR("GOOG.O","TR.SIShortInterest")
=TR("GOOG.O","TR.PriceToBVPerShare(SDate=0D)")
=TR("GOOG.O","PERCENT_CHG(TR.ShortInterestPct(SDate=0D),lag=-3AW)")

In .NET (does not work, RawValue is null)

DataServices.Instance.Realtime.Request("GOOG.O", "TR.PricePctChg5D", DataReceived, ErrorReceived);
DataServices.Instance.Realtime.Request("GOOG.O", "TR.SIShortInterest", DataReceived, ErrorReceived);
DataServices.Instance.Realtime.Request("GOOG.O", "TR.PriceToBVPerShare(SDate=0D)", DataReceived, ErrorReceived);
DataServices.Instance.Realtime.Request("GOOG.O", "PERCENT_CHG(TR.ShortInterestPct(SDate=0D),lag=-3AW)", DataReceived, ErrorReceived);

I feel like I'm missing something simple, but I'm not sure what the next steps are here..

Thank you