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

Name: Canandaigua National Bank & Trust Co — 13F Holdings, Q4 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 247 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.54%	+0.01%	+3.09%
2	XOM	Exxon Mobil CORP	Stock-Energy	3.86%	—	-0.33%
3	EFA	Ishares Msci Eafe ETF	ETF-Other	2.72%	—	+4.77%
4	JNJ	Johnson & Johnson	Stock-Healthcare	2.69%	+0.15%	+2.78%
5	FISI	Financial Institutions INC	Stock-Other	2.59%	—	-3.32%
6	UTXZ	United Tech CORP	Stock-Other	2.40%	—	-0.49%
7	VB	Vanguard Small-cap ETF	ETF-Other	2.26%	—	-0.74%
8	JPM	Jpmorgan Chase & Co	Stock-Financials	2.15%	—	-1.37%
9	STZ	Constellation Brands Inc-a	Stock-Consumer Staples	2.13%	-0.04%	-1.03%
10	VWO	Vanguard Ftse Emerging Marke	ETF-Emerging Markets	2.04%	—	+1.74%
11	MSFT	Microsoft CORP	Stock-Tech	1.79%	-0.52%	-1.02%
12	VO	Vanguard Mid-cap ETF	ETF-Other	1.77%	-0.04%	+0.12%
13	VNQ	Vanguard Real Estate ETF	ETF-Other	1.72%	—	+1.42%
14	PG	Procter & Gamble Co/the	Stock-Consumer Staples	1.63%	-0.07%	+1.24%
15	AAPL	Apple INC	Stock-Tech	1.57%	—	-1.29%
16	VGK	Vanguard Ftse Europe ETF	ETF-Other	1.40%	—	+3.47%
17	CVX	Chevron CORP	Stock-Energy	1.32%	—	+3.32%
18	PAYX	Paychex INC	Stock-Tech	1.25%	-0.08%	-2.00%
19	BNDX	Vanguard Total Intl Bond ETF	ETF-Other	1.23%	—	-0.56%
20	VSS	Vanguard Ftse All Wo X-us Sc	ETF-Other	1.23%	—	-1.77%
21	MCD	Mcdonald's CORP	Stock-Consumer Disc	1.23%	—	+3.84%
22	DD	DuPont de Nemours, Inc.	Stock-Other	1.17%	—	-0.17%
23	PFE	Pfizer INC	Stock-Healthcare	1.09%	-0.06%	-3.21%
24	ORCL	Oracle CORP	Stock-Tech	1.01%	-0.57%	-0.71%
25	VZ	Verizon Communications INC	Stock-Comm Services	1.01%	—	-3.32%
26	IBM	Intl Business Machines CORP	Stock-Tech	0.98%	—	+0.25%
27	PEP	Pepsico INC	Stock-Consumer Staples	0.96%	-0.04%	+0.65%
28	AEP	American Electric Power Company, Inc.	Stock-Utilities	0.93%	—	-9.82%
29	SDY	Ss Spdr S&p Dividend ETF	ETF-Other	0.90%	—	+0.15%
30	MRK	Merck & Co. INC.	Stock-Healthcare	0.89%	+0.17%	+2.89%
31	T	At&t INC	Stock-Comm Services	0.89%	—	-1.13%
32	DIS	Walt Disney Co/the	Stock-Comm Services	0.88%	—	+0.03%
33	MMM	3m Co	Stock-Industrials	0.85%	—	-0.45%
34	INTC	Intel CORP	Stock-Tech	0.84%	—	+8.03%
35	IWR	Ishares Russell Mid-cap ETF	ETF-Other	0.76%	—	+0.55%
36	VPL	Vanguard Ftse Pacific ETF	ETF-Other	0.76%	—	+2.02%
37	VNQI	Vanguard Glbl Ex-us Real Est	ETF-Other	0.72%	—	+1.63%
38	LMT	Lockheed Martin CORP	Stock-Industrials	0.70%	—	-0.38%
39	KO	Coca-cola Co/the	Stock-Consumer Staples	0.70%	—	+0.15%
40	DIA	Ss Spdr Dow Jones Indus Avg	ETF-Large Cap & Growth	0.66%	—	+0.05%
41	SNA	Snap-on INC	Stock-Industrials	0.66%	—	+1.45%
42	NSC	Norfolk Southern CORP	Stock-Industrials	0.66%	—	-1.11%
43	TIP	Ishares Tips Bond ETF	ETF-Other	0.65%	—	+2.54%
44	PFF	Ishares Preferred & Income S	ETF-Other	0.63%	+0.08%	-2.64%
45	BMY	Bristol-myers Squibb Co	Stock-Healthcare	0.61%	—	-2.64%
46	CVS	Cvs Health CORP	Stock-Healthcare	0.61%	—	-3.19%
47	FISI 8.48 PERP B-1	Financial Institutions I	Stock-Other	0.60%	-0.12%	EXIT
48	ABBV	Abbvie INC	Stock-Healthcare	0.59%	—	-0.68%
49	EEM	Ishares Msci Emerging Market	ETF-Emerging Markets	0.58%	—	+4.38%
50	IWM	Ishares Russell 2000 ETF	ETF-Small Cap	0.58%	—	+0.71%

