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.
- Forums
- ASX - Short Term Trading
- Short Term trading Week Starting: 27 Nov
Was a bit overwhelmed to start, but I came up with this. It's a...
- There are more pages in this discussion • 176 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)