Excel API: formula builder - retreive data from local server

daniel.schmitt2

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

Zhenya Kovalyov

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?

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

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

no problem!