1–50 of 200

Holding changes this quarter

Position changes disclosed by Canandaigua National Bank & Trust Co for the quarter ending Q4 2017, including ticker, issuer, weight change, shares change, and action
#	Ticker	Issuer	Weight Change	Shares Change	Action
1	SPY	Ss Spdr S&p 500 ETF Trust-us	+0.2%	+3.09%	Add
2	INTC	Intel CORP	+0.2%	+8.03%	Add
3	STZ	Constellation Brands Inc-a	+0.2%	-1.03%	Trim
4	MSFT	Microsoft CORP	+0.1%	-1.02%	Trim
5	JNJ	Johnson & Johnson	+0.1%	+2.78%	Add
6	JPM	Jpmorgan Chase & Co	+0.1%	-1.37%	Trim
7	MCD	Mcdonald's CORP	+0.1%	+3.84%	Add
8	UTXZ	United Tech CORP	+0.1%	-0.49%	Trim
9	CAT	Caterpillar INC	+0.1%	-0.28%	Trim
10	PAYX	Paychex INC	+0.1%	-2.00%	Trim
11	SNA	Snap-on INC	+0.1%	+1.45%	Add
12	VBR	Vanguard Small-cap Value ETF	+0.1%	+18.43%	Add
13	CVX	Chevron CORP	+0.1%	+3.32%	Add
14	DE	Deere & Co	+0.1%	-1.14%	Trim
15	EFA	Ishares Msci Eafe ETF	+0.1%	+4.77%	Add
16	MMM	3m Co	+0.1%	-0.45%	Trim
17	AAPL	Apple INC	0%	-1.29%	Trim
18	QCOM	Qualcomm INC	0%	-4.85%	Trim
19	CSCO	Cisco Systems INC	0%	+1.02%	Add
20	BAC	Bank Of America CORP	0%	-1.58%	Trim
21	DRI	Darden Restaurants INC	0%	-0.88%	Trim
22	FCX	Freeport-mcmoran INC	0%	-13.43%	Trim
23	BLKCHF	Blackrock INC	0%	+3.17%	Add
24	VWO	Vanguard Ftse Emerging Marke	0%	+1.74%	Add
25	DIS	Walt Disney Co/the	0%	+0.03%	Add
26	PEP	Pepsico INC	0%	+0.65%	Add
27	DIA	Ss Spdr Dow Jones Indus Avg	0%	+0.05%	Add
28	VPL	Vanguard Ftse Pacific ETF	0%	+2.02%	Add
29	LOW	Lowe's Cos INC	0%	-1.50%	Trim
30	TXN	Texas Instruments INC	0%	-1.17%	Trim
31	HON	Honeywell International INC	0%	+6.68%	Add
32	NEE	Nextera Energy INC	0%	+3.72%	Add
33	VO	Vanguard Mid-cap ETF	—	+0.12%	Add
34	VGK	Vanguard Ftse Europe ETF	—	+3.47%	Add
35	IBM	Intl Business Machines CORP	—	+0.25%	Add
36	FISI	Financial Institutions INC	0%	-3.32%	Trim
37	VB	Vanguard Small-cap ETF	0%	-0.74%	Trim
38	DKS	Dick's Sporting Goods INC	-0.1%	-40.73%	Trim
39	SLB	Slb LTD	-0.1%	-6.85%	Trim
40	CELG	Celgene CORP	-0.1%	+1.31%	Add
41	GILD	Gilead Sciences INC	-0.1%	-7.09%	Trim
42	CVS	Cvs Health CORP	-0.1%	-3.19%	Trim
43	XOM	Exxon Mobil CORP	-0.1%	-0.33%	Trim
44	JNJ	Johnson & Johnson	-0.2%	-36.19%	Trim
45	MRK	Merck & Co. INC.	-0.2%	+2.89%	Add
46	AEP	American Electric Power Company, Inc.	-0.6%	-9.82%	Trim
47	CAH	Cardinal Health INC	—	EXIT	Sold out
48	CME	Cme Group INC	—	NEW	New buy
49	AMAT	Applied Materials INC	—	NEW	New buy
50	GOVT	Ishares US Treasury Bond ETF	—	EXIT	Sold out