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