Google sheets ImportHTML table data

user_4625492 0
Viewed 58

so im trying to import data from openinsider.com this site provides information about insiders buying and selling stock in a company etc.

to pull the data need im using this =IMPORTHTML(A3,"table",12)

the html is in A3 - http://openinsider.com/search?q=GM

what i would like is for 'GM' to be easily changed to another ticker such as 'MSFT' by typing it into cell B1 is this possibe?

enter image description here

google-sheets-formula google-sheets
2 Answers

You should use concatenation

=CONCAT("http://openinsider.com/search?q=",B1)
user_5689530

Using & operator will do:

=IMPORTHTML("http://openinsider.com/search?q="&B1,"table")

enter image description here

user_158978610
Related