Ticker symbols supported by googlefinance function
The GOOGLEFINANCE function in Google Sheets allows you to lookup the price (or other attribute) of a stock or instrument.
https://support.google.com/docs/answer/3093281?hl=en
However, the documentation for which symbols it supports is sparse.
For example, this fund has a symbol "GB00B59G4Q73", and searching for this in Yahoo finance works.
But neither this nor the symbol "0P0000KSP6.L" works in Google Sheets, giving the error "When evaluating GOOGLEFINANCE, the query for the symbol: 'GB00B59G4Q73' returned no data."
How can I determine if I am using the correct symbol, or if the function does not support this symbol?
here is your "official documentation":
ticker - The ticker symbol for the security to consider.
Note: Reuters Instrument Codes are no longer supported. For example, ticker 123.TO or XYZ.AX would not work. Instead, use TSE:123 or ASX:XYZ.
Recommended: Add an exchange to avoid discrepancies. For example, use “NASDAQ:GOOG” instead of “GOOG." If an exchange is not specified, GOOGLEFINANCE will use its best judgement to choose one for you.
meaning that the best you can do is to go to https://www.google.com/finance and search for your ticker there instead of yahoo or other suppliers that are not supported
but you can always scrape it from yahoo:
=SUBSTITUTE(SPLIT(REGEXEXTRACT(QUERY(IMPORTXML(
"https://uk.finance.yahoo.com/quote/0P0000KSP6.L?p=0P0000KSP6.L&.tsrc=fin-srch", "//*"),
"select Col1
where Col1 contains 'Vanguard FTSE Dev World ex UK Equity Index AccLSE - LSE'
limit 1
offset 8", 0), "GBp(.*)"), "-"), ",", )*1
- Perl Regex fails to compile looking for \object
- Test if elements in a character string could be numeric
- How to remove all but emojis in a (Javascript) string?
- How to remove all characters from string apart from emoji
- How can I find all matches to a regular expression in Python?
- Zip code validation to exclude some formats
- How to allow specific words using javax.validation.constraints.Pattern?
- Create array of regex matches
- Handling complex parentheses structures to get the expected data
- Catching optional content just after a new line
- Regex to compare strings with Umlaut and non-Umlaut variations
- How can I check when there are only opening or closing quotes in PHP to make replacements?
- Regular Expression | Leap Years and More
- Regex date format validation on Java
- How can I replace every instance of a character from 3 groups of characters with just 3 different characters respectively?
- Regex to match 1 or less occurrence of string?
- Getting parts of a URL (Regex)
- Trim trailing spaces before newlines in a single multi-line string in JavaScript
- Only keep this String in Notepad++ (Regex)
- Redirect Youtube channel main page to videos section the proper way using regex
- Regular expression to validate repeating comma-separated groups without trailing comma
- Angular regex validator allows empty value, while the regex clause should demand at least one digit
- Parsing DeepDiff result
- Rewriting HTTP url to HTTPS using regular expression and javascript
- regex to match HTML <p ...> tag starting with a lowercase letter
- String.split() *not* on regular expression?
- How can I find the last occurance of a dot not preceding with a slash?
- How to extract table names and column names from sql query?
- How to use Rust regex on bytes (Vec<u8> or &[u8])?
- How to validate email by whitelist domain regex