|
PureBytes Links
Trading Reference Links
|
Correction. I left out the "D" and zero for open interest at the end.
Your first line should be:
PGAS.JK,D,12/15/2003,350,350,300,310,1081952480,0
PS I know the date formats don't tie up. Per the change log, there are
various allowed formats for date.
--- In equismetastock@xxxxxxxxxxxxxxx, smpretor <no_reply@xxx> wrote:
>
> 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@> 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/
|