How to use Google Finance to fetch stock data when the column contains stock ticker?

Question

The B3 cell contains the stock ticker symbol say TCS. When i try to execute

=GOOGLEFINANCE("NSE:B3","PRICE")

The formula is giving error "When evaluating GOOGLEFINANCE, the query for the symbol: 'B3' returned no data." I want TCS to be used instead of B3. Can you suggest

score 1 · Answer 1 · edited Feb 04 '22 at 00:19

1

Try this instead:

=GOOGLEFINANCE("NSE:"&B3,"PRICE")

edited Feb 04 '22 at 00:19

Dharman

30,962
25
85
135

answered Feb 04 '22 at 00:13

Lorena Gomez

1,946
2
4
11

How to use Google Finance to fetch stock data when the column contains stock ticker?

1 Answers1