13F-HR filed by Rehmann Capital Advisory Group
Rehmann Capital Advisory Group filed this 13F-HR for the quarter ended 2017-06-30, filed 2017-07-19, with 373 holding rows worth $523,435,000.
- Accession
- 0001633037-17-000005
- Filer
- CIK 1633037
- Filed
- 2017-07-19
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q2 2017
A holdings report, 374 entries on the cover page, a total value of $523,435,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $523,435,000 with VALUE read as thousands by filing date, 13F file number 028-16835. The quarter's positions are built on this report. The resolved quarter.
The information table after summing rows of one CUSIP and put or call (H4), with the CUSIP and issuer name as filed. Values in dollars after the unit check (method).
| Issuer as filed | CUSIP | Class | Amount | Value | Value read as | Type |
|---|---|---|---|---|---|---|
| PepsiCo,Inc. | 713448108 | COM | 263,546 | $30,437,000 | thousands by filing date | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 399,569 | $24,330,000 | thousands by filing date | |
| iShares S&P 500 Growth ETF | 464287309 | SHS | 167,441 | $22,914,000 | thousands by filing date | |
| iShares S&P 500 Value ETF | 464287408 | SHS | 187,127 | $19,641,000 | thousands by filing date | |
| iShares Core S&P Total U.S. Stock Market ETF | 464287150 | SHS | 298,269 | $16,530,000 | thousands by filing date | |
| FIRST TR VALUE LINE DIVID IN | 33734H106 | SHS | 531,294 | $15,540,000 | thousands by filing date | |
| Dow Chemical Company | 260543103 | COM | 204,512 | $12,899,000 | thousands by filing date | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 164,120 | $11,506,000 | thousands by filing date | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 46,293 | $11,268,000 | thousands by filing date | |
| IJH | 464287507 | COM | 58,931 | $10,251,000 | thousands by filing date | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 199,391 | $9,978,000 | thousands by filing date | |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 77,874 | $8,528,000 | thousands by filing date | |
| ISHARES TR | 464288513 | IBOXX HI YD ETF | 91,847 | $8,118,000 | thousands by filing date | |
| ISHARES TR | 46432F859 | CORE 1 5 YR USD | 127,918 | $6,429,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 43,425 | $6,254,000 | thousands by filing date | |
| Vanguard Intermediate-Term Corporate Bond ETF | 92206C870 | SHS | 70,694 | $6,188,000 | thousands by filing date | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 110,646 | $6,015,000 | thousands by filing date | |
| Vanguard Dividend Appreciation ETF | 921908844 | SHS | 61,172 | $5,669,000 | thousands by filing date | |
| iShares TIPS Bond ETF | 464287176 | SHS | 49,630 | $5,630,000 | thousands by filing date | |
| iShares S&P Mid-Cap 400 Value ETF | 464287705 | SHS | 37,341 | $5,547,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 76,482 | $4,987,000 | thousands by filing date | |
| iShares MBS ETF | 464288588 | SHS | 43,812 | $4,677,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 33,843 | $4,477,000 | thousands by filing date | |
| ISHARES RUSSELL 1000 VALUE ETF | 464287598 | ETF | 37,635 | $4,382,000 | thousands by filing date | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 35,286 | $4,200,000 | thousands by filing date | |
| Vanguard Growth | 922908736 | COM | 30,704 | $3,901,000 | thousands by filing date | |
| Pfizer Inc. | 717081103 | COM | 111,609 | $3,749,000 | thousands by filing date | |
| ISHARES TR | 464288661 | 3 7 YR TREAS BD | 29,761 | $3,678,000 | thousands by filing date | |
| ISHARES 1-5 YEAR INVESTMENT GRADE CORPORATE BOND ETF | 464288646 | ETF | 32,038 | $3,374,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C409 | COM | 40,997 | $3,281,000 | thousands by filing date | |
| ISHARES TR | 464287606 | S&P MC 400GR ETF | 16,589 | $3,262,000 | thousands by filing date | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 77,043 | $3,189,000 | thousands by filing date | |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 76,940 | $3,179,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 44,195 | $3,046,000 | thousands by filing date | |
| JPMorgan Chase & Co | 46625H100 | COM | 32,910 | $3,008,000 | thousands by filing date | |
| iShares Gold Trust | 464285105 | ISHARES | 236,581 | $2,825,000 | thousands by filing date | |
| ISHARES TR | 464288117 | INTL TREA BD ETF | 28,723 | $2,748,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A151 | SST SPDR BLOOMBE | 81,701 | $2,717,000 | thousands by filing date | |
| URSTADT BIDDLE PROPERTIES | 917286205 | COMMON STOCK | 135,753 | $2,688,000 | thousands by filing date | |
| PROASSURANCE CORP | 74267C106 | COM | 43,655 | $2,654,000 | thousands by filing date | |
| ISHARESAGENCYBONDETF | 464288166 | STOK | 22,376 | $2,544,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R866 | INTER MUN BD ACT | 46,190 | $2,470,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 30,355 | $2,451,000 | thousands by filing date | |
| Vanguard Value ETF | 922908744 | SHS | 25,204 | $2,434,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 27,580 | $2,404,000 | thousands by filing date | |
| Vanguard Intermediate-Term Bond ETF | 921937819 | SHS | 27,886 | $2,357,000 | thousands by filing date | |
| Amazon.com, Inc | 023135106 | COM | 2,180 | $2,110,000 | thousands by filing date | |
| SPY | 78462F103 | SHS | 8,567 | $2,071,000 | thousands by filing date | |
| ISHARES TR | 464287457 | COM | 23,937 | $2,022,000 | thousands by filing date | |
| Fidelity MSCI Information Technology Index ETF | 316092808 | SHS | 45,776 | $1,956,000 | thousands by filing date | |
| iShares Russell 2000 ETF | 464287655 | SHS | 13,879 | $1,956,000 | thousands by filing date | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 17,708 | $1,950,000 | thousands by filing date | |
| AT&T Inc | 00206R102 | COM | 51,648 | $1,949,000 | thousands by filing date | |
| PowerShares QQQ Trust Unit Ser | 73935A104 | COM | 13,560 | $1,866,000 | thousands by filing date | |
| Chevron Corporation | 166764100 | COM | 17,863 | $1,864,000 | thousands by filing date | |
| FIDELITY COVINGTON TRUST | 316092501 | MSCI FINLS IDX | 50,649 | $1,841,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y704 | INDL | 26,866 | $1,830,000 | thousands by filing date | |
| HYD | 92189F361 | ETF | 58,349 | $1,804,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 1,974 | $1,793,000 | thousands by filing date | |
| ISHARES TR | 46429B333 | GNMA BOND ETF | 35,483 | $1,764,000 | thousands by filing date | |
| GENERAL ELEC CO | 369604103 | COM | 65,171 | $1,760,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 51,444 | $1,736,000 | thousands by filing date | |
| VTI | 922908769 | COM | 13,859 | $1,725,000 | thousands by filing date | |
| FORD MTR CO COM | 345370860 | Stock | 153,655 | $1,719,000 | thousands by filing date | |
| Walmart Inc. | 931142103 | COM | 21,975 | $1,663,000 | thousands by filing date | |
| Gilead Sciences,Inc. | 375558103 | COM | 23,443 | $1,659,000 | thousands by filing date | |
| Vaneck Vectors AMT-Free Inter | 92189F544 | ETF | 68,399 | $1,636,000 | thousands by filing date | |
| Home Depot, Inc | 437076102 | COM | 10,291 | $1,579,000 | thousands by filing date | |
| Wells Fargo & Company | 949746101 | COM | 27,996 | $1,551,000 | thousands by filing date | |
| USBANCORPDEL | 902973304 | COM NEW | 29,306 | $1,522,000 | thousands by filing date | |
| Philip Morris International Inc. | 718172109 | COM | 12,872 | $1,512,000 | thousands by filing date | |
| ISHARES TR | 464287739 | U.S. REAL ES ETF | 18,730 | $1,494,000 | thousands by filing date | |
| UnitedHealth Group Inc | 91324P102 | COM | 8,042 | $1,491,000 | thousands by filing date | |
| META PLATFORMS INC CL A | 30303M102 | COM | 9,749 | $1,472,000 | thousands by filing date | |
| ISHARES TR | 464288448 | INTL SEL DIV ETF | 44,544 | $1,457,000 | thousands by filing date | |
| International Business Machines Corporation | 459200101 | COM | 9,396 | $1,445,000 | thousands by filing date | |
| Walt Disney Co | 254687106 | COM | 13,520 | $1,437,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A797 | ST STR SP BANK | 32,600 | $1,419,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78468R739 | ST NUVE TERM ETF | 28,941 | $1,404,000 | thousands by filing date | |
| Verizon Communications Inc | 92343V104 | COM | 31,144 | $1,391,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 1,480 | $1,376,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R833 | ENHAN SHRT MA AC | 13,446 | $1,368,000 | thousands by filing date | |
| Altria Group Inc | 02209S103 | COM | 18,299 | $1,363,000 | thousands by filing date | |
| JP MORGAN CHASE & CO | 46625H365 | EXCHANGE TRADED | 45,506 | $1,352,000 | thousands by filing date | |
| AbbVie,Inc. | 00287Y109 | COM | 18,573 | $1,347,000 | thousands by filing date | |
| ISHARES TR | 464287168 | COM | 14,609 | $1,347,000 | thousands by filing date | |
| Duke Energy Corporation | 26441C204 | COM | 15,906 | $1,330,000 | thousands by filing date | |
| ISHARES INC MSCI STH KOR ETF | 464286772 | MSCI STH KOR ETF | 19,594 | $1,329,000 | thousands by filing date | |
| Coca-Cola Company | 191216100 | COM | 29,356 | $1,317,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A516 | ST INTL BBG ETF | 47,683 | $1,317,000 | thousands by filing date | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 7,720 | $1,303,000 | thousands by filing date | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 23,645 | $1,294,000 | thousands by filing date | |
| McDonalds Corporation | 580135101 | COM | 8,394 | $1,286,000 | thousands by filing date | |
| VWO | 922042858 | SHS | 30,117 | $1,230,000 | thousands by filing date | |
| MONSANTO CO NEW | 61166W101 | COM | 10,197 | $1,207,000 | thousands by filing date | |
| CELGENE CORP | 151020104 | COM | 9,206 | $1,196,000 | thousands by filing date | |
| Lockheed Martin Corporation | 539830109 | COM | 4,267 | $1,185,000 | thousands by filing date | |
| Visa Inc | 92826C839 | COM | 12,469 | $1,169,000 | thousands by filing date | |
| ISHARES TR | 464288687 | COM | 29,462 | $1,154,000 | thousands by filing date | |
| MasterCard, Inc | 57636Q104 | COM | 9,489 | $1,152,000 | thousands by filing date | |
| UNITED TECHNOLOGIES CORP | 913017109 | COM | 9,125 | $1,114,000 | thousands by filing date | |
| Cisco Systems,Inc. | 17275R102 | COM | 35,554 | $1,113,000 | thousands by filing date | |
| ISHARES TR | 464287440 | 7-10 YR TRSY BD | 10,404 | $1,109,000 | thousands by filing date | |
| FS KKR CAPITAL CORP | 302635107 | COM | 121,063 | $1,108,000 | thousands by filing date | |
| Berkshire Hathaway Inc | 084670702 | COM | 6,184 | $1,047,000 | thousands by filing date | |
| POWERSHARES GLOBAL ETF TRUST | 73936T433 | WK VRDO TX FR | 41,753 | $1,041,000 | thousands by filing date | |
| iShares Core Dividend Growth ETF | 46434V621 | SHS | 32,843 | $1,029,000 | thousands by filing date | |
| iShares JP Morgan EM Local Ccy Bd ETF | 464286517 | SHS | 21,585 | $1,006,000 | thousands by filing date | |
| ISHARES RUSSELL 1000 ETF | 464287622 | ETF | 7,285 | $985,000 | thousands by filing date | |
| BB & T CORP | 054937107 | COM | 21,576 | $980,000 | thousands by filing date | |
| Merck & Co.,Inc. | 58933Y105 | COM | 15,252 | $977,000 | thousands by filing date | |
| ISHARES INC | 464286665 | MSCI PAC JP ETF | 21,704 | $965,000 | thousands by filing date | |
| BLACKROCK INC CL A COM | 09247X101 | COM | 2,261 | $955,000 | thousands by filing date | |
| Boeing Company | 097023105 | COM | 4,805 | $950,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y407 | SBI CONS DISCR | 10,173 | $912,000 | thousands by filing date | |
| NIKE,Inc. Class B | 654106103 | COM | 15,358 | $906,000 | thousands by filing date | |
| BlackRock Muniy Michigan | 09254V105 | Fund | 63,097 | $885,000 | thousands by filing date | |
| METLIFE INC COM | 59156R108 | Stock | 16,036 | $881,000 | thousands by filing date | |
| Southern Company | 842587107 | COM | 18,085 | $866,000 | thousands by filing date | |
| CVS Health Corporation | 126650100 | COM | 10,207 | $821,000 | thousands by filing date | |
| SPDR GOLD TR | 78463V107 | GOLD SHS | 6,868 | $811,000 | thousands by filing date | |
| Stryker Corporation | 863667101 | COM | 5,603 | $778,000 | thousands by filing date | |
| Vanguard Real Estate | 922908553 | SHS | 9,310 | $775,000 | thousands by filing date | |
| ISHARES TR | 46432F834 | COM | 13,242 | $760,000 | thousands by filing date | |
| Bristol-Myers Squibb Company | 110122108 | COM | 13,595 | $758,000 | thousands by filing date | |
| SPDR Series Trust | 78464A680 | SPDR Bloomberg 1-3 Month T-Bill ETF | 16,543 | $757,000 | thousands by filing date | |
| Thermo Fisher Scientific Inc. | 883556102 | COM | 4,334 | $756,000 | thousands by filing date | |
| Oracle Corporation | 68389X105 | COM | 15,052 | $755,000 | thousands by filing date | |
| DOUBLELINE INCOME SOLUTIONS | 258622109 | COM | 36,582 | $755,000 | thousands by filing date | |
| Bank of America Corp | 060505104 | COM | 31,058 | $753,000 | thousands by filing date | |
| 3M CO COM | 88579Y101 | Stock | 3,616 | $753,000 | thousands by filing date | |
| Comcast Corp | 20030N101 | COM | 19,176 | $746,000 | thousands by filing date | |
| iShares iBoxx Inv Grade Corporate Bond ETF | 464287242 | SHS | 6,188 | $746,000 | thousands by filing date | |
| Qualcomm Incorporated | 747525103 | COM | 13,278 | $733,000 | thousands by filing date | |
| NextEra Energy,Inc. | 65339F101 | COM | 5,207 | $730,000 | thousands by filing date | |
| Vanguard Mid-Cap Growth ETF | 922908538 | SHS | 6,149 | $724,000 | thousands by filing date | |
| ISHARES TR | 464287630 | RUS 2000 VAL ETF | 6,022 | $716,000 | thousands by filing date | |
| iShares Core Total USD Bond Market ETF | 46434V613 | SHS | 13,958 | $711,000 | thousands by filing date | |
| FIDELITY COVINGTON TRUST | 316092709 | MSCI INDL INDX | 20,207 | $703,000 | thousands by filing date | |
| Vanguard Mid-Cap Value ETF | 922908512 | SHS | 6,696 | $689,000 | thousands by filing date | |
| NUVEEN QUALITY MUNCP INCOME | 67066V101 | COM | 48,762 | $685,000 | thousands by filing date | |
| TJX Companies Inc | 872540109 | COM | 9,452 | $682,000 | thousands by filing date | |
| EMERSON ELEC CO COM | 291011104 | Stock | 11,408 | $680,000 | thousands by filing date | |
| iShares MSCI USA Min Vol Factor ETF | 46429B697 | SHS | 13,502 | $661,000 | thousands by filing date | |
| Vaneck Long Muni ETF | 92189F536 | ETF | 32,236 | $641,000 | thousands by filing date | |
| iShares Floating Rate Bond ETF | 46429B655 | SHS | 12,521 | $638,000 | thousands by filing date | |
| Medtronic Plc | G5960L103 | COM | 7,155 | $635,000 | thousands by filing date | |
| Starbucks Corporation | 855244109 | COM | 10,889 | $635,000 | thousands by filing date | |
| EXELON CORP COM | 30161N101 | Stock | 17,513 | $632,000 | thousands by filing date | |
| ISHARES INC MSCI TAIWAN ETF | 46434G772 | MSCI TAIWAN ETF | 17,449 | $624,000 | thousands by filing date | |
| Vanguard Total World Stock ETF | 922042742 | SHS | 9,210 | $622,000 | thousands by filing date | |
| CLAYMORE EXCHANGE TRD FD TR | 18383M381 | GUG BLT2018 HY | 24,302 | $617,000 | thousands by filing date | |
| STATE STR SPDR DOW JONES IND | 78467X109 | UT SER 1 | 2,887 | $616,000 | thousands by filing date | |
| YUM CHINA HLDGS INC | 98850P109 | COM | 15,443 | $609,000 | thousands by filing date | |
| Amgen Inc. | 031162100 | COM | 3,472 | $598,000 | thousands by filing date | |
| KIMBERLY-CLARK CORP COM | 494368103 | Stock | 4,603 | $594,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524706 | EMRG MKTEQ ETF | 23,827 | $592,000 | thousands by filing date | |
| CAPITAL ONE FINL CORP | 14040H105 | COM | 7,155 | $591,000 | thousands by filing date | |
| ISHARES TR | 46429B663 | CORE HIGH DV ETF | 7,096 | $590,000 | thousands by filing date | |
| Adobe Inc | 00724F101 | COM | 4,151 | $587,000 | thousands by filing date | |
| ISHARES TR | 464288281 | JPMORGAN USD EMG | 5,136 | $587,000 | thousands by filing date | |
| ISHARES SHORT-TERM NATIONAL MUNI BOND ETF | 464288158 | ETF | 5,501 | $582,000 | thousands by filing date | |
| United Parcel Service,Inc. Class B | 911312106 | COM | 5,207 | $576,000 | thousands by filing date | |
| RAYTHEON CO | 755111507 | COM NEW | 3,480 | $562,000 | thousands by filing date | |
| TARGET CORP COM | 87612E106 | Stock | 10,644 | $557,000 | thousands by filing date | |
| UNILEVER PLC | 904767704 | SPON ADR NEW | 10,221 | $553,000 | thousands by filing date | |
| Union Pacific Corporation | 907818108 | COM | 5,051 | $550,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33733E302 | DJ INTERNT IDX | 5,809 | $550,000 | thousands by filing date | |
| Health Care Select Sector SPDR Fund | 81369Y209 | SHS | 6,927 | $549,000 | thousands by filing date | |
| WELLTOWER INC COM | 95040Q104 | REIT | 7,270 | $544,000 | thousands by filing date | |
| Vanguard High Dividend Yield ETF | 921946406 | SHS | 6,874 | $537,000 | thousands by filing date | |
| NUVEEN MICH QUALITY INCOME MUN FD INC | 670979103 | CEF | 39,059 | $535,000 | thousands by filing date | |
| FIFTH THIRD BANCORP COM | 316773100 | Stock | 20,259 | $526,000 | thousands by filing date | |
| YUM BRANDS INC COM | 988498101 | Stock | 7,111 | $525,000 | thousands by filing date | |
| ISHARES MSCI EAFE SMALL-CAP ETF | 464288273 | ETF | 8,638 | $500,000 | thousands by filing date | |
| Honeywell Technologies | 438516106 | COM | 3,705 | $494,000 | thousands by filing date | |
| ISHARES TR MSCI CHINA ETF | 46429B671 | MSCI CHINA ETF | 9,026 | $494,000 | thousands by filing date | |
| Accenture Plc Class A | G1151C101 | COM | 3,959 | $490,000 | thousands by filing date | |
| BP PLC SPONSORED ADR | 055622104 | ADR | 13,933 | $483,000 | thousands by filing date | |
| DISCOVER FINL SVCS | 254709108 | COM | 7,701 | $479,000 | thousands by filing date | |
| American Express Company | 025816109 | COM | 5,665 | $477,000 | thousands by filing date | |
| SPDR SERIES TRUST BLOOMBERG BR | 78464A417 | BLOOMBERG BRCLYS | 12,836 | $477,000 | thousands by filing date | |
| Energy Select Sector SPDR Fund | 81369Y506 | SHS | 7,140 | $464,000 | thousands by filing date | |
| Mondelez International,Inc. Class A | 609207105 | COM | 10,669 | $461,000 | thousands by filing date | |
| LYONDELLBASELL INDUSTRIES NV SHS - A - | N53745100 | Stock | 5,444 | $459,000 | thousands by filing date | |
| Schlumberger Limited | 806857108 | COM | 6,651 | $438,000 | thousands by filing date | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 8,161 | $438,000 | thousands by filing date | |
| VANECK ETF TRUST | 92189F528 | VANECK SHRT MUNI | 24,621 | $430,000 | thousands by filing date | |
| ISHARES TR | 464287887 | S&P SML 600 GWT | 2,718 | $424,000 | thousands by filing date | |
| NORFOLK SOUTHN CORP COM | 655844108 | Stock | 3,474 | $423,000 | thousands by filing date | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 3,114 | $422,000 | thousands by filing date | |
| NUVEEN MUN CR INCOME FD | 67070X101 | COM SH BEN INT | 28,230 | $421,000 | thousands by filing date | |
| NUVEEN AMT FREE MUN CR INC F | 67071L106 | COM | 27,698 | $420,000 | thousands by filing date | |
| MCKESSON CORP COM | 58155Q103 | Stock | 2,539 | $418,000 | thousands by filing date | |
| ConocoPhillips | 20825C104 | COM | 9,467 | $416,000 | thousands by filing date | |
| HSBC HLDGS PLC SPON ADR NEW | 404280406 | ADR | 8,949 | $415,000 | thousands by filing date | |
| THETRADEDESKINCCLASSCLASSA | 88339J105 | STOK | 8,225 | $412,000 | thousands by filing date | |
| INVESCO FINANCIAL PREFERRED ETF | 73935X229 | COM | 21,466 | $410,000 | thousands by filing date | |
| XCELENERGY INC | 98389B100 | COM | 8,923 | $409,000 | thousands by filing date | |
| Eli Lilly and Company | 532457108 | COM | 4,932 | $406,000 | thousands by filing date | |
| ALLERGAN PLC | G0177J108 | SHS | 1,659 | $403,000 | thousands by filing date | |
| CBRE GROUP INC CL A | 12504L109 | Stock | 10,910 | $397,000 | thousands by filing date | |
| Tesla Motors, Inc | 88160R101 | COM | 1,080 | $391,000 | thousands by filing date | |
| Abbott Laboratories | 002824100 | COM | 7,967 | $387,000 | thousands by filing date | |
| Automatic Data Processing,Inc. | 053015103 | COM | 3,755 | $385,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78468R408 | ST TERM HIGH ETF | 13,732 | $384,000 | thousands by filing date | |
| POWERSHARES | 73936T565 | EXCHANGE TRADED | 25,259 | $382,000 | thousands by filing date | |
| Caterpillar Inc. | 149123101 | COM | 3,442 | $370,000 | thousands by filing date | |
| MORGAN STANLEY CHINA A SH FD | 617468103 | COM | 16,521 | $370,000 | thousands by filing date | |
| SAP SE SPON ADR | 803054204 | ADR | 3,529 | $369,000 | thousands by filing date | |
| DU PONT E I DE NEMOURS & CO | 263534109 | COM | 4,498 | $363,000 | thousands by filing date | |
| Vanguard Short-Term Bond ETF | 921937827 | SHS | 4,460 | $356,000 | thousands by filing date | |
| PIEDMONT REALTY TRUST INC | 720190206 | COM CL A | 16,876 | $356,000 | thousands by filing date | |
| CLAYMORE EXCHANGE TRD FD TR | 18383M373 | GUG BUL 2019 HY | 14,364 | $354,000 | thousands by filing date | |
| WISDOMTREE TR | 97717X669 | US QTLY DIV GRT | 9,600 | $353,000 | thousands by filing date | |
| SYSCOCORP | 871829107 | COM | 6,999 | $352,000 | thousands by filing date | |
| ROYAL DUTCH SHELL PLC SPN ADR | 780259107 | SPON ADR B | 6,460 | $352,000 | thousands by filing date | |
| Texas Instruments Incorporated | 882508104 | COM | 4,534 | $349,000 | thousands by filing date | |
| SANOFI SA SPONSORED ADR | 80105N105 | ADR | 7,235 | $347,000 | thousands by filing date | |
| KRAFT HEINZ CO COM | 500754106 | Stock | 4,038 | $346,000 | thousands by filing date | |
| GENERAL MILLS INC COM | 370334104 | Stock | 6,234 | $345,000 | thousands by filing date | |
| BAIDU INC SPON ADR REP A | 056752108 | ADR | 1,911 | $342,000 | thousands by filing date | |
| NORTHROP GRUMMAN CORP COM | 666807102 | Stock | 1,330 | $342,000 | thousands by filing date | |
| AMERICAN WTR WKS CO INC NEW COM | 030420103 | Stock | 4,349 | $339,000 | thousands by filing date | |
| VALERO ENERGY CORP COM | 91913Y100 | Stock | 4,963 | $335,000 | thousands by filing date | |
| MARATHON PETE CORP COM | 56585A102 | Stock | 6,356 | $333,000 | thousands by filing date | |
| ACTVISION BLIZZARD INC | 00507V109 | COM | 5,785 | $333,000 | thousands by filing date | |
| AETNA INC NEW | 00817Y108 | COM | 2,187 | $332,000 | thousands by filing date | |
| TAIWAN SEMICONDUCTOR MFG | 874039100 | SPONSORED ADS | 9,474 | $331,000 | thousands by filing date | |
| BECTON DICKINSON & CO | 075887109 | COM | 1,686 | $329,000 | thousands by filing date | |
| ISHARES TR | 464288638 | ISHS 5-10YR INVT | 2,992 | $328,000 | thousands by filing date | |
| American Tower Corporation | 03027X100 | COM | 2,474 | $327,000 | thousands by filing date | |
| VODAFONE GROUP PLC SPONSORED ADR | 92857W308 | ADR | 11,339 | $326,000 | thousands by filing date | |
| FEDEX CORP COM | 31428X106 | Stock | 1,484 | $322,000 | thousands by filing date | |
| FISERV INC | 337738108 | COM | 2,602 | $318,000 | thousands by filing date | |
| SPDR S&P Dividend ETF | 78464A763 | SHS | 3,567 | $317,000 | thousands by filing date | |
| WALGREENS BOOTS ALLIANCE INC | 931427108 | COM | 4,032 | $316,000 | thousands by filing date | |
| ISHARES TR | 46429B598 | MSCI INDIA ETF | 9,779 | $314,000 | thousands by filing date | |
| ISHARES CORE S&P U.S. GROWTH ETF | 464287671 | ETF | 6,432 | $310,000 | thousands by filing date | |
| WISDOMTREE TR | 97717W604 | US SMALLCAP DIVD | 3,856 | $310,000 | thousands by filing date | |
| GLAXOSMITHKLINE PLC-ADR | 37733W105 | SPONSORED ADR | 7,143 | $308,000 | thousands by filing date | |
| CENTERSTATE BK CORP | 15201P109 | COM | 12,386 | $308,000 | thousands by filing date | |
| NEW YORK REIT INC | 64976L109 | COM | 35,696 | $308,000 | thousands by filing date | |
| Vanguard FTSE All-World ex-US ETF | 922042775 | SHS | 6,145 | $307,000 | thousands by filing date | |
| Chubb Limited | H1467J104 | COM | 2,105 | $306,000 | thousands by filing date | |
| iShares MSCI Frontier 100 | 464286145 | cs | 10,703 | $306,000 | thousands by filing date | |
| CARLISLE COS INC COM | 142339100 | Stock | 3,194 | $305,000 | thousands by filing date | |
| HP INC COM | 40434L105 | Stock | 17,435 | $305,000 | thousands by filing date | |
| Costco Wholesale Corporation | 22160K105 | COM | 1,898 | $304,000 | thousands by filing date | |
| DXC TECHNOLOGY CO COM | 23355L106 | Stock | 3,911 | $300,000 | thousands by filing date | |
| GENERAL DYNAMICS CORP COM | 369550108 | Stock | 1,507 | $299,000 | thousands by filing date | |
| CRH PLC ADS | 12626K203 | ADR | 8,407 | $298,000 | thousands by filing date | |
| WESTERN DIGITAL CORP | 958102105 | COM | 3,318 | $294,000 | thousands by filing date | |
| Applied Materials,Inc. | 038222105 | COM | 7,101 | $293,000 | thousands by filing date | |
| Goldman Sachs Group,Inc. | 38141G104 | COM | 1,321 | $293,000 | thousands by filing date | |
| AFLAC INC COM | 001055102 | Stock | 3,776 | $293,000 | thousands by filing date | |
| S&P Global,Inc. | 78409V104 | COM | 1,998 | $292,000 | thousands by filing date | |
| ALLSTATE CORP COM | 020002101 | Stock | 3,278 | $290,000 | thousands by filing date | |
| Utilities Select Sector SPDR Fund | 81369Y886 | SHS | 5,569 | $289,000 | thousands by filing date | |
| ING GROEP N.V. SPONSORED ADR | 456837103 | ADR | 16,580 | $288,000 | thousands by filing date | |
| CONSTELLATION BRANDS INC CL A | 21036P108 | Stock | 1,485 | $288,000 | thousands by filing date | |
| LAMAR ADVERTISING CO CL A | 512816109 | REIT | 3,906 | $287,000 | thousands by filing date | |
| HUNTINGTON BANCSHARES INC COM | 446150104 | Stock | 21,107 | $285,000 | thousands by filing date | |
| GENTEX CORP COM | 371901109 | Stock | 15,038 | $285,000 | thousands by filing date | |
| DOMINION ENERGY INC COM | 25746U109 | Stock | 3,720 | $285,000 | thousands by filing date | |
| COLGATE PALMOLIVE CO COM | 194162103 | Stock | 3,849 | $285,000 | thousands by filing date | |
| SEACOAST BKG CORP FLA | 811707801 | COM NEW | 11,765 | $284,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X772 | S&P INTL ETF | 7,259 | $284,000 | thousands by filing date | |
| WISDOMTREE TR | 97717X594 | ITL HDG QTLY DIV | 9,590 | $284,000 | thousands by filing date | |
| BAOZUN INC ADR | 06684L103 | SPONSORED ADR | 12,786 | $283,000 | thousands by filing date | |
| Vanguard Utilities ETF | 92204A876 | SHS | 2,454 | $280,000 | thousands by filing date | |
| BROADCOM LTD | Y09827109 | SHS | 1,201 | $280,000 | thousands by filing date | |
| REALTY INCOME CORP COM | 756109104 | REIT | 5,021 | $277,000 | thousands by filing date | |
| TRAVELERS COMPANIES INC COM | 89417E109 | Stock | 2,187 | $277,000 | thousands by filing date | |
| REYNOLDS AMERICAN INC | 761713106 | COMMON STOCK | 4,255 | $277,000 | thousands by filing date | |
| CMS ENERGY CORP COM | 125896100 | Stock | 5,953 | $275,000 | thousands by filing date | |
| ECOLAB INC COM | 278865100 | Stock | 2,072 | $275,000 | thousands by filing date | |
| DCT INDUSTRIAL TRUST INC | 233153204 | COM NEW | 5,139 | $275,000 | thousands by filing date | |
| SYNCHRONYFINL | 87165B103 | STOK | 9,138 | $272,000 | thousands by filing date | |
| TIME WARNER INC | 887317303 | COM NEW | 2,695 | $271,000 | thousands by filing date | |
| Lowes Companies,Inc. | 548661107 | COM | 3,477 | $270,000 | thousands by filing date | |
| SUNTRUST BANKS INC | 867914103 | COM | 4,745 | $269,000 | thousands by filing date | |
| ROCKWELL MED INC | 774374102 | COM | 33,972 | $269,000 | thousands by filing date | |
| JD.COM INC SPON ADS CL A | 47215P106 | ADR | 6,801 | $267,000 | thousands by filing date | |
| EDWARDS LIFESCIENCES CORP COM | 28176E108 | Stock | 2,223 | $263,000 | thousands by filing date | |
| CBOE GLOBAL MKTS INC COM | 12503M108 | Stock | 2,879 | $263,000 | thousands by filing date | |
| CSX Corporation | 126408103 | COM | 4,785 | $261,000 | thousands by filing date | |
| PARKER-HANNIFIN CORP COM | 701094104 | Stock | 1,630 | $261,000 | thousands by filing date | |
| ISHARES INC MSCI BRAZIL ETF | 464286400 | MSCI BRAZIL ETF | 7,576 | $259,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C771 | SHS | 4,896 | $258,000 | thousands by filing date | |
| NETEASE COM INC SPONSORED ADS | 64110W102 | ADR | 853 | $256,000 | thousands by filing date | |
| Charles Schwab Corp | 808513105 | COM | 5,931 | $255,000 | thousands by filing date | |
| ISHARES TR | 464287689 | RUSSELL 3000 ETF | 1,771 | $255,000 | thousands by filing date | |
| PNC FINL SVCS GROUP INC COM | 693475105 | Stock | 2,038 | $254,000 | thousands by filing date | |
| CLAYMORE EXCHANGE TRD FD TR | 18383M399 | GUG BLT2017 HY | 9,878 | $254,000 | thousands by filing date | |
| Citigroup Inc. | 172967424 | COM | 3,789 | $253,000 | thousands by filing date | |
| ALIBABA GROUP HLDG LTD | 01609W102 | SPONSORED ADS | 1,796 | $253,000 | thousands by filing date | |
| CELANESE CORP DEL COM | 150870103 | Stock | 2,664 | $253,000 | thousands by filing date | |
| BANK OF NY MELLON CORP COM | 064058100 | Stock | 4,938 | $252,000 | thousands by filing date | |
| TRIVAGO N V SPON ADS A SHS N | 89686D105 | ADR | 10,597 | $251,000 | thousands by filing date | |
| NXP SEMICONDUCTORS N V COM | N6596X109 | Stock | 2,282 | $250,000 | thousands by filing date | |
| AMERICAN ELEC PWR CO INC COM | 025537101 | Stock | 3,524 | $245,000 | thousands by filing date | |
| NEOGEN CORP | 640491106 | COM | 3,535 | $244,000 | thousands by filing date | |
| Boston Scientific Corporation | 101137107 | COM | 8,699 | $241,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP VALUE ETF | 464287473 | ETF | 2,839 | $239,000 | thousands by filing date | |
| Intercontinental Exchange,Inc. | 45866F104 | COM | 3,606 | $238,000 | thousands by filing date | |
| JOHNSON CTLS INTL PLC SHS | G51502105 | Stock | 5,487 | $238,000 | thousands by filing date | |
| FLEX LTD ORD | Y2573F102 | Stock | 14,622 | $238,000 | thousands by filing date | |
| QIAGEN NV | N72482123 | SHS NEW | 7,107 | $238,000 | thousands by filing date | |
| DELTA AIR LINES INC COM NEW | 247361702 | Stock | 4,411 | $237,000 | thousands by filing date | |
| AVANGRID INC | 05351W103 | COM | 5,379 | $237,000 | thousands by filing date | |
| BIOVERATIV INC | 09075E100 | COM | 3,909 | $235,000 | thousands by filing date | |
| ZIMMER BIOMET HOLDINGS INC COM | 98956P102 | Stock | 1,813 | $233,000 | thousands by filing date | |
| ILLINOIS TOOL WKS INC | 452308109 | COM | 1,604 | $230,000 | thousands by filing date | |
| UNITED RENTALS INC COM | 911363109 | Stock | 2,039 | $230,000 | thousands by filing date | |
| GENERAL MTRS CO COM | 37045V100 | Stock | 6,583 | $230,000 | thousands by filing date | |
| HALLIBURTON CO COM | 406216101 | Stock | 5,395 | $230,000 | thousands by filing date | |
| MID AMERICA APARTMENT COMMUNITIES INC. | 59522J103 | Common Stock, par value $0.01 per share | 2,177 | $229,000 | thousands by filing date | |
| Vanguard S&P 500 ETF | 922908363 | COM | 1,027 | $228,000 | thousands by filing date | |
| SPROUTS FMRS MKT INC COM | 85208M102 | Stock | 10,012 | $227,000 | thousands by filing date | |
| ROCKWELL COLLINS INC | 774341101 | COM | 2,162 | $227,000 | thousands by filing date | |
| ISHARES INC | 464286533 | MSCI EMERG MRKT | 4,087 | $226,000 | thousands by filing date | |
| UBS GROUP AG SHS | H42097107 | Stock | 13,253 | $225,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524805 | INTL EQTY ETF | 7,083 | $225,000 | thousands by filing date | |
| AMERICAN INTL GROUP INC COM NEW | 026874784 | Stock | 3,588 | $224,000 | thousands by filing date | |
| CME Group Inc. Class A | 12572Q105 | COM | 1,771 | $222,000 | thousands by filing date | |
| PG&E CORP COM | 69331C108 | Stock | 3,348 | $222,000 | thousands by filing date | |
| AES CORP COM | 00130H105 | Stock | 19,845 | $220,000 | thousands by filing date | |
| ISHARES TR | 46434V100 | 0-5YR INVT GR CP | 4,334 | $219,000 | thousands by filing date | |
| MOODYS CORP COM | 615369105 | Stock | 1,796 | $219,000 | thousands by filing date | |
| TELEFLEX INCORPORATED | 879369106 | COM | 1,052 | $219,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 2,015 | $218,000 | thousands by filing date | |
| MYLAN NV | N59465109 | SHS EURO | 5,621 | $218,000 | thousands by filing date | |
| ROYAL DUTCH SHELL PLC SPN ADR | 780259206 | SPONS ADR A | 4,016 | $214,000 | thousands by filing date | |
| TESORO CORP | 881609101 | COM | 2,289 | $214,000 | thousands by filing date | |
| OMNICOM GROUP INC COM | 681919106 | Stock | 2,574 | $213,000 | thousands by filing date | |
| APTARGROUP INC COM | 038336103 | Stock | 2,452 | $213,000 | thousands by filing date | |
| ISHARES TR | 464287374 | NORTH AMERN NAT | 6,715 | $213,000 | thousands by filing date | |
| CINTAS CORP COM | 172908105 | Stock | 1,674 | $211,000 | thousands by filing date | |
| iShares Russell Midcap ETF | 464287499 | SHS | 1,095 | $210,000 | thousands by filing date | |
| PHILLIPS 66 COM | 718546104 | Stock | 2,534 | $210,000 | thousands by filing date | |
| CHARTER COMMUNICATIONS INC N | 16119P108 | COM | 613 | $206,000 | thousands by filing date | |
| Schwab U.S. Broad Market ETF | 808524102 | SHS | 3,514 | $205,000 | thousands by filing date | |
| ENI SPA SPONSORED ADR | 26874R108 | ADR | 6,770 | $204,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R783 | 0-5 HIGH YIELD | 2,017 | $204,000 | thousands by filing date | |
| 2U INC | 90214J101 | COM | 4,348 | $204,000 | thousands by filing date | |
| AIR PRODS & CHEMS INC | 009158106 | COM | 1,420 | $203,000 | thousands by filing date | |
| BANK HAWAII CORP | 062540109 | COM | 2,445 | $203,000 | thousands by filing date | |
| FIDELITY NATL INFORMATION SVCS COM | 31620M106 | Stock | 2,368 | $202,000 | thousands by filing date | |
| SUNCOR ENERGY INC NEW COM | 867224107 | Stock | 6,909 | $202,000 | thousands by filing date | |
| U HAUL HOLDING COMPANY | 023586100 | COM | 551 | $202,000 | thousands by filing date | |
| ALASKA AIR GROUP INC COM | 011659109 | Stock | 2,243 | $201,000 | thousands by filing date | |
| NEWELL BRANDS INC COM | 651229106 | Stock | 3,749 | $201,000 | thousands by filing date | |
| NNN REIT INC COM | 637417106 | REIT | 5,149 | $201,000 | thousands by filing date | |
| MOTOROLA SOLUTIONS INC COM NEW | 620076307 | Stock | 2,321 | $201,000 | thousands by filing date | |
| TOTALENERGIES SE | 89151E109 | SPONSORED ADS | 4,041 | $200,000 | thousands by filing date | |
| BARCLAYS PLC ADR | 06738E204 | ADR | 18,018 | $191,000 | thousands by filing date | |
| HEWLETT PACKARD ENTERPRISE CO COM | 42824C109 | Stock | 10,546 | $175,000 | thousands by filing date | |
| CHINA LIFE INSURANCE CO-ADR | 16939P106 | SPON ADR REP H | 11,256 | $173,000 | thousands by filing date | |
| MACATAWA BANK CORP | 554225102 | COMMON STOCK | 17,850 | $170,000 | thousands by filing date | |
| OCLARO INC | 67555N206 | COM | 17,919 | $167,000 | thousands by filing date | |
| AEGON N V | 007924103 | NY REGISTRY SHS | 32,573 | $166,000 | thousands by filing date | |
| WENDYS CO COM | 95058W100 | Stock | 10,511 | $163,000 | thousands by filing date | |
| VanEck Merk Gold Trust | 921078101 | SHS | 12,683 | $155,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33734X127 | ENERGY ALPHADX | 11,400 | $152,000 | thousands by filing date | |
| UNITED STATES OIL FUND LP | 91232N108 | UNITS | 14,880 | $141,000 | thousands by filing date | |
| SIRIUS XM HOLDINGS INC | 82968B103 | COM | 19,918 | $109,000 | thousands by filing date | |
| ELDORADO GOLD CORP NEW | 284902103 | COM | 39,312 | $104,000 | thousands by filing date | |
| NUVEEN CR STRATEGIES INCOME | 67073D102 | COM SHS | 10,018 | $86,000 | thousands by filing date | |
| INVESCO MUNI INCOME OPP TRST | 46132X101 | COM | 11,118 | $86,000 | thousands by filing date | |
| SYNERGY PHARMACEUTICALS DEL | 871639308 | COM NEW | 18,700 | $83,000 | thousands by filing date | |
| PRECISION DRILLING CORP | 74022D308 | COM 2010 | 17,604 | $60,000 | thousands by filing date | |
| PALATIN TECHNOLOGIES INC | 696077403 | COM PAR $ .01 | 12,000 | $5,000 | thousands by filing date |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001633037-17-000005 | this filing | 2017-07-19 | acceptance time not in the bulk data set |