I have a google sheet which has googlefinance formulas to get various values related to stocks. I have also created a function in app script which basically sends the value of the stocks in my email, and this function is set to trigger every month. Now, since the stock values are dynamic, I need the sheet to refresh everytime before the function for sending stock value in mail in triggered (so that I get the most recently updated value of stock from googlefinance). My query is:
- Does the sheet refreshes by defualt when a function is called?
- If not, How can I incorporate this feature in my code.
Thanks in advance
I am trying to search for a script (or any other way) to be added to my function to refresh the sheet before the values are shared over mail.