"high" - The high price for the specified date(s). "close" - The closing price for the specified date(s). "open" - The opening price for the specified date(s). Currencies don't have trading windows, so open, low, high, and volume won't return for this argument.Īttribute is one of the following for historical data: "currency" - The currency in which the security is priced. "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. Not all futures are supported at this time.Ī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: Use TSE:123 or ASX:XYZ instead of ticker 123.TO or XYZ.AX. 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)
