How to query historical futures for a given underlying?

Question

Question by bmcelroy · Oct 05, 2017 at 01:08 AM · historical query futures

How to query historical futures for a given underlying?

I would like to query historical futures for a given underlying (HSI or KOSPI200 for example)?

I can use /Search/FuturesAndOptionsSearch, which allows an `UnderlyingRic` to search for current futures, but I can't find any documentation for an equivalent option in HistoricalSearch or HistoricalCriteriaSearch.

0 Show 1

10 |1500 characters needed characters left characters exceeded

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

bmcelroy · Oct 09, 2017 at 08:20 PM 0

Share

bumppppppp

Answer 1 · 2017-11-27T02:04:56Z

Best Answer

Answer by bmcelroy · Nov 27, 2017 at 02:04 AM

The answer was to use a combination of HistoricalChainResolution and ReferenceHistory.

A HistoricalChainResolution of '0#HSI:' yielded futures and ReferenceHistory gave me the information I required.

1 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

REFINITIV

Christiaan Meihsl ♦♦ · Nov 27, 2017 at 03:18 AM 0

Share

@bmcelroy, thank you for sharing the solution :)

Answer 2 · 2017-10-10T03:49:48Z

REFINITIV

Answer by jirapongse.phuriphanvichai · Oct 10, 2017 at 03:49 AM

Yes, you are correct. There is no UnderlyingRic option in HistoricalSearch and HistoricalCriterialSearch. Therefore, those endpoints don't support UnderlyingRic.

Please contact TRTH V2 support team via Contact Us for confirmation and solution.

0 · Share

10 |1500 characters needed characters left characters exceeded

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

How to query historical futures for a given underlying?

2 Replies

Watch this question

Related Questions