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

Options
subin.john
subin.john Newcomer
in Eikon Data APIs

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?

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

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

Answers

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭

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

  • subin.john
    subin.john Newcomer

    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

  • subin.john
    subin.john Newcomer

    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

  • subin.john
    subin.john Newcomer

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

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    https://community.developers.refinitiv.com/discussion/comment/40161#Comment_40161

    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.

  • subin.john
    subin.john Newcomer

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

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    https://community.developers.refinitiv.com/discussion/comment/40162#Comment_40162

    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.

Categories