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
But I can't type
A2 physically, because it will not be treated as taking the content of cell A2.