Australian (ASX) Stock Market Forum

How to import Norgate Premium US Stocks data into Python?

Joined
Jun 15, 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
 

Trembling Hand

Can be found on the bid
Joined
Jun 10, 2007
Posts
8,852
Reactions
191
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
 
Joined
Jun 15, 2017
Posts
19
Reactions
1
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
 
Joined
Nov 6, 2018
Posts
2
Reactions
0
Hi Trembling Hand - Quandl does not provide ASX equity data so not really an option? (albeit it would be a much better python solution).
 

tech/a

No Ordinary Duck
Joined
Oct 14, 2004
Posts
19,528
Reactions
3,884
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.
 
Joined
Nov 6, 2018
Posts
2
Reactions
0
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.

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
 
Joined
Feb 6, 2019
Posts
1
Reactions
0
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.
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
 

Richard Dale

Norgate Data
Joined
Feb 22, 2005
Posts
171
Reactions
37
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