Help

Trying to calculate new stock value on button press

Topic Labels: Scripting extentions
Solved
Jump to Solution
468 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Pim_Wagenmakers
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

image

Please help.

Thank you very much in advance!!!

1 Solution

Accepted Solutions
TheTimeSavingCo
15 - Saturn
15 - Saturn

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
script update field

See Solution in Thread

4 Replies 4
Andy_Cloke
7 - App Architect
7 - App Architect

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
15 - Saturn
15 - Saturn

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
script update field

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

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