Australian (ASX) Stock Market Forum

How to import Norgate Premium US Stocks data into Python?

Jump to new
L

lmz4005

Joined
15 June 2017
Posts
19
Reactions
1
Hi guys,

My first baby steps in Python coding and I can draw a -basic- graph with google datas for 1 stock!

Now I want to import PremiumData for US stocks (on my PC used for Amibroker) and I am stuck here:

engine = create_engine('mysql+mysqlconnector://root:root@localhost/????’)

I know can use the converter tool to create csv file to put these database under if this is what needs to be done.

But then I don’t know what to write here: mysql+mysqlconnector://root:root@localhost/????’
for Python to access it from my PC.

If you have an easy answer, I would be grateful otherwise maybe you can point me in the right direction in terms of literature (the book I have from the library is not deep enough).

Thanks. Laurent
 
Not an easy first step to be taking but... PremiumData is stored in Metastock Binary file format. You can search Github and StackOverFlow.com to get an idea of how detailed the process is and to be frank, I wouldn't be bothered. Far easier to just use quandl. If Python and R take off as the method for retail the likes of Norgate are going to go the way of Atari!

Here are a few example that I have started to play with and then moved on to better ideas,

http://themech.net/2008/08/reading-metastock-files/

https://github.com/akapur/pycomputrac
 
Thanks but I think "Easy is for lazy"unless proven otherwise :):):)
I want to be able to use data from ASX, US which I have bought from PremiumData.
Can I export the Premium ASX Data into a CSV file (using the converter tool) and use this as my Python database?
How do I code this then?

much appreciated
Laurent
 
Hi Trembling Hand - Quandl does not provide ASX equity data so not really an option? (albeit it would be a much better python solution).
 
Hi Everyone

So---out of interest if you could be supplied with

Software that can automatically up date and convert your Norgate Data
Easily imported into Python
Easily load customised lists from single tickers to the full ASX
and any sub category. Including any list of your own.
Quick and simple and can handle multilevel data frames.

Plus education on correct implementation and how to handle missing
data to suit your requirements---and much more.

What would that be worth---yes its a leading question---yes it is available.
 
tech/a said:
Hi Everyone

So---out of interest if you could be supplied with

Software that can automatically up date and convert your Norgate Data
Easily imported into Python
Easily load customised lists from single tickers to the full ASX
and any sub category. Including any list of your own.
Quick and simple and can handle multilevel data frames.

Plus education on correct implementation and how to handle missing
data to suit your requirements---and much more.

What would that be worth---yes its a leading question---yes it is available.
Click to expand...


Hi "Tech",

What I really want for Xmas is to be able to query the native Norgate DB using Python. I don't really want to muck around exporting data into flat files etc ... I actually wrote to Norgate yesterday asking if this was on the drawing board. I will look at the whole proposition to give you a value but yes I would be open to making a donation to get a solution - but I would want it to be Norgate endorsed. I hate the way the ground keeps moving away from under me when I am heavily vested in solutions.

Luthor
 
tech/a said:
Hi Everyone

So---out of interest if you could be supplied with

Software that can automatically up date and convert your Norgate Data
Easily imported into Python
Easily load customised lists from single tickers to the full ASX
and any sub category. Including any list of your own.
Quick and simple and can handle multilevel data frames.

Plus education on correct implementation and how to handle missing
data to suit your requirements---and much more.

What would that be worth---yes its a leading question---yes it is available.
Click to expand...

Hello Tech,

I am very interested in the functionality (and education) that you describe.
You posted this question some time ago. Has this been converted in a product or offer ?
Is there more information available ?

SilverQuant
 
FYI, we are now testing a direct interface to Norgate Data. Testing is open to any Norgate Data subscriber. If you are a subscriber to Norgate Data, we would be happy to have you as a tester - just let us know.

(Note: This is only applicable to Norgate Data, not to our legacy service Premium Data)
 
Top