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

[amibroker] ASCII import, from two files, relational database like



PureBytes Links

Trading Reference Links


I have two  files as shown here. I have to merge them.
Cumbersome  to edit and paste in excel, as several tickers in a day.
any idea.

rgds


file1.csv
Ticker	Date/Time	open	high	low	close	volume
ACC	2/7/2005	373.1	376.95	366.2	368.1	9544
ACC	2/8/2005	367.9	375.65	365	371.7	9259
ACC	2/9/2005	372.55	378.45	371.15	377	6882
ACC	2/10/2005	378.5	386.3	377.55	381.85	11614

file2.csv
Ticker	Date/Time	oi
ACC	2/7/2005	6511500
ACC	2/8/2005	6687000
ACC	2/9/2005	7029000
ACC	2/10/2005	7456500

desired file
Ticker	Date/Time	open	high	low	close	volume	oi
ACC	2/7/2005	373.1	376.95	366.2	368.1	9544
	6511500
ACC	2/8/2005	367.9	375.65	365	371.7	9259
	6687000
ACC	2/9/2005	372.55	378.45	371.15	377	6882
	7029000
ACC	2/10/2005	378.5	386.3	377.55	381.85	11614
	7456500







------------------------ Yahoo! Groups Sponsor --------------------~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.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/