For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
7 1 0 0

Translating Excel request to C# request

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvote
Accepted
39.2k 75 11 27

@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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
7 1 0 0

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
23k 22 9 14

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?




20200501.gif (13.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea