I have excel file [.xlsx] which contain sensex EOD of 2 years. It has 5 columns with Date,Close,Open,High,Low,Volume. I want to open it in amibroker such that it show candle stick chart from that data. How is it possible?
Please follow below steps to import data into AmiBroker
1. File > Import Wizard
2. Pick Files and add all the files of EOD which you have
3. You will get optional fields where you can choose which fields exist in the file
Choose from the dropdown and enter the fields and click next which shall import data into mibroker
(Authorized vendor of NSE supporting realtime datafeeds to Amibroker, Metastock and Ninjatrader)