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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 2 1 4

Calling reference OAS in python API

I'm trying to recreate the following excel api call in python: RHistory(FEED!J1,"ROAS.Timestamp;ROAS.Value","NBROWS:1000 INTERVAL:1D",,"SORT:DESC",J4)

My issue is I'm not sure how to specify that I want the ROAS returned in python, not the index level.

Consider the following code snippet: (line1) EndDate = datetime.now() (line2) StartDate = EndDate - timedelta(days=1000) (line3)MERHWC0_data = ek.get_timeseries([".MERHWC0"], start_date=StartDate, end_date=EndDate) line 3 only returns the close field for .MERHWC0.Is ROAS supported by the python API?

eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikon
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.

1 Answer

Upvotes
Accepted
39.3k 76 11 27

At the moment get_timeseries method can only retrieve a subset of timeseries data available through RHistory function in Eikon Excel. There's no way to specify a timeseries view such as ROAS. Only timeseries that belong to the default view for the instrument can be retrieved using get_timeseries method.
The only two APIs currently available through Eikon that provide the capability to retrieve the data you're after are RHistory COM library, which can only be used in Excel VBA, and Eikon .NET API.

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.