Translating Excel request to C# request

Robby.Stamper

Hi,

I have the following query in Excel to pull up net income

=TR("MSFT.O","ZAV(TR.TotalRevenue(Scale=6))","SDate=0 EDate=-199 Period=FQ0 Frq=FQ",B2)

How do I convert that to the equivalent request in my C# code

request = timeSeries.SetupDataRequest("MSFT.O")

.WithView("BID")

.WithAllFields()

.WithInterval(CommonInterval.Quarterly)

.WithNumberOfPoints(10)

.OnDataReceived(DataReceivedCallback)

.CreateAndSend();

Many Thanks in advance,

Robby Stamper

Alex Putkov.1

@Robby.Stamper

The interface you tried to utilize (legacy Eikon .NET API) does not provide access to fundamental & reference data.

I suggest instead you look into .NET implementation of Eikon Data APIs:

https://github.com/Refinitiv-API-Samples/Article.EikonDataAPI.DotNet.Library

Another alternative is DEX2 library of legacy Eikon COM APIs.

Robby.Stamper

Oops, typo. I am trying to retrieve Total Revenue not Net Income.

zoya faberov

Hello Robby @Robby.Stamper

I am able to request what appears to be the same content via Python Eikon Data API this way:

ek.get_data("MSFT.O",'TR.TotalRevenue(Scale=6, SDate=0, EDate=-199, Period=FQ0, Frq=FQ)')

Resulting in:

Does this help?