Consolidated Water Co. Ltd.
US ˙ NasdaqGS ˙ KYG237731073

Introduction

This page provides a comprehensive analysis of the known insider trading history of Mctaggart Frederick W.. Insiders are officers, directors, or significant investors in a company. It is illegal for insiders to make trades in their companies based on specific, non-public information. This does not mean it is illegal for them to make any trades in their own companies. However, they must report all trades to the SEC via a Form 4. Despite these restrictions, academic research suggests that insiders - in general - tend to outperform the market in their own companies.

Average Trade Profitability

The average trade profitability is the average return of all the open market purchases made by the insider in the last three years. To calculate this, we examine every open-market, unplanned purchase made by the insider, excluding all trades that were marked as part of a 10b5-1 trading plan. We then calculate the average performance of those trades over 3, 6, and 12 months, averaging each of those durations to generate a final performance metric for each trade. Finally, we average all of the performance metrics to calculate a performance metric for the insider. This list only includes insiders that have made at least three trades in the last two years.

If this insiders trade profitability is "N/A", then the insider either has not made any open-market purchases in the last three years, or the trades they’ve made are too recent to calculate a reliable performance metric.

Update Frequency: Daily

See the list of most profitable insider traders.

Companies with Reported Insider Positions

The SEC filings indicate Mctaggart Frederick W. has reported holdings or trades in the following companies:

Security Title Latest Reported Holdings
US:CWCO / Consolidated Water Co. Ltd. PRESIDENT AND CEO, Director 289,158
How to Interpret the Charts

The following charts show the stock performance of securities subsequent to each open-market, non-planned trade made by Mctaggart Frederick W.. Non-planned trade are trades that were not made as part of a 10b5-1 trading plan. The stock performance is charted as cumulative percent change in share price. For example, if an insider trade was made on January 1, 2019, the chart will show the daily percent change of the security to the present day. If the share price were to go from $10 to $15 during this time, the cumulative percent change in share price would be 50%. A change in price from $10 to $20 would be 100%, and a change in price of $10 to $5 would be -50%.

Ultimately, we are trying to determine how closely the insider’s trades correlate to excess returns (positive or negative) in the share price in order to see if the insider is timing their trades to profit from insider information. Consider the situation where an insider was doing this. In this situation, we would expect either (a) positive returns after purchases, or (b) negative returns after sales. In the case of (a), the PURCHASE chart would show a series of upwardly sloping curves, indicating positive returns after each purchase transaction. In the case of (b), the SALE chart would show a series of downward sloping curves, indicating negative returns after each sale transaction.

However, this alone is not enough to draw conclusions. If, for example, the share price of the company was in a non-cyclical climb over many years, then we would expect all the post-purchase plots to be upwardly sloping. Likewise, non-cyclical declines over many years would result in downward sloping post-trade plots. Neither of these charts would suggest insider trading activity.

The strongest indicator would be a situation where the share price was extremely cyclical, and there were both positive signals in the PURCHASE chart and negative plots on the SALE chart. This situation would be highly suggestive of an insider that was timing trades to their financial advantage.

Insider Purchases CWCO / Consolidated Water Co. Ltd. - Short Term Profit Analysis

In this section, we analyze the profitability of every unplanned, open-market insider purchase made in CWCO / Consolidated Water Co. Ltd.. This analysis helps to understand if the insider consistently generates abnormal returns, and is worth following. This analysis is for one-year following each trade, and the results are theoretical.

The following table shows the most recent open market purchases that were not part of an automatic trading plan.

Trade Date Ticker Insider Reported
Shares
Reported
Price
Adjusted
Shares
Adjusted
Price
Cost Basis Days to
Max
Price at
Max
Max
Profit ($)
Max Return (%)
There are no known unplanned open-market trades for this insider and security combination

Adjusted Price is the split-adjusted price. Adjusted Shares is the split-adjusted shares.

CWCO / Consolidated Water Co. Ltd. Insider Trades
Insider Sales CWCO / Consolidated Water Co. Ltd. - Short Term Loss Analysis

In this section, we analyze the short-term loss avoidance of every unplanned, open-market insider sale made in CWCO / Consolidated Water Co. Ltd.. A consistent pattern of loss avoidance may suggest that future sale transactions may predict declines in price. This analysis is for one-year following each trade, and the results are theoretical.

The following table shows the most recent open market sales that were not part of an automatic trading plan.

Trade Date Ticker Insider Reported
Shares
Reported
Price
Adjusted
Shares
Adjusted
Price
Cost Basis Days to
Min
Price at
Min
Max Loss
Avoided ($)
Max Loss
Avoided (%)
2016-12-09 CWCO MCTAGGART FREDERICK W. 6,012 11.1081 6,012 11.1081 66,782 55 10.05 -6,360 -9.52
2016-12-06 CWCO MCTAGGART FREDERICK W. 2,537 11.3500 2,537 11.3500 28,795
2016-11-29 CWCO MCTAGGART FREDERICK W. 2,915 11.5379 2,915 11.5379 33,633
2013-08-16 CWCO MCTAGGART FREDERICK W. 6,007 12.4026 6,007 12.4026 74,502
2013-08-15 CWCO MCTAGGART FREDERICK W. 16,641 12.4127 16,641 12.4127 206,560
2013-08-14 CWCO MCTAGGART FREDERICK W. 7,352 12.4903 7,352 12.4903 91,829

