Recreating Rhistory query using Elektron in the Cloud

mark.patterson
mark.patterson Newcomer
in Elektron

Hi there,

We currently have a number of spreadsheets used by dealing teams running FXT terminals that call out Rhistory functions such as the following:

=RHistory("GBPJMD=R;GBPJOD=R;GBPJPY=R;GBPKES=R;GBPKRW=R;GBPKWD=R;GBPKYD=R;GBPLBP=R;GBPMUR=R;GBPMXN=R;GBPMYR=R;GBPNOK=R;GBPNZD=R;GBPOMR=R;GBPPEN=R;GBPPGK=R;GBPPHP=R;GBPPLN=R;GBPQAR=R;GBPRUB=R;GBPSAR=R;GBPSEK=R;GBPSGD=R","BID.Timestamp;BID.Low","START:07:31 END:07:42 TIMEZONE:LON INTERVAL:1M",,"CH:In;Fd TSREPEAT:NO" )

We are looking to bring these functions into our hosted application with an Elektron in the cloud service. Is there a way to replicate the Rhistory function via Elektron in the cloud to return a response as a set of data that we can then work with?

Kind regards,

Mark

Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    Hello @mark.patterson,

    Elektron in the cloud, or Elektron RealTime in the Cloud is Elektron Websocket API enabled connectivity option. I.e. the app is connecting via Elektron Websocket:

    Elektron Websocket API

    Therefore, will not be able to connect via RHistory, will need to re-implement the content retrieval to utilize websockets.

Answers

  • zoya faberov
    zoya faberov ✭✭✭✭✭

    Hello @mark.patterson,

    This may also be a good time to discuss the new requirements with your Refinitiv account team.

    With the deeper understanding of the requirements and the available resources, seeing the bigger picture, they may be able to suggest a better approach.

  • mark.patterson
    mark.patterson Newcomer

    Hi Zoya,

    Thanks for the feedback, I have been in touch with our account team to discuss potential options.

Categories