Can anyone please outline the steps to export MCX Bhavcopy data downloded in .csv format to excel sheet, please also mention if it's better to download it commodity wise or date wise.
Thanks for your valuable time.
use the import wizard, select the file and then the headers, select only OHLC and V and skip the other columns, select "," as the seperator and import. you can either do it datewise or commodity wise as per your wish