For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
dilan.cse avatar image
3 ●1 ●3 ●2

What is the logic for generating the RIC from the description for exchange OPR?

I'm using DSS API for searching option symbols for OPR exchange.

I'm getting results such as

{

"Identifier": "SPXx182015000.U",

"IdentifierType": "Ric",

"Source": "OPQ",

"Key": "VjF8MHgwMDEwMGIwMDFhYWM1MjY4fDB4MDAxMDBiMDAxNjhlZTk4ZnxPUFF8RFZRVXxERVJWfE9QVHxEfHxTUFh4MTgyMDE1MDAwLlV8NzE1NA",

"Description": "SPX Dec0 1500.0P",

"InstrumentType": "DerivativeQuote",

"Status": "Valid",

"ExchangeCode": "OPQ",

"CurrencyCode": "USD",

"FuturesAndOptionsType": "Options",

"PutCallCode": "Put",

"ExpirationDate": "2020-12-18T00:00:00.000Z",

"StrikePrice": 1500,

"AssetStatus": "Active"

}


{

"Identifier": "FISVM152111000.U",

"IdentifierType": "Ric",

"Source": "OPQ",

"Key": "VjF8MHgwMDEwMGIwMDFkMWY2YTU4fDB4MDAxMDBiMDAxZDFmM2ZkYnxPUFF8RFZRVXxERVJWfE9QVHxEfHxGSVNWTTE1MjExMTAwMC5VfDcxNDY",

"Description": "FISV Jan1 110.0P",

"InstrumentType": "DerivativeQuote",

"Status": "Valid",

"ExchangeCode": "OPQ",

"CurrencyCode": "USD",

"FuturesAndOptionsType": "Options",

"PutCallCode": "Put",

"ExpirationDate": "2021-01-15T00:00:00.000Z",

"StrikePrice": 110,

"AssetStatus": "Active"

}



I want to get a generic logic so that i can get the RIC from the "Description" of the above result.

Is there any such logic?



dss-rest-apidatascope-selectdss
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
veerapath.rungruengrayubkul avatar image
11.3k ●26 ●9 ●14

Hi @dilan.cse,

Do you mean the logic to construct the Options RIC?

You can refer to the <RULES7> RIC as follows.

List of Month Codes


1594349722970.png (102.0 KiB)
1594349803280.png (70.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dilan.cse avatar image dilan.cse

Hi @veerapath.rungruengrayubkul,

Thanks.

What will happen if the strike price is higher than 4 digits. For example 11000 or 100,000? Then how can we incorporate this to RIC?

veerapath.rungruengrayubkul avatar image veerapath.rungruengrayubkul dilan.cse

Hi @dilan.cse,

I have found the following information related to your questions.

For Strike Price > 0 to < 1000 – 3 Characters for Integer Part of the Strike and 2 Characters for Decimal Portion of the Strike
For Strike Price >= 1000 to < 10000 – 4 Characters for Integer Part of the Strike and 1 Character for Decimal Portion of the Strike
For Strike Price >= 10000 to < 100000 – First Character of the Strike Portion would be an Alphabet “A” to “I” followed by the last four characters of the Strike Price (excluding the decimals if any).
Alphabet “A” will be used For Strikes >= 10000 and < 20000
Alphabet “B” will be used For Strikes >= 20000 and < 30000
Alphabet “C” will be used for Strikes >= 30000 and < 40000
.
.
Alphabet “I” will be used for Strikes >= 90000 and < 100000

Also, we have added the 10000 stirke on the database: NDXl1721A0000.U

Anyway, as I'm not content expert, please contact Content support to confirm this information via MyRefinitiv.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.