Prices - Excel Documentation | Intrinio

Excel Documentation

We are hiring Software Engineers!   Visit Our Careers Page

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.

Function:
=IntrinioHistoricalPrices(identifier, item, sequence, start_date, end_date, frequency)
Available in Sandbox

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 prices.
Options:
date
open
high
low
close
volume
ex_dividend
split_ratio
adj_open
adj_high
adj_low
adj_close
adj_volume
show more show less
close
start_date
The first date for which to return prices. 2014-09-28
end_date
The last date for which to return prices. 2015-09-28
frequency
The frequency of the historical prices.
Options:
daily
weekly
monthly
quarterly
yearly
show more show less
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 prices.
start_date
* required
The first date for which to return prices.
end_date
* required
The last date for which to return prices.
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
date the date of the stock price historical data date
open the actual observed first traded stock price on the trading date number
high the actual observed highest traded stock price on the trading date number
low the actual observed lowest traded stock price on the trading date number
close the actual observed last trade stock price on the trading date number
volume the actual observed number of shares of stock traded between market participants on the trading date number
ex_dividend the nonsplit adjusted dividend per share on the ex-dividend date; not available on index historical prices number
split_ratio the split factor on the split date - not available on index historical prices number
adj_open the dividend and split adjusted open price; not available on index historical prices number
adj_high the dividend and split adjusted high price; not available on index historical prices number
adj_low the dividend and split adjusted low price; not available on index historical prices number
adj_close the dividend and split adjusted close price; not available on index historical prices number
adj_volume the dividend and split adjusted volume; not available on index historical prices number
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