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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
2 0 0 1

Aligning data downloads by date

I want to download a 2005-todate price & volume history of a bunch of tickers. The price data (OHLC) calc date differs from the Volume data calc dates. So when the data is downloaded the dates are not aligned. Is it possible to set parameters such that the dates are aligned for the full dataset? Trying to find a generic solution, rather than requesting dates for every field and then combining the dataframes.

Here is an example.

1669196354353.png


1669196369638.png


eikon-data-apipythonrefinitiv-dataplatform-eikon#content
1669196354353.png (17.8 KiB)
1669196369638.png (70.4 KiB)
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
56.1k 145 45 65

@vbala

Sorry about the issue that you are facing.

Typically, the date will be aligned when fields are in the same category.

The TR.OPENPRICE, TR.HIGHPRICE, TR.LOWPRICE, and TR.CLOSEPRICE fields are in the Time Series Data category.

The TR.PriceClose and TR.Volume fields are in the Price and Volume category

The TR.CompanyMarketCap field is in the Time Series Ratios category.

I think this is why the date is not aligned. As I know, it doesn't have the option to align dates in different categories.

You can see a list of categories in the Data Item Browser tool (DIB).

1669255359541.png I hope that this information is of help.


1669255359541.png (75.9 KiB)
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.