|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, "spikejones65" <spikejones65@xxx> wrote:
>
> Unfortunately thats the way the data file comes. Can you recommend a way to reformat it?
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "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 amibroker@xxxxxxxxxxxxxxx, "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
> > >
> >
>
------------------------------------
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:amibroker-digest@xxxxxxxxxxxxxxx
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|