Google
Search results
Learn how to use the Google Finance API to access real-time financial market data, such as stock quotes, indices, currencies, and news. See the API parameters, examples, and full response for different types of queries.
- Sample Usage
- Syntax
- Notes
- GeneratedCaptionsTabForHeroSec
GOOGLEFINANCE("NASDAQ:GOOG", "price", DATE(2014,1,1), DATE(2014,12,31), "DAILY") GOOGLEFINANCE("NASDAQ:GOOG","price",TODAY()-30,TODAY()) GOOGLEFINANCE(A2,A3)
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]) 1. ticker - The ticker symbol for the security to consider. It’s mandatory to use both the exchange symbol and ticker symbol for accurate results and to avoid discrepancies. For example, use “NASDAQ:GOOG” instead of “GOOG.” 1.1. If the exchange symbol is not specified...
Usage restrictions: The data is not for financial industry professional use or use by other professionals at non-financial firms (including government entities). Professional use may be subject to additional licensing fees from a third-party data provider. 1. All parameters must be enclosed in quotation marks or be references to cells containing te...
Learn how to use GOOGLEFINANCE function to fetch securities information from Google Finance in Google Sheets. See syntax, attributes, examples and usage restrictions for real-time and historical data.
Google Finance provides real-time market quotes, international exchanges, up-to-date financial news, and analytics to help you make more informed trading and investment decisions.
May 14, 2021 · Learn how to use Google Finance API in Google Sheets and discover nine other platforms that offer financial data and analysis. Compare the pros and cons of Quandl, Yahoo Finance API, Interactive Brokers, Alpha Vantage and more.
- Google Finance API was a tool which allowed us to extract data about stocks and financial assets from Google Finance. It isn’t supported by Google...
- On Google Sheets: =GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
- On Google Sheets: =GOOGLEFINANCE(stock symbol, “pe”)
- On Google Sheets: =GOOGLEFINANCE(stock symbol, “eps”)
- On Google Sheets: =GOOGLEFINANCE(stock symbol, “beta”)
- 1) Quandl 2) Yahoo Finance API 3) Interactive Brokers 4) Alpha Vantage 5) TradingView 6) Investors Exchange (IEX) 7) Currencylayer API 8) Tradier A...
Feb 9, 2009 · In order to find chart data using the financial data API of Google, one must simply go to Google as if looking for a search term, type finance into the search engine, and a link to Google finance will appear.
Jun 26, 2008 · The Google Finance API makes it easy to create and access investment data for your users -- ranging from updating their investment holdings and watchlists to retrieving current portfolio value and performance.
Aug 11, 2022 · What is the Google Finance API, and what can it be used for? The Google Finance API was an application programming interface designed around Google Finance that allowed developers and any other users to access stock data included on the Google
