Was a bit overwhelmed to start, but I came up with this. It's a...

  1. 111 Posts.
    lightbulb Created with Sketch. 7
    Was a bit overwhelmed to start, but I came up with this.
    It's a bit simpler than the Willy Wonka one floating around for Yahoo Finance.
    I downloaded an ASX .csv file with all listings, concatenated asx: in front of all tickers, then copied/pasted into Google Sheets A column.
    Then made the individual functions fx for each column in row A2, grabbed the whole row and dragged it down the 2250 listings.
    It's saved in the cloud, so I don't know else to save and post. It's a HTML file.
    You need a Google account and password to start the Google sheet.
    Sorting columns is a breeze, although it auto saves after every change, so I found it better to copy and paste to an excel file when doing a lot of sorting. Sometimes it won't undo/redo.
    If you look at radio buttons above function fx line, you'll see you can easily adjust decimals up or down.
    look up https://support.google.com/docs/ans...1-636453716143099183-4190368376&hl=en-GB&rd=1 for all the column options.
    GoogleSheets.PNG
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.