I've been working on a DLL (using the free GNU C++ (gcc) compiler and Codeblocks IDE) to read Metastock Data downloaded from a trial version of Stock Quote Data from DataHQ and are happy to upload on here for people to have a play with. Firstly, is this a forum where you can upload zip files? as .zip doesn't seem like a valid file extension and this is my first post?
I did upload an earlier version on the hometrader forum a couple of years ago, but can't be bothered paying another $600 to become an active member and have been told recently that my post about it since then was fairly inactive. I thought I'd give it another go on a free forum just in case people find it interesting as I've noticed some posts on this issue.
Anyway, my zip file is called "MSDR.zip" and contains the following files:
The MSDRDLL.dll file contains all the executable code to access a Metastock Database and the excel 2003 file MSDRDLLTesta.xls contains the VBA code (which calls dll code) to display the data in excel.
In order to get things to work, the following needs to be done:
1) Metastock Data downloaded from DataHQ. Should be in a directory such as D:\TradingData\Stocks\ASX\Equities\.
2) Both files (from zip file) need to be in the same directory.
3) In Excel, Open file MSDRDLLTesta.xls and make sure Macros is enabled.
4a) In Excel, open macro window (Alt-F11) and search for the word "Initialize" and keep hitting find next until you get to the Initialize function.
4b) In Initialize() code, change the dbpath to where you have your metastock data installed (e.g. D:\Trading Data\Stocks\ASX\Equities\) and make sure there is a backslash at the end.
Sounds like a lot of work, which is probably why I never got much feedback on the hometrader forum, but could be useful if people are able to get it to work. I have only used it on a trial version from DataHQ which was the End Of Day ASX package that would of normally cost $15 back in 2012. It requires that Metastock data be in the format "Date, Open, High, Low, Close, Volume and Open Interest". If not it won't work. For example, it may not work for intraday data downloads as that might include a time.
Anyway, is anyone interested in this kind of stuff? and if so, am I able/allowed to upload the zip file?