Google Finance - 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.

Google Online Preview   Download