I'm trying to get the googlefinance formula to work for multiple country exchanges.

e.g. Tencent is listed on Hong Kong stock exchange, the code is 0700.

If I put =googlefinance(HKG:0700,"price"), it works, but I want to link the 0700 part to another cell, so it will look like =googlefinance(HKG:A2,"price").

But I can't type A2 physically, because it will not be treated as taking the content of cell A2.

1 Answer 1


Use string concatenation with &:


enter image description here

Note that I had to put '0700 in A2, or change the cell format to 'plain text'; just typing in 0700 will result in Google Sheets converting it automatically to 700.

Your Answer

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

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