question

Upvotes
Accepted
3 0 1 2

RHistory API time series for Bid & Ask

Hello,

is there a possibility to retrieve time series for bid & ask prices in RHistory API? In particular, I am interested in CFI2Zc1 historical bid/ask at a specific time.

Thanks.

eikoneikon-com-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.

1 Answer

· Write an Answer
Upvotes
Accepted
39.4k 77 11 27

It's perfectly possible. Set FieldList property of RHistoryAPI.RHistoryQuery object to "TRDPRC_1.Bid;TRDPRC_1.Ask" and RequestParams property of the same object to "INTERVAL:TAQ END:YYYY-MM-DD:HH:MM NBROWS:1", where YYYY-MM-DD:HH:MM is the date and time for which you need the quotes in the specified format.
For data retrieval modeling I suggest you use Formula Builder wizard to create an instance of RHistory worksheet function. And then you can copy & paste the field names and parameters into your VBA code using RHistory 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.

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.