[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
 [amibroker] Re: ASCII import, from two  files, relational database like
 
 
| 
 PureBytes Links 
Trading Reference Links 
 | 
I feel your pain. Had a similar issue and after hours wasted 
combining different flags like $HYBRID (which simply doesn't do as 
the manual says) finally decided to write a macro to combine the 
files. Wish I had done that immediately.
-treliff
--- In amibroker@xxxxxxxxxxxxxxx, "mrmurty" <mrmurty@xxxx> wrote:
> 
> 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 --------------------~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/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/
 
 |   
 
 | 
 |   
 
 |