|
PureBytes Links
Trading Reference Links
|
Hi Angelo
The problem is in your text file format, not the symbol's format. The
required format per the utility's readme file is:
SYMB,D,YYMMDD,O,H,L,C,V,OI.
The file must be comma deliminated e.g. your first line should be:
PGAS.JK,12/15/2003,350,350,300,310,1081952480
I guess the above answers your question "Is there any other way so
that the historical data for one simbol can be updated in that one
simbol", but if not I would guess that the MetaStock downloader is the
only way.
Regards
Stuart
--- In equismetastock@xxxxxxxxxxxxxxx, "Angelo" <angelo@xxx> wrote:
>
> Hi Stuart,
>
> Thank you for the advice. My problem is that when the ascii file
contains a simbol with historical dates it creates mess in metastock
database. For example, the text below:
>
> PGAS.JK 12/15/2003 350 350 300 310 1081952480
> PGAS.JK 12/16/2003 310 310 300 300 358462480
> PGAS.JK 12/17/2003 300 305 300 300 89955000
> PGAS.JK 12/18/2003 305 305 300 305 79497500
> PGAS.JK 12/19/2003 305 310 305 310 246537500
> PGAS.JK 12/22/2003 310 310 300 305 90657500
> PGAS.JK 12/23/2003 305 310 300 305 65215000
> PGAS.JK 12/29/2003 305 310 305 310 58637500
> PGAS.JK 12/30/2003 305 315 305 310 356640000
> PGAS.JK 1/2/2004 310 320 310 320 348500000
> PGAS.JK 1/5/2004 320 325 315 320 187942500
> PGAS.JK 1/6/2004 320 340 320 335 852422480
> PGAS.JK 1/7/2004 335 340 330 340 337615000
> PGAS.JK 1/8/2004 340 345 335 340 264387500
>
> It creates multiple new symbols; symbols and dates created as
symbols. Before we open the database, MetaStock told us that there are
some merge secuities. Is there any other way so that the historical
data for one simbol can be updated in that one simbol?
>
> Best regards,
> Angelo
>
>
> ----- Original Message -----
> From: smpretor
> To: equismetastock@xxxxxxxxxxxxxxx
> Sent: Saturday, August 09, 2008 1:54 PM
> Subject: [EquisMetaStock Group] Re: MsCmdLineUtils
>
>
> Hi Angelo
>
> Happy to be of assistance. I use the utility when I create synthetic
> data files or for the odd Yahoo data download. Not very often.
>
> To answer your question about the command syntax:
> 1. I would copy asc2ms.exe to C:\ASCII.
> 2. "filename.csv" is the Ascii file in the example.
> 3. "-r updateRecord" updates the record and not appends.
> 4. "-t" is to transverse folders (your MetaStock data folder has more
> than 255 securities). (NOTE - I have never had to use -t before so I
> don't know what it does. It is the correct option in terms of the
> utility's readme file.)
> 5. "-o" specifies the output directory.
> 6. I suggest a backup of your data before you try the next step.
> 7. The full command is below.
>
> asc2ms.exe -f filename.csv -r updateRecord -t -o c:\MSDATA
>
> Hope this helps.
>
> Stuart
>
> --- In equismetastock@xxxxxxxxxxxxxxx, "Angelo" <angelo@> wrote:
> >
> > Hi Stuart,
> >
> > Thank you so much for your info. Have you use the utility.
> > I have been trying and it works on normal condition. But when I
> wanted to convert using asc2ms and the ascii file included historical
> data of on symbol for adjustment purposes, it created new symbols
> merged with the historical dates. The added symbols is kind of a mess.
> >
> > Can you help me?
> > Suppose below my condition:
> >
> > -Ascii file under folder C:\ASCII
> > -Ascii filename is asciidata.txt
> > -MetaSTock data folder is under c:\MSDATA
> > -Ascii data field is SYMBOL DD/MM/YYYY OPEN HIGH LOW CLOSE
VOLUME (so,
> > no open interest)
> > -Whenever there is the same date I want the ascii to overwrite
msdata
> > at the same symbol and date
> > -Whenever there is a new security I want it to be created
> > automatically in the C:\MSDATA
> > -MetaSTock data folder consist more than 255 securities.
> >
> > I am using MsCmdLineUtilsV1.8.4. Can you help my how should I
type the
> > command?
> >
> >
> > Thanks before.
> >
> >
> > Best regards,
> > Angelo
> >
>
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/equismetastock/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:equismetastock-digest@xxxxxxxxxxxxxxx
mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx
<*> 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/
|