Canandaigua National Bank & Trust Co — Q3 2017 13F Holdings

Name: Canandaigua National Bank & Trust Co — 13F Holdings, Q3 2017
Creator: AlphaSMO
License: https://www.sec.gov/forms

CIK: 0001074266

Total reported value

$1.1B

← Back to latest quarter

Full holdings list this quarter

Showing top 200 holdings (of 241 total)

#	Ticker	Issuer	Asset Subclass	Weight	Weight Change	Shares Change
1	SPY	Ss Spdr S&p 500 ETF Trust-us	ETF-Large Cap & Growth	4.37%	+0.01%	+3.19%
2	XOM	Exxon Mobil CORP	Stock-Energy	4.00%	—	+12.88%
3	EFA	Ishares Msci Eafe ETF	ETF-Other	2.67%	—	-0.20%
4	FISI	Financial Institutions INC	Stock-Other	2.62%	—	-3.23%
5	JNJ	Johnson & Johnson	Stock-Healthcare	2.57%	+0.15%	+0.59%
6	UTXZ	United Tech CORP	Stock-Other	2.32%	—	+26.75%
7	VB	Vanguard Small-cap ETF	ETF-Other	2.30%	—	+0.80%
8	JPM	Jpmorgan Chase & Co	Stock-Financials	2.06%	—	+13.38%
9	VWO	Vanguard Ftse Emerging Marke	ETF-Emerging Markets	2.01%	—	+6.01%
10	STZ	Constellation Brands Inc-a	Stock-Consumer Staples	1.98%	-0.04%	+61.74%
11	VNQ	Vanguard Real Estate ETF	ETF-Other	1.79%	—	+4.04%
12	VO	Vanguard Mid-cap ETF	ETF-Other	1.77%	-0.04%	+0.59%
13	PG	Procter & Gamble Co/the	Stock-Consumer Staples	1.68%	-0.07%	+0.71%
14	MSFT	Microsoft CORP	Stock-Tech	1.66%	-0.52%	-0.67%
15	AAPL	Apple INC	Stock-Tech	1.53%	—	-2.92%
16	AEP	American Electric Power Company, Inc.	Stock-Utilities	1.51%	—	+1.99%
17	VGK	Vanguard Ftse Europe ETF	ETF-Other	1.40%	—	+2.78%
18	BNDX	Vanguard Total Intl Bond ETF	ETF-Other	1.31%	—	-0.51%
19	VSS	Vanguard Ftse All Wo X-us Sc	ETF-Other	1.28%	—	-1.04%
20	CVX	Chevron CORP	Stock-Energy	1.26%	—	+13.27%
21	DD	DuPont de Nemours, Inc.	Stock-Other	1.20%	—	—
22	PAYX	Paychex INC	Stock-Tech	1.18%	-0.08%	-0.84%
23	PFE	Pfizer INC	Stock-Healthcare	1.17%	-0.06%	+6.83%
24	MCD	Mcdonald's CORP	Stock-Consumer Disc	1.14%	—	+8.84%
25	ORCL	Oracle CORP	Stock-Tech	1.10%	-0.57%	+1.54%
26	MRK	Merck & Co. INC.	Stock-Healthcare	1.04%	+0.17%	+14.16%
27	VZ	Verizon Communications INC	Stock-Comm Services	1.03%	—	+6.05%
28	IBM	Intl Business Machines CORP	Stock-Tech	0.98%	—	+17.38%
29	T	At&t INC	Stock-Comm Services	0.96%	—	+6.21%
30	PEP	Pepsico INC	Stock-Consumer Staples	0.93%	-0.04%	-1.34%
31	SDY	Ss Spdr S&p Dividend ETF	ETF-Other	0.92%	—	-5.26%
32	DIS	Walt Disney Co/the	Stock-Comm Services	0.85%	—	+0.46%
33	MMM	3m Co	Stock-Industrials	0.81%	—	-0.57%
34	IWR	Ishares Russell Mid-cap ETF	ETF-Other	0.75%	—	-1.77%
35	CVS	Cvs Health CORP	Stock-Healthcare	0.75%	—	+1.49%
36	VNQI	Vanguard Glbl Ex-us Real Est	ETF-Other	0.73%	—	+8.19%
37	VPL	Vanguard Ftse Pacific ETF	ETF-Other	0.73%	—	+2.02%
38	KO	Coca-cola Co/the	Stock-Consumer Staples	0.72%	—	-1.51%
39	LMT	Lockheed Martin CORP	Stock-Industrials	0.72%	—	-3.30%
40	PFF	Ishares Preferred & Income S	ETF-Other	0.70%	+0.08%	+0.87%
41	BMY	Bristol-myers Squibb Co	Stock-Healthcare	0.69%	—	-0.02%
42	INTC	Intel CORP	Stock-Tech	0.68%	—	+1.05%
43	TIP	Ishares Tips Bond ETF	ETF-Other	0.67%	—	+0.36%
44	NSC	Norfolk Southern CORP	Stock-Industrials	0.64%	—	+13.46%
45	DIA	Ss Spdr Dow Jones Indus Avg	ETF-Large Cap & Growth	0.63%	—	+9.87%
46	FISI 8.48 PERP B-1	Financial Institutions I	Stock-Other	0.63%	-0.12%	EXIT
47	SLB	Slb LTD	Stock-Energy	0.61%	—	-6.44%
48	SNA	Snap-on INC	Stock-Industrials	0.59%	—	+8.11%
49	IWM	Ishares Russell 2000 ETF	ETF-Small Cap	0.59%	—	+10.40%
50	ABBV	Abbvie INC	Stock-Healthcare	0.57%	—	-2.78%

