Discussions
»
Product and Service Development
»
Data Related Questions
»
Export metastock data (multiple securities) to excel worksheets?
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/7/2009(UTC)
Posts: 13
|
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
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
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 [:D]
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/7/2009(UTC)
Posts: 13
|
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
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Data Related Questions
»
Export metastock data (multiple securities) to excel worksheets?
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.
