Question on DSS Time Series Extraction API

Hi We are trying to use timeSeries DSS API to get previous days high and close.
In the document it has
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Monaco; color: #3933ff}
p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Monaco}
span.s1 {color: #000000}
span.s2 {color: #931a68}
span.s3 {color: #3933ff}
.put("Condition",
new JSONObject().put("LastPriceOnly", false)
.put("StartDate", "2015-10-28T00:00:00.000Z")
.put("EndDate", "2015-11-04T00:00:00.000Z").put("LookBackPeriod", "EOD-4M")));
Questions:
1. Start and End date are in EST ?
2. If we want to get high/low between previous day Open and Close market what dates should we specify.
3. What is EOD-4M mean?
Best Answer
-
Hi @soyarlagadda,
I think EOD Pricing is more suitable than Timeseries. The EOD Pricing provides initial and validated end of day prices. It normally provides end of day prices for the previous trading day. You can use the "High Price" and "Low Price" fields to get high and low for the previous trading day. For more information, please see REST API Tutorial 2: On Demand End of Day Extraction
With regard to your questions:
The Start and End date should be date in instrument's exchange.
According to the LookBackPeriod description, the Lookback is added to the Price date. That means if you selected January 2, 2016 as your Price Date and 4 months as your Lookback, DataScope Select would look back as far as September 2, 2015 if null prices were reported for the instruments on January 2, 2016
0
Answers
-
Thanks for the help. What is the time zone, EST ?
0 -
The Start and End date are just dates. These fields are used for specifying range of which trading day, the historical prices are extracted for, so they do not depend on time zone.
0 -
Thank you for the help.
Today we have extracted EOD Extraction and found this discrepancy.
For AUD, it looks like AUD -> USD rate
However, for CAD it is USD - > CAD rate
How do we identify which is inverse?
{"IdentifierType":"Ric","Identifier":"AUD=","Ask Price":0.7185,"Asset Category":"SPO","Asset Category Description":"Spot","Asset Status":"ISS","Asset Status Description":"Issued","Bid Price":0.718,"Common Code":null,"CUSIP":null,"Exchange Code":"RCT","Exchange Description":"SOURCE IS A THOMSON REUTERS CONTRIBUTOR","Expiration Date":null,"High Price":0.7196,"ISIN":null,"Issuer OrgID":null,"Low Price":0.7139,"Mid Price":0.71825,"Official Close Price":null,"Open Price":0.7149,"Previous Close Price":null,"RIC":"AUD=","Ticker":null,"Trade Date":"2018-09-17","Trading Symbol":null,"Universal Close Price":0.718,"Volume":null}
{"IdentifierType":"Ric","Identifier":"CAD=","Ask Price":1.3046,"Asset Category":"SPO","Asset Category Description":"Spot","Asset Status":"ISS","Asset Status Description":"Issued","Bid Price":1.3042,"Common Code":null,"CUSIP":null,"Exchange Code":"RCT","Exchange Description":"SOURCE IS A THOMSON REUTERS CONTRIBUTOR","Expiration Date":null,"High Price":1.3048,"ISIN":null,"Issuer OrgID":null,"Low Price":1.2997,"Mid Price":1.3044,"Official Close Price":null,"Open Price":1.3034,"Previous Close Price":null,"RIC":"CAD=","Ticker":null,"Trade Date":"2018-09-17","Trading Symbol":null,"Universal Close Price":1.3042,"Volume":null}
0 -
I'm not sure if I understand your question correctly. If you want to identify currency pair of the RICs, you can use the "Base Currency Code" and "Currency Code" fields.
If you want other RICs providing inverse currency pair, you can use <USDAUD=R> for USD->AUD cross rate and <CADUSD=R> for CAD->USD cross rate.
You can also search for RICs using the RIC Search Tool.
Hope this helps.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 687 Datastream
- 1.4K DSS
- 621 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 254 ETA
- 557 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 276 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 669 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 229 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