Daily History
Returns daily historical price data (Open, High, Low, Close, Volume) for a stock using QuoteMedia's data service.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | Stock ticker symbol |
Output Columns
| Column | Description |
|---|---|
| Date | Trading date |
| Open | Opening price |
| High | Day's high price |
| Low | Day's low price |
| Close | Closing price |
| Volume | Trading volume |
Notes
- Returns daily (end-of-day) data
- Data spills into multiple cells
- Typically returns several months of history
Examples
=QM_GetHistory("AAPL")=QM_GetHistory("SPY")=QM_GetHistory("MSFT")=QM_GetHistory(A1)When to Use
- Historical price analysis
- Building charts in Excel
- Backtesting strategies
- Technical analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need intraday data | QM_GetIntradayDataFiveMinutes() |
| Need 1-hour bars | QM_GetIntradayDataOneHour() |
| Need specific date range | QM_List() with date parameters |
| Need single historical close | Close_Historical() |
Common Issues & FAQ
Q: How much history is returned?
A: Typically several months to a year of daily data. For longer history or specific date ranges, use QM_List().
Q: Why is the data not showing? A: Ensure you have enough empty cells for the data to spill into. The array needs space below and to the right.
Q: How do I get intraday data?
A: Use QM_GetIntradayDataFiveMinutes(), QM_GetIntradayDataOneHour(), or other intraday functions.
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?