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.

convert excel data to csv format file then load into Mstock

Mornington Crescent said:

convert excel data to csv format file then load into Mstock

Click to expand...

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?

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

jb00013 said:

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?

Click to expand...

@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

jb00013 said:

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?

Click to expand...

Take a look at MLDownloader. It will import any ASCII file and save the data in Metastock formatted folders of your choice.