Yahoo Finance - Get Started

	B	C	D	E	F	G	H	I	J	K	L	M	N
1			Import Yahoo Finance stock data
2			Collect and track +200 stock indicators from Yahoo Finance with Google Sheets.
3
4
5	➊	Install ImportFromWeb		INSTALL
6
7	➋	Copy this spreadsheet and activate ImportFromWeb		MAKE A COPY
8
9	< Expand to learn more
17
18
19		💡	✓ ImportFromWeb has fetched your data
20
21	➍	Add your stock symbols		Load examples
22			link	marketCap	dividend	dividendDate	eps	bid	dayLow	dayHigh	volume	earningsDate	shortRatio
23		AAP	https://finance.yahoo.com/quote/AAP	3,212,990,720	1	2026-01-23	-10.22	50000	52.39	53.88	1056229	2025-10-30
24		TSLA	https://finance.yahoo.com/quote/TSLA	1,485,776,355,328	--	--	1.43	200	431.12	447.91	87062787	2026-01-28
25		VZ	https://finance.yahoo.com/quote/VZ	172,388,548,608	2.76	2025-11-03	4.69	80000	40.75	40.96	701147	2026-01-27
26		MSFT	https://finance.yahoo.com/quote/MSFT	3,551,046,664,192	3.64	2025-12-11	14.05	500	475.2	484.24	33458975	2026-01-28
27		SMTC	https://finance.yahoo.com/quote/SMTC	6,797,992,448	--	--	0.56	200	71.21	75.4	1797131	2025-11-24
28		SRPT	https://finance.yahoo.com/quote/SRPT	2,236,158,464	--	--	-2.83	200	20.76	21.38	1317829	2025-11-03
29		ARWR	https://finance.yahoo.com/quote/ARWR	8,997,109,760	--	--	-0.01	2100	58.63	66.23	4366974	2026-02-09
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107