COMERICA SECURITIES INC

13F filer, CIK 1399248, DETROIT, MI

COMERICA SECURITIES INC reported $672,926,000 across 384 holdings for the quarter ended 2017-06-30, in a 13F-HR filed 2017-08-10. Its ten largest share positions make up 22.4% of the portfolio.

Filed 2017-08-10 (acceptance time not in the bulk data set), ingested 2026-10-07 19:08:39 UTC13F-HR 0001399248-17-000033

Period: 2017-06-30
Reported value: $673M
Holdings: 384
Top 10 weight: 22.4%
New: 26
Sold out: 20

Largest buys vs the previous quarter

Security	Shares change	Approx. value
IVVadded	+13,682	$3.33M
CVSadded	+37,469	$3.02M
INTERPUBLIC GROUP COSnew	+119,341	$2.94M
IBMadded	+17,597	$2.71M
BB & T CORPadded	+45,920	$2.08M

Ranked by the share change valued at this quarter's implied price (value over shares in the 13F). A position sold out is valued at the previous quarter's price, its last report.

Largest sells vs the previous quarter

Security	Shares change	Approx. value
GENERAL ELEC COreduced	-123,092	-$3.36M
CAHreduced	-35,083	-$2.75M
CMAreduced	-37,357	-$2.75M
MATexited	-97,202	-$2.49M
IRMexited	-67,211	-$2.4M

Ranked by the share change valued at this quarter's implied price (value over shares in the 13F). A position sold out is valued at the previous quarter's price, its last report.

Holdings, Q2 2017

Share positions as resolved from 13F-HR 0001399248-17-000033, largest first. % of portfolio is the value over $672,926,000, the sum of the share positions whose value is usable for ratios (method).

