For a deeper look into our Elektron API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

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 512.0 KiB each and 1.0 MiB total.

3 Answers

· Write an Answer
Upvotes
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

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 512.0 KiB each and 1.0 MiB total.

Upvotes
zoya faberov avatar image
32.2k ●40 ●11 ●20

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 512.0 KiB each and 1.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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.