This Excel application performs web query from Yahoo finance website, retrieves quotes based on the Ticker selected from a set of stocks in worksheet “ASXListedCompanies”. The retrieved data is then used to update a Chart.
List of Tickers: List of tickers are kept in a dynamic range which serves as a data source of the dropdown box in worksheet “Query”. New stocks can be pasted in the dynamic range which will automatically show up in the dropdown list.
Web query can be performed for any ticker for as many days as you want.
Download xlsm file
List of Tickers: List of tickers are kept in a dynamic range which serves as a data source of the dropdown box in worksheet “Query”. New stocks can be pasted in the dynamic range which will automatically show up in the dropdown list.
Web query can be performed for any ticker for as many days as you want.
Download xlsm file
No comments:
Post a Comment