Security	Shares	Value	% of portfolio	Change	Timeline
IVVISHARES TR	186,495	$45.4M	6.75%	+13,682	Timeline
IJHISHARES TR	94,995	$16.5M	2.46%	+2,638	Timeline
DBEFDBX ETF TR	479,082	$14.4M	2.14%	+4,699	Timeline
EFAISHARES TR	220,556	$14.4M	2.14%	+440	Timeline
BIVVANGUARD BD INDEX FDS	160,660	$13.6M	2.02%	+12,955	Timeline
EEMISHARES TR	261,198	$10.8M	1.61%	+12,751	Timeline
IJRISHARES TR	152,087	$10.7M	1.59%	+6,241	Timeline
IWMISHARES TR	60,547	$8.53M	1.27%	+2,685	Timeline
IVWISHARES TR	61,154	$8.37M	1.24%	+3,252	Timeline
FPFFIRST TR INTER DURATN PFD &	325,495	$8.08M	1.2%	+16,728	Timeline
PIMCO DYNAMIC CR INCOME FDPIMCO DYNAMIC CR INCOME FD	357,243	$8.03M	1.19%	+19,589
TIPISHARES TR	70,292	$7.97M	1.18%	+6,295	Timeline
USMVISHARES TR	149,027	$7.29M	1.08%	+7,792	Timeline
SPYSTATE STR SPDR S&P 500 ETF T	29,271	$7.11M	1.06%	+621	Timeline
IWRISHARES TR	34,706	$6.67M	0.99%	+1,219	Timeline
CSMPROSHARES TR	103,915	$6.25M	0.93%	+1,543	Timeline
IVEISHARES TR	58,445	$6.14M	0.91%	+1,217	Timeline
IGIBISHARES TR	52,069	$5.72M	0.85%	+9,223	Timeline
VOVANGUARD INDEX FDS	38,202	$5.45M	0.81%	+5,246	Timeline
VBVANGUARD INDEX FDS	39,991	$5.42M	0.81%	+369	Timeline
DVYISHARES TR	57,944	$5.34M	0.79%	+1,589	Timeline
BSVVANGUARD BD INDEX FDS	61,913	$4.94M	0.73%	+2,799	Timeline
ABBVABBVIE INC	67,931	$4.93M	0.73%	+1,488	Timeline
CVSCVS HEALTH CORP	61,131	$4.92M	0.73%	+37,469	Timeline
IWFISHARES TR	40,330	$4.8M	0.71%	-427	Timeline
NUENUCOR CORP	81,435	$4.74M	0.7%	+34,298	Timeline
FLOTISHARES TR	92,093	$4.69M	0.7%	+794	Timeline
FTGCFIRST TR EXCHANGE TRAD FD VI	230,203	$4.54M	0.67%	+12,384	Timeline
RAYTHEON CORAYTHEON CO	26,223	$4.25M	0.63%	+1,731
AAPLAPPLE INC	29,426	$4.24M	0.63%	+1,300	Timeline
GLWCORNING INC	140,486	$4.22M	0.63%	-13,398	Timeline
GVIISHARES TR	37,864	$4.19M	0.62%	+3,429	Timeline
VUGVANGUARD INDEX FDS	32,968	$4.19M	0.62%	+5,857	Timeline
INTCINTEL CORP	121,738	$4.11M	0.61%	-1,726	Timeline
VWOVANGUARD INTL EQUITY INDEX F	99,927	$4.08M	0.61%	+12,822	Timeline
IWDISHARES TR	34,951	$4.07M	0.6%	+1,183	Timeline
MRKMERCK & CO INC	62,840	$4.06M	0.6%	+421	Timeline
CSCOCISCO SYS INC	127,808	$4M	0.59%	+6,403	Timeline
VBRVANGUARD INDEX FDS	31,643	$3.9M	0.58%	+2,243	Timeline
METAMETA PLATFORMS INC	25,431	$3.84M	0.57%	+1,598	Timeline
VIGVANGUARD SPECIALIZED FUNDS	39,839	$3.69M	0.55%	+5,675	Timeline
AMZNAMAZON COM INC	3,782	$3.66M	0.54%	+282	Timeline
VHTVANGUARD WORLD FD	24,279	$3.59M	0.53%	-329	Timeline
LWLAMB WESTON HLDGS INC	80,923	$3.56M	0.53%	+741	Timeline
UNHUNITEDHEALTH GROUP INC	18,709	$3.47M	0.52%	-84	Timeline
CVXCHEVRON CORPORATION	32,308	$3.37M	0.5%	+1,339	Timeline
IBMINTERNATIONAL BUSINESS MACHS	21,490	$3.31M	0.49%	+17,597	Timeline
HEALTHSOUTH CORPHEALTHSOUTH CORP	67,790	$3.3M	0.49%	+409
EXTENDED STAY AMER INCEXTENDED STAY AMER INC	167,365	$3.24M	0.48%	+3,473
CELGENE CORPCELGENE CORP	24,571	$3.19M	0.47%	+2,564
IPINTERNATIONAL PAPER CO	55,376	$3.13M	0.47%	+734	Timeline
IEFAISHARES TR	51,409	$3.13M	0.47%	+7,126	Timeline
VTVVANGUARD INDEX FDS	32,327	$3.12M	0.46%	+6,068	Timeline
ABTABBOTT LABORATORIES	63,919	$3.11M	0.46%	+117	Timeline
AJGGALLAGHER ARTHUR J & CO	53,719	$3.08M	0.46%	+279	Timeline
PowerShares QQQ Trust Unit …PowerShares QQQ Trust Unit Ser	22,266	$3.07M	0.46%	+957
AGGISHARES TR	28,015	$3.07M	0.46%	+512	Timeline
IEIISHARES TR	24,485	$3.03M	0.45%	+1,000	Timeline
IEMGISHARES INC	60,246	$3.02M	0.45%	+17,736	Timeline
OLNOLIN CORP	99,523	$3.01M	0.45%	+561	Timeline
ORIOLD REP INTL CORP	153,139	$2.99M	0.44%	+1,610	Timeline
VXUSVANGUARD STAR FDS	56,829	$2.95M	0.44%	+10,542	Timeline
SYYSYSCO CORP	58,436	$2.94M	0.44%	+23,608	Timeline
INTERPUBLIC GROUP COSINTERPUBLIC GROUP COS	119,341	$2.94M	0.44%	new
TE CONNECTIVITY LTDTE CONNECTIVITY LTD	37,147	$2.92M	0.43%	-1,390
FVDFIRST TR EXCHANGE-TRADED FD	99,527	$2.91M	0.43%	-27,086	Timeline
CA INC COMCA INC COM	84,409	$2.91M	0.43%	+134
BB & T CORPBB & T CORP	63,981	$2.9M	0.43%	+45,920
STWDSTARWOOD PPTY TR INC	126,512	$2.89M	0.43%	+715	Timeline
DUPONT FABROS TECHNOLOGY INCDUPONT FABROS TECHNOLOGY INC	46,305	$2.85M	0.42%	-8,014
COPCONOCOPHILLIPS	64,916	$2.85M	0.42%	+3,088	Timeline
INNSUMMIT HOTEL PPTYS	151,566	$2.83M	0.42%	+2,616	Timeline
PBFPBF ENERGY INC	126,089	$2.81M	0.42%	+11,086	Timeline
Lincoln National CorporatLincoln National Corporat	72,914	$2.8M	0.42%	+2,183
ARCCARES CAPITAL CORP	170,027	$2.79M	0.41%	-1,443	Timeline
REGAL ENTMT GROUPREGAL ENTMT GROUP	134,914	$2.76M	0.41%	+1,363
RRYDER SYS INC	38,043	$2.74M	0.41%	+550	Timeline
BNDXVANGUARD CHARLOTTE FDS	49,394	$2.69M	0.4%	+3,963	Timeline
OKEONEOK INC NEW	51,109	$2.67M	0.4%	+576	Timeline
COACH INCCOACH INC	55,893	$2.67M	0.4%	-15,967
BROADCOM LTDBROADCOM LTD	11,374	$2.65M	0.39%	+462
EFAVISHARES TR	37,538	$2.6M	0.39%	-413	Timeline
NSCNORFOLK SOUTHN CORP	21,142	$2.57M	0.38%	-10	Timeline
PACWEST BANCORP DELPACWEST BANCORP DEL	54,715	$2.56M	0.38%	+551
JPMJPMORGAN CHASE & CO	27,595	$2.52M	0.37%	+2,005	Timeline
COFCAPITAL ONE FINL CORP	29,622	$2.45M	0.36%	+627	Timeline
STIPISHARES TR	23,763	$2.38M	0.35%	+1,289	Timeline
VNQVANGUARD INDEX FDS	28,055	$2.33M	0.35%	+430	Timeline
AMGNAMGEN INC	13,333	$2.3M	0.34%	+725	Timeline
HEFAISHARES TR	80,677	$2.29M	0.34%	+53,811	Timeline
CAGCONAGRA BRANDS INC	64,132	$2.29M	0.34%	+838	Timeline
UNITED TECHNOLOGIES CORPUNITED TECHNOLOGIES CORP	17,686	$2.16M	0.32%	+1,388
GOOGLALPHABET INC	2,312	$2.15M	0.32%	+88	Timeline
XEFRXEATON VANCE SR FLTNG RTE TR	143,769	$2.14M	0.32%	+13,001	Timeline
BSLBLACKSTONE SENI FLTN RAT 202	119,068	$2.13M	0.32%	+10,548	Timeline
EFTEATON VANCE FLOATING RATE IN	140,509	$2.13M	0.32%	+12,168	Timeline
CMICUMMINS INC	12,888	$2.09M	0.31%	+16	Timeline
VVRINVESCO SR INCOME TR	458,322	$2.09M	0.31%	+39,670	Timeline
TAT&T INC	55,191	$2.08M	0.31%	-8,832	Timeline
GLDSPDR GOLD TR	16,374	$1.93M	0.29%	+58	Timeline
NUVEEN SHORT DURATION CREDITNUVEEN SHORT DURATION CREDIT	109,672	$1.93M	0.29%	+12,828
NKENIKE INC	32,346	$1.91M	0.28%	-1,407	Timeline
THL CR SR LN FDTHL CR SR LN FD	107,638	$1.91M	0.28%	+10,139
TRVTRAVELERS COMPANIES INC	15,061	$1.91M	0.28%	+305	Timeline
QAINYLIM ETF TR	64,540	$1.9M	0.28%	+10,934	Timeline
VOYA PRIME RATE TRUSTVOYA PRIME RATE TRUST	351,642	$1.89M	0.28%	+40,050
PIONEER FLOATING RATE FUND IPIONEER FLOATING RATE FUND I	157,241	$1.87M	0.28%	+15,750
MSFTMICROSOFT CORP	26,770	$1.84M	0.27%	+2,446	Timeline
EMBISHARES TR	15,420	$1.76M	0.26%	+10,478	Timeline
HYGHISHARES U S ETF TR	19,265	$1.76M	0.26%	+1,113	Timeline
VZVERIZON COMMUNICATIONS INC	38,863	$1.74M	0.26%	+1,330	Timeline
VVISA INC	18,509	$1.74M	0.26%	+72	Timeline
SCORPIO TANKERS INCSCORPIO TANKERS INC	423,883	$1.68M	0.25%	+2,061
FAFFIRST AMERN FINL CORP	37,538	$1.68M	0.25%	new	Timeline
JNJJOHNSON & JOHNSON	12,589	$1.67M	0.25%	-176	Timeline
XOMEXXON MOBIL CORP	20,561	$1.66M	0.25%	-4,763	Timeline
VTVANGUARD INTL EQUITY INDEX F	24,221	$1.65M	0.24%	-57	Timeline
DISDISNEY WALT CO	15,495	$1.65M	0.24%	+1,023	Timeline
MOALTRIA GROUP INC	21,832	$1.64M	0.24%	-7,571	Timeline
BPBP PLC	47,128	$1.63M	0.24%	-5,069	Timeline
RYDEX ETF TRUSTRYDEX ETF TRUST	13,058	$1.63M	0.24%	0
PMPHILIP MORRIS INTL INC	13,148	$1.56M	0.23%	-7,397	Timeline
SBUXSTARBUCKS CORP	26,694	$1.56M	0.23%	+346	Timeline
HDHOME DEPOT INC	10,066	$1.54M	0.23%	+266	Timeline
PGPROCTER & GAMBLE CO	17,714	$1.54M	0.23%	-900	Timeline
VTWOVANGUARD SCOTTSDALE FDS	13,626	$1.54M	0.23%	+1,768	Timeline
ALPS ETF TRALPS ETF TR	128,763	$1.54M	0.23%	-5,495
SPDR SERIES TRUST BLOOMBERG…SPDR SERIES TRUST BLOOMBERG BR	41,122	$1.53M	0.23%	+2,386
IGSBISHARES TR	14,478	$1.52M	0.23%	+1,483	Timeline
LQDISHARES TR	12,627	$1.52M	0.23%	+3,378	Timeline
VONGVANGUARD SCOTTSDALE FDS	12,109	$1.48M	0.22%	+595	Timeline
TJXTJX COS INC NEW	20,259	$1.46M	0.22%	+1,271	Timeline
GOOGALPHABET INC	1,598	$1.45M	0.22%	+7	Timeline
VDCVANGUARD WORLD FD	10,019	$1.42M	0.21%	+1,322	Timeline
KMBKIMBERLY-CLARK CORP	10,819	$1.41M	0.21%	+259	Timeline
VPUVANGUARD WORLD FD	11,936	$1.37M	0.2%	+1,746	Timeline
WMTWALMART INC	18,079	$1.37M	0.2%	+50	Timeline
Dow Chemical CompanyDow Chemical Company	20,946	$1.33M	0.2%	-6,328
BRK-BBERKSHIRE HATHAWAY INC DEL	7,667	$1.3M	0.19%	+191	Timeline
FTAFIRST TR EXCHANGE-TRADED ALP	25,749	$1.29M	0.19%	+553	Timeline
DLTRDOLLAR TREE INC	18,432	$1.29M	0.19%	+1,142	Timeline
SHWSHERWIN WILLIAMS CO	3,644	$1.28M	0.19%	+61	Timeline
SHYISHARES TR	15,103	$1.28M	0.19%	-11,573	Timeline
MAMASTERCARD INCORPORATED	10,496	$1.27M	0.19%	+183	Timeline
QCOMQUALCOMM INC	22,996	$1.27M	0.19%	+1,978	Timeline
LMTLOCKHEED MARTIN CORP	4,543	$1.26M	0.19%	+50	Timeline
SLBSLB LIMITED	18,896	$1.25M	0.19%	+4,568	Timeline
NVONOVO-NORDISK A S	29,038	$1.25M	0.19%	+878	Timeline
HYGISHARES TR	13,839	$1.22M	0.18%	-4,112	Timeline
OXYOCCIDENTAL PETE CORP	19,704	$1.19M	0.18%	+6,028	Timeline
PRICELINE GRP INCPRICELINE GRP INC	636	$1.19M	0.18%	+20
TTCTORO CO	17,106	$1.19M	0.18%	+859	Timeline
VOOVANGUARD INDEX FDS	5,338	$1.19M	0.18%	+405	Timeline
WSOWATSCO INC	7,676	$1.18M	0.18%	new	Timeline
KOCOCA COLA CO	25,891	$1.17M	0.17%	+474	Timeline
VEAVANGUARD TAX-MANAGED FDS	28,125	$1.16M	0.17%	+583	Timeline
PFFISHARES TR	29,564	$1.16M	0.17%	+2,789	Timeline
UPSUNITED PARCEL SVCS INC	10,434	$1.15M	0.17%	+320	Timeline
LAM RESEARCH CORPLAM RESEARCH CORP	8,061	$1.14M	0.17%	-240
CNICANADIAN NATL RY CO	13,986	$1.14M	0.17%	+181	Timeline
IYFISHARES TR	10,442	$1.12M	0.17%	+2,396	Timeline
MPCMARATHON PETE CORP	21,152	$1.11M	0.16%	-56	Timeline
WFCWELLS FARGO & CO	19,922	$1.1M	0.16%	-2,297	Timeline
ALLALLSTATE CORP	12,408	$1.1M	0.16%	+4	Timeline
PYPLPAYPAL HLDGS INC	20,466	$1.1M	0.16%	-1,333	Timeline
MLMMARTIN MARIETTA MATLS INC	4,927	$1.1M	0.16%	+1,066	Timeline
TLTISHARES TR	8,603	$1.08M	0.16%	+2,995	Timeline
GSGOLDMAN SACHS GROUP INC	4,802	$1.07M	0.16%	-154	Timeline
PKGPACKAGING CORP AMER	9,420	$1.05M	0.16%	+118	Timeline
DDWMWISDOMTREE TR	36,558	$1.04M	0.15%	-1,775	Timeline
ADMARCHER DANIELS MIDLAND CO	25,119	$1.04M	0.15%	+218	Timeline
FEMFIRST TR EXCH TRD ALPHDX FD	43,908	$1.03M	0.15%	+13,290	Timeline
VLOVALERO ENERGY CORP	15,038	$1.01M	0.15%	-1,218	Timeline
FDTFIRST TR EXCH TRD ALPHDX FD	17,886	$988K	0.15%	+8,562	Timeline
IMCBISHARES TR	5,810	$981K	0.15%	-112	Timeline
TMOTHERMO FISHER SCIENTIFIC INC	5,587	$976K	0.15%	+115	Timeline
REYNOLDS AMERICAN INCREYNOLDS AMERICAN INC	14,802	$970K	0.14%	-2,023
ICFISHARES TR	9,554	$966K	0.14%	-170	Timeline
HONHONEYWELL INTL INC	7,163	$955K	0.14%	-58	Timeline
ELLAUDER ESTEE COS INC	9,895	$950K	0.14%	+182	Timeline
WDCWESTERN DIGITAL CORP	10,546	$940K	0.14%	-36	Timeline
NWLNEWELL BRANDS INC	17,487	$938K	0.14%	new	Timeline
BLACKROCK INCBLACKROCK INC	2,182	$922K	0.14%	+68
ACNACCENTURE PLC IRELAND	7,406	$916K	0.14%	-1,531	Timeline
FYXFIRST TR EXCHANGE-TRADED ALP	16,357	$910K	0.14%	+3,063	Timeline
SUSUNCOR ENERGY INC NEW	31,054	$907K	0.13%	+3,898	Timeline
BABOEING CO	4,514	$893K	0.13%	-136	Timeline
MDTMEDTRONIC PLC	9,959	$884K	0.13%	-197	Timeline
PEPPEPSICO INC	7,589	$877K	0.13%	+123	Timeline
AIGAMERICAN INTL GROUP INC	13,679	$855K	0.13%	-184	Timeline
STLDSTEEL DYNAMICS INC	23,716	$853K	0.13%	-194	Timeline
SCHWCHARLES SCHWAB CORP (THE)	19,576	$841K	0.12%	+2,319	Timeline
FPEFIRST TR EXCH TRADED FD III	41,986	$840K	0.12%	+5,303	Timeline
IVZINVESCO LTD	23,671	$833K	0.12%	+502	Timeline
VODVODAFONE GROUP PLC	27,723	$827K	0.12%	+1,724	Timeline
TDTORONTO DOMINION BK ONT	16,235	$818K	0.12%	-325	Timeline
IEFISHARES TR	7,636	$814K	0.12%	+3,400	Timeline
BNDVANGUARD BD INDEX FDS	9,940	$813K	0.12%	+2,643	Timeline
NEARISHARES U S ETF TR	15,917	$800K	0.12%	+7,398	Timeline
IWVISHARES TR	5,418	$780K	0.12%	-60	Timeline
UNPUNION PAC CORP	7,127	$776K	0.12%	+349	Timeline
FDSFACTSET RESH SYS INC	4,653	$773K	0.11%	+95	Timeline
CMCSACOMCAST CORP NEW	19,684	$769K	0.11%	+647	Timeline
VBKVANGUARD INDEX FDS	5,268	$768K	0.11%	-6	Timeline
VOTVANGUARD INDEX FDS	6,355	$748K	0.11%	+123	Timeline
PFEPFIZER INC	22,190	$745K	0.11%	-1,795	Timeline
POWERSHARESPOWERSHARES	32,193	$745K	0.11%	+115
SCRIPPS NETWORKS INTERACT INSCRIPPS NETWORKS INTERACT IN	10,901	$745K	0.11%	+215
MAGELLAN MIDSTREAM PARTNERS…MAGELLAN MIDSTREAM PARTNERS, L	10,376	$740K	0.11%	-25
STZCONSTELLATION BRANDS INC	3,810	$738K	0.11%	new	Timeline
PCARPACCAR INC	11,134	$735K	0.11%	+603	Timeline
HRLHORMEL FOODS CORP	21,007	$717K	0.11%	+648	Timeline
VCITVANGUARD SCOTTSDALE FDS	8,169	$715K	0.11%	+4,872	Timeline
WMWASTE MGMT INC DEL	9,690	$711K	0.11%	+229	Timeline
LEALEAR CORP	4,840	$688K	0.1%	+433	Timeline
SNYSANOFI SA	14,158	$678K	0.1%	-591	Timeline
BCEBCE INC	15,014	$677K	0.1%	+1,506	Timeline
TSMTAIWAN SEMICONDUCTOR MANUFAC	18,660	$669K	0.1%	+1,365	Timeline
ZTSZOETIS INC	10,508	$657K	0.1%	+260	Timeline
KHCKRAFT HEINZ CO	7,662	$656K	0.1%	+23	Timeline
FDXFEDEX CORP	2,992	$652K	0.1%	-240	Timeline
ECLECOLAB INC	4,899	$652K	0.1%	+270	Timeline
SUBISHARES TR	6,154	$651K	0.1%	+219	Timeline
STATE STREETSTATE STREET	5,251	$647K	0.1%	-60
TROWPRICE T ROWE GROUP INC	8,649	$642K	0.1%	-2,212	Timeline
MUBISHARES TR	5,821	$641K	0.1%	+50	Timeline
SCHOSCHWAB STRATEGIC TR	12,580	$634K	0.09%	0	Timeline
ADBEADOBE INC	4,475	$633K	0.09%	-932	Timeline
CCITIGROUP INC	9,129	$611K	0.09%	-212	Timeline
MCDMCDONALDS CORP	3,978	$609K	0.09%	-2,744	Timeline
XLFSELECT SECTOR SPDR TR	24,572	$606K	0.09%	+5,863	Timeline
GREAT PLAINS ENERGY INCGREAT PLAINS ENERGY INC	20,427	$598K	0.09%	+553
CCICROWN CASTLE INC	5,929	$594K	0.09%	+1,436	Timeline
DDOMINION ENERGY INC	7,560	$579K	0.09%	+1,259	Timeline
TXNTEXAS INSTRS INC	7,439	$572K	0.09%	+468	Timeline
MXIISHARES TR	9,555	$572K	0.09%	+4,159	Timeline
ELVELEVANCE HEALTH INC FORMERLY	3,036	$571K	0.08%	-378	Timeline
CBCHUBB LIMITED	3,890	$568K	0.08%	+233	Timeline
FASTFASTENAL CO	12,668	$551K	0.08%	+4,442	Timeline
MMM3M CO	2,634	$548K	0.08%	-408	Timeline
EBAYEBAY INC.	15,496	$541K	0.08%	+1,099	Timeline
IGFISHARES TR	12,241	$538K	0.08%	+174	Timeline
CTSHCOGNIZANT TECHNOLOGY SOLUTIO	7,810	$519K	0.08%	+32	Timeline
DUKDUKE ENERGY CORP NEW	6,192	$518K	0.08%	+589	Timeline
iShares Gold TrustiShares Gold Trust	43,332	$517K	0.08%	-3,100
NGGNATIONAL GRID PLC	8,134	$511K	0.08%	new	Timeline
VTIVANGUARD INDEX FDS	4,060	$505K	0.08%	+15	Timeline
QTECFIRST TR EXCHANGE-TRADED FD	8,058	$503K	0.07%	+1,614	Timeline
EMLPFIRST TR EXCHANGE-TRADED FD	20,489	$503K	0.07%	-770	Timeline
FTCFIRST TR EXCHANGE-TRADED ALP	9,108	$500K	0.07%	+181	Timeline
FNXFIRST TR EXCHANGE-TRADED ALP	8,429	$499K	0.07%	-29	Timeline
SOSOUTHERN CO	10,371	$497K	0.07%	-3,219	Timeline
STTSTATE STR CORP	5,434	$490K	0.07%	-35	Timeline
AZNASTRAZENECA PLC-SPONS ADR	14,369	$490K	0.07%	+2,681	Timeline
SCZISHARES TR	8,460	$489K	0.07%	-453	Timeline
GLAXOSMITHKLINE PLC-ADRGLAXOSMITHKLINE PLC-ADR	10,735	$467K	0.07%	+1,933
GDGENERAL DYNAMICS CORP	2,350	$465K	0.07%	+15	Timeline
GISGENERAL MILLS INC	8,323	$461K	0.07%	+1,430	Timeline
UAAUNDER ARMOUR INC	20,950	$456K	0.07%	-145	Timeline
HDBHDFC BANK LTD	5,200	$454K	0.07%	+1,459	Timeline
IYHISHARES TR	2,727	$453K	0.07%	+330	Timeline
POWERSHARES INDIA ETF TRPOWERSHARES INDIA ETF TR	19,633	$448K	0.07%	+477
MOSMOSAIC CO	19,024	$434K	0.06%	+2,476	Timeline
CAHCARDINAL HEALTH INC	5,496	$431K	0.06%	-35,083	Timeline
LOWLOWES COS INC	5,437	$422K	0.06%	-230	Timeline
HCAHCA HEALTHCARE INC	4,816	$420K	0.06%	-393	Timeline
AETNA INC NEWAETNA INC NEW	2,761	$419K	0.06%	new
XLESELECT SECTOR SPDR TR	6,396	$415K	0.06%	-672	Timeline
KMIKINDER MORGAN INC DEL	21,667	$415K	0.06%	-6,382	Timeline
WPPWPP PLC NEW	3,821	$412K	0.06%	+82	Timeline
USBUS BANCORP	7,839	$409K	0.06%	+627	Timeline
VMWARE, INC.VMWARE, INC.	4,648	$406K	0.06%	+448
PPLPPL CORP	10,330	$403K	0.06%	+1,586	Timeline
RED HAT INCRED HAT INC	4,170	$399K	0.06%	+183
EMREMERSON ELEC CO	6,665	$397K	0.06%	-255	Timeline
LLYELI LILLY & CO	4,801	$395K	0.06%	+199	Timeline
SAPSAP SE	3,752	$393K	0.06%	-409	Timeline
NVSNOVARTIS AG	4,686	$391K	0.06%	-4,222	Timeline
EWEDWARDS LIFESCIENCES CORP	3,296	$390K	0.06%	-95	Timeline
IYRISHARES TR	4,884	$390K	0.06%	+292	Timeline
WELLWELLTOWER INC	5,180	$388K	0.06%	+295	Timeline
RIORIO TINTO PLC	8,987	$380K	0.06%	-111	Timeline
PSXPHILLIPS 66	4,487	$371K	0.06%	+932	Timeline
PRUPRUDENTIAL FINL INC	3,434	$371K	0.06%	+206	Timeline
SHVISHARES TR	3,291	$363K	0.05%	-2,165	Timeline
TOTALENERGIES SETOTALENERGIES SE	7,302	$362K	0.05%	+2,481
FTSE RAFI 1000 US Lg CapFTSE RAFI 1000 US Lg Cap	3,469	$359K	0.05%	+1,394
CATCATERPILLAR INC	3,312	$356K	0.05%	-29	Timeline
MBBISHARES TR	3,331	$356K	0.05%	+301	Timeline
BDXBECTON DICKINSON & CO	1,826	$356K	0.05%	+236	Timeline
CMACOMERICA INC	4,798	$353K	0.05%	-37,357	Timeline
MONSANTO CO NEWMONSANTO CO NEW	2,970	$352K	0.05%	+278
MDLZMONDELEZ INTL INC	8,100	$351K	0.05%	+217	Timeline
AKAMAKAMAI TECHNOLOGIES INC	6,982	$348K	0.05%	+1,599	Timeline
BUDANHEUSER BUSCH INBEV SA NV	3,148	$347K	0.05%	+231	Timeline
ALLERGAN PLCALLERGAN PLC	1,416	$344K	0.05%	+263
ETNEATON CORP PLC	4,313	$336K	0.05%	-1,619	Timeline
VRSKVERISK ANALYTICS INC	3,974	$335K	0.05%	+204	Timeline
WALGREENS BOOTS ALLIANCE INCWALGREENS BOOTS ALLIANCE INC	4,258	$333K	0.05%	-157
BIDUBAIDU INC	1,828	$327K	0.05%	-790	Timeline
SMFGSUMITOMO MITSUI FIN GRP INC	41,078	$327K	0.05%	+680	Timeline
REGNREGENERON PHARMACEUTICALS	661	$325K	0.05%	+112	Timeline
SYKSTRYKER CORPORATION	2,321	$323K	0.05%	-1,700	Timeline
GENERAL ELEC COGENERAL ELEC CO	11,805	$322K	0.05%	-123,092
TGTTARGET CORP	6,106	$319K	0.05%	-26,541	Timeline
FEXFIRST TR EXCHANGE-TRADED ALP	6,009	$319K	0.05%	new	Timeline
BSXBOSTON SCIENTIFIC CORP	11,478	$318K	0.05%	+99	Timeline
BABAALIBABA GROUP HLDG LTD	2,256	$318K	0.05%	-271	Timeline
ORCLORACLE CORP	6,300	$316K	0.05%	-1,237	Timeline
APHAMPHENOL CORP	4,213	$312K	0.05%	+245	Timeline
MIDDMIDDLEBY CORP	2,535	$308K	0.05%	+150	Timeline
THSTREEHOUSE FOODS INC	3,757	$307K	0.05%	+45	Timeline
BIIBBIOGEN INC	1,126	$306K	0.05%	+98	Timeline
IBBISHARES TR	981	$304K	0.05%	-13	Timeline
TSCOTRACTOR SUPPLY CO	5,596	$303K	0.05%	+2,254	Timeline
ROSTROSS STORES INC	5,243	$303K	0.05%	+936	Timeline
BMYBRISTOL-MYERS SQUIBB CO	5,398	$301K	0.04%	+228	Timeline
EEMVISHARES INC	5,404	$299K	0.04%	-4,789	Timeline
XLPSELECT SECTOR SPDR TR	5,421	$298K	0.04%	+275	Timeline
ADPAUTOMATIC DATA PROCESSING IN	2,864	$295K	0.04%	0	Timeline
FXOFIRST TR EXCHANGE-TRADED FD	10,330	$295K	0.04%	+1,737	Timeline
ROCKWELL COLLINS INCROCKWELL COLLINS INC	2,810	$295K	0.04%	+416
UBSUBS GROUP AG	17,277	$293K	0.04%	+1,325	Timeline
VTRVENTAS INC	4,222	$293K	0.04%	+319	Timeline
ALEXION PHARMACEUTICALS INCALEXION PHARMACEUTICALS INC	2,394	$291K	0.04%	+196
FGDFIRST TR EXCHANGE-TRADED FD	11,508	$288K	0.04%	0	Timeline
HALHALLIBURTON CO	6,606	$282K	0.04%	+18	Timeline
GILDGILEAD SCIENCES INC	3,958	$280K	0.04%	-3,074	Timeline
CORE LABORATORIES N VCORE LABORATORIES N V	2,760	$280K	0.04%	+231
MTBM & T BK CORP	1,723	$279K	0.04%	+273	Timeline
ICEINTERCONTINENTAL EXCHANGE IN	4,217	$278K	0.04%	-115	Timeline
ROYAL DUTCH SHELL PLC SPN A…ROYAL DUTCH SHELL PLC SPN ADR	5,099	$278K	0.04%	+772
CHKPCHECK POINT SOFTWARE TECH LT	2,473	$270K	0.04%	-232	Timeline
IWPISHARES TR	2,485	$269K	0.04%	+462	Timeline
PHGKONINKLIJKE PHILIPS N V	7,479	$268K	0.04%	+972	Timeline
PIONEER NATURAL RESOURCES COPIONEER NATURAL RESOURCES CO	1,677	$268K	0.04%	new
MLRGISHARES TR	1,818	$266K	0.04%	-14	Timeline
AXPAMERICAN EXPRESS CO	3,110	$262K	0.04%	+385	Timeline
HSYHERSHEY CO	2,438	$262K	0.04%	0	Timeline
NOCNORTHROP GRUMMAN CORP	1,019	$262K	0.04%	-30	Timeline
MUFGMITSUBISHI UFJ FINANCIAL GRO	38,698	$261K	0.04%	-11,223	Timeline
ISHARES TRISHARES TR	10,169	$260K	0.04%	new
AMTAMERICAN TOWER CORP	1,944	$258K	0.04%	new	Timeline
METMETLIFE INC	4,682	$257K	0.04%	+263	Timeline
SHMSPDR SERIES TRUST	5,218	$253K	0.04%	0	Timeline
RELX NVRELX NV	12,251	$253K	0.04%	-86
LYGLLOYDS BANKING GROUP PLC	71,417	$252K	0.04%	+11,038	Timeline
YUMCYUM CHINA HLDGS INC	6,376	$251K	0.04%	new	Timeline
MMSMAXIMUS INC	4,002	$251K	0.04%	+223	Timeline
VAWVANGUARD WORLD FD	2,050	$250K	0.04%	-146	Timeline
NATIONAL OILWELL VARCO INCNATIONAL OILWELL VARCO INC	7,580	$250K	0.04%	0
AEPAMERICAN ELEC PWR CO INC	3,535	$246K	0.04%	+119	Timeline
JP MORGAN CHASE & COJP MORGAN CHASE & CO	8,200	$244K	0.04%	-195
RYDEX ETF TRUSTRYDEX ETF TRUST	6,184	$244K	0.04%	new
SDYSPDR SERIES TRUST	2,723	$242K	0.04%	-735	Timeline
HPQHP INC	13,763	$242K	0.04%	new	Timeline
HOGHARLEY DAVIDSON INC	4,452	$240K	0.04%	0	Timeline
CPBTHE CAMPBELLS COMPANY	4,604	$240K	0.04%	0	Timeline
NDAQNASDAQ INC	3,312	$237K	0.04%	new	Timeline
ISCGISHARES TR	1,451	$233K	0.03%	new	Timeline
BBVABANCO BILBAO VIZCAYA ARGENTA	27,835	$233K	0.03%	+3,093	Timeline
XRAYDENTSPLY SIRONA INC	3,589	$233K	0.03%	new	Timeline
FNFFIDELITY NATL FINL INC	5,100	$229K	0.03%	new	Timeline
HARRIS CORP INCHARRIS CORP INC	2,068	$226K	0.03%	+70
NEENEXTERA ENERGY INC	1,596	$224K	0.03%	-294	Timeline
IYEISHARES TR	6,227	$221K	0.03%	-120	Timeline
PANWPALO ALTO NETWORKS INC	1,629	$218K	0.03%	new	Timeline
BNYBANK OF NY MELLON CORP	4,259	$217K	0.03%	-66	Timeline
KEYKEYCORP	11,535	$216K	0.03%	+83	Timeline
CBRLCRACKER BARREL OLD CTRY STOR	1,283	$215K	0.03%	new	Timeline
MSMORGAN STANLEY	4,784	$213K	0.03%	new	Timeline
VTWGVANGUARD SCOTTSDALE FDS	1,729	$213K	0.03%	0	Timeline
TWENTY FIRST CENTY FOX INCTWENTY FIRST CENTY FOX INC	7,529	$213K	0.03%	+1,170
FEMSFIRST TR EXCH TRD ALPHDX FD	5,614	$207K	0.03%	-154	Timeline
BACBANK OF AMER CORP	8,397	$204K	0.03%	-2,649	Timeline
BFHBREAD FINANCIAL HOLDINGS INC	793	$204K	0.03%	new	Timeline
XILINX INCXILINX INC	3,136	$202K	0.03%	new
SWKSTANLEY BLACK & DECKER INC	1,422	$200K	0.03%	-428	Timeline
MSMLISHARES TR	1,235	$200K	0.03%	new	Timeline
FFORD MTR CO	14,041	$157K	0.02%	-50,084	Timeline
BCSBARCLAYS PLC	13,090	$139K	0.02%	-297	Timeline
ITUBITAU UNIBANCO HLDG S A	10,598	$117K	0.02%	new	Timeline
IBNICICI BK LTD	12,780	$115K	0.02%	new	Timeline
ABEVAMBEV SA	10,203	$57K	0.01%	-2,485	Timeline

