Costa Rica Stock Exchange Prices Excel Documentation - Historical data | Intrinio

Costa Rica Stock Exchange Prices

Excel Documentation

Historical Data

Historical Data

Returns the historical stock price data for the security with the specified composite ticker or FIGI.

Function:
=IntrinioHistoricalData(identifier, item, sequence)
Available in Sandbox

Parameters

Name Description Example
identifier
* required
A composite ticker symbol (TICKER:MIC) or FIGI INC:XBNV
item
* required
A stock price data tag (reference) adj_close_price
start_date
The earliest date for which to return data. 2018-04-02
end_date
The latest date for which to return data. 2018-5-03
frequency
The frequency of the historical prices & valuation data.
Options:
daily
weekly
monthly
quarterly
yearly
show more show less
yearly
type
The type of historical data to fetch. For financial statements, the type reflects the type of financial statement. For Sector data, the type reflect the aggretation (mean, median, max, min) type of the data.
Options:
FY
QTR
TTM
YTD
count
sum
max
75thpctl
mean
median
25thpctl
min
show more show less
FY
sequence
* required
An integer 0 or greater for calling a single historical data point from the first entry, based on sort order. 0
show_date
If true, the function will return the date value, and if false the function will return the data point value for a given query.
Options:
Yes
show more show less
Yes
identifier
* required
A composite ticker symbol (TICKER:MIC) or FIGI
item
* required
A stock price data tag (reference)
start_date
* required
The earliest date for which to return data.
end_date
* required
The latest date for which to return data.
frequency
* required
The frequency of the historical prices & valuation data.
type
* required
The type of historical data to fetch. For financial statements, the type reflects the type of financial statement. For Sector data, the type reflect the aggretation (mean, median, max, min) type of the data.
sequence
* required
An integer 0 or greater for calling a single historical data point from the first entry, based on sort order.
show_date
* required
If true, the function will return the date value, and if false the function will return the data point value for a given query.

Output Fields

Name Description Type
identifier A composite ticker symbol (TICKER:MIC) or FIGI -
item A stock price data tag (reference) -
date the date associated with the value -
value the value -
identifier
A composite ticker symbol (TICKER:MIC) or FIGI
item
A stock price data tag (<a href='https://data.intrinio.com/data-tags/edi-stock-prices'>reference</a>)
date
the date associated with the value
value
the value