|
PureBytes Links
Trading Reference Links
|
Hello Sanjay,
I have written a free utility to convert comma separated price data
to metastock data format, you can get this
>From my website http://www.geocities.com/mimansoor it's also
available from files section of equismetastock yahoo groups.
Here are the steps you need to do to convert your excel price data to
metastock format.
1. Get the metastock command line utility from
http://www.geocities.com/mimansoor/MsCmdLineUtilsV1.5.2.zip
2. Open your excel data in excel and select the date column and
convert the date format to
14-Mar-01 format by selecting format cells, save it as csv file format
3. open the .csv file in your favourite editor (I use gvim J ) and
convert the header line from
DATE,TICKER,NAME,OPEN,HIGH,LOW,CLOSE,VOLUME,O.INTREST
To
<date>,<ticker>,<name>,<open>,<high>,<low>,<close>,<vol>,<openint>
4. use asc2ms –f BPDEC04.csv -o test
5. Your MASTER,DAT files will be in test directory.
Regards,
Mansoor.
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/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/
|