3

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 codes
  • B2:B contains the exchange code, e.g., .ax for Australia
  • So what’s your question? – Alex Sep 28 '13 at 5:30
  • What do I need to change to have the 'arrayformula' fill down the sheet as I add more values in columes A and B? – Chris Sep 29 '13 at 6:24
  • @Chris: Please, create a demo spreadsheet and share it for view only with anyone with the link. – Rubén Jan 22 '16 at 19:02
  • I edited out smartquotes from your formula. Was that a paste error or do you actually have them in there? That could be problematic. – ale Jan 29 '16 at 0:32
3

It doesn't work with arrayformula - importdata, and importxml will not work it unfortunately.

  • A change make to Google Sheets on early weeks of 2017 makes that arrayformula now works on SPLIT – Rubén Apr 14 '17 at 3:40
  • 1
    Yeah i noticed is about time. But that still doesn't work with import data unfortunately as far as i know – Aurielle Perlmann Apr 14 '17 at 3:42
  • I agree, arrayformula still doesn't work with import functions. By the way, I marked this other question as duplicate of this one. – Rubén Apr 14 '17 at 3:45
  • wow, ok.. i thought i was doing something wrong but it's good to see it's a google sheet limitation. That's super weird though... why doesn't this work?! – Oneezy Aug 19 '18 at 12:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.