4

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
4
  • So what’s your question?
    – Alex
    Sep 28, 2013 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, 2013 at 6:24
  • @Chris: Please, create a demo spreadsheet and share it for view only with anyone with the link. Jan 22, 2016 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, 2016 at 0:32

2 Answers 2

3

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

4
  • A change make to Google Sheets on early weeks of 2017 makes that arrayformula now works on SPLIT Apr 14, 2017 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 Apr 14, 2017 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. Apr 14, 2017 at 3:45
  • 1
    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, 2018 at 12:25
-2

This article says that can be achieved by writing an app script that then takes the importxml xpath as array driving down the column row by row producing the results in the desired column. https://stackoverflow.com/questions/33147567/how-to-place-importxml-result-to-a-google-script-array

1
  • Welcome to Web Applications! Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference.
    – Glorfindel
    Jul 23, 2021 at 10:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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