Avinash K
Reputation: 53
How to use Google Finance to fetch stock data when the column contains stock ticker?
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
Upvotes: 1
Views: 1572
Answers (1)
Related Questions
- How to get the price of a stock at a particular date from Google Finance?
- Ticker symbols supported by googlefinance function
- How to find the return of stock Tickers in rows of dataframe?
- How to get a ticker symbol from a company name with the Google Finance API?
- Using INDEX to only show the prices of a stock using the GoogleFinance function in Google Sheets
- fetching stock ticker data from yahoo finance
- Fetch API information for stocks with ^ in the ticker name
- How To Return Query For Name of Stock Ticker From Corporation Name In R
- fetch google finance data
- How to get data using Google finance API