I have configured to fetch the data on every 1 min from investing wesite.

[![enter image description here][1]][1]


The table data is fetching from website. while trying to update date when 15 minutes status D column change to either strong sell or strong buy time on time and date column the functions are not working. please find below requirement. 

1) I need to update time and date in G column when D column update from the website either Strong sell or strong buy.
2) once the time and data updated if the time and date less then 1 minute then need to get email alerts. 

I have tried functions on the table but not working. kindly help me on this why the functions are not working .onchange .onedit.  



  [1]: https://i.sstatic.net/UgpjL.png