Hello, i'm new around here, and just getting started with Metastock.

Is it possible to conveniently export metastock securities data for multiple symbols to an excel file, and get the data for each symbol on a different worksheet within the same excel file? (without doing a lot of manual cut/copy/paste operations).

Thanks in advance

- Winvestor

 

Hi Winvestor,

Welcome to the Forum.

Yes, it is possible to output MS data to Excel, but it is a lot more complicated to output all the data on respective worksheets in a single workbook.  You can get API-helpers to write to Excel, but none of these are natively available to be called from MS formula. You will need the MDK to be able to write your own library functions, to call the ExcelWrite functions.  You can use the Downloader to expot MS data to individual Excel files, but that isn't what you asked for.  In the end nothing is really convenient, so I guess the proper answer to your question should have been no, there is no convenient way to do it.

Instead of taking the data to the Excel, why not take the Excel functions to MS?


Hope this helps.

wabbit

---

"The question of whether a computer can think is no more interesting than the question of whether a submarine can swim."
Edsgar W. Dijkstra

 

MS: 6.52 EOD, 7.x EOD, 8.0 PRO, 9.2 PRO w/QC, 10 PRO w/QC C, 11 PRO w/QC & MDK
For custom MetaStock programming : http://www.wabbit.com.au
My SkyPE status :
My SkyPE account : wabbit.com.au

Thank you Wabbit, it certainly helps. I will take your suggestion and play around with taking the Excel functions to Metastock. It will probably take me days to weeks though..

Two more questions
- what is MDK?
- is there a simple way to read Metastock Master, Emaster, and Xmaster files? When i use dowloader to export data to individual excel files, i get a bunch of files with numerical filenames, and within those files the individual stocks are referred to with a numerical code rather than the stock symbol. So at this point i have no idea which stock symbol corresponds to which stock number and which filename. Therefore i need to construct an index or lookup table of all this information, and i'm guessing the info i need is in the master files?

Winvestor

FYI, regarding the MDK (MetaStock Developer's Kit):

http://www.equis.com/Partners/Developers.aspx