| A | B | C | D | |
|---|---|---|---|---|
1 | Symbol | NYSE:CRM | 11/30/2025 | https://www.lexnetcg.com/blog/google-sheets/googlefinance-function/ |
2 | ||||
3 | Attribute | Result | Formula Used | Attribute Meaning |
4 | price | 230.54 | =GOOGLEFINANCE($B$1,A4) | Real-time price quote, delayed by up to 20 minutes. |
5 | priceopen | 229 | =GOOGLEFINANCE($B$1,A5) | The price as of market open. |
6 | high | 232.56 | =GOOGLEFINANCE($B$1,A6) | The current day's high price. |
7 | low | 228.63 | =GOOGLEFINANCE($B$1,A7) | The current day's low price. |
8 | volume | 3691505 | =GOOGLEFINANCE($B$1,A8) | The current day's trading volume. |
9 | marketcap | 219474100000 | =GOOGLEFINANCE($B$1,A9) | The market capitalization of the stock. |
10 | tradetime | 11/28/2025 13:00:06 | =GOOGLEFINANCE($B$1,A10) | The time of the last trade. |
11 | datadelay | 0 | =GOOGLEFINANCE($B$1,A11) | How far delayed the real-time data is. |
12 | volumeavg | 8091071 | =GOOGLEFINANCE($B$1,A12) | The average daily trading volume. |
13 | pe | 33.45 | =GOOGLEFINANCE($B$1,A13) | The price/earnings ratio. |
14 | eps | 6.89 | =GOOGLEFINANCE($B$1,A14) | The earnings per share. |
15 | high52 | 369 | =GOOGLEFINANCE($B$1,A15) | The 52-week high price. |
16 | low52 | 221.96 | =GOOGLEFINANCE($B$1,A16) | The 52-week low price. |
17 | change | 2.39 | =GOOGLEFINANCE($B$1,A17) | The price change since the previous trading day's close. |
18 | beta | 1.19 | =GOOGLEFINANCE($B$1,A18) | The beta value. |
19 | changepct | 1.05 | =GOOGLEFINANCE($B$1,A19) | The percentage change in price since the previous trading day's close. |
20 | closeyest | 228.15 | =GOOGLEFINANCE($B$1,A20) | The previous day's closing price. |
21 | shares | 952000000 | =GOOGLEFINANCE($B$1,A21) | The number of outstanding shares. |
22 | currency | USD | =GOOGLEFINANCE($B$1,A22) | The currency in which the security is priced. Currencies don't have trading windows, so open, low, high, and volume won't return for this argument. |