question

Upvotes
Accepted
anil_jaipur avatar image
1 ●1 ●1 ●3

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.

eikoneikon-com-apicorporate-events
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.

Zhenya Kovalyov avatar image Zhenya Kovalyov

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!

zoya faberov avatar image zoya faberov

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

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @anil_jaipur

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? 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

Jirapongse avatar image   Jirapongse

@anil_jaipur

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
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

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