Yahoo Finance
WebToSheets pulls a live quote for any ticker, including its price, change, day and 52-week ranges, and volume.
lightbulb
There is no need to write this by hand. Open the sidebar's Formula
Builder, pick Yahoo Finance, and enter the ticker.
Choosing a supported URL
- Page type: a quote page at
/quote/<SYMBOL>. - Domains:
finance.yahoo.comand country variants such asca.finance.yahoo.comoruk.finance.yahoo.com.
A typical Yahoo Finance quote URL looks like this:
https://finance.yahoo.com/quote/AAPLChoosing what to extract
WebToSheets exposes one selector for each field on the quote. For example, you may use the price selector for the latest trade, or 52w_high for the top of the 52-week range:
| Field | Selector | Example value |
|---|---|---|
| Price Current market price |
price
|
182.45 |
| Change Absolute change since previous close |
change
|
0.65 |
| Change % Percentage change since previous close |
change_percent
|
0.36 |
| Previous close Previous close price |
previous_close
|
181.80 |
| Close Closing price |
close
|
181.80 |
| Open Today's opening price |
open
|
180.50 |
| Day high Day high |
high
|
184.20 |
| Day low Day low |
low
|
180.10 |
| 52-week high 52-week high |
52w_high
|
199.62 |
| 52-week low 52-week low |
52w_low
|
164.08 |
| Volume Trading volume |
volume
|
48250000 |
| Company name Company name |
name
|
Apple Inc. |
| Symbol Ticker symbol |
symbol
|
AAPL |
| Currency Trading currency |
currency
|
USD |
| Exchange Exchange name |
exchange
|
NasdaqGS |
| Timezone Market timezone |
timezone
|
EST |
Tracking a price
To track a stock's price and daily move, you may pass the price and change_percent selectors:
=SCRAPE("https://finance.yahoo.com/quote/AAPL", "price,change_percent")As you can see, WebToSheets returns the live price and percentage change across two columns:
A
B
1
|
182.45
+0.36%
fx
Still stuck?
We usually reply within 24 hours on business days.