Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
2 0 1 3

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.

@vbala

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

1 Answer

· Write an Answer
Upvotes
Accepted
79.2k 251 52 74

@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.

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.