question

Upvotes
Accepted
daniel.schmitt2 avatar image
20 ●1 ●0 ●1

Excel API: formula builder - retreive data from local server

Is it possible to specify the Server from which to retreive the data explicitly in the excel API / formula builder? I.e. I want to request a time series history from a (local) server different from IDN_selectfeed.
I could not find anything in the documentation / questions on this board.

Customer support directed me to this board. Thank you v much

eikonapieikon-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

Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

Try RTFEED:<your_feed_name> in the RHistory Request param, something along the lines of 

=RHistory("AAPL.O",".Timestamp;.Close","RTFEED:TEST INTERVAL:1D",,"TSREPEAT:NO CH:Fd")

Which Time series API for Excel are you using?

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.

daniel.schmitt2 avatar image daniel.schmitt2

Thank you very much for your answer. Indeed the approach led me to the solution: There is no history set up on the server under consideration. Ergo I find invalid soruce.
Thanks

Zhenya Kovalyov avatar image Zhenya Kovalyov daniel.schmitt2

no problem!

Zhenya Kovalyov avatar image Zhenya Kovalyov

For the RHistory API the process is similar:

 With myRHistoryQuery
        .InstrumentIDList = "AAPL.O"
        .FieldList = "TRDPRC_1.TIMESTAMP;TRDPRC_1.VALUE;TRDPRC_1.VOLUME"
        .RequestParams = "RTFEED:your_feed_name NBROWS:25 INTERVAL:TICK"
        .RefreshParams = "FRQ:5S"
        .DisplayParams = "SORT:D"
    
        .Subscribe
    End With

more info is in the RHistory API tutorial