I am new to the stock market game and I was looking around for a spread sheet that contained all 2150 ASX listed
companies with detailed updateable information.
After a long internet search I was unable to find what I was looking for so I set about make my own.
There is 1001 web sites that will give you quote information however getting all 2150 companies data into Excel was easier said than done. I decided to use Yahoo Finance as my information source, that main problem was that most of these quote providers have a limit on how many quotes you can receive at once, for or Yahoo this limit is 200.
This hurdle was overcome by adding 200 company codes to 11 hidden sheets and updating the individually. This is all done with a button press that updates each sheet and copies the data to the "ALL" sheet.
The update button is located in the top left and takes around 10-15 seconds for the data to download.
At the moment the columns I have added to the sheet are as follows:
CODE, NAME, LAST TRADE DATE, OPEN, LAST, ASK, BID, HIGH, LOW, CHANGE, DIV YEILD, PE RAITO, AVERAGE DAILY VOL , VOLUME, % CHANGE, 52 LOW, 52 HIGH, MARKET CAPTIAL, BOOK VALUE.
Please let me know if there are any bugs or improvements that could be made, As I am a beginner to this game I don't fully understand all the data types that are available on Yahoo Finance, I have added what I thought was needed.