Friday, October 25, 2013
Send mail from Excel
This a simple demonstration of sending email from Excel via Outlook.
Works fine in version 2007.
Works fine in version 2007.
Fetching stock quote from Australian Stock Exchange
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
Subscribe to:
Posts (Atom)