If you want yyyymmdd, you could do so via Excel to your csv file and, of course, just save it when done to a different name.
Open excel Open file click on column header to highlight date column right click to get at format column custom where you define as yyyymmdd or whatever you want (I would have to use custom as date for me does not have yyyymmdd option) then file, save as, another name. ... --- In [email protected], "spikejones65" <spikejone...@...> wrote: > > Unfortunately thats the way the data file comes. Can you recommend a way to > reformat it? > > > --- In [email protected], "tf28373" <tomfid@> wrote: > > > > I think that you should firstly change date format to the following: > > rrrrmmdd so as you'd have 20091109 and time format: hhmmss to obtain > > 145000. Afterwards in Amibroker you choose file/import wizard and click > > pick files indicating files with your .csv data. Hit "next" and define the > > type of each column. Remember about ticker if you have one in .csv fifiles. > > That's all. > > > > Tomasz > > > > > > --- In [email protected], "spikejones65" <spikejones65@> wrote: > > > > > > I have a CSV file with 5 minute intra day data. The date is formated > > > "9/11/2009 2:50:00 PM". Is there a way to convent the date during > > > import to a format AB supports? If not does anyone have a sugestion on > > > how to reformat the date? I am a new AmiBroker user just learning to > > > program. Any advice would be appreciated. > > > > > > Thanks in advance, > > > > > > Spike > > > > > >
