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

dilan.cse
dilan.cse Newcomer
in DSS

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?



Tagged:

Best Answer

Answers

  • dilan.cse
    dilan.cse Newcomer
    https://community.developers.refinitiv.com/discussion/comment/62939#Comment_62939

    Hi @veerapath.rungruengrayubkulveerapath.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
    veerapath.rungruengrayubkul LSEG
    https://community.developers.refinitiv.com/discussion/comment/62972#Comment_62972

    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.

Categories