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,824,037,376	1	2025-10-24	-10	200	60.94	63.75	872577	2025-11-13
24		TSLA	https://finance.yahoo.com/quote/TSLA	1,345,824,096,256	--	--	1.66	100	414.3	425.7	102824287	2025-10-22
25		VZ	https://finance.yahoo.com/quote/VZ	184,759,140,352	2.76	2025-11-03	4.3	2400	43.81	44.25	5004287	2025-10-21
26		MSFT	https://finance.yahoo.com/quote/MSFT	3,810,465,939,456	3.32	2025-09-11	13.67	300	507	514.22	7371755	2025-10-29
27		SMTC	https://finance.yahoo.com/quote/SMTC	5,360,897,536	--	--	0.63	200	59.71	61.78	321635	2025-11-25
28		SRPT	https://finance.yahoo.com/quote/SRPT	1,809,255,552	--	--	-0.68	100	17.23	18.27	2535775	2025-11-05
29		ARWR	https://finance.yahoo.com/quote/ARWR	3,955,561,472	--	--	-1.2	100	28.46	29.91	1124521	2025-08-07
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