Is there any way to get the qualifiers on trade and quote data when working through TimeSeries Eikon .NET API? It looks like if I subscribe to the TSDB_RAW view, I can see fields like TRD_QUAL_3, but these don't correspond to anything I am familiar with. Is there documentation available for possible qualifier values?
Handling qualifiers is very complex. The reason for this is that each exchange has its own way of coding and mapping them. So, depending on the exchange, the qualifiers will be in one field or another, or a set of fields, and the data in those fields will vary by exchange as well. To add to the difficulty, it happens that exchanges change the mapping ...
For trades check out these fields: ACT_FLAG1, CTS_QUAL, TRD_QUAL_2, IRGCOND, PRC_QL_CD, PRC_QL2, MKT_ST_IND, LIMIT_IND, ACT_TP_1, etc.
For quotes start with this field: ACT_TP_1
Documentation: using the Eikon GUI you can find some information on the qualifiers. In a quote window, open WORLD/TAS1 (TAS stands for Time And Sales), or directly enter <countryISO>/TAS1 or <countryISO>/CHAR1 and follow the contextual menus (you might need to search a bit through those pages to find the qualifiers descriptions).
Hope this helps.
Thanks. I'm aware of all those fields, and that is what I'm used to seeing, but that is not what I am seeing in Eikon.
Let me give you an example. There was a block trade in FGBLU6 at 20160824T120839 (UTC). This should have a qualifier of 489[IRGCOND], and I see this qualifier in other systems. In Eikon however, this is what I see:
TSDB_VhExchgTime 8/24/2016 12:08:39 PM
TSDB_COLLECT_DATETIME 8/24/2016 12:08:00 PM
So I don't see any qualifier fields that I am used to, and I see some that I have never seen before (e.g. the TRD_QUAL_4 and TRD_QUAL_5).
How do I map between the two? Or is there a different request I can make to get things like IRGCOND?
Here's the request I made:
ITimeSeriesDataService ts = DataServices.Instance.TimeSeries; _req = ts.SetupDataRequest("FGBLU6") .WithView("TSDB_RAW") .WithAllFields() .WithInterval(CommonInterval.Trades) .From(new DateTime(2016,8,24,12,8,0)) .To(new DateTime(2016, 8, 24, 12, 9, 0)) .WithTimeZone(TimezoneType.GMT) .OnDataReceived(on_data) .CreateAndSend();
Ok, now I understand your query better, but I don't have an answer as to why you get different fields. I shall escalate further.
BTW I checked the particular block trade you mention elsewhere:
Sorry this took some time. In a nutshell, you cannot get the qualifiers on trade and quote data when working with the TimeSeries Eikon .NET API. If you require the qualifiers, we recommend you use a different API, for instance TRTH (Thomson Reuters Tick History).