Rank: Member
Groups: Registered, Registered Users
Joined: 9/8/2006(UTC)
Posts: 14
|
I am using The Downloader to convert Metastock data -> ascii text. If I select hundreds of securities, they will be converted in a single text file. Is it possible to have the output as a seperate security text file eg. the output of 100 securities would be 100 ascii text file of each security.
Is there any utilities to handle metastock data manipulation?
Thank you
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
As long as there is a <ticker> header and column defined, the data will be converted into separate security files.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 9/8/2006(UTC)
Posts: 14
|
I may not explain clearly. I prefer to select eg. 100 Metastock data file (securities) by highlight them all at once and have the 100 seperate ascii text file as output.
I am not used to The Downloader, but what you suggest sounds like converting from ascii to MetaStock file.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
Sorry about the confusion. For going from MetaStock format into ASCII, you want to set the Destination File Name as *.TXT instead of a specific filename. This will create a separate TXT file named after each ticker symbol.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 9/8/2006(UTC)
Posts: 14
|
This's really solve my problem. Thanks a lot.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 9/8/2006(UTC)
Posts: 14
|
Everthing is going allright , however there are some points about output file name when using *.TXT :
1) There is a time frame suffix at file name D for daily , 30 for 30 minutes . Is it possible to get rid of these suffix?
2) The special characters have been changed to underscore ( _ ) eg. the output file name of RS.1 will be RS_1D
What I am looking for is the file name ( output) that is exactly the same as security name. I am trading in countries other than US and the local data provider use two special characters ( @ and period) to seperate security class eg. BWR@W vs BWR.1
Thank you.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
The output file is hard-coded when using a wildcard, so there is not any option to change the output filenames.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 4/5/2006(UTC)
Posts: 129
Location: Norgate Data
|
A (free) third party Metastock-ASCII and ASCII-Metastock converter is available here:
http://www.geocities.com/mimansoor/
These are command line tools rather than GUI so quite a bit harder to use.
This might do the job a bit better with respect to filenames than The Downloader.
I've only used it a few times in the past but, at the price, you can't go wrong.
Cheers,
Richard.
|
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 9/8/2006(UTC)
Posts: 14
|
Thanks Pyradius, youe suggestion is helpful and definitely I can make use of it in other time.
Richard, the command line is faster than the downloader but still convert all MetaStock data into one single ascii file. I am not sure whether I understand correctly ( I am not keen on Programming at all). If this is the case, I might look around and see what I can grapse for it !
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/13/2007(UTC)
Posts: 1
|
I am using Downloader, not MetaStock. My analysis software uses ASCII files. It will be painful converting the database each time the data are updated :^(.Two questions:
1. Can the entire database be converted automatically to separate ASCII files after updating it?
2. Can Downloader store the individual ticker files with the data ordered newest-to-oldest instead of the default oldest-to-newest?
thanks!
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 4/5/2006(UTC)
Posts: 129
Location: Norgate Data
|
1. No.
2. No.
Perhaps you should get your analysis software to read in the native "MetaStock" format. File format specifications exist in the public domain around the Internet, Equis sells a read-only SDK that can be used to read the data, and there's also MetaLib which can read MetaStock data too.
|
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/13/2007(UTC)
Posts: 2
|
Folks,
i ama newbie and i am using Metastock 7.2 , when i download EOD data and convert from ascii to MS , it sends the Data to the folders from A to S folders but does not send data into folder from T onwards , i have checked the EOD data and it is downloaded ok , so all charts are up to date up to S but after that they are a week old and not updating.
any suggestions would be appreciated !
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
If you try and convert the folders that are having problems, what messages show up in the Conversion Report? (Double click on one of the items in the conversion report)
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/13/2007(UTC)
Posts: 2
|
Thanks Pyradius,
the conversion report showed that i had a sub sub folder T under my main EOD sub folder F ( dunno why or how ?) so the data wasnt being distributed properly , i just deleted the offending file & re converted the last 20 days and all charts are now up to date.
thanks for the help!
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
