Transforming some existing Excel data pulls to .NET

vsarpe
vsarpe Newcomer
in Eikon COM

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

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @vsarpe

    ThomsonReuters.Desktop.SDK.DataAccess.Signed can be used to retrieve real-time data. It can retrieve CF_NAME and PCTCHNG fields because those fields are real-time fields.

    However, it is unable to retrieve TR.xxx fields. The library that can retrieve TR.xxx fields is DEX2 in COM APIs for use in custom applications. The example (Dex2 Sample) is available at Fundamental and Reference Data example.

    image

    However, please refer to this thread if you would like to use ThomsonReuters.Desktop.SDK.DataAccess.Signed and Eikon COM within the same application.


Answers

Categories