|
PureBytes Links
Trading Reference Links
|
Panda, it really comes down to what is more important to you: time or
$.
Personally I would avoid free EOD data like the plague, and get some
decent headache-free data such as http://www.premiumdata.net
However, if you must sort & archive all that Yahoo EOD data, try
something like this batch file:
---8<--------------------------
rem merges & sorts all *.txt into "update.txt", needs rpsort.com
cls
copy /A *.txt c:\zownload\update.txt /V
@echo off
copy /B rpsort.com c:\zownload\*.* /Y /V >nul
echo.
echo sorting update.txt mega-file...
echo.
c:\zownload\rpsort.com /q c:\zownload\update.txt >c:\zownload\update1.
srt
del c:\zownload\rpsort.com >nul
del c:\zownload\update.txt >nul
rename c:\zownload\update1.srt update.txt >nul
echo.
echo ... done!
echo.
---8<--------------------------
You can find RPSort.com if you do a search on Google.
jose '-)
http://www.metastocktools.com
--- In equismetastock@xxxxxxxxxxxxxxx, "panda" <ckng001@xxxx> wrote:
>
> 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 --------------------~-->
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/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/
|