For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
dmdeclercq avatar image
1 ●0 ●0 ●1

recreate Rhistory function through VBA

I managed to get the Eikon VBA API up and running with the following parameters (from the example file) :

Instrument GB0008754136

Fields TRDPRC_1.TIMESTAMP;TRDPRC_1.VALUE;TRDPRC_1.VOLUME

Request Mode NBROWS:25 INTERVAL:TICK CODE:MULTI

RefreshParams FRQ:5S

DisplayParams SORT:D CH:Fd


Now I would like to recreate the following Rhistoryfunction according to that parameter layout : =RHistory("TRGBNBPD1";".Timestamp;.Close";"START:41275 END:43789 INTERVAL:1D";;"SORT:ASC TSREPEAT:NO CH:Fd";G12) . How do I convert it from that history function to the necessary parameters to utilize in the VBA API?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-com-api
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
Jirapongse avatar image
38.1k ●69 ●35 ●53

@dmdeclercq

The following is the syntax of the RHistory function:

=RHistory("Instruments","[Fields]","Request","[Refresh]","[Display]",[Destination Cell])


I think you can apply it to the parameters of the RHistory VBA API.

For more information regarding the RHistory VBA API, please refer to Tutorial 9 - Time Series History - RHistoryAPI.

icon clock
10 |1500

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

Click below to post an Idea Post Idea