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

Re: [EquisMetaStock Group] Re: MsCmdLineUtils



PureBytes Links

Trading Reference Links

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
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@yahoogroups.com, "Angelo" <angelo@xxx> 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
>

__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___