Metastock convert excel or asci to metastock

This is a discussion on Metastock convert excel or asci to metastock within the Trading Software forums, part of the Commercial category; Hello, I need to convert the stock data from Excel to Metastock. A conversion witch have to be done manually. ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Jan 29, 2012, 10:07pm   #1
 
2 Posts
Joined Jan 2012
Metastock convert excel or asci to metastock

Hello,

I need to convert the stock data from Excel to Metastock. A conversion witch
have to be done manually. Therefore I'd like to automate this proces but the question is how to this?

1) Does anyone have a excel vba solution to convert to the metastock format?
2) Does anyone have a command line utility witch can solve this (asc2ms have lot of problems)

Thanks in advance.
jb00013 is offline   Reply With Quote
Old Jan 30, 2012, 1:04am   #2
 
Mornington Crescent's Avatar
Joined Jun 2004
Re: Metastock convert excel or asci to metastock

convert excel data to csv format file then load into Mstock
__________________
You have to decide !
Mornington Crescent is offline   Reply With Quote
Old Jan 30, 2012, 10:34am   #3
 
2 Posts
Joined Jan 2012
Re: Metastock convert excel or asci to metastock

jb00013 started this thread
Quote:
Originally Posted by Mornington Crescent View Post
convert excel data to csv format file then load into Mstock
Thanks for your reaction,

I understand that you can't directly load a csv file in metastock but that you have to convert it with the metastock downloader. This is for me the current processing path. I like to automate this you don't need the downloader but the question is how?
jb00013 is offline   Reply With Quote
Old Jan 30, 2012, 2:13pm   #4
 
Mornington Crescent's Avatar
Joined Jun 2004
Re: Metastock convert excel or asci to metastock

its a long time since I used Mstock and the manual disappeared some time ago

check to see how their data files are organised and if they will open properly with a text reader

but from memory, if its not allowed in the manual then you would have to do it manually
__________________
You have to decide !
Mornington Crescent is offline   Reply With Quote
Old Feb 11, 2012, 1:05pm   #5
Joined Mar 2005
Re: Metastock convert excel or asci to metastock

Quote:
Originally Posted by jb00013 View Post
Thanks for your reaction,

I understand that you can't directly load a csv file in metastock but that you have to convert it with the metastock downloader. This is for me the current processing path. I like to automate this you don't need the downloader but the question is how?
@jb00013,

there's an add-on called "Metalib" (ca. 60 Euros) which can write Metastock data read from Excel/VBA. Take a look:
MetaLib: SDK for reading/writing MetaStock security price data in VB, C#, Delphi, C++

So you can automate your conversion jobs.

bye
zentrader
zentrader22 is offline Software vendor   Reply With Quote
Old Feb 12, 2012, 10:31pm   #6
Joined Jul 2008
Re: Metastock convert excel or asci to metastock

Quote:
Originally Posted by jb00013 View Post
Thanks for your reaction,

I understand that you can't directly load a csv file in metastock but that you have to convert it with the metastock downloader. This is for me the current processing path. I like to automate this you don't need the downloader but the question is how?
Take a look at MLDownloader. It will import any ASCII file and save the data in Metastock formatted folders of your choice.
colion is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
export From metastock To excel abcpankaj Trading Software 2 Aug 8, 2010 8:49am
Read / Write to Metastock Data from Excel MarkVincent Trading Software 3 Jul 6, 2009 4:08am
Metastock Signals into EXCEL rahul100 Trading Software 0 Feb 18, 2009 1:52pm
Convert Metastock System into MT3 ssblack Trading Software 8 Mar 10, 2008 11:01am
Excel to Metastock RobcPettit Trading Software 3 Jul 6, 2005 5:37pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)