13F-HR filed by Somerset Group LLC
Somerset Group LLC filed this 13F-HR for the quarter ended 2017-12-31, filed 2018-02-12, with 71 holding rows worth $119,602,000.
- Accession
- 0001062993-18-000607
- Filer
- CIK 1567912
- Filed
- 2018-02-12
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q4 2017
A holdings report, 71 entries on the cover page, a total value of $119,602,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $119,601,000 with VALUE read as thousands by filing date, 13F file number 028-15423. 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 |
|---|---|---|---|---|---|---|
| 3M CO COM | 88579Y101 | Stock | 74,822 | $17,611,000 | thousands by filing date | |
| USBANCORPDEL | 902973304 | COM NEW | 282,423 | $15,132,000 | thousands by filing date | |
| C H ROBINSON WORLDWIDE IN COM NEW | 12541W209 | Stock | 105,963 | $9,440,000 | thousands by filing date | |
| PowerShares QQQ Trust Unit Ser | 73935A104 | COM | 30,222 | $4,707,000 | thousands by filing date | |
| Wells Fargo & Company | 949746101 | COM | 71,887 | $4,361,000 | thousands by filing date | |
| Guggenheim S&P 500 Equal Weighted ETf | 78355W106 | Equity | 40,673 | $4,109,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33733E302 | DJ INTERNT IDX | 31,578 | $3,470,000 | thousands by filing date | |
| Amazon.com, Inc | 023135106 | COM | 2,433 | $2,845,000 | thousands by filing date | |
| WEYERHAEUSER CO COM NEW | 962166104 | REIT | 78,902 | $2,782,000 | thousands by filing date | |
| iShares U.S. Financials ETF | 464287788 | SHS | 22,060 | $2,635,000 | thousands by filing date | |
| TRAVELERS COMPANIES INC COM | 89417E109 | Stock | 17,872 | $2,424,000 | thousands by filing date | |
| Chevron Corporation | 166764100 | COM | 19,215 | $2,406,000 | thousands by filing date | |
| iShares U.S. Medical Devices ETF | 464288810 | SHS | 13,676 | $2,373,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 27,706 | $2,370,000 | thousands by filing date | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 12,137 | $2,266,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 11,075 | $1,874,000 | thousands by filing date | |
| PALO ALTO NETWORKS INC | 697435105 | COM | 11,812 | $1,712,000 | thousands by filing date | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 34,263 | $1,614,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 21,727 | $1,528,000 | thousands by filing date | |
| NextEra Energy,Inc. | 65339F101 | COM | 8,935 | $1,396,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y704 | INDL | 17,262 | $1,306,000 | thousands by filing date | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 8,745 | $1,293,000 | thousands by filing date | |
| Boston Scientific Corporation | 101137107 | COM | 48,200 | $1,195,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 13,931 | $1,165,000 | thousands by filing date | |
| ISHARES TR | 464287606 | S&P MC 400GR ETF | 5,145 | $1,110,000 | thousands by filing date | |
| Vanguard Real Estate | 922908553 | SHS | 13,299 | $1,104,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 23,710 | $1,094,000 | thousands by filing date | |
| Texas Instruments Incorporated | 882508104 | COM | 10,000 | $1,044,000 | thousands by filing date | |
| Verizon Communications Inc | 92343V104 | COM | 19,575 | $1,036,000 | thousands by filing date | |
| RYDEX ETF TRUST HEALTH CARE | 78355W841 | COM | 5,544 | $996,000 | thousands by filing date | |
| CHENIERE ENERGY INC COM NEW | 16411R208 | Stock | 18,322 | $986,000 | thousands by filing date | |
| PepsiCo,Inc. | 713448108 | COM | 7,781 | $933,000 | thousands by filing date | |
| iShares U.S. Aerospace & Defense ETF | 464288760 | SHS | 4,954 | $932,000 | thousands by filing date | |
| DOMINION ENERGY INC COM | 25746U109 | Stock | 10,628 | $862,000 | thousands by filing date | |
| NORTHERN TR CORP COM | 665859104 | Stock | 8,500 | $849,000 | thousands by filing date | |
| McDonalds Corporation | 580135101 | COM | 4,889 | $841,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 783 | $825,000 | thousands by filing date | |
| JP MORGAN CHASE & CO | 46625H365 | EXCHANGE TRADED | 29,135 | $800,000 | thousands by filing date | |
| META PLATFORMS INC CL A | 30303M102 | COM | 4,490 | $792,000 | thousands by filing date | |
| FIRST TR EXCHANGE TRADED FD | 33733A102 | CHINDIA ETF | 19,277 | $763,000 | thousands by filing date | |
| ENERGY TRANSFER L P | 29273V100 | COM UT LTD PTN | 42,200 | $728,000 | thousands by filing date | |
| TARGET CORP COM | 87612E106 | Stock | 10,553 | $689,000 | thousands by filing date | |
| Costco Wholesale Corporation | 22160K105 | COM | 3,616 | $673,000 | thousands by filing date | |
| ISHARES TR | 464288687 | COM | 15,700 | $598,000 | thousands by filing date | |
| ISHARES TR | 464287523 | COM | 3,504 | $595,000 | thousands by filing date | |
| ECOLAB INC COM | 278865100 | Stock | 4,417 | $593,000 | thousands by filing date | |
| Schwab U.S. Small-Cap ETF | 808524607 | SHS | 7,598 | $530,000 | thousands by filing date | |
| HYD | 92189F361 | ETF | 16,080 | $502,000 | thousands by filing date | |
| WILLIAMS PARTNERS L P | 96950F104 | COM UNIT L P | 12,401 | $481,000 | thousands by filing date | |
| SANMINA-SCI CORP | 800907206 | COM | 14,487 | $478,000 | thousands by filing date | |
| ALIBABA GROUP HLDG LTD | 01609W102 | SPONSORED ADS | 2,593 | $447,000 | thousands by filing date | |
| ALPS ETF TR | 00162Q866 | ALERIAN MLP | 39,350 | $425,000 | thousands by filing date | |
| PHILLIPS 66 COM | 718546104 | Stock | 4,142 | $419,000 | thousands by filing date | |
| MPLX LP | 55336V100 | COM UNIT REP LTD | 11,744 | $417,000 | thousands by filing date | |
| iShares TIPS Bond ETF | 464287176 | SHS | 3,639 | $415,000 | thousands by filing date | |
| Schwab US Mid-Cap ETF | 808524508 | SHS | 7,179 | $382,000 | thousands by filing date | |
| CHENIERE ENERGY PARTNERS L P | 16411Q101 | COM UNIT | 12,050 | $357,000 | thousands by filing date | |
| AMERICAN TOWER CORP | 029912201 | COMMON STOCK | 2,474 | $353,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 2,480 | $347,000 | thousands by filing date | |
| Whirlpool Corp | 096332010 | COM | 1,951 | $329,000 | thousands by filing date | |
| ENTERPRISE PRODS PARTNERS L | 293792107 | COM | 12,000 | $318,000 | thousands by filing date | |
| COLUMBIA PROPERTY TRUST INC | 198287203 | COM NEW | 13,100 | $301,000 | thousands by filing date | |
| GENERAL MILLS INC COM | 370334104 | Stock | 4,694 | $278,000 | thousands by filing date | |
| CENCORA INC COM | 03073E105 | Stock | 3,000 | $275,000 | thousands by filing date | |
| DOWDUPONT INC | 26078J100 | COM | 3,846 | $274,000 | thousands by filing date | |
| Utilities Select Sector SPDR Fund | 81369Y886 | SHS | 4,895 | $258,000 | thousands by filing date | |
| Crown Castle | 228227104 | COM | 2,250 | $250,000 | thousands by filing date | |
| PLAINS ALL AMERN PIPELINE L | 726503105 | UNIT LTD PARTN | 12,000 | $248,000 | thousands by filing date | |
| Energy Select Sector SPDR Fund | 81369Y506 | SHS | 3,352 | $242,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 2,343 | $215,000 | thousands by filing date | |
| Merck & Co.,Inc. | 58933Y105 | COM | 3,613 | $203,000 | thousands by filing date |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001062993-18-000607 | this filing | 2018-02-12 | acceptance time not in the bulk data set |