![giggle finance giggle finance](https://mountainside.com/wp-content/uploads/2020/10/hello-giggles-logo.png)
"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.
![giggle finance giggle finance](https://gigglefinance.com/wp-content/uploads/2022/06/importance-of-gig-economy-in-boosting-diversity-768x513.png)
"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.
![giggle finance giggle finance](https://images.thenile.io/r1000/9398712248898.jpg)
GOOGLEFINANCE("NASDAQ:GOOG","price",TODAY()-30,TODAY()) Fetches current or historical securities information from Google Finance.