"shares" - The number of outstanding shares. "closeyest" - The previous day's closing price. "changepct" - The percentage change in price since the previous trading day's close. "change" - The price change since the previous trading day's close. "volumeavg" - The average daily trading volume. "datadelay" - How far delayed the real-time data is. "tradetime" - The time of the last trade.
"marketcap" - The market capitalization of the stock. "volume" - The current day's trading volume. "priceopen" - The price as of market open. "price" - Real-time price quote, delayed by up to 20 minutes. For example, use TSE:123 or ASX:XYZ instead of ticker 123.TO or XYZ.AX.Īttribute - The attribute to fetch about ticker from Google Finance and is required if a date is specified.Īttribute is one of the following for real-time data: Note: Reuters Instrument Codes are no longer supported. If the exchange symbol is not specified, GOOGLEFINANCE will use its best judgement to choose one for you. For example, use “NASDAQ:GOOG” instead of “GOOG.” It’s mandatory to use both the exchange symbol and ticker symbol for accurate results and to avoid discrepancies. Ticker - The ticker symbol for the security to consider. GOOGLEFINANCE("NASDAQ:GOOG","price",TODAY()-30,TODAY()) Fetches current or historical securities information from Google Finance.
0 kommentar(er)
