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)
Featured News
Featured News
The Watchlist
LU7
LITHIUM UNIVERSE LIMITED
Alex Hanly, CEO
Alex Hanly
CEO
SPONSORED BY The Market Online