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

Some corporate event fields are empty when using the C# API

I am using the C# Eikon Data API to find events in the future on which a company is expected to split. This is working for some fields, however other fields are always blank. Specifically, any field that shows what type the event is, is always blank. In the simple query example below, the first four fields are returned with valid values in them, however the last field, TR.CACorpActEventType, is always empty. I need to know how to cause Eikon to properly return a value in that field. For reference, when I look at the field in the Data Item Browser, it shows “Share Split”, so I know the value exists, but it's not being returned to me.


Also, if I may add a second question: What would be the proper value for the "Frq" argument to pass when querying for corporate events?


Thank you.

var args = new Dictionary<string, string>
{
      { "SDate", "2023-03-08" },
      { "EDate", "2024-12-31" },
      { "Frq", "Q" }
};


var json = eikon.GetDataRaw(
    "IVOG.K,IVOO.K",
    new List<string>
    {
        "TR.TickerSymbol",
        "TR.AdjmtFactorAdjustmentDate",
        "TR.AdjmtFactorAdjustmentFactor",
        "TR.AdjmtFactorIsApplied",
        "TR.CACorpActEventType"
    },
    args);


eikon-data-api#technologyc#
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
78.2k 246 52 72

@jiah

Thanks for reaching out to us.

If I change the SDate to "2023-01-01", the "TR.CACorpActEventType" returns a value.

var args = new Dictionary<string, string>
{
      { "SDate", "2023-01-01" },
      { "EDate", "2024-12-31" }
};
 
List<string> RICs = new List<string> {"IVOG.K,IVOO.K" };
var df = eikon.GetData(
    RICs,
    new List<string>
    {
        "TR.TickerSymbol",
        "TR.AdjmtFactorAdjustmentDate",
        "TR.AdjmtFactorAdjustmentFactor",
        "TR.AdjmtFactorIsApplied",
        "TR.CACorpActEventType",
        "TR.CACorpActEventType.coraxcaanndate"
    },
    args);
df

The output is:

1678329577922.png

You can use the Data Item Browser to search for available fields and parameters.

1678329698782.png


I hope that this information is of help.


1678329577922.png (58.0 KiB)
1678329698782.png (43.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.

Upvotes
23 0 0 3

Thanks, that does work. But it sounds more like a bug. I did some additional testing, and I found that you must go at least 14 days in the past. So this will also work:

var sdate = DateTime.Now.AddDays(-14);

However anything less, like this, will not:

var sdate = DateTime.Now.AddDays(-13);

I would like to know *why* this is. Is there a valid reason? Or is it a bug?


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.

I think the date of this event is 23 Feb 2023 so the date range should cover this date.

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.