HistoricalCriteriaSearch how to limit result from the request

@johan.lundquist,

Your request

It specifies only 2 criteria:

RicPattern - Return all RIC names that contain the string "SEK".

Range - Return all instruments that were active during that time period.

So your query returns all instruments that were active on 20th November 2018, where the RIC contains "SEK". That will deliver many results, hence the long extraction time you observe.

The returned FirstDate / LastDate are the first / last dates where each instrument was active.

Filtering results

You cannot define:

• The IdentifierType. But results will only contain "Ric" and "ChainRic", nothing else.
• The instrument "Status". That said, you will only receive instruments that were active in the range you specified. I believe (not 100% sure, I'm not a data specialist) that the returned Status should always be "Valid".

That said, there is a whole set of criteria you can use to limit results:

RicPattern, BondTypeCodes, ContributorIds, CountryCodes, CurrencyCodes, DomainCodes, ExchangeCodes, FutureMonthCodes, InstrumentTypeCodes, OptionMonthCodes, OptionTypeCodes, CouponRate, StrikePrice, ExpiryDate, MaturityDate.

A few comments on these filters:

• InstrumentTypeCodes can limit results to specific types, like Forex Cash Options (by setting InstrumentTypeCodes to value 211) for instance.
• CurencyCodes uses a number for each currency, not a string. You can find the numbers using a GET to endpoint /RestApi/v1/Search/GetHistoricalCurrencies. For SEK the number is 752.
• ExchangeCodes behaves in a similar way, you can find the numbers using a GET to endpoint /RestApi/v1/Search/GetHistoricalExchanges.

Note on the RicPattern regular expression

As per this thread, historical criteria search currently supports only the following regular expression patterns:

• Begin with: ^ e.g. ^IBM // Begin with ‘IBM’
• End with: $ e.g. =RR$ // End with ‘=RR’
• Contain: string e.g. EUR // Contain ‘EUR’

You can escape special characters using a double slash, i.e. "\\"

Example: If you want to use a "." as a literal dot (and not as "any character"), then you need to escape it with , like in "\\.N$" to select any RIC that ends with ".N".

Example query

Retrieve Energy Market Statistics instruments containing "RED" in the RIC, in Danish or Swedish krona:

{
  "Request": {
    "RicPattern": "RED",
    "BondTypeCodes": null,
    "ContributorIds": null,
    "CountryCodes": null,
    "CurrencyCodes": [ "208", "752" ],
    "DomainCodes": null,
    "ExchangeCodes": null,
    "FutureMonthCodes": null,
    "InstrumentTypeCodes": [ "133" ],
    "OptionMonthCodes": null,
    "OptionTypeCodes": null,
    "CouponRate": null,
    "StrikePrice": null,
    "ExpiryDate": null,
    "MaturityDate": null,
    "Range": {
      "Start": "2018-11-20T00:00:00.000Z",
      "End": "2018-11-21T00:00:00.000Z"
    }
  }
}

For more information

The TRTH REST API Tutorial 14 and the REST API Reference tree provide information you might find useful.

Hope this helps.