How to get FX rates from DSS rest API using python? any prerequisites needs to be done from our appl
Best Answer
-
@prakash.balusamy,
Prerequisites
- There are no specific ones for Python, as the API is a pure REST API.
- As DSS is a commercial product, you need DSS specific credentials (username and password) which you should have received if you are a customer.
Python
As the API is a REST API, any language that can process HTTP communication and can decode JSON can be used. Python is fine, it is easy to access DSS using Python.
Next steps
I guess you would benefit most from reading the Programming without SDK tutorial, which explains how to interact with the API using Python and Java, and also explains how you can identify which API call to use depending on what data you need.
How to get FX rates
At this point we cannot tell you exactly which API calls to use, because your query is not specific enough: what FX rates do you need ? Do you want an intraday snapshot, End of Day data, something else ? If you can tell us exactly what data you are trying to get, we can give you more details on how to retrieve it.
1
Answers
-
@Christiaan Meihsl,
What is difference between Intraday snapshot and End of day FX rate? currently, we are getting the rate from market data server, when we query each time for same RIC, we get different rates. I thought it's real time data.
in this case, what FX rate work for us?0 -
@prakash.balusamy,
The choice of the price type you need to request depends on your use case. Different use cases require different data, and the difference is very important from a financial and functional perspective. If you are unsure, please check this point with your business stakeholders, they will know.
Intraday snapshot
This is a snapshot of the current price, in other words something similar to what you get from your real-time market data server. Please bear in mind:
- DSS is not a "real-time" product, it will not respond as fast as a real-time data feed, which is built for an entirely different purpose.
- Receiving a snapshot of the current price implies you are entitled for real-time data (that is a contractual aspect). If you are not entitled for real-time data you can request delayed data using a / in front of the RIC. A delayed price is the price of some minutes ago. The delay depends on the data provider. I don't know what the delay is for FX. For Xetra (the german exchange) the delay is 15 minutes.
End of Day
This is the price at the end of the previous trading day.
0 -
@Christiaan Meihsl, Thanks for your answers!
I have discussed with business stakeholders, they need Intraday snapshot data.
Below are few question I have for now,- For testing, DSS have any testing host or Do I need to use the actual host which DSS provided for production?
- For Intraday snapshot extract, can I use "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest" ? or I need to check with DSS support team to get exact type
- Do I need to raise Firewall between our network and DSS network? because I am getting the below error:
Error: Status Code:403 Message:{"error":{"message":"No permission for template \"IntradayPricingReportTemplate\"."}}
0 -
@prakash.balusamy,
To your 3 queries:
- You must use the production host.
- Yes, that is the right type. See the DSS tutorial on intraday requests for details.
- The 403 error means you are not allowed to request intraday data. For permission issues, you need to contact your Refinitiv account manager. For explanations on the HTTP return codes, see the HTTP status help page.
0 -
@Christiaan Meihsl, Thanks for your answers!
What's the port number for DSS production host (159.43.0.2) ? Is't 443?
0 -
@prakash.balusamy, yes, it is standard HTTPS, i.e. TCP 443.
As a side note, please post new queries in separate threads, that will ensure they get attention from the moderators.
1 -
Hello, Christiaan,
could you elaborate on this a bit further? For example, if I have BMW in my identifier list and want to ask the Last Price from 15min ago, where would I put the slash / ?
"Identifier": "BMWG.DE",
"IdentifierType": "Ric"Just before the B? Like this:
"Identifier": "/BMWG.DE",
"IdentifierType": "Ric"
That is not working on my end, I get "All identifiers were invalid".
Thank you very much
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