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)