|
Hello,
Change date format in CSV file to
dd/mm/yyyy format. Should work ok. If you have date format like, 24-December, or
other Excel Date formats, it will give a Error.
For further confirmation,
Open the spliced file (New file) in
any Text Editor. If there are any other characters than what should be present,
it will show the same. You can delete that and save.
Cheers
Prashanth
----- Original Message -----
Sent: Sunday, July 10, 2005 11:09
PM
Subject: [amibroker] Re: Files not
compatible?
I'll try that, but just out of curiousity - how would you
do it in
Excel? I actually used to tutor an Excel class part-time in
college,
so I am pretty familiar with it. I never did have to convert to
different file types though.
Thanks,
Jacques
--- In
amibroker@xxxxxxxxxxxxxxx,
"dingo" <dingo@x...> wrote:
> use a
text editor to cut and paste since you aren't that familiar
with
the
> workings of Excel.
>
> d
>
>
> _____
>
> From:
amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx]
On
Behalf
> Of jacquesmmathieu
> Sent: Sunday, July 10, 2005 1:24
PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Files
not compatible?
>
>
> I've been trying to find a way to
splice csv files together so
that I
> can splice futures contracts
together. I want to create a
continuous
> contract file, but I can
get free data from brite futures. I just
have
> to be able to
splice it. What I've been doing is importing data to
> Amibroker,
exporting the files to a csv format, and then cutting
and
>
pasting. Or trying to. It seems that every time I modify a file in
>
Excel I can't use the data in Amibroker anymore. I get a weird
prompt
> like this:
>
> CN05.csv may contain features that are
not compatible with CSV
(comma
> delimited). Do you want to keep
the workbook in this format?
>
> If I click yes then I can't use
the file to import anymore - when
I
> use the wizard I get an error
in the date format. If I click no it
> gives me the option to change
the file to a .xls and then I can't
use
> it either. Is there a way
around this? Why doesn't it just save it
in
> the same format? I
knew there was a reason I became a biologist.
>
> Jacques
>
>
>
>
> Please note that this group is for
discussion between users only.
>
> To get support from AmiBroker
please send an e-mail directly to
> SUPPORT {at} amibroker.com
>
> For other support material please check also:
> http://www.amibroker.com/support.html
>
>
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit
your group "amibroker
> <http://groups.yahoo.com/group/amibroker>
" on the web.
>
>
>
* To unsubscribe from this group, send an email
to:
> amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
<mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
>
>
> * Your
use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
>
<http://docs.yahoo.com/info/terms/>
.
>
>
>
_____
Please note that this group is for
discussion between users only.
To get support from AmiBroker please
send an e-mail directly to
SUPPORT {at} amibroker.com
For other
support material please check also:
http://www.amibroker.com/support.html
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
YAHOO! GROUPS LINKS
|