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

Re: [EquisMetaStock Group] Re: Merging ASCII data files



PureBytes Links

Trading Reference Links

Hi Pandan
 
I thing you and me are in the same boat. I face lots of problem, sorted out some, but still have some.
 
 
Sherene
KL
----- Original Message -----
From: panda
Sent: Monday, March 21, 2005 8:24 PM
Subject: Re: [EquisMetaStock Group] Re: Merging ASCII data files


Thank you Jose for early reply.  (I think I can still trust my local data
provider except for its world indices which it obtained from Yahoo I
presume).

Looks like the batch file will merge the original ASCII text files and copy
rpsort.com into zownload directory.  Then it calls rpsort.com to sort the
merged text file and put the results in another file, finally it deletes the
2 working files and renames the end-results file.

For each zipped EODs I have, it contained 25 smaller files.  So, now I could
copy
them all to a single mega-file for each year and update them daily like I
update the MS database.  Hmmm ...   :)

By the way, what are the switch >nul (other like /A, /B, \V can be found at
the DOS prompt help but not this) and the @ at ' @echo off '?
Purpose for copying rpsort.com to zownload directory instead of putting it
in directory beforehand?

Hee Hee

Best regards,
ckng

P/S Just try it.  Great!

But on further testing ... need to delete the header lines accumulated
manually(<TICKER>,<PER>,<DTYYYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPEN
INT>) and some which attached to end of some lines 'cause the file from
which it comes from do not have a carriage return at end.
The copy command in batch file, cannot append new files to old ones... to
facilitate further rounds of sorting.

(For Info Purposes: for directory name of more than 1 word, try xxxxx~1 as
name, since program
run in DOS - eg. C:\My Documents becomes C:\MyDocu~1)

----- Original Message -----
From: "Jose" <josesilva22@xxxxxxxxx>
To: <equismetastock@xxxxxxxxxxxxxxx>
Sent: Monday, March 21, 2005 1:10 AM
Subject: [EquisMetaStock Group] Re: Merging ASCII data files


>
>
> 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 Links
>
>
>
>
>
>
>






Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links