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.