GoogleFinance Function Attributes - SpreadsheetSolving
[Pages:8]GoogleFinance Function Attributes
Real-time Market Data
Price Priceopen High Low Volume Marketcap Tradetime Datadelay Volumeavg PE
Eps High52 Low52 Change Beta Changepct Closeyest Shares Currency
Mutual Fund Data
CloseYest Date Returnytd Netassets Change Changepct Returnday Return1 Return4 Return13
Return52 Return156 Return 260 Incomedividend 0I.n18comedividenddate Capitalgain Capitalgaindate Morningstarrating Expenseratio Yieldpct
Historical Market Data
Open Close High Low Volume
All
Definitions
Real-time Market Data
Price Priceopen High Low Volume Marketcap Tradetime Datadelay Volumeavg PE Eps High52 Low52 Change Beta Changepct Closeyest Shares Currency
market price of the stock - delayed by up to 20 minutes. opening price of the stock for the current day. highest price the stock traded for the current day. lowest price the stock traded for the current day. number of shares traded of this stock for the current day. market cap of the stock. last time the stock traded. delay in the data using googleFinance() function. average volume for this stock. Price-to-Earnings ratio for this stock. earnings-per-share for this stock. 52-week high for this stock. 52-week low for this stock. change in the stock price since yesterday's market close. beta value of this stock. percent change in the stock price since yesterday's close. yesterday's closing price of this stock. number of shares outstanding of this stock. the currency in which this stock is traded.
Mutual Fund Data
CloseYest Date Returnytd Netassets Change
Changepct Returnday Return1 Return4 Return13 Return52 Return156 Return 260 Incomedividend Incomedividenddate: Capitalgain: Capitalgaindate: Morningstarrating: Expenseratio: Yieldpct
NAV of a mutual fund. date at which NAV (net asset value) was reported. year-to-date return total. day-end net assets of the mutual fund. change in NAV value between most recent reported & prior % change in NAV. one-day total return. one-week total return. four-week total return. thirteen-week total return. 52 week total return. 156 week total return. 260 week total return. amount of the most recent cash distribution for fund. date the above occurred. amount of most recent capital gain distribution from fund. date of above. Morningstar "star" rating.
% of fund assets that pays operating expenses & management fees
Sum of trailing 12-month's income distributions divided by last month's ending NAV, plus capital gains distributed over same period
Historical Market Data
Open Close High Low Volume All
opening price of the stock for the indicated day. closing price of the stock for the indicated day. highest price the stock traded to date. lowest price the stock traded to date. number of shares traded of this stock to date. date/open/close/high/low/volume returned as a table
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- attributes of a real man
- good attributes of a person
- function and function notation problems
- function and function notation
- function keys function windows 10
- function of a function math
- function of a function calculator
- function inside a function python
- function not a function worksheet
- linear function using function notation
- function or not a function worksheet answers
- function and not function examples