Returns the closing price for a stock on a specific date

Returns the split and dividend adjusted closing price for a stock

Returns the historical adjusted closing share price for a specified period, accounting for stock splits and dividend adjustments.

Use when user asks for:
- What was the split-adjusted closing price historically?
- Historical adjusted close price for a past period
- Get dividend-adjusted historical prices

Do NOT use when:
- User wants unadjusted historical close price -> use Close_Historical()
- User needs current adjusted price -> use AdjustedClose()
- User wants the adjustment factor itself -> use hf_Share_Factor()

Share Price Adjusted Close (Historical)

Syntax

Examples

When to Use

When NOT to Use

Common Issues & FAQ

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Related Functions