Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by asdfasdfasdf_deprecated_0 · Aug 24, 2016 at 10:34 AM · eikon-sdkcontentqualifiers

qualifiers for tick data in Eikon .NET API

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?

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

5 Replies

  • Sort: 
avatar image
REFINITIV
Answer by Christiaan Meihsl · Aug 25, 2016 at 04:42 AM

@asdfasdfasdf

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

Examples:

  • France: FR/TAS1 or FR/CHAR1
  • Germany: DE/TAS1 or DE/CHAR1
  • UK: GB/TAS1 or GB/CHAR1. See also LSETAS01 for the London STock Exchange.
  • LIFFE: LIFFEFLAGS01, GB/FUTTAS1
  • Euronext: NXT/TAS1

etc.

Hope this helps.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by asdfasdfasdf_deprecated_0 · Aug 25, 2016 at 11:58 AM

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_TRDPRC_1 167.66

TSDB_TRDVOL_1 4000

TSDB_BID 167.65

TSDB_BIDSIZE 217

TSDB_ASK 167.66

TSDB_ASKSIZE 137

TSDB_VhExchgTime 8/24/2016 12:08:39 PM

TSDB_COLLECT_DATETIME 8/24/2016 12:08:00 PM

TSDB_RTL_Wrap 0

TSDB_RTL 46430

TSDB_Sub_RTL 0

TSDB_RuleClauseNo 4

TSDB_TRD_QUAL_4 12062

TSDB_TRD_QUAL_5 151029

TSDB_REU_QUAL 13156

TAG d24_m08_y2016_h12_m08_s00_ms0000_0_46430_0_4

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();

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Christiaan Meihsl · Aug 25, 2016 at 12:48 PM

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:

  • In TRTH: the qualifiers field contain: OTC[ALIAS];489[IRGCOND]; [PRC_QL2]
  • In the Eikon GUI (time series tool): the trade flags are OTC Block Trade (screenshot)


fgblu6-blockt-24082016.png (20.7 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by asdfasdfasdf_deprecated_0 · Aug 31, 2016 at 10:10 AM

Is there an update on this?

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Christiaan Meihsl · Sep 02, 2016 at 03:52 AM

@asdfasdfasdf

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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

futures trading dates via eikon api

Eikon APi -Retrieve constituents?

Retrieve list of instruments for all stocks on an exchange

Eikon Core and Eikon API

Retrieve Historical price and fundamental data Eikon API

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges