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

Proper start date for stock split queries in C#

I asked a question here which was partially answered:


https://community.developers.refinitiv.com/questions/103066/some-corporate-event-fields-are-empty-when-using-t.html


It appears that the start date must be some time in the past, but we're not exactly sure how far back we must go or why.


Can you please investigate your server side code and explain what they starting date must be and why.


Thank you.

eikon#technology#contentc#
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
Accepted
10.1k 18 6 9

@jiah So again let me try in Python first - so for this event the announcement date falls in between the SDate/EDate parameters.

events_df = rd.get_data('IVOG.K',['TR.TickerSymbol','TR.AdjmtFactorAdjustmentDate','TR.AdjmtFactorAdjustmentFactor','TR.AdjmtFactorIsApplied','TR.CACorpActEventType','TR.CACorpActEventType.coraxcaanndate'],{'SDate':'2023-02-01', 'EDate':'2024-12-31'}) 

events_df

1678809649471.png

However - if I try this:

events_df = rd.get_data('IVOG.K',['TR.TickerSymbol','TR.AdjmtFactorAdjustmentDate','TR.AdjmtFactorAdjustmentFactor','TR.AdjmtFactorIsApplied','TR.CACorpActEventType','TR.CACorpActEventType.coraxcaanndate'],{'SDate':'2023-03-14', 'EDate':'2024-12-31'})
 
events_df

1678809978124.png

Here I get the event but I don't get the Corporate Change Event Type or the coraxcaanndate. Is this sort of what you mean?


1678809649471.png (75.5 KiB)
1678809978124.png (82.1 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.

Upvotes
23 0 0 3

Yes, great example. Just by changing the start date, various fields go empty. I'm trying to find why that is (perhaps a bug?), and what the proper start date should be.


I think the value will be missing even if you back off the date by 5 or 10 days.

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

Following back up on this. Can you tell me how many days I need to go back to properly get the events information? Thanks.

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
78.1k 246 52 72

@jiah

Each event (TR.CACorpActEventType) has an announcement date (TR.CACorpActEventType.coraxcaanndate).

For example, if you would like to get an event that was announced on 23 Feb 2023, the SDate must be before 23 Feb 2023 and the EDate must be after 23 Feb 2023. For example, SDate is 01 Feb 2023 and EDate is 01 Mar 2023. Then you will get events announced between 01 Feb 2023 and 01 Mar 2023.


1679365110375.png



1679365110375.png (9.0 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.

Upvotes
23 0 0 3

Ok, so it's measured off of the announcement date. You can close this ticket now. Thank you.

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.