Consolidated Water Co. Ltd.
US ˙ NasdaqGS ˙ KYG237731073

Introduction

This page provides a comprehensive analysis of the known insider trading history of David Sasnett. 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 David Sasnett has reported holdings or trades in the following companies:

Security Title Latest Reported Holdings
US:CWCO / Consolidated Water Co. Ltd. EVP & CHIEF FINANCIAL OFFICER 79,879
Director 1,500,000
How to Interpret the Charts

The following charts show the stock performance of securities subsequent to each open-market, non-planned trade made by David Sasnett. 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 Sasnett David 3,971 11.0000 3,971 11.0000 43,681 55 10.05 -3,772 -8.64
2016-12-08 CWCO Sasnett David 5,470 11.0000 5,470 11.0000 60,170
2015-11-23 CWCO Sasnett David 4,500 11.8500 4,500 11.8500 53,325
2015-03-18 CWCO Sasnett David 7,383 9.8613 7,383 9.8613 72,806
2013-12-12 CWCO Sasnett David 865 12.9400 865 12.9400 11,193
2013-12-12 CWCO Sasnett David 2,747 12.9500 2,747 12.9500 35,574
2013-12-12 CWCO Sasnett David 1,437 12.9600 1,437 12.9600 18,624
2013-12-12 CWCO Sasnett David 834 12.9700 834 12.9700 10,817
2013-03-19 CWCO Sasnett David 2,163 9.0566 2,163 9.0566 19,589
2013-03-18 CWCO Sasnett David 5,220 9.0913 5,220 9.0913 47,457

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 David Sasnett 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 8,892 79,879 12.53
2025-01-06 2025-01-02 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 3,893 70,987 5.80
2024-03-28 2024-03-27 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 5,735 67,094 9.35
2024-01-04 2024-01-02 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 4,839 61,359 8.56
2023-04-04 2023-03-31 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 2,931 56,520 5.47
2023-01-05 2023-01-03 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 4,547 53,589 9.27
2022-04-01 2022-03-30 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 3,982 49,042 8.84
2022-01-05 2022-01-03 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 4,192 45,060 10.26
2021-04-01 2021-03-30 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 5,810 40,868 16.57
2021-01-06 2021-01-04 4 CWCO Consolidated Water Co. Ltd.
Common Stock
A - Award 4,001 35,058 12.88
2020-03-20 2020-03-18 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 6,496 31,057 26.45
2020-01-06 2020-01-02 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 4,409 24,561 21.88
2019-04-02 2019-04-01 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 2,032 20,152 11.21
2019-01-03 2019-01-02 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 4,167 18,120 29.86
2018-03-29 2018-03-28 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 2,472 13,953 21.53
2018-01-03 2018-01-02 4 CWCO Consolidated Water Co. Ltd.
COMMON STOCK
A - Award 4,236 11,481 58.47
2017-04-04 2017-03-31 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
A - Award 2,708 7,245 59.69
2016-12-12 2016-12-09 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY
M - Exercise -3,971 0 -100.00
2016-12-12 2016-12-09 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -3,971 4,537 -46.67 11.00 -43,681 49,907
2016-12-12 2016-12-09 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 3,971 8,508 87.52 10.68 42,410 90,865
2016-12-12 2016-12-08 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY
M - Exercise -5,470 3,971 -57.94
2016-12-12 2016-12-08 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -5,470 4,537 -54.66 11.00 -60,170 49,907
2016-12-12 2016-12-08 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 5,470 10,007 120.56 10.68 58,420 106,875
2016-06-23 2016-06-21 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
A - Award 1,426 4,537 45.84
2015-11-24 2015-11-23 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY
M - Exercise -4,500 14,383 -23.83
2015-11-24 2015-11-23 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -4,500 3,111 -59.12 11.85 -53,325 36,865
2015-11-24 2015-11-23 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 4,500 7,611 144.65 10.68 48,060 81,285
2015-03-20 2015-03-18 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY)
M - Exercise -7,383 0 -100.00
2015-03-20 2015-03-18 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -7,383 3,111 -70.35 9.86 -72,806 30,679
2015-03-20 2015-03-18 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 7,383 10,494 237.32 7.90 58,326 82,903
2013-12-13 2013-12-12 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY
M - Exercise -7,383 7,383 -50.00
2013-12-13 2013-12-12 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -834 6,222 -11.82 12.97 -10,817 80,699
2013-12-13 2013-12-12 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -1,437 7,056 -16.92 12.96 -18,624 91,446
2013-12-13 2013-12-12 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -2,747 8,493 -24.44 12.95 -35,574 109,984
2013-12-13 2013-12-12 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -865 11,240 -7.15 12.94 -11,193 145,446
2013-12-13 2013-12-12 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 7,383 12,105 156.35 7.90 58,326 95,630
2013-03-29 2013-03-27 4 DUBL DubLi, Inc.
OPTION (RIGHT TO BUY)
A - Award 1,500,000 1,500,000
2013-03-20 2013-03-19 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY)
M - Exercise -2,163 14,766 -12.78
2013-03-20 2013-03-19 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -2,163 4,722 -31.42 9.06 -19,589 42,765
2013-03-20 2013-03-19 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 2,163 6,885 45.81 7.90 17,088 54,392
2013-03-20 2013-03-18 4 CWCO CONSOLIDATED WATER CO LTD
OPTION (RIGHT TO BUY)
M - Exercise -5,220 16,929 -23.57
2013-03-20 2013-03-18 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
S - Sale -5,220 4,722 -52.50 9.09 -47,457 42,929
2013-03-20 2013-03-18 4 CWCO CONSOLIDATED WATER CO LTD
COMMON STOCK
M - Exercise 5,220 9,942 110.55 7.90 41,238 78,542
2013-01-10 3 CWCO CONSOLIDATED WATER CO LTD
Common Stock
4,722
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)