question

Upvotes
Accepted
mark.patterson avatar image
3 ●0 ●0 ●2

Recreating Rhistory query using Elektron in the Cloud

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

elektronrefinitiv-realtimeelektron-sdk
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.

3 Answers

Upvotes
Accepted
zoya faberov avatar image
23k ●22 ●9 ●14

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.

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.

Upvotes
zoya faberov avatar image
23k ●22 ●9 ●14

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.

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.

Upvotes
mark.patterson avatar image
3 ●0 ●0 ●2

Hi Zoya,

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

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.

Click below to post an Idea Post Idea