I’m using importdata
to retrieve Yahoo stock information, which works fine on individual rows, but when combined with arrayformula
to fill down the page when additional symbols are added does not initiate continue. The formula I'm using is:
=arrayformula(ImportData("http://finance.yahoo.com/d/quotes.csv?s="&CONCAT(A2:A,B2:B)&"&f=snk2l1jkm3m4"))
A2:A
contains the stock codesB2:B
contains the exchange code, e.g.,.ax
for Australia