Hi Friends,
i need help to export data to excel sheet but as per our "EXPIRY DATE".I am having one formula but it gives monthly open, high, low, close as per CALENDAR.I Need "EXPIRY DATE WISE" like if we want monthly data than open ,high, low ,close should be as per "EXPIRY DATE"....i am attaching that formula kindly do the needful .....:thumb:
_SECTION_BEGIN("export to excel");
Filter=1;
AddColumn(O,"Open");
AddColumn(H,"High");
AddColumn(L,"Low");
AddColumn(C,"Close");
AddColumn(V,"Volume",1.0);
AddColumn(OI,"Open Interest",1.0);
_SECTION_END();
i need help to export data to excel sheet but as per our "EXPIRY DATE".I am having one formula but it gives monthly open, high, low, close as per CALENDAR.I Need "EXPIRY DATE WISE" like if we want monthly data than open ,high, low ,close should be as per "EXPIRY DATE"....i am attaching that formula kindly do the needful .....:thumb:
_SECTION_BEGIN("export to excel");
Filter=1;
AddColumn(O,"Open");
AddColumn(H,"High");
AddColumn(L,"Low");
AddColumn(C,"Close");
AddColumn(V,"Volume",1.0);
AddColumn(OI,"Open Interest",1.0);
_SECTION_END();