Hello!
I am trying to achieve the following.
I would like to update my stock on button press by adding or removing the value given in the cell.
Please help.
Thank you very much in advance!!!
+17Hi Pim,
You could use the button to run a script that makes an API call (using fetch) to a financial API like AlphaVantage and updates your cell with the response.
If you’re happy using a third-party app you could follow this video to use the Data Fetcher app:
Then follow this guide to run the request when a button is pressed.
+31Hi Pim, I’ve put something together here for you that should do what you’re looking for
It would require that the button runs a Scripting App though, which forces the sidebar to appear
+9Hi Pim, I’ve put something together here for you that should do what you’re looking for
It would require that the button runs a Scripting App though, which forces the sidebar to appear
Thank you very much!!! that was what I was looking for.
+9Hi Pim,
You could use the button to run a script that makes an API call (using fetch) to a financial API like AlphaVantage and updates your cell with the response.
If you’re happy using a third-party app you could follow this video to use the Data Fetcher app:
Then follow this guide to run the request when a button is pressed.
Thank you very much for the suggestion!! That is certainly something I will be looking into.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.