question

Upvotes
Accepted
20 0 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

eikoneikon-com-apiapi
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
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 5.0 MiB each and 10.0 MiB total.

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

no problem!

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

Click below to post an Idea Post Idea