| A | B | C | D | |
|---|---|---|---|---|
1 | Symbol | NYSE:CRM | 12/1/2025 | https://www.lexnetcg.com/blog/google-sheets/googlefinance-function/ |
2 | ||||
3 | Attribute | Result | Formula Used | Attribute Meaning |
4 | price | 232.44 | =GOOGLEFINANCE($B$1,A4) | Real-time price quote, delayed by up to 20 minutes. |
5 | priceopen | 228.67 | =GOOGLEFINANCE($B$1,A5) | The price as of market open. |
6 | high | 234.25 | =GOOGLEFINANCE($B$1,A6) | The current day's high price. |
7 | low | 228.6 | =GOOGLEFINANCE($B$1,A7) | The current day's low price. |
8 | volume | 3473903 | =GOOGLEFINANCE($B$1,A8) | The current day's trading volume. |
9 | marketcap | 221416161743 | =GOOGLEFINANCE($B$1,A9) | The market capitalization of the stock. |
10 | tradetime | 12/1/2025 15:53:10 | =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 | 7385131 | =GOOGLEFINANCE($B$1,A12) | The average daily trading volume. |
13 | pe | 33.76 | =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 | 1.9 | =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 | 0.82 | =GOOGLEFINANCE($B$1,A19) | The percentage change in price since the previous trading day's close. |
20 | closeyest | 230.54 | =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. |