Automatic filling of Stock price
I have a list of scrips of stock market. When I add a new scrip in a new row, I would like to automatically fill its current price using GoogleFinance function of google sheets.
In the attached google sheets, Column A contains the mnemonics of the scrip from which column B calculates the current price. When I add a new scrip, I copy the formula to the new row. How do I achieve it automatically?
Solution
GOOGLEFINANCE is already a type of ARRAYFORMULA so it is not supported under ARRAYFORMULA. this means that it is not possible to process your A column with one single formula. you have only two options how to do this:
- use script which will detect new entry in A column and insert single-cell
GOOGLEFINANCEformula adjacent to it - hardcode it like:
=IFERROR({GOOGLEFINANCE("NSE:"&A2);
GOOGLEFINANCE("NSE:"&A3);
GOOGLEFINANCE("NSE:"&A4);
GOOGLEFINANCE("NSE:"&A5);
GOOGLEFINANCE("NSE:"&A6);
GOOGLEFINANCE("NSE:"&A7);
GOOGLEFINANCE("NSE:"&A8);
GOOGLEFINANCE("NSE:"&A9)})
- Find the first row of a 2d which contains all required associative elements
- Filter rows of a 2d array which contain two specified column values
- Find the first occurring array row which contains a search value and return the first level key
- Search for a column value in a 2d array and return its first level key
- Return the first level key upon finding a qualifying subarray in a multidimensional array
- Search for a value in the 3rd level of a 3d array and return the first level key
- (PHP) specific array sort
- Sort a multi-dim array by a column
- Sort a multi-dimensional array by a column
- Declare a fixed value to each of an array of key values to populate a new associative array
- How to declare a new associative element of a specific first level element?
- How to push a new row into a 2d array?
- Sort all rows of a 2d array to align with the sorted result of a specific row
- Sort a row of a 2d array and apply the same movements to all other rows
- Sort a 2d array by three columns
- Sort a 2d array by a column of d-n-Y formatted dates
- Sort a 2-D array by a column
- Sort an associative array by Y-m-d formatted keys
- Array sorted by PHP gets unsorted when accessed in a Javascript for() loop
- Sorting an associative array with `arsort()` prints 1 instead of the sorted array
- How to sort a 2-d array by a column?
- How to sort multi-dimensional array by a column and preserve the non-numeric first level keys
- Sort an associative array by key in a descending direction
- PHP copy reference from array to array
- Comparing two arrays ignoring element order in Ruby
- How to divide a matrix in MATLAB into N^2 segments each with NxN elements?
- Explode string only once on first occurring newline character
- How to make all array keys the same as their respective value?
- what is the wrong with this javascript function?
- Batch matrix multiplication in numpy