I want to create a graph with different stock values starting and ending at a certain day. To do that I create a table like this:


Where the first column is the market and the second one is the ticker of the company. Under both of them is the name of the company combined in two cells.

Now, I want to make a call to Google Finance to get all the stock values daily since a date specified in other cell and sheet:

=GoogleFinance(""&A1&":"&B1; "price"; Stocks!A28; TODAY())

This returns X rows x 2 columns with the headers Date and Close. i.e:


What can I do to remove the header row, "Date" and "Close", from the table?

I saw another question using the function INDEX to return a value of the array, but I think it only returns one single value and is not possible to return a lot of them starting with an offset:

 =INDEX(GoogleFinance(""&A1&":"&B1; "price"; Stocks!A28; TODAY());2;2)

I also tried using FILTER or OFFSET but I don't know if they just don't work for this or I'm doing something wrong.


1 Answer 1


Please try:

=query(GoogleFinance(""&G1&":"&H1; "price"; Stocks!A28; TODAY());"select * label Col1 '', Col2''")



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