[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Files not compatible?



PureBytes Links

Trading Reference Links

Thank you Geo and Prashanth. I'll try that as soon as I get back. 
The swells from Hurricane Dennis are hitting so it's time to go 
surf! Thanks guys.

Jacques

--- In amibroker@xxxxxxxxxxxxxxx, "Prashanth" <prash454@xxxx> wrote:
> 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 ----- 
>   From: jacquesmmathieu 
>   To: amibroker@xxxxxxxxxxxxxxx 
>   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@xxxx> 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
> 
> 
> 
> 
> 
> -------------------------------------------------------------------
-----------
>   YAHOO! GROUPS LINKS 
> 
>     a..  Visit your group "amibroker" on the web.
>       
>     b..  To unsubscribe from this group, send an email to:
>      amibroker-unsubscribe@xxxxxxxxxxxxxxx
>       
>     c..  Your use of Yahoo! Groups is subject to the Yahoo! Terms 
of Service. 
> 
> 
> -------------------------------------------------------------------
-----------




------------------------ Yahoo! Groups Sponsor --------------------~--> 
Try Online Currency Trading with GFT. Free 50K Demo. Trade 
24 Hours. Commission-Free. 
http://us.click.yahoo.com/DldnlA/9M2KAA/U1CZAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> 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/