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 Data APIs /
avatar image
Question by subin.john · Mar 18, 2019 at 02:25 PM · aud fx rate

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?

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.

6 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Mar 18, 2019 at 04:33 PM

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

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 Alex Putkov. · Mar 18, 2019 at 02:53 PM

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

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 subin.john · Mar 18, 2019 at 03:02 PM

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

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 subin.john · Mar 18, 2019 at 03:03 PM

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

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 subin.john · Mar 19, 2019 at 05:11 PM

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

Comment

People who like this

0 Show 1 · 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
Alex Putkov. ♦♦ · Mar 19, 2019 at 05:34 PM 0
Share

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.

avatar image
Answer by subin.john · Mar 19, 2019 at 05:52 PM

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

Comment

People who like this

0 Show 1 · 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
Alex Putkov. ♦♦ · Mar 19, 2019 at 05:56 PM 0
Share

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.

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 >
9 People are following this question.
  • 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