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	2,920,682,496	1	2026-01-23	-10.22	20000	48.17	50.11	1177088	2025-10-30
24		TSLA	https://finance.yahoo.com/quote/TSLA	1,536,761,266,176	--	--	1.43	200	440.71	466.33	84761112	2026-01-28
25		VZ	https://finance.yahoo.com/quote/VZ	167,560,757,248	2.76	2025-11-03	4.69	7900	38.78	39.96	155967	2026-01-27
26		MSFT	https://finance.yahoo.com/quote/MSFT	3,769,404,751,872	3.64	2025-12-11	14.05	100	506.58	514.83	22927843	2026-01-28
27		SMTC	https://finance.yahoo.com/quote/SMTC	5,857,244,160	--	--	0.63	300	64.2	68.9	995337	2025-11-25
28		SRPT	https://finance.yahoo.com/quote/SRPT	2,513,173,248	--	--	-0.68	4200	23.02	24.48	4491921	2025-11-03
29		ARWR	https://finance.yahoo.com/quote/ARWR	5,573,161,984	--	--	-1.2	100	37.56	40.55	1375484	2025-11-26
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