Full ASX Excel Spreadsheet, page-71

  1. SonicBlast
    10,631 Posts.
    lightbulb Created with Sketch. 39
    clock Created with Sketch.
    08/05/17
    09:43
    Post #: 24533559
    For those who can vba code and have reformatted the 1.5xls ver just edit your macro and do a string replace.

    excelallasx2.PNG
    NEW url comes from http://download.finance.yahoo.com/d/quotes.csv?s=
    You also have to replace the NEW url across the "Project" otherwise it wont update all the sheets/modules etc.
    I have it working in ver 1.5.xls
    Thanks @WilliamWonka

    Sonic
    Last edited by SonicBlast: 08/05/17
    Likes Created with Sketch.  Upvote
    Stroke 3 Created with Sketch. Comments Created with Sketch. Reply

  2. Top Stories

 

Featured News

NEWS Finding properties tenants will want to rent
right-arrow Created with Sketch.
NEWS The Big Deal: Free-to-air TV swings the axe, but will it be enough as enormous sports deal bills loom?
right-arrow Created with Sketch.
STN Saturn’s stars have aligned for the gold explorer’s Apollo Project
right-arrow Created with Sketch.
ALK Alkane Resources hit 57.2Kozpa gold production through FY24 – and eyeing 70Ktpa in FY26
right-arrow Created with Sketch.
ITM Fast-track assaying yields 182 g/t gold for iTech at new NT play
right-arrow Created with Sketch.
SXE SCEE boosts Synergy deal by $50M for Collie battery project
right-arrow Created with Sketch.
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.