Excel Documentation

Prices

Prices

Returns professional-grade historical stock prices for a security or stock market index. Historical prices are available back to 1996 or the IPO date, with some companies with data back to the 1970s. Stock market index historical price data is available back to the 1950s at the earliest.

Parameters

Name Description Example
identifier
* required
The stock market ticker symbol associated with the companies common stock securities or the stock market index. AAPL
item
The selected observation of the historical prices.
Options:
date
open
high
low
close
volume
ex_dividend
split_ratio
adj_open
adj_high
adj_low
adj_close
adj_volume
close
start_date
The first date in which historical stock prices are delivered- historical daily prices go back to 1996 for most companies, but some go back further to the 1970s or to the date of the IPO. 2014-09-28
end_date
The last date in which historical stock prices are delivered- end of day prices are available around 5 p.m. EST and real-time prices are updated every minute throughout the trading day. 2015-09-28
frequency
The frequency of the historical prices.
Options:
daily
weekly
monthly
quarterly
yearly
daily
sequence
* required
An integer 0 or greater for calling a single historical data point from the first entry, based on sort order. 0
identifier
* required
The stock market ticker symbol associated with the companies common stock securities or the stock market index.
item
* required
The selected observation of the historical prices.
start_date
* required
The first date in which historical stock prices are delivered- historical daily prices go back to 1996 for most companies, but some go back further to the 1970s or to the date of the IPO.
end_date
* required
The last date in which historical stock prices are delivered- end of day prices are available around 5 p.m. EST and real-time prices are updated every minute throughout the trading day.
frequency
* required
The frequency of the historical prices.
sequence
* required
An integer 0 or greater for calling a single historical data point from the first entry, based on sort order.

Output Fields

Name Description Type Example
date the date of the stock price historical data date 2016-09-23
open the actual observed first traded stock price on the trading date number 114.42
high the actual observed highest traded stock price on the trading date number 114.79
low the actual observed lowest traded stock price on the trading date number 111.55
close the actual observed last trade stock price on the trading date number 112.71
volume the actual observed number of shares of stock traded between market participants on the trading date number 52481151.0
ex_dividend the nonsplit adjusted dividend per share on the ex-dividend date; not available on index historical prices number 0.0
split_ratio the split factor on the split date - not available on index historical prices number 1.0
adj_open the dividend and split adjusted open price; not available on index historical prices number 114.42
adj_high the dividend and split adjusted high price; not available on index historical prices number 114.79
adj_low the dividend and split adjusted low price; not available on index historical prices number 111.55
adj_close the dividend and split adjusted close price; not available on index historical prices number 112.71
adj_volume the dividend and split adjusted volume; not available on index historical prices number 52481151.0
date
the date of the stock price historical data
open
the actual observed first traded stock price on the trading date
high
the actual observed highest traded stock price on the trading date
low
the actual observed lowest traded stock price on the trading date
close
the actual observed last trade stock price on the trading date
volume
the actual observed number of shares of stock traded between market participants on the trading date
ex_dividend
the nonsplit adjusted dividend per share on the ex-dividend date; not available on index historical prices
split_ratio
the split factor on the split date - not available on index historical prices
adj_open
the dividend and split adjusted open price; not available on index historical prices
adj_high
the dividend and split adjusted high price; not available on index historical prices
adj_low
the dividend and split adjusted low price; not available on index historical prices
adj_close
the dividend and split adjusted close price; not available on index historical prices
adj_volume
the dividend and split adjusted volume; not available on index historical prices