Institutional Trading
The dataset provides a comprehensive analysis of institutional investment behaviors, strategies, and portfolio dynamics assist professional investors in making informed decisions.
Data is updated quarterly as data arrives after market close US-EST time.
Tutorials are the best documentation — Insitutional Trading Tutorial
Input Datasets
13F Filings, Market Data
Models Used
Simple Calculations, Aggregations
Model Outputs
Standardized Ratios
Description
This dataset provides comprehensive analysis of institutional investment behaviors, including metrics on fund ratios, growth, derivative usage, and portfolio dynamics.
It offers investors valuable insights into market trends, risk profiles, investment strategies, and fund flows, enabling informed decision-making in institutional trading.
Data Access
Institutional Trading Data
This data is around 1GB if you download the entire dataset.
Filtered Dataset
Reports
Grouped ranking
Plots
Institutional Flow Prediction
Grouped Plot
Data Dictionary
| Name | Description | Type |
|---|---|---|
std_percentoftotal_fund_median | Rolling standard deviation of 'percentoftotal' over the last 4 quarters for each investor. | float64 |
std_put_call_ratio_fund_median | Rolling standard deviation of the put-call ratio over the last 4 quarters for each investor. | float64 |
std_derivative_ratio_fund_median | Rolling standard deviation of the derivative ratio over the last 4 quarters for each investor. | float64 |
derivative_ratio_fund_median | Ratio of the sum of put value and call value to share value for each investor. | float64 |
put_call_ratio_fund_median | Put-call ratio calculated as the difference between put value and call value divided by their sum for each investor. | float64 |
fund_ratio_fund_median | Ratio of fund value to share value for each investor. | float64 |
debt_ratio_fund_median | Ratio of debt value to share value for each investor. | float64 |
preferred_ratio_fund_median | Ratio of preferred stock value to share value for each investor. | float64 |
totalvalue_median | Median of the total value of holdings for each investor. | float64 |
percentoftotal_median | Median of the percentage of total holdings for each investor. | float64 |
shrholdings_growth_median | Median of the percentage growth in shareholdings for each investor. | float64 |
totalvalue_growth_median | Median of the percentage growth in total value for each investor. | float64 |
put_call_ratio_fund_growth_median | Median of the percentage growth in put-call ratio for each investor. | float64 |
derivative_ratio_fund_growth_median | Median of the percentage growth in derivative ratio for each investor. | float64 |
market_tilt_pca_median | Median of the market tilt component calculated through PCA for each investor. | float64 |
sector_tilt_pca_median | Median of the sector tilt component calculated through PCA for each investor. | float64 |
strategy_tilt_pca_median | Median of the strategy tilt component calculated through PCA for each investor. | float64 |
quantitative_tilt_pca_median | Median of the quantitative tilt component calculated through PCA for each investor. | float64 |
instrument_tilt_pca_median | Median of the instrument tilt component calculated through PCA for each investor. | float64 |
weight_variability_median | Median of the variability in weightings for each investor's portfolio. | float64 |
weight_mean_median | Median of the mean weights of holdings in each investor's portfolio. | float64 |
weight_coff_variance_median | Median of the coefficient of variance of weights in each investor's portfolio (variability relative to mean weight). | float64 |
weight_max_median | Median of the maximum weight in each investor's portfolio. | float64 |
weight_kurtosis_median | Median of the kurtosis of weights in each investor's portfolio (measure of the 'tailedness' of the distribution of weights). | float64 |
weight_skew_median | Median of the skewness of weights in each investor's portfolio (measure of asymmetry of the distribution of weights). | float64 |
num_investments_median | Median number of investments in each investor's portfolio. | float64 |
new_investments_median | Median ratio of new investments to total investments in each investor's portfolio. | float64 |
divestments_median | Median ratio of divestments to total investments in each investor's portfolio. | float64 |
new_investments_to_divestments_median | Median ratio of new investments to divestments in each investor's portfolio. | float64 |
portfolio_turnover_median | Median portfolio turnover, measuring changes in portfolio composition, for each investor. | float64 |
net_change_to_investments_median | Median of the net change to investments, indicating the net inflow or outflow, in each investor's portfolio. | float64 |
uncorrelated_percentile_median | Median of the uncorrelated percentile, indicating the degree of uncorrelation in each investor's portfolio components. | float64 |
flow_percentage_mean_median | Median of the mean flow percentage, indicating the average flow relative to the value, in each investor's portfolio. | float64 |
performance_value_mean_median | Median of the mean performance value, indicating the average value of performance, in each investor's portfolio. | float64 |
fund_return_quarter_median | Median return of funds for each investor, calculated quarterly. | float64 |
fund_flows_percent_quarter_median | Median percentage of fund flows for each investor, calculated quarterly. | float64 |
std_percentoftotal_fund_std | Standard deviation of the rolling standard deviation of 'percentoftotal' over the last 4 quarters for each investor. | float64 |
std_put_call_ratio_fund_std | Standard deviation of the rolling standard deviation of the put-call ratio over the last 4 quarters for each investor. | float64 |
std_derivative_ratio_fund_std | Standard deviation of the rolling standard deviation of the derivative ratio over the last 4 quarters for each investor. | float64 |
derivative_ratio_fund_std | Standard deviation of the derivative ratio for each investor. | float64 |
put_call_ratio_fund_std | Standard deviation of the put-call ratio for each investor. | float64 |
fund_ratio_fund_std | Standard deviation of the fund ratio for each investor. | float64 |
debt_ratio_fund_std | Standard deviation of the debt ratio for each investor. | float64 |
preferred_ratio_fund_std | Standard deviation of the preferred stock ratio for each investor. | float64 |
totalvalue_std | Standard deviation of the total value of holdings for each investor. | float64 |
percentoftotal_std | Standard deviation of the percentage of total holdings for each investor. | float64 |
shrholdings_growth_std | Standard deviation of the growth in the number of shareholdings for each investor. | float64 |
totalvalue_growth_std | Standard deviation of the growth in the total value of holdings for each investor. | float64 |
put_call_ratio_fund_growth_std | Standard deviation of the growth in the put-call ratio for each investor. | float64 |
derivative_ratio_fund_growth_std | Standard deviation of the growth in the derivative ratio for each investor. | float64 |
market_tilt_pca_std | Standard deviation of the market tilt principal component analysis (PCA) for each investor. | float64 |
sector_tilt_pca_std | Standard deviation of the sector tilt principal component analysis (PCA) for each investor. | float64 |
strategy_tilt_pca_std | Standard deviation of the strategy tilt principal component analysis (PCA) for each investor. | float64 |
quantitative_tilt_pca_std | Standard deviation of the quantitative tilt principal component analysis (PCA) for each investor. | float64 |
instrument_tilt_pca_std | Standard deviation of the instrument tilt principal component analysis (PCA) for each investor. | float64 |
weight_variability_std | Standard deviation of the variability of weights of holdings in each investor's portfolio. | float64 |
weight_mean_std | Standard deviation of the mean weights of holdings in each investor's portfolio. | float64 |
weight_coff_variance_std | Standard deviation of the coefficient of variance of weights in each investor's portfolio. | float64 |
weight_max_std | Standard deviation of the maximum weight in each investor's portfolio. | float64 |
weight_kurtosis_std | Standard deviation of the kurtosis of weights in each investor's portfolio. | float64 |
weight_skew_std | Standard deviation of the skewness of weights in each investor's portfolio. | float64 |
num_investments_std | Standard deviation of the number of investments in each investor's portfolio. | float64 |
new_investments_std | Standard deviation of the ratio of new investments to total investments in each investor's portfolio. | float64 |
divestments_std | Standard deviation of the ratio of divestments to total investments in each investor's portfolio. | float64 |
new_investments_to_divestments_std | Standard deviation of the ratio of new investments to divestments in each investor's portfolio. | float64 |
portfolio_turnover_std | Standard deviation of portfolio turnover, measuring changes in portfolio composition, for each investor. | float64 |
net_change_to_investments_std | Standard deviation of the net change to investments, indicating the net inflow or outflow, in each investor's portfolio. | float64 |
uncorrelated_percentile_std | Standard deviation of the uncorrelated percentile, indicating the degree of uncorrelation in each investor's portfolio components. | float64 |
flow_percentage_mean_std | Standard deviation of the mean flow percentage, indicating the average flow relative to the value, in each investor's portfolio. | float64 |
performance_value_mean_std | Standard deviation of the mean performance value, indicating the average value of performance, in each investor's portfolio. | float64 |
fund_return_quarter_std | Standard deviation of quarterly fund returns for each investor. | float64 |
fund_flows_percent_quarter_std | Standard deviation of quarterly fund flows percentage for each investor. | float64 |
totalvalue | Total value of holdings for each investor. | float64 |
total_derivatives | Total value of derivative holdings (puts and calls) for each investor. | float64 |
percentoftotal | Percentage of total holdings for each investor. | float64 |
growth_totalvalue | Growth rate of the total value of holdings for each investor. | float64 |
growth_shrholders | Growth rate of the number of shareholders for each investor. | float64 |
growth_shrvalue | Growth rate of the share value for each investor. | float64 |
growth_percentoftotal | Growth rate of the percentage of total holdings for each investor. | float64 |
growth_shrholder_value_divergence | Divergence between growth rates of share value and shareholders for each investor. | float64 |
diversification_score_ticker | Score indicating the level of diversification in the portfolio based on the presence of different types of investments. | float64 |
derivative_ratio_ticker | Ratio of derivative holdings to share value for each ticker. | float64 |
derivative_holder_ratio | Ratio of derivative holders to total shareholders for each ticker. | float64 |
derivative_holder_value_divergence | Divergence between derivative holder ratio and derivative ratio for each ticker. | float64 |
short_interest | Value of short interest (put value minus share value) for each ticker. | float64 |
security_concentration | Concentration of security, calculated as share value divided by total value, for each ticker. | float64 |
put_call_ratio_ticker | Put-call ratio for each ticker, calculated as the difference between put and call values divided by their sum. | float64 |
put_call_holder_ratio | Put-call holder ratio for each ticker, calculated as the difference between put and call holders divided by their sum. | float64 |
put_holder_value_sentiment_divergence | Divergence between put-call holder ratio and put-call ratio, indicating sentiment divergence for each ticker. | float64 |
value_per_holder | Average value per holder for each ticker. | float64 |
debt_equity_ratio | Ratio of debt value to equity value for each ticker. | float64 |
historical_high_sharevalue | Historical highest share value for each ticker. | float64 |
percentage_from_high_sharevalue | Percentage difference from historical high share value for each ticker. | float64 |
previous_high_sharevalue | Previous highest share value for each ticker. | float64 |
percentage_above_previous_high | Percentage above the previous highest share value for each ticker. | float64 |
overweight | Indicator of overweight investment in a particular ticker. | float64 |
allocation_pressure_percentile | Percentile rank of allocation pressure for each ticker, indicating the degree of pressure on allocation. | float64 |
net_flows_sum | Sum of net flows for each ticker over the given period. | float64 |
net_flows_max | Maximum net flow for each ticker over the given period. | float64 |
net_flows_std | Standard deviation of net flows for each ticker over the given period. | float64 |
net_flows_mean | Mean of net flows for each ticker over the given period. | float64 |
net_flows_inflow_outflow_value_ratio | Ratio of inflows to outflows in terms of value for each ticker. | float64 |
net_flows_inflow_outflow_count_ratio | Ratio of the number of inflows to outflows for each ticker. | float64 |
appreciation_value_sum | Sum of appreciation value for each ticker over the given period. | float64 |
new_value_sum | Sum of new value for each ticker over the given period. | float64 |
turnover_percentage_median | Median of turnover percentage for each ticker over the given period. | float64 |
quarter_return | Return for each ticker in the quarter. | float64 |
quarter_flows | Flows for each ticker in the quarter. | float64 |
derivative_overloaded | Indicator of high derivative concentration for each ticker. | float64 |
put_overloaded | Indicator of high put option concentration for each ticker. | float64 |
Feature Descriptions
Standard Deviation Metrics (Columns 0-38)
Purpose: These metrics provide insights into the volatility and risk associated with various investment strategies and portfolio compositions.
Usage: Investors can use these metrics to assess the risk profile of different funds and compare the stability of their investment strategies.
Growth Metrics (Columns 75-79)
Purpose: These metrics track the growth or decline in the value of investments, the number of shareholders, and their share value over time.
Usage: Useful for identifying trends in investment preferences and shareholder behaviors.
Diversification Score (Column 80)
Purpose: Indicates the level of diversification in a portfolio based on different types of investments.
Usage: Investors can evaluate the risk mitigation strategies of different funds based on their diversification scores.
Derivative and Put-Call Metrics (Columns 81-88)
Purpose: Provide insights into the use of derivatives and options in investment strategies.
Usage: These metrics help in understanding the risk appetite and hedging strategies of investors.
Historical Highs and Debt-Equity Ratio (Columns 90-94)
Purpose: Offers a historical perspective on share values and assesses the leverage used by funds.
Usage: Useful for long-term investment analysis and understanding the use of debt in investment strategies.
Allocation Pressure and Flow Metrics (Columns 96-107)
Purpose: These metrics assess the inflows and outflows from funds, alongside the allocation pressure on investments.
Usage: Essential for understanding market liquidity, investor sentiment, and pressure on asset allocation.
Overloaded Indicators (Columns 108-109)
Purpose: Indicate high concentrations in derivatives and puts.
Usage: Investors can gauge the level of speculation and potential overexposure to certain investment instruments.
Use Cases
This dataset provides a comprehensive analysis of institutional investment behaviors, strategies, and portfolio dynamics. It covers various aspects like fund ratios, growth metrics, derivative concentrations, shareholder dynamics, and more. The data is designed to assist professional investors in understanding market trends, evaluating investment strategies, and making informed decisions.
Market Trend Analysis: Understand broad market trends by analyzing growth metrics and standard deviations.
Risk Assessment: Evaluate the risk profiles of different funds and strategies using volatility and diversification metrics.
Strategy Evaluation: Assess and compare the effectiveness of different investment strategies.
Investment Decision Making: Utilize historical data and flow metrics to make informed investment decisions.
Last updated
