Trying to calculate new stock value on button press

[Pim_Wagenmakers]

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!!!

[Andy_Cloke]

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.

[TheTimeSavingCo · Accepted solution]

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

[Pim_Wagenmakers]

Thank you very much!!! that was what I was looking for.

[Pim_Wagenmakers]

Thank you very much for the suggestion!! That is certainly something I will be looking into.