Next Earning Date

I have a google spreadsheet with a list of symbols/stocks (NASDAQ, AMEX, NYSE, etc) with their prices. I have a created a column ''Next Earnings Date''. I would like someone to create a macro to automate the process of always displaying the next earnings date when I enter a new symbol. I know we can access the list of historical and future earnings, for instance TSLA, here: https://finance.yahoo.com/calendar/earnings?symbol=TSLA. It might be useful.