Home > Back-end >  ARRAYFORMULA with GOOGLEFINANCE function
ARRAYFORMULA with GOOGLEFINANCE function

Time:09-29

I want to create a simple function that returns company name for every line that is filled with the Symbol via GoogleFinance function, however, I am not able to make the script work for every line.

Here is the example:

enter image description here

Or this with the header

={"Name";BYROW(A2:A, LAMBDA(r, IF(r="",,GOOGLEFINANCE(r, "name"))))}

enter image description here

  • Related