How to filter out certain trade types

jirapongse.phuriphanvichai ,

The code which you share above is same what we are calling to get the data. Now we want to know the syntax to filter the list which is mentioned above. can you share us the syntax with Filter to exclude those results. we just want to exclude those results from data.

_subscription = _timeSeries.SetupDataSubscription("EUR=")
        .WithView("BID")
        .WithAllFields()
        .WithInterval(CommonInterval.Quotes)
        .WithNumberOfPoints(50)
 
        .WithFilter(filter => filter.ContributorIn(new[] {"RBSN"}))
        .WithFilter(filter => filter.NumericValueOfField("BID").GreaterOrEqual(1.1342))
 
        .OnDataReceived(DataReceivedCallback)
        .CreateAndStart();

We contacted Eikon Excel support, but have been advised that it is best to repost our issue here.

As added information, our application is for US and Canadian equities. So we are typically passing RIC’s such as:

AGU.TO

HON.N

AAPL.O

Our customer has complained that the price data returned by the DataAccess.TimeSeries service is not the same data that is being used in the preparation of day price candle charts such as 5 minute bars on their Eikon terminal.

After reviewing the raw price data we pull, Eikon Support did agree that the data is different. They advised us that to ensure we only perform our custom analysis on the same prices that are used in the price charts for a particular day (say 5 minute candle charts) then we need to impose filters for certain trade types (see the table below)

We are using ThomsonReuters.Desktop.SDK.DataAccess.TimeSeries in a C# application we have written.

Here is the code which we are using to get the data through this SDK ThomsonReuters.Desktop.SDK.DataAccess.TimeSeries.

// DateTime dt = DateTime.ParseExact(argument[1], "yyyy-MM-dd ", CultureInfo.InvariantCulture);
dtStart = DateTime.Parse(string.Format("{0} " + StartingTime , startDate),
CultureInfo.InvariantCulture);
dtEnd = DateTime.Parse(string.Format("{0} " + EndingTime, EndDate),
CultureInfo.InvariantCulture);

this.dataSubscription = DataServices.Instance.TimeSeries.SetupDataSubscription(this.Ric)
.WithInterval(CommonInterval.Trades)
.From(dtStart)
.To(dtEnd)
.OnDataReceived(this.OnSubscriptionDataReceived)
.OnDataUpdated(this.OnSubscriptionDataUpdated)
.OnStatusUpdated(status => this.Title = string.Format("Status: {0} Error: {1}", status.State, status.Error))
.CreateAndStart();

This is the same code which you have in your Eikon desktop API section on the developer support website. As you can see there is no withFilter in this basic sample.

Add code to filter out these trade types: We have been advised that these FID 1003 criteria in the table below need to be filtered using the withFilter capability in the above mentioned API.

Unique ID IDN Value Description

152526 1_N Next Day Trade

152540 4_B Average Price Trade

152542 4_M Market Center Official Close

152543 4_Q Market Center Official Open

152544 4_H Price Variation Trade

154580 2_9 Official Consolidated Close

152549 4_I Odd Lot trades

152525 1_C Cash Trade (Same Day Clearing)

152527 1_R Seller

152536 3_T Extended Hours Trade

152537 3_U Extended Hours Sold (Out of Sequence)

-------------------------------------------------------------------------------------

We are assuming we would need to add:

.WithFilter(filter => filter.stringValueOfField("TRADETYPE").Equal(“X_X”))

or perhaps

.WithFilter(filter => filter.stringValueOfField("FID 1003").Equal(“X_X”))

I have used the placeholder "X_X" above because I do not know the correct FID 1003 that defines common session trades in any day that would be used to build the candles such as 5 minute bars ofn an Eikon price chart? If such a single FID 1003 exists then we would want to apply that filter only – keeping only those trades and excluding the other ones that are returned by the TimeSeries service.

If a single FID 1003 value for common session trades does not exist this would mean we will have to build a multiple criteria filter. What is the syntax to construct a multi-line query to remove all of the above IDN values listed in the table?

.WithFilter(filter => filter.stringValueOfField("FID 1003").NotEqual(“1_N”))

.WithFilter(filter => filter.stringValueOfField("FID 1003").NotEqual(“4_B”))

etc., etc.

Thank you again.