Excel Spreadsheets and Trading

  1. 654 Posts.
    Hi Everyone,

    I hope you are all well!

    I am just seeking a bit of information and know how from the HC community!

    I am looking for a bit of advice with the technical points of excel - I would like to create a sheet that scrapes data from a live source.

    1. Is it possible to have a spreadsheet that gives me a live feed (changing as the SP on market does)
    2. What site could I use for this?
    3. Am I able to somehow link this to my Commsec account?
    4. I would like to manually enter a stock code, then the relevant information that I require pops into my spreadsheet - I know you can do this using google finance, however I have found it to be not quite as accurate as Commsec, eg I would like the SP to 4dec places.

    Thank you!

    E
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.