title: How can I use Google Sheets to keep a most recent announcement date for tickers I have?
body: <p>I've got an extensive google sheet file, one of the sheets which are called "Ticker List" has a range of tickers on it. I would like there to be a column in that range which presents the date of the most recent announcement only (column "O"). The ticker symbol is in column "A". </p>
  
  <p>Since I do not need the data to be backdated before today, I originally tried to create a importxml function, which goes to "today's announcements" on ASX website. URL: "<a href="https://www.asx.com.au/asx/statistics/todayAnns.do" rel="nofollow noreferrer">https://www.asx.com.au/asx/statistics/todayAnns.do</a>". Although the XPath confuses me. </p>
  
  <p>None</p>
  
  <p>I want the code to scan that website, if a ticker that is in my range (column A) has an announcement today, then to update column O to today's date, and keep that date there until the next announcement. The order of my current ticker range, is not update-able, although I do have a sheet in my file that is called "backend" and has a lot of queries and ranges to help sift through data.</p>