Agilent Technologies, Inc.
US ˙ NYSE ˙ US00846U1016

SecurityA / Agilent Technologies, Inc.
InstitutionSpiderRock Advisors, LLC
Latest Disclosed Ownership17,571 shares
Latest Disclosed Value $ 2,608,942
SpiderRock Advisors, LLC ownership in A / Agilent Technologies, Inc.

On November 1, 2024 - SpiderRock Advisors, LLC filed a 13F-HR form disclosing ownership of 17,571 shares of Agilent Technologies, Inc. (US:A) valued at $2,608,942 USD as of September 30, 2024. The entity filed a previous 13F-HR on August 12, 2024 disclosing 17,554 shares of Agilent Technologies, Inc.. This represents a change in shares of 0.10% during the quarter. The current value of the position is $2,431,299 USD.

SpiderRock Advisors, LLC has a history of taking positions in derivatives of the underlying security (A) in the form of stock options.

Institutional Ownership: 13F and NPORT Filings

The Security and Class in the table below are shown exactly as filed by the investor. We do our best to track continuity of investments through acquisitions, and this will be reflected in the table as changes in names. In addition to descriptive data, performance of the investment is shown over time. To calculate quarterly performance, we first calculate cost basis of the shares purchased during the quarter, then use that to calculate gross profit. Quarterly return is Gross Profit / Starting Portfolio value.

Note that cost basis is calculated and stored in thousands, so small quarterly changes in shares frequently result in a cost basis of zero.

Upgrade to unlock premium data and export to Excel .

Institutional Put/Call Ratios
(Premium Subscription Required)

In addition to reporting standard equity and debt issues, institutions with more than 100MM assets under management must also disclose their put and call option holdings. Since put options generally indicate negative sentiment, and call options indicate positive sentiment, we can get a sense of the overall institutional sentiment by plotting the ratio of puts to calls. The chart to the right plots the historical put/call ratio for this instrument.

Using Put/Call Ratio as an indicator of investor sentiment overcomes one of the key deficiencies of using total institutional ownership, which is that a significant amount of assets under management are invested passively to track indices. Passively-managed funds do not typically buy options, so the put/call ratio indicator more closely tracks the sentiment of actively-managed funds.

A / Agilent Technologies, Inc. Historical Put/Call Ratio
Disclosed Equity Positions (from 13F/NPORT Filings)
File
Date
Effective
Date
Form Security Class ID Avg Price
Paid (Est)
Reported
Shares
ΔShares ΔShares
(%)
Reported
Value
(x1000)
ΔValue
(%)
Alloc
(%)
ΔAlloc ΔAlloc (%) Cost Basis
(x1000)
Unrealized
Gain/Loss
(x1000)
2024-11-01 2024-09-30 13F AGILENT TECHNOLOGIES COM 00846U101 17,571 17 0.10 2,609 14.64 0.0415
2024-08-12 2024-06-30 13F AGILENT TECHNOLOGIES COM 00846U101 17,554 -18 -0.10 2,276 -11.38 0.0457
2024-04-30 2024-03-31 13F AGILENT TECHNOLOGIES COM 00846U101 17,572 2,567 5,734.09 0.0639
2017-05-02 2017-03-31 13F AGILENT TECHNOLOGIES COM 00846U101 44 0.0414
Disclosed Put Options
File
Date
Effective
Date
Form Security Class ID Opt Avg Share Price Shares ΔShares
(%)
Value
(x1000)
ΔValue
(%)
Prior Allocation
(%)
Allocation
(%)
ΔAllocation
(%)
Cost Basis
(x1000)
Profit
(x1000)
Return
(%)
2024-11-01 2024-09-30 13F AGILENT TECHNOLOGIES PUT Put 14,500 0.00 2,153 14.53 n/a n/a n/a
2024-08-12 2024-06-30 13F AGILENT TECHNOLOGIES COM Put 14,500 0.00 1,880 -11.28 n/a n/a n/a
2024-04-30 2024-03-31 13F AGILENT TECHNOLOGIES COM Put 14,500 2,118 211,700.00 n/a n/a n/a
2024-01-30 2023-12-31 13F Agilent Technologies Ordinary Shares Put 2 0.00 n/a n/a n/a
2023-10-25 2023-09-30 13F Agilent Technologies Ordinary Shares Put 2 0.00 n/a n/a n/a
2023-07-31 2023-06-30 13F Agilent Technologies Ordinary Shares Put 2 n/a n/a n/a
2023-04-24 2023-03-31 13F Agilent Technologies Ordinary Shares Put 1 n/a n/a n/a
2023-02-07 2022-12-31 13F Agilent Technologies Ordinary Shares Put 1 -100.00 n/a n/a n/a
2022-11-04 2022-09-30 13F Agilent Technologies Ordinary Shares Put 760 0.00 n/a n/a n/a
2022-08-03 2022-06-30 13F Agilent Technologies Ordinary Shares Put 760 295.83 n/a n/a n/a
2021-01-28 2020-12-31 13F Agilent Technologies Ordinary Shares Put 192 2.13 n/a n/a n/a
2020-10-16 2020-09-30 13F AGILENT TECHNOLOGIES ORDINARY SHARES Put 188 0.00 n/a n/a n/a
2020-08-19 2020-06-30 13F/A AGILENT TECHNOLOGIES COM Put 188 1,609.09 n/a n/a n/a
2020-08-13 2020-06-30 13F AGILENT TECHNOLOGIES COM Put 7 n/a n/a n/a
2020-05-11 2020-03-31 13F AGILENT TECHNOLOGIES COM Put 11 1,000.00 n/a n/a n/a
2020-01-17 2019-12-31 13F AGILENT TECHNOLOGIES COM Put 1 -75.00 n/a n/a n/a
2019-10-28 2019-09-30 13F AGILENT TECHNOLOGIES COM Put 4 -50.00 n/a n/a n/a
2019-07-29 2019-06-30 13F AGILENT TECHNOLOGIES COM Put 8 -11.11 n/a n/a n/a
2019-05-15 2019-03-31 13F AGILENT TECHNOLOGIES COM Put 9 50.00 n/a n/a n/a
2019-02-08 2018-12-31 13F AGILENT TECHNOLOGIES COM Put 6 50.00 n/a n/a n/a
2018-11-08 2018-09-30 13F AGILENT TECHNOLOGIES COM Put 4 300.00 n/a n/a n/a
2017-05-02 2017-03-31 13F AGILENT TECHNOLOGIES COM Put 1 n/a n/a n/a
Legend
Shares
The total number of shares held by the institution at the end of the reporting period (the effective date). This is provided in the filing.
Value
The total value of the shares as of the effective date. This is provided in the filing.
Avg. Share Price
The weighted average share price of the shares held by the institution. We use FIFO accounting to determine this price
Class
This is the security class as indicated by the filer. There are a variety of values for this field. Common values include "EC" = equity common, "EP" - equity preferred
Allocation (%)
The percent of the institution's portfolio that this position represents. This is provided in NPORT filings. For 13F filings, we calculate it.
Change in Allocation
The change in allocation from the prior reporting period. This is calculated as current allocation - prior allocation.
Change in Allocation (%)
The percent change in allocation from the prior reporting period. This is calculated as (current allocation - prior allocation) / prior allocation.
Cost Basis
The total cost of the shares held. This is calculated as reported shares * avg. share price
Unrealized Gain/Loss
This is the market value of the position as of the effective date minus the cost basis.