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

[amibroker] Re: TJ - export data to ASCII csv format Problem



PureBytes Links

Trading Reference Links

Jim,

There are many ways to do this.  You need to be more specific.  Do 
you want to export current symbol, all symbols in the current 
databases.  I have written a script, with a click of a button you can 
export the current symbol to your format.  Email me and I will send 
you the script.

--- In amibroker@xxxxxxxxxxxxxxx, "jnk1997" <jnk1997@xxxx> wrote:
> I tried using the following exploration to export Amibroker data 
> to .csv format so that another program can read the file.
> 
> //Exploration to export data to ASCII csv format so other programs 
> can read data.
> 
> Filter = 1;
> AddColumn(Open,"Open");
> AddColumn(High,"High");
> AddColumn(Low,"Low");
> AddColumn(Close,"Close");
> AddColumn(Volume,"Volume");
> 
> The resulting exported file (idti.csv) looks like this:
> 
> Ticker,Date/Time,Open,High,Low,Close,Volume,
> IDTI,01/02/2001,32.50,34.38,30.50,30.88,2239000.00
> IDTI,01/03/2001,30.00,38.00,29.88,37.98,5280600.00
> IDTI,01/04/2001,37.31,43.81,37.06,42.81,6443000.00
> 
> 
> When I delete the first line
> Ticker,Date/Time,Open,High,Low,Close,Volume,
> 
> And delete the ticker and comma (IDTI,) in front of each line the 
> file works, the other program can read the file.
> 
> Question:
> How can I set up the exploration to export the data without the 
> heading (the first line) and ticker symbol on each line?
> 
> Thanks in advance for your help.
> Jim


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/ySSFAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/