For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 0 2

How to get hourly bid high and bid low data through C#?

Hi all,

I would like to get bid high and bid low hourly data, and the Excel formula as follows.

=RHistory("AUD=","BID.Timestamp;BID.High;BID.Low","START:2019-06-25 INTERVAL:60M","FRQ:1H","TSREPEAT:NO CH:In;Fd")

I used GetTimeSeries to get the data, but the TimeSeriesField in EikonDataAPI only has HIGH and LOW parameters. How could I retrieve the same results through API?

Thanks for helping.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonc#
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
Accepted
18k 21 12 20

Hi @hsiuling.kao

I think you are using .NET API.

Please refer to the document at this URL.

You can modify the sample code and retrieve the data accordingly.


ahs.png (311.8 KiB)
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
3 0 0 2

Hi @chavalit.jintamalit,

I use this API, it looks similar but I can't use GetTimeSeries function to get bid high and bid low data, my code is as below. Can I use this one or I should change API?

Thanks for helping!


rt.png (9.8 KiB)
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
39.2k 75 11 27

@hsiuling.kao
Using GetTimeSeries method of open source .NET edition of Eikon Data APIs you are indeed retrieving the bid high and low for spot FX RICs. At the moment Eikon Data APis can only retrieve the default timeseries view for any given RIC, which for FX spot RICs is BID.
You can compare the results you get from the =RHistory function you mentioned to the output of GetTimeSeries method of Eikon Data APIs. They should match. If however you would like to retrieve intraday ask quotes for FX RICs, this is currently not possible using Eikon Data APIs.

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
3 0 0 2

Thank you so much, I will change my API to retrieve data.

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