question

Upvotes
Accepted
5 0 0 1

先物の原資産コード(Alias Underlying RIC)の取得

Tickデータ(Tick History Time and Sales)やIntraデータ(Tick History Intraday Summaries)では先物の[Alias Underlying RIC]の取得が可能ですが、他に[Alias Underlying RIC]とExipiration Dateなどが取得できるAPIは存在しないでしょうか?

可能であればRICコード&[Alias Underlying RIC]&Expiration Dateがメタ情報として取得できる方法が知りたいです。


#producttick-history-rest-api
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.

Hi @shiro.chiba ,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thank you,

AHS

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thank you,

AHS

Upvotes
Accepted
79.2k 251 52 74

@shiro.chiba

Thank you for reaching out to us.

Please let us know the report template that you are using.

Otherwise, you can refer to the Data Dictionary - Refinitiv Tick History Custom Reporting document that lists all avaiable fields in each report template.

For example, the TermsAndConditionsExtractionRequest extraction request supports the "Underlying RIC" field

{
                
    "ExtractionRequest": {
                
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
            "RIC",
            "Expiration Date",
            "Strike Price",
            "Underlying RIC"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "JNI625X6.OS",
                    "IdentifierType": "Ric"
                },
                {
                
                    "Identifier": "JNI050X4.OS",
                    "IdentifierType": "Ric"
                }
            ],
            "ValidationOptions": {
                "AllowHistoricalInstruments": true
            }
        }
    }
}
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.

Upvotes
5 0 0 1

@Jirapongse

ありがとうございます。

上記の方法でUnderlying Code/Exipiration Date/Last Trading DayなどのFieldをリクエストしました。先物の満期日としてはLast Trading Dayがそれに該当することが確認できました。

ただし、原資産コード(Underlying Code)については、想定していたものが取得できませんでした。(以下に取得結果を添付しました。)

想定していた原資産コードとしては、ESc1の場合ですと、例えば現時点ではESZ3などがそれにあたります。このような原資産コードと満期日のリストを取得する方法は他にございますでしょうか?

1699513910776.png



1699513910776.png (4.9 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.

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.