For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 1 2

incorrect FX rate - For USDAUDFIXMP=WM for 18-MAR-2019

We were trying to fetch rate yesterday (March 17th ) 7:53PM EST (Sydney time 10: 53AM, March 18th) and we were not getting any rate for 18th.

Do you know why we are not getting the rate for 18th instead we are getting the rate of 17th March?

eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikonforex
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
Accepted
39.3k 76 11 27

As far as I can see you're getting what you're supposed to be getting. You're just not interpreting it correctly. The RIC USDAUDFIXMP=WM is updated hourly a few minutes past the hour. On March 18th at 10:53 Sydney time the last update (with the value of PRIMACT_1 equal to +0.70805) had been published on March 18th at 10:05 Sydney time, which is March 17th 23:05 GMT (or March 17th 19:05 New York time). Since the date value of the field VALUE_DT1 is according to GMT, the value of VALUE_DT1 corresponding to the update published on March 18 at 10:53 Sydney time is "17 Mar 2019". If you need to convert the date value in field VALUE_DT1 to Sydney time I suggest you combine it with the time value in field VALUE_TS1 and use the combined datetime value (e.g. "17-Mar-19 23:05") to convert from UTC to Sydney time, which will give "18-Mar-19 10:05".

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
39.3k 76 11 27

It would be helpful to know how you determined that you were getting the rate for March 17th. I'm guessing you were looking at the value in FID VALUE_DT1, which represents the date according to GMT. At the time of your observation GMT date was still March 17th. It did not yet change to March 18th, which would happen at the next update after midnight GMT (8 PM EDT, 11 am Sydney).

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 0 1 2

We use the below format to get the rate

FORMAT AUDFIX10H *IDN_RDF.ANY.USDAUDFIXMP=WM.NaE[PRIMACT_1] *IDN_RDF.ANY.USDAUDFIXMP=WM.NaE[VALUE_DT1]

Let me know if I needs to use the different format to get the correct rate, which is published between 10-11 Sydney time?

Thanks

Subin

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 0 1 2

the format we are getting on this request says that it is for 17th

Sample log:

2019-03-17 19:53:38,275 SubscriptionResult [Thread-1] DEBUG: Unsubscribing: IDN_RDF.ANY.USDAUDFIXMP=WM.NaE

2019-03-17 19:54:35,130 GatherLineLayout [main] DEBUG: [line: AUDFIX10H +0.70805 17 MAR 2019]

2019-03-17 19:54:35,130 GatherMain [main] INFO : Finished writing output file

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 0 1 2

Asper the suggestion i changed the VALUE_DT1 to VALUE_TS1

Now I am getting the response as below

Log:
2019-03-19 16:47:24,986 GatherLineLayout [main] DEBUG: [line: AUDFIX10H +0.70930 20:08:23]

how do i get the same format (UDFIX10H +0.70805 17 MAR 2019) When I request on 7:00PM EST (Sydney time 10:00 AM next Day) with sydney date (format DD MMM YYYY)?

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.

I don't think I understand the question. Are you asking how you can use your custom application to log the date value in GMT that you retrieve from Elektron datafeed in the timezone of your choice? I couldn't possibly tell you how to use your application, as I have no knowledge of it. Unless timezone conversion is already implemented in your application, I'd think the source code would need to me modified to provide this capability. From programming perspective conversion between timezones is a standard programming task that any software developer is familiar with.

Upvotes
1 0 1 2

You mean VALUE_DT1 gives in GMT day always and convert it and use it my application ?

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.

All date and time values on Elektron datafeed are in GMT. If you'd like to display any date or time values you retrieve from Elektron in another time zone, you do indeed need to do time zone conversion in your application.