Corporate Actions Fetching from RDATA based on Ex Date filter.

We want to pull Corporate Actions from RDATA based on Ex Date

We are using code

MyRData = MyDex2Mgr.CreateRData(MyDex2Cookie);
MyRData.RequestParam = = "DT:ED " + fromDate.ToString("ddMMMyy") + ";" + toDate.ToString("ddMMMyy") + " CURR:USD";
MyRData.DisplayParam = "RH:In;D";

We are getting data by above code but filtered on the basis of Pay date While we wnat it on the basis of Ex Date of Corporate Action.

While in Excel we are getting data by filtered data on the basis of tag Ex date by DT:ED.

=RData(B5:B6 , F3:M3 ,+"DT:ED D:"&+F1&";"&+H1,,"RH:In;Dt;Ped CH:Fd",C4)

Please suggest.

Best Answer

  • @anil_jaipur it looks like you are missing a 'D:' parameter before the date in your RequestParam string:

    MyRData.RequestParam = = "DT:ED D:" + fromDate.ToString("ddMMMyy") + ";" + toDate.ToString("ddMMMyy") + " CURR:USD";

Answers

  • Hi.

    Could you please provide more details:

    1. sample of the list of instruments;
    2. list of fields
    3. exact values of all params

    Thanks!

  • Hello @anil_jaipur,

    In order for us to help, we'd like to better understand your question. Please provide the details, as suggested by Zhenya Kovalyov.

    Thanks,

    -AHS