0
$\begingroup$

I'm thinking of getting End of Day stock prices from Metastock, but was wondering if it would be possible to have Python to automatically extract the stock prices and store it in a SQL.

Would that be possible? To use Python to interact with Metastock and collect data?

Any other recommendations for End of Day stock prices? (Asian Equities)

$\endgroup$
1
$\begingroup$

Metastock uses a binary format that you would have to convert to text before exporting it to a SQL table. Also, there is no Python library that could extract data directly from Metastock's end-of-day servers.

You may consider quandl which allows Python developers to download pricing data as well as economic indicators. You can download CSV, JSON, or XML. If you use their Python library, you can easily retrieve data into a pandas DataFrame.

https://www.quandl.com/

$\endgroup$
  • $\begingroup$ Thanks!! It's slightly more expensive than Metastock though. But I think phasing the data would be much much much easier. $\endgroup$ – jake wong Feb 10 '16 at 3:28
  • $\begingroup$ You might purchase the DataLink tool that allows a text-based MetStock file, but you lose straight through automation. Once you have the text file, it should not be difficult to import it into a database. $\endgroup$ – andrew.paul.acosta Feb 10 '16 at 3:45
  • 1
    $\begingroup$ you mean to say that if I get the DataLink tool, I would still need to manually download all the text files for the ticker/counter, and then I would be able to import it into a database? So in your opinion, it would be easier to just use quandl? $\endgroup$ – jake wong Feb 12 '16 at 2:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.