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)
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
|