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

[EquisMetaStock Group] Merging ASCII data files



PureBytes Links

Trading Reference Links


Hi all,

I have a rare occasion where my database for one particular stocks contained
an unusual spike on one of its bar.  Upon re-updating, the spike
disappeared.  Moreover, some of my raw EOD data files contained errors which
I manually corrected (errors occurred in world indices where it's not as
critical - free EODs, so what do you expect!).  For these two reasons, I am
now keeping all my EOD files that I used to update my MS database daily,
just in case.

So as each trading days go by, the no. of EOD files grows bigger and bigger.
So now I am looking at merging all these EOD files by the year (2004, 2005,
etc.) before zipping them.  Moreover, I would like to sort the data
according to stocks (instead of dates in the original ASCII files) in the
merging process. All this will simplify and quicken the updating process
with downloader if ever I need to re-update.  So, anybody got an efficient
way of going about this?  The right merging&sorting software, etc ... (Each
EOD file consists of 25 ACII text files).  (Excel could sort data but saving
them back into ASCII files as per original format (with commas) will be a
problem, opening each individual files for each EOD and copy&paste will be
cumbersome, saving the MS database will not do as some of the stocks which I
seldom look into may contained errors).

Thank you for your time in reading and answering my message.

Best regards,
ckng






------------------------ Yahoo! Groups Sponsor --------------------~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

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