How to export data into excel from amibroker "expiry datewise"

rocky01

Active Member
#1
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();
 

Similar threads