Very Simple - Save your file as .csv rather than excel.
Then to to AmiBroker>File>Import Wizard and follow the steps. Suggest flipping the Ticker and Date columns so Ticker is first - and be sure that you pick the correct date format - and check the box to ignore 1 row so it doesn't try to load the headers as a quote. At most a few minutes. Good luck. Mike --- In amibroker@yahoogroups.com, "ford7k" <for...@...> wrote: > > > Hi Experts > > A friend sent me a eod data file in excel for optionscall s. > It has date ticker o h l c volume etc columns > > This is end of day data. > Is there any utility to help read this data into amibroker? > > My friend told me > first I have to create a new database. > with time setting of end of day > then he says the excel file has to be given a short name and > it can be linked to amibroker. > > please help. > > many cilly doubts come to mind > like > > what format amibroker reads? I think it is ASCII > How can we link excel file to amibroker. > > thanks for time and effort > regards > ford >