I currently have a sheet that uses the GoogleFinance operator to pull stock info automatically. I then use formulas in other columns to automate other information accordingly. I want to be able to add user data in the glide app (i.e. stock ticker), and have all the formulas run on the new row of dat…

The best way would require some Google Scripting to write the formula to the proper cells when a row is appended. It would also entail setting up a timed trigger to automatically run to check for those new rows. An alternative way would be to have a sheet that has all of the formula pre populated,…

You can use my method here to copy the formula down. [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when …

Using Google Finance to pull stock info

Ask for Help

ThinhDinh June 19, 2020, 12:30am 3

You can use my method here to copy the formula down.

Topic		Replies	Views
Apply an existing formula in Google Sheet when a new item is added by the user Ask for Help	6	864	November 29, 2020
Google Sheets Formula Carry Down Ask for Help	13	3618	July 28, 2022
Doesn't write on my Google Sheet Ask for Help	4	1866	January 25, 2020
Array formula in Google Sheet Ask for Help	3	433	October 11, 2022
User input into Google Sheets? Ask for Help	5	490	February 6, 2023

Using Google Finance to pull stock info

Related topics