![]() "interval" is the parameter to specify the granularity of the imported data.Alternatively, the end-date parameter can be specified as the number of days from the start-date.Skip these parameters to return real-time data. The date should be represented in the format MM/DD/YYYY, for example "" or using one of the date-related functions, for example =DATE(yyyy,mm,dd). "start-date" and "end-date" represent a date span for collecting historical data.Discover all GOOGLEFINANCE function attributes. By default, GOOGLEFINANCE function returns the "price" attribute. For example, the "currency" attribute denotes the currency in which the security ( "ticker-symbol") is priced. "attribute" is the parameter to specify the type of data about "ticker-symbol" to import from Google Finance.on the New York Stock Exchange "USDEUR" is the ticker symbol for the exchange rate of the currency pair US dollar to Euro.Īll other parameters for the GOOGLEFINANCE function are optional: For example, "NYSE:V" is the ticker symbol for Visa Inc. "ticker-symbol" is an abbreviated name for traded securities such as stocks, shares, currency, etc.Is the GOOGLEFINANCE function worth it? GOOGLEFINANCE Google Sheets explained GOOGLEFINANCE syntax in Google SheetsĪccording to the Google official documentation, here is the GOOGLEFINANCE formula syntax: =GOOGLEFINANCE("ticker-symbol", "attribute", "start-date", "end-date", "interval") ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |