Price Range Current Day
Returns a formatted string showing the day's trading range from low to high.
Return Format
Returns a string in the format: "Low - High" Example: "185.20 - 188.50"
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
Notes
- Returns a formatted string, not a number
- For numeric values, use
DaysLow()andDaysHigh()separately - Data is typically delayed 15 minutes
Syntax
=DaysRange(Symbol)Examples
When to Use
- Displaying formatted trading range
- Quick overview of day's price movement
- Building quote displays and dashboards
- Reports requiring range format
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need low value only | DaysLow() |
| Need high value only | DaysHigh() |
| Need numeric range | =DaysHigh()-DaysLow() |
| Historical range | Historical functions |
Common Issues & FAQ
Why can't I do math with this result?
DaysRange() returns a formatted string. For calculations, use DaysLow() and DaysHigh() separately.
How do I calculate the numeric range?
Use =DaysHigh("AAPL")-DaysLow("AAPL") to get the range as a number.
What if I need to parse the low and high values?
It's better to use DaysLow() and DaysHigh() directly for numeric operations.
Related Formulas
More MarketXLS Price Quotes formulas you can use in the same worksheet:
- QM Ask Size
- QM Get Recent Option Stats Dynamic
- Quote DateTime (On Demand)
- Raw Ask Size
- Raw Bid Size
- Share Volume
- Strike (On Demand)
- Today's Volume
See DaysRange used in a complete workbook: Google Sheets Stock Price: How to Get Real-Time Stock Quotes Beyond GOOGLEFINANCE
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?