Finance

How to track Dow stocks in Google Sheets via Google Finance | Gwinnett Daily Post The Street Partner Content


The Dow Jones Industrial Average is a key barometer of the U.S. stock market. Its 30 component stocks — such as Apple (AAPL) , Boeing  (BA) , JPMorgan Chase  (JPM) , and Walmart  (WMT)  — are a narrow representation of major industries in the U.S. economy. 

Now, you can track one of the most widely followed equity indexes in the U.S. in real-time using Google Finance imported into Google Sheets. TheStreet has created a dynamic spreadsheet that updates throughout the trading day, and you can track basic data such as price, percent change, and market capitalization.


This page requires Javascript.

Javascript is required for you to be able to read premium content. Please enable it in your browser settings.

kA 2=:8?lQ46?E6CQmkDEC@?8mk2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^9@H\E@^9@H\E@\AC@E64E\52E2\:?\8@@8=6\D966EDQm#6=2E65i w@H E@ AC@E64E 52E2 😕 v@@8=6 $966EDi !C6G6?E:?8 244:56?E2= 492?86Dk^2mk^DEC@?8mk^Am

kAmw6C6’D 9@H H6 DECF4EFC65 2 DAC625D966E 7@C J@F E@ EC24< E96 4@>A@?6?ED @7 E96 s@H E9C@F89@FE E96 EC25:?8 52J] *@F 42? D@CE 6249 DE@4< 3J ?2>6[ A6C46?E 492?86[ 2?5 >2C<6E 42A:E2=:K2E:@?] *@F 42? 2=D@ 5@H?=@25 E96 DAC625D966E 2?5 4FDE@>:K6 :E J@FCD6=7]k^Am

kAmkDEC@?8m%96 DAC625D966E G6CD:@? @7 E9:D EFE@C:2= 42? 36 5@H?=@2565 k2 9C67lQ9EEADi^^5@4D]8@@8=6]4@>^DAC625D966ED^5^`>B0y#u+acIbKIa!ez(D;D)y\|=s24`h|z@5G:}\x~r4^65:ER8:5la`_fc`ehghQm96C6k^2m] |2<6 2 4@AJ @7 E96 H@C<D966E 3J D6=64E:?8 Q|2<6 2 4@AJQ 7C@> E96 5C@A\5@H? 😕 E96 u:=6 >6?F]k^DEC@?8mk^Am

k9amw@H E@ FD6 E9:D EC24<6Ck^9am