Sold out in Q2 2017

Positions in the previous quarter's report that this quarter's report no longer lists.

Security	Shares before	Value before	Type
MATMATTEL INC	97,202	$2.49M	shares
IRMIRON MTN INC DEL	67,211	$2.4M	shares
KKELLANOVA	27,573	$2M	shares
BGSB & G FOODS INC	42,562	$1.71M	shares
HPHELMERICH & PAYNE INC	11,098	$739K	shares
IYJISHARES TR	5,742	$723K	shares
NATIONAL GRID PLCNATIONAL GRID PLC	8,097	$514K	shares
POWERSHS DB US DOLLAR INDEX…POWERSHS DB US DOLLAR INDEX DO	16,321	$424K	shares
IWBISHARES TR	2,867	$376K	shares
VCLTVANGUARD SCOTTSDALE FDS	3,933	$354K	shares
DU PONT E I DE NEMOURS & CODU PONT E I DE NEMOURS & CO	4,122	$331K	shares
SUNTRUST BANKS INCSUNTRUST BANKS INC	5,631	$311K	shares
BRK-ABERKSHIRE HATHAWAY INC DEL	1	$250K	shares
AZOAUTOZONE INC	339	$245K	shares
RPMRPM INTL INC	3,775	$208K	shares
IJTISHARES TR	1,320	$202K	shares
GWWWW GRAINGER INC	862	$201K	shares
FIRST TRUST NEW OPPORTUNITI…FIRST TRUST NEW OPPORTUNITIES	12,800	$173K	shares
SANBANCO SANTANDER SA	10,592	$64K	shares
INUVO INCINUVO INC	47,033	$61K	shares

How Q2 2017 was built

Available 13F filings of this filer for the quarter and their roles: the base report is the latest original or restatement, NEW HOLDINGS amendments filed after it are added (method).

Filing	Role	Amendment	Filed	Accepted	Ingested
13F-HR 0001399248-17-000033	base		2017-08-10	acceptance time not in the bulk data set	2026-10-07 19:08:39 UTC