REST API question on TRTHv2

1) How can I programmatically get RICs for search
criteria like "ES futures" or even "S&P500 E-mini
futures"
2) How do the report templates work with recurring
invocations when there is an end date in the temple.
3) I need the full rest api spec, so far I only found
examples and guides I don't seem to be able to find an actual api doc anywhere
Answers
-
3) The API is documented online, in the REST API Reference Tree. You can also look at this tutorial which should help you understand that reference, and give you other pointers.
2) When a report template contains an end date (and start date) they define the date/time range for the historical data you request. That has nothing to do with when the request will run, which is defined by a schedule. If a recurring schedule uses an unvarying instrument list and report template, it will just return the same data every time. Side note: a request can also be On Demand, but such requests do not use a predefined report template.
1) There are various historical search capabilities for TRTH customers: HistoricalSearch is the simplest. HistoricalCriteriaSearch allows searching by a whole set of criteria, and HistoricalChainResolution allows searching for chain constituents.
0 -
Thank you @Christiaan Meihsl
Case: 0550095
Client: Higher
Moment CapitalHere is a follow up from client
on question 1"Thank you for your
answers. On question 2 and 3 I'm all set. On question 1 I'm still not.
Very specifically, given, the 3 api calls you provided in the answer, what
should the request body be to request all historical RICs for all expirations
for E-mini S&p 500 future's given the only the root ES and a date range
I don't want the users of my code to have to know anything but ES or VS(as
another example) to retrieve the RIC's.
Similarly, for options, the only additional data that I would expect to supply
is puts or calls or both and a strike % range from in the money up or
down."0 -
Follow-up on question 1:
Note: all the following are historical criteria requests, using a POST to this endpoint: http://hosted.datascopeapi.reuters.com/RestApi/v1/Search/HistoricalCriteriaSearch
1.1 Body to request all historical RICs for all expirations for futures given the root ES and a date range:
{
"Request": {
"RicPattern": "^ES",
"BondTypeCodes": null,
"ContributorIds": null,
"CountryCodes": null,
"CurrencyCodes": null,
"ExchangeCodes": null,
"FutureMonthCodes": null,
"InstrumentTypeCodes": [ "114" ],
"OptionMonthCodes": null,
"OptionTypeCodes": null,
"CouponRate": null,
"StrikePrice": null,
"ExpiryDate": null,
"MaturityDate": null,
"Range": {
"Start": "2017-05-01T00:00:00.000Z",
"End": "2017-05-17T00:00:00.000Z"
}
}
}Explanations:
- RIC pattern is a regex, which defines "any RIC starting with ES". Accepted regular expressions are listed in this query.
- InstrumentTypeCodes is an array of values (one or more, comma separated), each one defining an instrument type. In this example 114 is for Equities Futures (there are other codes for other futures, like cross market, metals, etc). Parameters and possible values are described in the HistoricalCriteriaSearch section of the REST API Reference Tree.
This query returns more than 4000 results.
1.2 Body to request all historical RICs for all put options given the root ES and a date range:
{
"Request": {
"RicPattern": "^ES",
"BondTypeCodes": null,
"ContributorIds": null,
"CountryCodes": null,
"CurrencyCodes": null,
"ExchangeCodes": null,
"FutureMonthCodes": null,
"InstrumentTypeCodes": [ "116" ],
"OptionMonthCodes": null,
"OptionTypeCodes": [ "1" ],
"CouponRate": null,
"StrikePrice": null,
"ExpiryDate": null,
"MaturityDate": null,
"Range": {
"Start": "2017-05-01T00:00:00.000Z",
"End": "2017-05-17T00:00:00.000Z"
}
}
}Explanations:
- InstrumentTypeCodes 116 is for Equities Options.
- OptionTypeCodes 1 is for put (0 is for call, and there are more options)
This will return more than 7000 results.
1.3 You can filter on strike price, using a range in absolute values (not %):
{
"Request": {
"RicPattern": "^ES",
"BondTypeCodes": null,
"ContributorIds": null,
"CountryCodes": null,
"CurrencyCodes": null,
"ExchangeCodes": null,
"FutureMonthCodes": null,
"InstrumentTypeCodes": [ "116" ],
"OptionMonthCodes": null,
"OptionTypeCodes": [ "1" ],
"CouponRate": null,
"StrikePrice": {
"Min": 100,
"Max": 200
},
"ExpiryDate": null,
"MaturityDate": null,
"Range": {
"Start": "2017-05-01T00:00:00.000Z",
"End": "2017-05-17T00:00:00.000Z"
}
}
}This last request returns one result (ES100R7).
Wide open queries deliver very large data sets and can be quite lengthy (and even time out after 5 minutes). Restricting result sets by using a short time range, and other filtering criteria (currency, exchange, etc.) is therefore recommended.
Added later to this response:
Illustration of a similar Historical Search with Criteria, in the GUI:
- Select Historical Search
- Click on Criteria to display the filter criteria.
- To illustrate your use case, set the RIC Identifier to start with ES
- Click on Instrument Types to filter on those
- You can filter the display of available types, like here for futures
- Click on all those you want to select in the left column, they will appear in the right column.
- Select the date range for the query.
As you can see, other criteria are available (maturity and expiration dates, strike price, etc.).
0 -
Thank you for your detailed explanation, however, I it does not really address my question. I'm looking for all futures for an equity index by root ES which is equivalent to E-mini S&p 500 futures. The query you provided and other combination in historical search gives me all Rics that strat with ES. That's like a million other Rics that I do not need, for instance, ES is actually an EverSource stock.
In order to properly find E-mini S&p 500 futures, I need to be able to Search/HistoricalCriteriaSearch by RICRoot which is not available!The only place where it is available is Search/FuturesAndOptionsSearch but for some reason, the entire TRTH organization keeps pointing me at back at HistoricalCriteriaSearch? Why?
0 -
Although TRTH resides in DSS, these products are different. HistoricalCriteriaSearch is a function in TRTH while FuturesAndOptionsSearch is a function in DSS.
This question is about TRTH so the TRTH support team will typically refer to the function available in TRTH which is HistoricalCriteriaSearch.
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
- 690 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 716 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
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