kAmv@@8=6 u:?2?46 2==@HD J@F E@ D6=64E DA64:7:4 2EEC:3FE6D DF49 2D E96 =2E6DE AC:46[ :?EC252J 9:89 2?5 =@H[ 2?5 52:=J AC:46 492?86 E@ >@?:E@C 2 A2CE:4F=2C DE@4<] x? E9:D DAC625D966E[ H6’G6 =:DE65 E96 a_ 2G2:=23=6 2EEC:3FE6D 7@C C62=\E:>6 >@?:E@C:?8 😕 2? k2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^9@H\E@^9@H\E@\4C62E6\5C@A5@H?\8@@8=6\D966EDQm:?\46== 5C@A\5@H? =:DEk^2m] k^Am

kAm%96 7:CDE 4@=F>? Wr@=F>? pX @? E96 =67E =:DED E96 E:4<6C DJ>3@=D @7 E96 s@H DE@4<D[ 2?5 E96 D6G6? DF446DD:G6 4@=F>?D E@ E96 C:89E Wr@=F>?D q E@ xX 5672F=E E@ D6G6? 2EEC:3FE6Di “?2>6” W4@>A2?J ?2>6X[ “AC:46” W=2E6DE 2G2:=23=6 AC:46X[ “492?86” W492?86 😕 5@==2C G2=F6X[ “492?86A4E” WA6C46?E 492?86X[ “9:89” W:?EC252J 9:89 AC:46X[ “=@H” W:?EC252J =@H AC:46X[ “EC256E:>6” WEC25:?8 E:>6 @7 =2E6DE AC:46X[ 2?5 “>2C<6E42A” W>2C<6E 42A:E2=:K2E:@? 😕 5@==2CDX]k^Am

kAmt249 @7 E9@D6 D6G6? 4@=F>?D 92D 2? :?\46== 5C@A\5@H? =:DE E92E J@F 42? 492?86 E@ 2?J @7 E96 @E96C a_ 2EEC:3FE6D]k^Am

kAm%@ 96=A G:DF2=:K6 E96 52E2[ H6 2AA=:65 k2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^9@H\E@^9@H\E@\FD6\4@?5:E:@?2=\7@C>2EE:?8\:?\8@@8=6\D966EDQm4@?5:E:@?2= 7@C>2EE:?8k^2m @? D@>6 @7 E96 2EEC:3FE6D[ ?2>6=J “492?86[” “492?86A4E[” 2?5 “>2C<6E42A]” u@C “492?86” 2?5 “492?86A4E[” 2? :?4C62D6 😕 E96 52:=J 492?86 😕 AC:46 9:89=:89ED E96 46== 😕 8C66?[ 2?5 2 564C62D6 9:89=:89ED E96 46== 😕 C65] }@ 492?86 <66AD E96 46== H9:E6]k^Am

kAmu@C “>2C<6E42A[” E96 >2C<6E G2=F6D @7 E96 b_ s@H DE@4<D E2<6 2 4@=@C 8C25:6?E[ C2?8:?8 7C@> 52C< J6==@H 7@C E96 4@>A2?:6D H:E9 E96 =2C86DE 42A:E2=:K2E:@? D9@H? 2E E96 E@A @7 E96 4@=F>? E@ 3C:89E J6==@H 7@C E96 D>2==6DE 2E E96 3@EE@>]k^Am

kAm%@ >2:?E2:? E96 :?E68C:EJ @7 E96 >24C@D FD65 😕 E96 DAC625D966E[ “492?86A4E” 2?5 “>2C<6E42A” Wr@=F>?D t 2?5 xX 2C6 k2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^9@H\E@^9@H\E@\AC@E64E\52E2\:?\8@@8=6\D966EDQmAC@E64E65k^2m 3642FD6 492?8:?8 E96 2EEC:3FE6 @7 6:E96C 😕 E96:C C6DA64E:G6 4@=F>? H:== =:<6=J =625 E@ 2 5:776C6?E @FE4@>6 H96? CF??:?8 E96:C >24C@D]k^Am

kD64E:@?mk7:8FC6mk:>8 DC4lQ9EEADi^^HHH]E96DEC66E]4@>^]:>286^407:ETar90g__TarH0`a__^|;p_~s*b|;*_}K<I}s&`|Kxa^5@H\492?86]A?8Q 96:89ElQefdQ H:5E9lQ`a__Q ^mk7:842AE:@?mkAm%96 <6J3@2C5 D9@CE4FED “r@>>2?5 Z ~AE:@? Z $9:7E Z a” 2?5 “r@>>2?5 Z ~AE:@? Z $9:7E Z b” D@CE E96 s@H DE@4<D 3J A6C46?E 492?86]k^AmkAm k^AmkAm k^Amk^7:842AE:@?mk^7:8FC6mk5:Gmk6>m’:6H E96 b :>286D @7 E9:D 82==6CJ @? E96 k2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^:?G6DE:?8^DE@4<D^9@H\E@\EC24<\5@H\DE@4<D\:?\8@@8=6\D966ED\G:2\8@@8=6\7:?2?46Qm@C:8:?2= 2CE:4=6k^2mk^6>mk^5:Gmk^D64E:@?m

k9am#F??:?8 E96 >24C@Dk^9am

kAm*@F 42? @A6C2E6 E96 >24C@D FD:?8 E96 5C@A\5@H? >6?F @C FD:?8 <6J3@2C5 D9@CE4FED] &?56C “tIE6?D:@?D” 😕 E96 >6?F 32C @7 E96 DAC625D966E[ 8@ E@ “|24C@D[” 2?5 2 =:DE @7 E96 >24C@D H:== 2AA62C 😕 E96 3@EE@> D64E:@? @7 E96 5C@A\5@H?] k^Am

kAm%96 ?2>6 @7 E96 >24C@ 😀 =:DE65 E@ E96 =67E[ 2?5 :ED <6J3@2C5 D9@CE4FE WH92E <6JD E@ FD6X 😀 =:DE65 E@ E96 C:89E] %96 >24C@D @? E9:D DAC625D966E 7@4FD @? D@CE:?8 52E2 3J 4@=F>?]k^Am

kAmp=E6C?2E:G6=J[ J@F 42? FD6 <6J3@2C5 D9@CE4FED] ~? E96 |24 ~$[ E96 <6J3@2C5 D9@CE4FED 2C6 2D 7@==@HDik^Am

k3=@4<BF@E6mkAmr@>>2?5 Z ~AE:@? Z $9:7E Z ` — }2>6 WpD46?5:?8Xk^Amk^3=@4<BF@E6m

k3=@4<BF@E6mkAmr@>>2?5 Z ~AE:@? Z $9:7E Z a — $@CE 3J T r92?86 Ww:896DE E@ {@H6DEXk^Amk^3=@4<BF@E6m

k3=@4<BF@E6mkAmr@>>2?5 Z ~AE:@? Z $9:7E Z b — $@CE 3J T r92?86 W{@H6DE E@ w:896DEXk^Amk^3=@4<BF@E6m

k3=@4<BF@E6mkAmr@>>2?5 Z ~AE:@? Z $9:7E Z c — $@CE 3J |2C<6E r2A:E2=:K2E:@? W{2C86DE E@ $>2==6DEXk^Amk^3=@4<BF@E6m

kAm%96 7:CDE >24C@ 2==@HD J@F E@ D@CE E96 s@H DE@4<D 3J ?2>6 😕 r@=F>? q] p7E6C CF??:?8 E96 >24C@[ b| 😀 2E E96 E@A[ (2=E s:D?6J r@>A2?J 😀 2E E96 3@EE@>[ 2?5 2== @7 E96 52E2 7C@> pa E@ xb` >@G6 4@CC6DA@?5:?8=J 😕 E96 52E2 D@CE]k^Am

kAm%96 D64@?5 >24C@ D@CED E96 52E2 3J A6C46?E 492?86 7C@> 9:896DE E@ =@H6DE] x? E9:D 7F?4E:@?[ DE@4<D H:E9 E96 =2C86DE A6C46?E :?4C62D6D 2C6 2E E96 E@A[ 2?5 E9@D6 H:E9 E96 =@H6DE :?4C62D6D @C =2C86DE A6C46?E 564C62D6D 2C6 2E E96 3@EE@>] k^Am

kAm%96 E9:C5 >24C@ 😀 E96 :?G6CD6 @7 E96 D64@?5 2?5 D@CED 7C@> =@H6DE E@ 9:896DE A6C46?E 492?86] WxE >2<6D D6?D6 E@ D@CE 3J A6C46?E 492?86 C2E96C E92? AC:46 492?86 3642FD6 A6C46?E 492?86 D9@HD 9@H DE@4< AC:46D 92G6 492?865 C6=2E:G6 E@ E96:C AC6G:@FD 4=@D:?8 AC:46D]X k^Am

kAm%96 7@FCE9 >24C@ D@CED 4@>A2?:6D 3J >2C<6E 42A:E2=:K2E:@?[ H:E9 E96 =2C86DE @?6D 2AA62C:?8 2E E96 E@A]k^Am

kAm(96? J@F 86E FD65 E@ CF??:?8 >24C@D[ J@F 42? 4C62E6 2 7:7E9 >24C@ 3J D@CE:?8 E96 s@H DE@4<D 3J >2C<6E 42A:E2=:K2E:@? 7C@> D>2==6DE E@ =2C86DE] ~C[ 4C62E6 >24C@D E@ 4FDE@>:K6 9@H J@F H2?E E@ D9@H E96 52E2]k^Am

kAmpG@:5 >2<:?8 492?86D E@ E96 DAC625D966E 3642FD6 2?J 492?86 H:== =:<6=J 27764E E96 @FE4@>6 @7 CF??:?8 E96 >24C@D] |24C@D CF? 32D65 @? E96 DAC625D966E’D 46== C2?86 7C@> pa E@ xb` W96256CD 2C6?’E 27764E65 F?=6DD E96C6 2C6 492?86D E@ E96 2EEC:3FE6D @? E96 5C@A\5@H? =:DEX]k^Am

kAmw@H6G6C[ J@F 42? >2<6 492?86D E@ E96 2EEC:3FE6D 7@C D@>6 @7 E96 4@=F>?D[ DF49 2D “AC:46[” “492?86[” “9:89[” “=@H[” 2?5 “EC256E:>6]” x7 J@F 5@ H2?E E@ 4FDE@>:K6 E96 DAC625D966E 3J 255:?8 4@=F>?D @7 5:776C6?E 2EEC:3FE6D[ 4@?D:56C 65:E:?8 E96 >24C@D E@ 244@>>@52E6 492?86D 😕 E96 46== C2?86]k^Am

kAm}@E6 E92E v@@8=6 u:?2?46 AFED 2 5:D4=2:>6C 2E E96 3@EE@> @7 E96 DAC625D966E E@ :?7@C> FD6CD @7 E96 =:>:E2E:@?D 2?5 FD286 @7 E96 DE@4< 52E2i “”F@E6D 2C6 ?@E D@FC465 7C@> 2== >2C<6ED 2?5 >2J 36 56=2J65 FA E@ a_ >:?FE6D] x?7@C>2E:@? 😀 AC@G:565 V2D :DV 2?5 D@=6=J 7@C :?7@C>2E:@?2= AFCA@D6D[ ?@E 7@C EC25:?8 AFCA@D6D @C 25G:46]”k^Am

kAm$@[ EC25:?8 @? E9:D :?7@C>2E:@? 😀 2E J@FC @H? C:D<] k^Am

kAmkDEC@?8mp82:?[ H6VG6 2=C625J 5@?6 2== E96 H@C< 7@C J@F] %96 DAC625D966E G6CD:@? @7 E9:D EFE@C:2= 42? 36 k2 9C67lQ9EEADi^^5@4D]8@@8=6]4@>^DAC625D966ED^5^`>B0y#u+acIbKIa!ez(D;D)y\|=s24`h|z@5G:}\x~r4^65:ER8:5la`_fc`ehghQm5@H?=@2565 96C6k^2m] t2D:=J >2<6 2 4@AJ @7 E96 H@C<D966E 3J D6=64E:?8 Q|2<6 2 4@AJQ 7C@> E96 5C@A\5@H? 😕 E96 u:=6 >6?F]k^DEC@?8mk^Am

k9am(2E49 E96 s@H EC24<6C G:56@ EFE@C:2=k^9am

kAmk:7C2>6 H:5E9lQde_Q 96:89ElQb`dQ DC4lQ9EEADi^^HHH]J@FEF36]4@>^6>365^c%|&E>:’xuHQ 7C2>63@C56ClQ_Qmk^:7C2>6mk^Am

kAmkDEC@?8m%9:D 😀 ;FDE @?6 @7 >2?J 2CE:4=6D 23@FE 62DJ\E@\FD6 k2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^:?G6DE:?8^DE@4<D^9@H\E@\EC24<\8@@8=6\7:?2?46\DE@4<\DAC625D966EQmE@@=Dk^2m 😕 v@@8=6 $966ED] $66 D@>6 @7 E96 9:89=:89ED 36=@H 2?5 =6E FD <?@H H92E J@FV5 =:<6 E@ D66 ?6IE] t>2:= FD 96C6i k2 9C67lQ>2:=E@iE@@=DoE962C6?28C@FA]?6EQmE@@=DoE962C6?28C@FA]?6Ek^2mk^DEC@?8mk^Am

kA 2=:8?lQ46?E6CQmkDEC@?8mk2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^:?G6DE:?8^DE@4<D^9@H\E@\EC24<\8@@8=6\7:?2?46\DE@4<\DAC625D966EQm#6=2E65i w@H E@ EC24< DE@4<D 7C@> v@@8=6 u:?2?46 😕 v@@8=6 $966EDk^2mk^DEC@?8mk^Am

kA 2=:8?lQ46?E6CQmkDEC@?8mk2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^:?G6DE:?8^DE@4<D^9@H\E@\4C62E6\2\DE@4<\EC24<6C\H:E9\=:G6\52E2\FD:?8\8@@8=6\7:?2?46Qm#6=2E65i w@H E@ 4C62E6 2 DE@4< EC24<6C H:E9 =:G6 52E2 FD:?8 v@@8=6 u:?2?46k^2mk^DEC@?8mk^Am

kA 2=:8?lQ46?E6CQmkDEC@?8mk2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^9@H\E@^9@H\E@\4C62E6\5C@A5@H?\8@@8=6\D966EDQm#6=2E65i w@H E@ 4C62E6 2? :?\46== 5C@A5@H? =:DE @? v@@8=6 $966EDk^2mk^DEC@?8mk^Am

kA 2=:8?lQ46?E6CQmkDEC@?8mk2 9C67lQ9EEADi^^HHH]E96DEC66E]4@>^9@H\E@^9@H\E@\FD6\4@?5:E:@?2=\7@C>2EE:?8\:?\8@@8=6\D966EDQm#6=2E65i w@H E@ FD6 4@?5:E:@?2= 7@C>2EE:?8 😕 v@@8=6 $966EDi #2?86D[ 7@C>F=2D U2>Aj >@C6k^2mk^DEC@?8mk^Am



Source link

Leave a Reply