Skip to main content

INSTITUTIONAL

Get data about institutional ownership for a given company over time.

Syntax

=OBB.EQUITY.OWNERSHIP.INSTITUTIONAL(symbol,[include_current_quarter],[date])

Examples

=OBB.EQUITY.OWNERSHIP.INSTITUTIONAL("AAPL")

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for.True
include_current_quarterBooleanInclude current quarter data.False
dateTextA specific date to get data for.False

Data

NameDescription
symbolSymbol representing the entity requested in the data.
cikCentral Index Key (CIK) for the requested entity.
dateThe date of the data.
investors_holdingNumber of investors holding the stock.
last_investors_holdingNumber of investors holding the stock in the last quarter.
investors_holding_changeChange in the number of investors holding the stock.
numberOf13FsharesNumber of 13F shares.
lastNumberOf13FsharesNumber of 13F shares in the last quarter.
numberOf13FsharesChangeChange in the number of 13F shares.
total_investedTotal amount invested.
last_total_investedTotal amount invested in the last quarter.
total_invested_changeChange in the total amount invested.
ownership_percentOwnership percent.
last_ownership_percentOwnership percent in the last quarter.
ownership_percent_changeChange in the ownership percent.
new_positionsNumber of new positions.
last_new_positionsNumber of new positions in the last quarter.
new_positions_changeChange in the number of new positions.
increased_positionsNumber of increased positions.
last_increased_positionsNumber of increased positions in the last quarter.
increased_positions_changeChange in the number of increased positions.
closed_positionsNumber of closed positions.
last_closed_positionsNumber of closed positions in the last quarter.
closed_positions_changeChange in the number of closed positions.
reduced_positionsNumber of reduced positions.
last_reduced_positionsNumber of reduced positions in the last quarter.
reduced_positions_changeChange in the number of reduced positions.
total_callsTotal number of call options contracts traded for Apple Inc. on the specified date.
last_total_callsTotal number of call options contracts traded for Apple Inc. on the previous reporting date.
total_calls_changeChange in the total number of call options contracts traded between the current and previous reporting dates.
total_putsTotal number of put options contracts traded for Apple Inc. on the specified date.
last_total_putsTotal number of put options contracts traded for Apple Inc. on the previous reporting date.
total_puts_changeChange in the total number of put options contracts traded between the current and previous reporting dates.
put_call_ratioPut-call ratio, which is the ratio of the total number of put options to call options traded on the specified date.
last_put_call_ratioPut-call ratio on the previous reporting date.
put_call_ratio_changeChange in the put-call ratio between the current and previous reporting dates.