1–50 of 200

Holding changes this quarter

Position changes disclosed by Canandaigua National Bank & Trust Co for the quarter ending Q3 2017, including ticker, issuer, weight change, shares change, and action
#	Ticker	Issuer	Weight Change	Shares Change	Action
1	STZ	Constellation Brands Inc-a	+0.7%	+61.74%	Add
2	UTXZ	United Tech CORP	+0.3%	+26.75%	Add
3	XOM	Exxon Mobil CORP	+0.2%	+12.88%	Add
4	JPM	Jpmorgan Chase & Co	+0.2%	+13.38%	Add
5	CVX	Chevron CORP	+0.2%	+13.27%	Add
6	IR	Ingersoll-rand PLC	+0.1%	+104.77%	Add
7	UNUSD	Unilever N V -ny Shares	+0.1%	+153.37%	Add
8	VWO	Vanguard Ftse Emerging Marke	+0.1%	+6.01%	Add
9	✓	Hyster B	+0.1%	—	Unchanged
10	VZ	Verizon Communications INC	+0.1%	+6.05%	Add
11	NSC	Norfolk Southern CORP	+0.1%	+13.46%	Add
12	BA	Boeing Co/the	+0.1%	—	Unchanged
13	PFE	Pfizer INC	+0.1%	+6.83%	Add
14	MRK	Merck & Co. INC.	+0.1%	+14.16%	Add
15	VBR	Vanguard Small-cap Value ETF	+0.1%	+22.11%	Add
16	ABBV	Abbvie INC	+0.1%	-2.78%	Trim
17	FCX	Freeport-mcmoran INC	+0.1%	+5.62%	Add
18	GSK	GSK plc ADRhedged	+0.1%	+138.17%	Add
19	MCD	Mcdonald's CORP	0%	+8.84%	Add
20	VNQI	Vanguard Glbl Ex-us Real Est	0%	+8.19%	Add
21	BMY	Bristol-myers Squibb Co	0%	-0.02%	Trim
22	DIA	Ss Spdr Dow Jones Indus Avg	0%	+9.87%	Add
23	INTC	Intel CORP	0%	+1.05%	Add
24	IWM	Ishares Russell 2000 ETF	0%	+10.40%	Add
25	IBM	Intl Business Machines CORP	0%	+17.38%	Add
26	GILD	Gilead Sciences INC	0%	-0.69%	Trim
27	TGT	Target CORP	0%	+5.21%	Add
28	T	At&t INC	0%	+6.21%	Add
29	VGK	Vanguard Ftse Europe ETF	0%	+2.78%	Add
30	MSFT	Microsoft CORP	0%	-0.67%	Trim
31	SPY	Ss Spdr S&p 500 ETF Trust-us	0%	+3.19%	Add
32	VSS	Vanguard Ftse All Wo X-us Sc	0%	-1.04%	Trim
33	PG	Procter & Gamble Co/the	-0.1%	+0.71%	Add
34	VB	Vanguard Small-cap ETF	-0.1%	+0.80%	Add
35	AAPL	Apple INC	-0.1%	-2.92%	Trim
36	EFA	Ishares Msci Eafe ETF	-0.1%	-0.20%	Trim
37	VNQ	Vanguard Real Estate ETF	-0.1%	+4.04%	Add
38	VO	Vanguard Mid-cap ETF	-0.1%	+0.59%	Add
39	JNJ	Johnson & Johnson	-0.1%	-10.26%	Trim
40	DIS	Walt Disney Co/the	-0.1%	+0.46%	Add
41	AEP	American Electric Power Company, Inc.	-0.3%	+1.99%	Add
42	FISI	Financial Institutions INC	-0.4%	-3.23%	Trim
43	DD	DuPont de Nemours, Inc.	—	NEW	New buy
44	DUK	Du Pont E I De Nemour&Co	—	EXIT	Sold out
45	DOW	Dow Chem Co	—	EXIT	Sold out
46	WOBDX	Jpmorgan Core Bond-i	—	NEW	New buy
47	TEVA	Teva Pharmaceutical-sp Adr	—	EXIT	Sold out
48	GOVT	Ishares US Treasury Bond ETF	—	NEW	New buy
49	AMT	American Tower CORP	—	EXIT	Sold out
50	ALLE	Allegion plc	—	NEW	New buy