- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 14, 2022 03:19 AM
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!!!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 14, 2022 08:14 PM
Hi 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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 14, 2022 06:42 AM
Hi 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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 14, 2022 08:14 PM
Hi 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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 14, 2022 11:38 PM
Thank you very much!!! that was what I was looking for.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 14, 2022 11:39 PM
Thank you very much for the suggestion!! That is certainly something I will be looking into.
