GOOGLEFINANCE Examples*
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABC
1
SymbolCRM
2
3
AttributeResultFormula
4
priceopen150.34=GOOGLEFINANCE($B$1,A4)
5
high151.38=GOOGLEFINANCE($B$1,A5)
6
low147.4=GOOGLEFINANCE($B$1,A6)
7
volume5203299=GOOGLEFINANCE($B$1,A7)
8
marketcap113946747665=GOOGLEFINANCE($B$1,A8)
9
tradetime1/22/2019 16:01:12=GOOGLEFINANCE($B$1,A9)
10
datadelay0=GOOGLEFINANCE($B$1,A10)
11
volumeavg6686195=GOOGLEFINANCE($B$1,A11)
12
pe139.65=GOOGLEFINANCE($B$1,A12)
13
eps1.07=GOOGLEFINANCE($B$1,A13)
14
high52161.19=GOOGLEFINANCE($B$1,A14)
15
low52102.37=GOOGLEFINANCE($B$1,A15)
16
change-3.56=GOOGLEFINANCE($B$1,A16)
17
beta1.27=GOOGLEFINANCE($B$1,A17)
18
changepct-2.33=GOOGLEFINANCE($B$1,A18)
19
closeyest152.51=GOOGLEFINANCE($B$1,A19)
20
shares765000000=GOOGLEFINANCE($B$1,A20)
21
currencyUSD=GOOGLEFINANCE($B$1,A21)
22
Loading...
Main menu