• Australian (ASX) Stock Market Forum

Hello and welcome to Aussie Stock Forums!

To gain full access you must register. Registration is free and takes only a few seconds to complete.

Already a member? Log in here.

How to import Norgate Premium US Stocks data into Python?

Discussion in 'Software and Data' started by lmz4005, Jul 29, 2017.

  1. lmz4005

    lmz4005

    Posts:
    19
    Likes Received:
    1
    Joined:
    Jun 15, 2017
    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
     
  2. Trembling Hand

    Trembling Hand Can be found on the bid

    Posts:
    8,843
    Likes Received:
    180
    Joined:
    Jun 10, 2007
    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
     
    lmz4005 likes this.
  3. lmz4005

    lmz4005

    Posts:
    19
    Likes Received:
    1
    Joined:
    Jun 15, 2017
    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
     
  4. Trembling Hand

    Trembling Hand Can be found on the bid

    Posts:
    8,843
    Likes Received:
    180
    Joined:
    Jun 10, 2007
    lmz4005 and Indoril like this.
  5. lmz4005

    lmz4005

    Posts:
    19
    Likes Received:
    1
    Joined:
    Jun 15, 2017
    much appreciated thanks.
     
  6. lexluthor

    lexluthor

    Posts:
    2
    Likes Received:
    0
    Joined:
    Nov 6, 2018
    Hi Trembling Hand - Quandl does not provide ASX equity data so not really an option? (albeit it would be a much better python solution).
     
  7. tech/a

    tech/a No Ordinary Duck

    Posts:
    18,840
    Likes Received:
    2,434
    Joined:
    Oct 14, 2004
    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.
     
  8. lexluthor

    lexluthor

    Posts:
    2
    Likes Received:
    0
    Joined:
    Nov 6, 2018

    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
     
  9. SilverQuant

    SilverQuant

    Posts:
    1
    Likes Received:
    0
    Joined:
    Feb 6, 2019
    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
     
  10. Richard Dale

    Richard Dale Norgate Data

    Posts:
    157
    Likes Received:
    17
    Joined:
    Feb 22, 2005
    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)
     
Loading...

Share This Page