|
PureBytes Links
Trading Reference Links
|
<SPAN
class=439035815-20062003>Jim,
How
about simply creating an excel macro?
Regards,
Jayson
<FONT face=Tahoma
size=2>-----Original Message-----From: jnk1997
[mailto:jnk1997@xxxxxxxxx]Sent: Friday, June 20, 2003 11:56
AMTo: amibroker@xxxxxxxxxxxxxxxSubject: [amibroker] TJ -
export data to ASCII csv format ProblemI 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.00IDTI,01/03/2001,30.00,38.00,29.88,37.98,5280600.00IDTI,01/04/2001,37.31,43.81,37.06,42.81,6443000.00When
I delete the first
lineTicker,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.JimSend
BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
ADVERTISEMENT
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 the Yahoo! Terms of Service.
|