question

Upvotes
Accepted
grzegorz.zajac avatar image
3 ●0 ●0 ●0

How to convert TIMACT_MS (FID 4148) from number format to time format in my TRTH Market Depth output?

Hi,

My Refinitiv Access client Baader Bank AG is looking to implement TRTH. Can you tell me the formula how to convert the number format given in the below FIDs to a readabletime format?

FID5
TIMACT04:00.0FID4148
TIMACT_MS25463899

Excel is able to convert FID 5 into a time format, but it's not able to convert the milliseconds/nanoseconds in FID 4148

tick-history-rest-api
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.

2 Answers

Upvote
Accepted
zoya faberov avatar image
23k ●22 ●9 ●14

Hello @grzegorz.zajac,

TIMEACT_MS is time in milliseconds, elapsed since Unix Epoch, Jan 1, 1970.

I think you are looking to convert in Excel, perhaps Excel convert epoch milliseconds to datetime can be of help to you.

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
grzegorz.zajac avatar image
3 ●0 ●0 ●0

Pefect. Thanks for the prompt reply.

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