question

Upvotes
Accepted
1 2 1 4

Is it possible to get TRADE_DATE on every message?

For example this fid only appears on certain message and not all trades

FIELD_ENTRY 16/TRADE_DATE: 27 JAN 2017

I'm trying to get a full date time stamp including SALTIM which is the time component.

treprfarfa-apitrade
icon clock
10 |1500

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

Hello @avnish.madan

What are the RICs that you would like to get TRADE_DATE?

@avnish.madan

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks

AHS

Upvotes
Accepted
9.5k 10 5 7

Hello @avnish.madan

RFA Java passes all fields/FID to you as it receives from the feed/provider. If the feed does not provide TRADE_DATE field in every message so you cannot get it.

You may try to use work around mentioned by Zoya's answer.

If you have more questions regarding TRADE_DATE or any fields, you should contact feed/data team who is the data expert and can provide you with the proper answers. You can submit data questions to them directly via MY ACCOUNT, https://my.thomsonreuters.com . After logging in, click "RAISE A CASE" then "Product Support", click your subject. At “Select product * “ type the feed e.g. “Thomson Reuters Elektron Real-Time”. If you face any problems during raise the case, you should contact RDC Administrator(rdc.administrator@thomsonreuters.com).

icon clock
10 |1500

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

Upvotes
1 2 1 4

It could be any RIC for eg VOD.L. Looking a generic approach. Thanks

icon clock
10 |1500

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

Upvotes
30.3k 34 11 17

@avnish.madan

FID set in the message is determined by the provider (Elektron?), subscriber can filter out/ignore any FIDs it's not interested in.

However, two points that may be helpful:

Trade messages are intended to carry TRADE_DATE in the update, quotes are not. If you need this info to be used with every message, maybe a better way is to store it within your subscriber application, perhaps hashed by RIC, and enrich other updates on the application side.

Snapshot carries all the FIDs. Perhaps no-update request, snapshot that carries all the FIDs will work better for your use case.

icon clock
10 |1500

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

Upvotes
13.7k 26 8 12

@avnish.madan

Depending on the exchange, the trade date and time could be (no guarantee, there are cases where the information is just not available) found in various fields. Here are some FIDs that may carry that information:

Date: ACTIV_DATE, CRRNT_DATE, VALUE_DT1, GV1_DATE

Time: SALTIM, EXCHTIM, TIMACT, TRDTIM_1, TRDTIM_MS, SALTIM_MS, TIMCOR, GV1_TIME, VALUE_TS1

icon clock
10 |1500

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