recreate Rhistory function through VBA

dmdeclercq

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?

Jirapongse

@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.