Katelynn's Report

Katelynn's Report

(US Market)


Font Size:

Investment Trends

Investment Company Sentiment

This module monitors the portfolio of each investment company that files Form 13F, which is required to be reported to the SEC within 45 days after each quarter end (i.e. Mar 31st, Jun 30th, Sep 30th, Dec 31st). The data is updated daily around 6:00 AM US CDT.


Query Box: Input CIK, or company name, or fund manager name of investment company. Only 1 entity is allowed on each query. If input is name, please wait a few seconds for the auto-complete function to fill in CIK. The database search is based on CIK.
For example, to make query on the portfolio of Berkshire Hathaway, just input 1067983 (i.e. CIK of the company), or "berkshire" (case insensitive), or "fm:[marc d."(i.e name of the fund manager), and then select corresponding entry from the drop-down list generated by auto-complete function.

Time Span: Choose from 3-month to MAX time span on the right side of the option panel. This will affect the historical portfolio chart. By default this is set to 2-year.

Portfolio by Sector/Industry

The following images are based on data reported by Berkshire Hathaway for the 2nd quarter of 2019.

These sections provide summarization of the institutional holdings grouped by sectors and by industries, respectively. Two presentation schemes are used. While both schemes determine the proportion of each sector (or industry) (as denoted by the area size on the treemap) by current market value, different colorization strategies are used to emphasize distinct features of current holdings compare with previous period. As shown below.

  • Percentage Change of Dollar Value

    The tiles are colored by percentage changes in the market value of specific sector/industry compare with previous period. Green tile denotes increase in market value. Red tile denotes decrease in market value. Cyan tile denotes brand new holdings (i.e. no holding in corresponding sector/industry was found in previous period). White tile denotes no change in market value.
    This colorization scheme reflects the overall effect of market appreciation/depreciation of share prices as well as acquisition/disposition, if any, at the discretion of portfolio manager.

    In the above example, the reporter has securities that worth $95.02 Bil in the finance sector, which is 6.37% higher than pervious period (i.e. 1st quarter of 2019). The finance sector accounts for 45.7% (weights) of its total portfolio value. The weights is 0.88 units higher than pervious period (44.82%).
    Click the tile will open in east panel all holdings and transactions history in the finance sector.

  • Acquisition/Disposition Percentage of Capital

    The tiles are colored by the overall acquisition/disposition dollar amount calculated from changes in shares amount multiplying deduced per share prices. Green tile denotes overall capital inflow. Red tile denotes overall capital outflow. Cyan tile denotes brand new holdings (i.e. no holding in corresponding sector/industry was found in previous period). White tile denotes no change in holding shares amount.
    This colorization scheme mainly reflects the acquisition/disposition at the discretion of portfolio managers. In another word, there will be no change at all if there is no change in holding shares amount, regardless of any appreciation/depreciation of market price per share.

    In the above example, the reporter has a total of $1.07 Bil capital inflow into the finance sector, which accounts for 1.14% of sector total before inflow. Note while previous image shows 3.75% increase of the market value of the securities in the consumer non-durables sector, there is actually no capital inflow/outflow (i.e. the portfolio manager didn't make any change to the sector. The increase in market value is purely a result of market appreciation of share prices).

  • Historical Portfolio

    The historical market value grouped by sector or by industry. The following image illustrates the holdings of Berkshire Hathaway grouped by sector since 2nd quarter of 2015.


This section provides the portfolio of investment company at per security level. For each security, its area sizes on the treemap is determined by its corresponding market value (i.e. holding shares multiply market price per share). The tile color is determined by percentage change of holding shares (NOT market value) compare with previous period. Green tile denotes increase in holding shares. Red tile denotes decrease in holding shares. White tile denotes no change (Restatement). Cyan tile denotes brand new holding.

According to the treemap above, the reporter currently holds 537,300 shares of AMZN (Amazon Inc) common stocks, which has a market value of $1017.4 Mil and accounts for 0.49% of the reporter's total portfolio. This represents a 11% increase in holding shares of AMZN compare with previous period (i.e. 1st quarter of 2019).

Top Acquisitions/Dispositions

This section shows the top 20 acquisitions and dispositions of current period. As a reminder, the securities that were sold out won't be displayed in the treemap, and can only be found in the top dispositions table.

East Panel

This section provides the transactions histories reported on Form 13F and Form 13G/D, respectively. Specifically, click on any sector or industry tile in the central panel to enable filtering of transaction records to show specific sector or industry. Alternatively, type in keyword like "finance" into the quick search box on the top right corner to narrow down results to "finance" sector (the number of records might be trimmed due to max record limit).