| A | B | C | D | |
|---|---|---|---|---|
1 | Symbol | NYSE:CRM | 9/21/2025 | https://www.lexnetcg.com/blog/google-sheets/googlefinance-function/ |
2 | ||||
3 | Attribute | Result | Formula Used | Attribute Meaning |
4 | price | 247.09 | =GOOGLEFINANCE($B$1,A4) | Real-time price quote, delayed by up to 20 minutes. |
5 | priceopen | 246.02 | =GOOGLEFINANCE($B$1,A5) | The price as of market open. |
6 | high | 247.2 | =GOOGLEFINANCE($B$1,A6) | The current day's high price. |
7 | low | 243.35 | =GOOGLEFINANCE($B$1,A7) | The current day's low price. |
8 | volume | 11813947 | =GOOGLEFINANCE($B$1,A8) | The current day's trading volume. |
9 | marketcap | 235229701222 | =GOOGLEFINANCE($B$1,A9) | The market capitalization of the stock. |
10 | tradetime | 9/19/2025 16:00:08 | =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 | 10133343 | =GOOGLEFINANCE($B$1,A12) | The average daily trading volume. |
13 | pe | 35.85 | =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 | 226.48 | =GOOGLEFINANCE($B$1,A16) | The 52-week low price. |
17 | change | 2.81 | =GOOGLEFINANCE($B$1,A17) | The price change since the previous trading day's close. |
18 | beta | 1.22 | =GOOGLEFINANCE($B$1,A18) | The beta value. |
19 | changepct | 1.15 | =GOOGLEFINANCE($B$1,A19) | The percentage change in price since the previous trading day's close. |
20 | closeyest | 244.28 | =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. |