Adjusted Price is the split-adjusted price. Adjusted Shares is the split-adjusted shares.

CWCO / Consolidated Water Co. Ltd. Insider Trades
Insider Trading History

This table shows the complete list of insider trades made by Mctaggart Frederick W. as disclosed to the Securities Exchange Commission (SEC).

File Date Tran Date Form Ticker Security Code 10b5-1 Shares Remaining Shares Percent
Change
Share
Price
Tran
Value
Remaining
Value
2025-03-27 2025-03-25 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 19,491 289,158 7.23
2025-02-20 2025-02-19 4 CWCO Consolidated Water Co. Ltd.
Common Stock
S - Sale X -28 269,667 -0.01 28.05 -785 7,564,159
2025-02-20 2025-02-19 4 CWCO Consolidated Water Co. Ltd.
Common Stock
S - Sale X -2,300 269,695 -0.85 28.02 -64,446 7,556,854
2025-02-20 2025-02-18 4 CWCO Consolidated Water Co. Ltd.
Common Stock
S - Sale X -2,000 271,995 -0.73 28.00 -56,000 7,615,860
2025-01-06 2025-01-02 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 8,533 273,995 3.21
2024-03-28 2024-03-27 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 12,711 265,462 5.03
2024-01-04 2024-01-02 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 10,647 252,751 4.40
2023-04-04 2023-03-31 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 6,626 242,104 2.81
2023-01-05 2023-01-03 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 10,078 235,478 4.47
2022-04-01 2022-03-30 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 8,749 225,400 4.04
2022-01-05 2022-01-03 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 9,313 216,651 4.49
2021-04-01 2021-03-30 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 13,252 207,338 6.83
2021-01-06 2021-01-04 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 8,977 194,086 4.85
2020-03-20 2020-03-18 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 15,278 185,109 9.00
2020-01-06 2020-01-02 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 10,035 169,831 6.28
2019-04-02 2019-04-01 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 4,892 159,796 3.16
2019-01-03 2019-01-02 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 9,774 154,904 6.73
2018-03-29 2018-03-28 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 6,130 145,130 4.41
2018-01-03 2018-01-02 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 10,215 139,000 7.93
2017-04-04 2017-03-31 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
A - Award 6,620 128,785 5.42
2016-12-13 2016-12-09 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY
M - Exercise -6,214 0 -100.00
2016-12-13 2016-12-09 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -6,012 122,165 -4.69 11.11 -66,782 1,357,021
2016-12-13 2016-12-09 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 6,214 128,177 5.09 10.68 66,366 1,368,930
2016-12-08 2016-12-06 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY
M - Exercise -2,537 6,214 -28.99
2016-12-08 2016-12-06 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -2,537 121,963 -2.04 11.35 -28,795 1,384,280
2016-12-08 2016-12-06 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 2,537 124,500 2.08 10.68 27,095 1,329,660
2016-12-01 2016-11-29 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY
M - Exercise -2,915 8,751 -24.99
2016-12-01 2016-11-29 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -2,915 121,963 -2.33 11.54 -33,633 1,407,197
2016-12-01 2016-11-29 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 2,915 124,878 2.39 10.68 31,132 1,333,697
2016-06-23 2016-06-21 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
A - Award 3,535 121,963 2.98
2014-04-01 2014-03-28 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
A - Award 5,000 118,428 4.41
2014-04-01 2014-03-28 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
A - Award 7,302 113,428 6.88
2013-08-16 2013-08-16 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -6,007 106,126 -5.36 12.40 -74,502 1,316,238
2013-08-16 2013-08-15 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -16,641 112,133 -12.92 12.41 -206,560 1,391,873
2013-08-16 2013-08-14 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -7,352 128,774 -5.40 12.49 -91,829 1,608,426
2013-04-08 2013-03-20 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
A - Award 11,131 136,126 8.91
2013-01-10 3 CWCO CONSOLIDATED WATER CO LTD
Common Stock
124,995
P
Open market or private purchase of non-derivative or derivative security
S
Open market or private sale of non-derivative or derivative security
A
Grant, award, or other acquisition of securities from the company (such as an option)
C
Conversion of derivative
D
Sale or transfer of securities back to the company
F
Payment of exercise price or tax liability using portion of securities received from the company
G
Gift of securities by or to the insider
K
Equity swaps and similar hedging transactions
M
Exercise or conversion of derivative security received from the company (such as an option)
V
A transaction voluntarily reported on Form 4
J
Other (accompanied by a footnote describing the transaction)