Skip to content
Disclosery

MACGUIRE, CHESWICK & TUTTLE INVESTMENT COUNSEL LLC

Follow

13F filer, CIK 1442173, DARIEN, CT

MACGUIRE, CHESWICK & TUTTLE INVESTMENT COUNSEL LLC reported $549,885,000 across 96 holdings for the quarter ended 2017-12-31, in a 13F-HR filed 2018-01-29. Its ten largest share positions make up 36.92% of the portfolio.

Filed (acceptance time not in the bulk data set), ingested 13F-HR 0001442173-18-000001

Period
2017-12-31
Reported value
$550M
Holdings
96
Top 10 weight
36.92%
New
4
Sold out
3

Largest buys vs the previous quarter

SecurityShares changeApprox. value
PNRnew+145,575$10.3M
TTDnew+54,190$2.48M
EQIXnew+1,340$607K
Vadded+4,615$526K
ADBEadded+2,230$391K

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

SecurityShares changeApprox. value
NKEreduced-16,306-$1.02M
SLBreduced-14,750-$994K
JPMreduced-8,152-$872K
WALGREENS BOOTS ALLIANCE INCreduced-11,464-$832K
CBREreduced-12,445-$539K

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, Q4 2017

Share positions as resolved from 13F-HR 0001442173-18-000001, largest first. % of portfolio is the value over $549,881,000, the sum of the share positions whose value is usable for ratios (method).

SecurityHistorySharesValue% of portfolioChangeLatest eventTimeline
AMZNAMAZON COM INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 25,881 shares; 2017Q2: 24,609 shares; 2017Q3: 24,647 shares; 2017Q4: 24,452 shares 24,452$28.6M5.2%-195Timeline
JPMJPMORGAN CHASE & COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 257,929 shares; 2017Q2: 242,097 shares; 2017Q3: 242,952 shares; 2017Q4: 234,800 shares 234,800$25.1M4.57%-8,152Timeline
AAPLAPPLE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 157,595 shares; 2017Q2: 151,210 shares; 2017Q3: 150,192 shares; 2017Q4: 147,138 shares 147,138$24.9M4.53%-3,054Timeline
HDHOME DEPOT INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 126,840 shares; 2017Q2: 120,900 shares; 2017Q3: 120,920 shares; 2017Q4: 118,216 shares 118,216$22.4M4.07%-2,704Timeline
JNJJOHNSON & JOHNSONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 136,309 shares; 2017Q2: 134,559 shares; 2017Q3: 134,639 shares; 2017Q4: 132,824 shares 132,824$18.6M3.37%-1,815Timeline
GOOGALPHABET INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 16,892 shares; 2017Q2: 15,992 shares; 2017Q3: 17,311 shares; 2017Q4: 16,936 shares 16,936$17.7M3.22%-375Timeline
HONHONEYWELL INTL INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 123,242 shares; 2017Q2: 112,817 shares; 2017Q3: 112,227 shares; 2017Q4: 109,947 shares 109,947$16.9M3.07%-2,280Timeline
APHAMPHENOL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 200,027 shares; 2017Q2: 189,977 shares; 2017Q3: 193,482 shares; 2017Q4: 189,517 shares 189,517$16.6M3.03%-3,965Timeline
DHRDANAHER CORP DELQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 181,505 shares; 2017Q2: 175,255 shares; 2017Q3: 177,110 shares; 2017Q4: 174,090 shares 174,090$16.2M2.94%-3,020Timeline
WFCWELLS FARGO & COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 290,411 shares; 2017Q2: 270,424 shares; 2017Q3: 269,949 shares; 2017Q4: 265,049 shares 265,049$16.1M2.92%-4,900Timeline
FISVFISERV INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 129,615 shares; 2017Q2: 122,640 shares; 2017Q3: 122,295 shares; 2017Q4: 119,945 shares 119,945$15.7M2.86%-2,350Timeline
METAMETA PLATFORMS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 91,719 shares; 2017Q2: 86,114 shares; 2017Q3: 86,439 shares; 2017Q4: 87,976 shares 87,976$15.5M2.82%+1,537Timeline
COSTCOSTCO WHOLESALE CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 85,991 shares; 2017Q2: 84,356 shares; 2017Q3: 84,286 shares; 2017Q4: 82,761 shares 82,761$15.4M2.8%-1,525Timeline
MRSHMARSH & MCLENNAN COS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 188,041 shares; 2017Q2: 178,591 shares; 2017Q3: 179,066 shares; 2017Q4: 176,546 shares 176,546$14.4M2.61%-2,520Timeline
CBRECBRE GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 354,070 shares; 2017Q2: 342,585 shares; 2017Q3: 341,755 shares; 2017Q4: 329,310 shares 329,310$14.3M2.59%-12,445Timeline
SBUXSTARBUCKS CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 259,321 shares; 2017Q2: 244,031 shares; 2017Q3: 209,271 shares; 2017Q4: 201,071 shares 201,071$11.5M2.1%-8,200Timeline
URIUNITED RENTALS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 61,245 shares; 2017Q2: 59,805 shares; 2017Q3: 62,055 shares; 2017Q4: 61,570 shares 61,570$10.6M1.92%-485Timeline
PNRPENTAIR PLCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: not reported; 2017Q3: not reported; 2017Q4: 145,575 shares 145,575$10.3M1.87%newTimeline
UNITED TECHNOLOGIES CORPUNITED TECHNOLOGIES CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 78,608 shares; 2017Q2: 77,408 shares; 2017Q3: 78,108 shares; 2017Q4: 76,848 shares 76,848$9.8M1.78%-1,260
SLBSLB LIMITEDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 169,166 shares; 2017Q2: 157,986 shares; 2017Q3: 156,746 shares; 2017Q4: 141,996 shares 141,996$9.57M1.74%-14,750Timeline
COFCAPITAL ONE FINL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 97,803 shares; 2017Q2: 93,318 shares; 2017Q3: 93,833 shares; 2017Q4: 93,808 shares 93,808$9.34M1.7%-25Timeline
MSFTMICROSOFT CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 113,701 shares; 2017Q2: 107,811 shares; 2017Q3: 107,841 shares; 2017Q4: 109,146 shares 109,146$9.34M1.7%+1,305Timeline
CELGENE CORPCELGENE CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 92,374 shares; 2017Q2: 87,321 shares; 2017Q3: 87,771 shares; 2017Q4: 85,411 shares 85,411$8.91M1.62%-2,360
PGPROCTER & GAMBLE COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 106,015 shares; 2017Q2: 95,025 shares; 2017Q3: 93,870 shares; 2017Q4: 90,440 shares 90,440$8.31M1.51%-3,430Timeline
XOMEXXON MOBIL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 117,388 shares; 2017Q2: 103,921 shares; 2017Q3: 102,620 shares; 2017Q4: 97,261 shares 97,261$8.13M1.48%-5,359Timeline
WALGREENS BOOTS ALLIANCE INCWALGREENS BOOTS ALLIANCE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 123,929 shares; 2017Q2: 117,844 shares; 2017Q3: 117,694 shares; 2017Q4: 106,230 shares 106,230$7.71M1.4%-11,464
ORCLORACLE CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 175,054 shares; 2017Q2: 164,454 shares; 2017Q3: 166,004 shares; 2017Q4: 162,004 shares 162,004$7.66M1.39%-4,000Timeline
CVXCHEVRON CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 59,501 shares; 2017Q2: 58,561 shares; 2017Q3: 57,561 shares; 2017Q4: 57,195 shares 57,195$7.16M1.3%-366Timeline
BLACKSTONE GROUP LP/THEBLACKSTONE GROUP LP/THEQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 257,540 shares; 2017Q2: 235,690 shares; 2017Q3: 232,490 shares; 2017Q4: 216,015 shares 216,015$6.92M1.26%-16,475
XPOXPO INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 66,530 shares; 2017Q2: 66,055 shares; 2017Q3: 74,005 shares; 2017Q4: 72,130 shares 72,130$6.61M1.2%-1,875Timeline
FTVFORTIVE CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 84,112 shares; 2017Q2: 84,079 shares; 2017Q3: 85,829 shares; 2017Q4: 87,959 shares 87,959$6.36M1.16%+2,130Timeline
KOCOCA COLA COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 159,219 shares; 2017Q2: 142,449 shares; 2017Q3: 141,369 shares; 2017Q4: 135,551 shares 135,551$6.22M1.13%-5,818Timeline
PIONEER NATURAL RESOURCES COPIONEER NATURAL RESOURCES COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 14,660 shares; 2017Q2: 33,460 shares; 2017Q3: 32,750 shares; 2017Q4: 32,590 shares 32,590$5.63M1.02%-160
MRKMERCK & CO INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 109,500 shares; 2017Q2: 100,700 shares; 2017Q3: 103,975 shares; 2017Q4: 99,962 shares 99,962$5.62M1.02%-4,013Timeline
ABTABBOTT LABORATORIESQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 106,228 shares; 2017Q2: 96,378 shares; 2017Q3: 97,278 shares; 2017Q4: 93,378 shares 93,378$5.33M0.97%-3,900Timeline
DISDISNEY WALT COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 41,065 shares; 2017Q2: 41,790 shares; 2017Q3: 42,425 shares; 2017Q4: 41,135 shares 41,135$4.42M0.8%-1,290Timeline
MCDMCDONALDS CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 20,203 shares; 2017Q2: 19,568 shares; 2017Q3: 19,888 shares; 2017Q4: 19,988 shares 19,988$3.44M0.63%+100Timeline
USBUS BANCORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 66,627 shares; 2017Q2: 66,052 shares; 2017Q3: 65,827 shares; 2017Q4: 61,227 shares 61,227$3.28M0.6%-4,600Timeline
BRK-BBERKSHIRE HATHAWAY INC DELQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 14,616 shares; 2017Q2: 13,716 shares; 2017Q3: 13,666 shares; 2017Q4: 13,581 shares 13,581$2.69M0.49%-85Timeline
AMTAMERICAN TOWER CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 15,900 shares; 2017Q2: 17,365 shares; 2017Q3: 17,365 shares; 2017Q4: 17,765 shares 17,765$2.54M0.46%+400Timeline
TTDTHE TRADE DESK INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: not reported; 2017Q3: not reported; 2017Q4: 54,190 shares 54,190$2.48M0.45%newTimeline
NKENIKE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 92,165 shares; 2017Q2: 53,480 shares; 2017Q3: 53,480 shares; 2017Q4: 37,174 shares 37,174$2.33M0.42%-16,306Timeline
GOOGLALPHABET INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 2,522 shares; 2017Q2: 2,367 shares; 2017Q3: 2,367 shares; 2017Q4: 2,162 shares 2,162$2.28M0.41%-205Timeline
BACBANK OF AMER CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 66,763 shares; 2017Q2: 71,388 shares; 2017Q3: 74,363 shares; 2017Q4: 75,813 shares 75,813$2.24M0.41%+1,450Timeline
BERRY GLOBAL GROUP INCBERRY GLOBAL GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 35,635 shares; 2017Q2: 35,335 shares; 2017Q3: 35,435 shares; 2017Q4: 35,585 shares 35,585$2.09M0.38%+150
VVISA INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: not reported; 2017Q3: 12,685 shares; 2017Q4: 17,300 shares 17,300$1.97M0.36%+4,615Timeline
GILDGILEAD SCIENCES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 120,566 shares; 2017Q2: 103,721 shares; 2017Q3: 33,538 shares; 2017Q4: 26,726 shares 26,726$1.92M0.35%-6,812Timeline
TIME WARNER INCTIME WARNER INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 120,671 shares; 2017Q2: 26,226 shares; 2017Q3: 25,026 shares; 2017Q4: 20,886 shares 20,886$1.91M0.35%-4,140
PEPPEPSICO INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 15,969 shares; 2017Q2: 15,019 shares; 2017Q3: 14,769 shares; 2017Q4: 14,549 shares 14,549$1.75M0.32%-220Timeline
CSCOCISCO SYS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 44,296 shares; 2017Q2: 44,266 shares; 2017Q3: 44,266 shares; 2017Q4: 44,266 shares 44,266$1.7M0.31%0Timeline
INTCINTEL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 32,275 shares; 2017Q2: 32,275 shares; 2017Q3: 32,275 shares; 2017Q4: 32,275 shares 32,275$1.49M0.27%0Timeline
ADBEADOBE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 6,050 shares; 2017Q2: 6,050 shares; 2017Q3: 6,050 shares; 2017Q4: 8,280 shares 8,280$1.45M0.26%+2,230Timeline
ULTAULTA BEAUTY INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 5,116 shares; 2017Q2: 6,446 shares; 2017Q3: 5,726 shares; 2017Q4: 4,576 shares 4,576$1.02M0.19%-1,150Timeline
SHOPSHOPIFY INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: 6,445 shares; 2017Q3: 7,545 shares; 2017Q4: 8,030 shares 8,030$811K0.15%+485Timeline
NOWSERVICENOW INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 4,285 shares; 2017Q2: 6,055 shares; 2017Q3: 6,055 shares; 2017Q4: 6,205 shares 6,205$809K0.15%+150Timeline
MMM3M COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 3,081 shares; 2017Q2: 3,081 shares; 2017Q3: 3,081 shares; 2017Q4: 3,081 shares 3,081$725K0.13%0Timeline
NVDANVIDIA CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 1,945 shares; 2017Q2: 2,400 shares; 2017Q3: 3,200 shares; 2017Q4: 3,200 shares 3,200$619K0.11%0Timeline
CERNER CORPCERNER CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 11,330 shares; 2017Q2: 10,480 shares; 2017Q3: 9,430 shares; 2017Q4: 9,130 shares 9,130$615K0.11%-300
EQIXEQUINIX INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: not reported; 2017Q3: not reported; 2017Q4: 1,340 shares 1,340$607K0.11%newTimeline
ABBVABBVIE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 5,700 shares; 2017Q2: 5,700 shares; 2017Q3: 5,700 shares; 2017Q4: 6,060 shares 6,060$586K0.11%+360Timeline
GENERAL ELEC COGENERAL ELEC COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 123,623 shares; 2017Q2: 55,513 shares; 2017Q3: 39,830 shares; 2017Q4: 30,473 shares 30,473$532K0.1%-9,357
PMPHILIP MORRIS INTL INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 3,000 shares; 2017Q2: 4,200 shares; 2017Q3: 4,200 shares; 2017Q4: 4,200 shares 4,200$444K0.08%0Timeline
TREELENDINGTREE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: 1,275 shares; 2017Q3: 1,275 shares; 2017Q4: 1,275 shares 1,275$434K0.08%0Timeline
VARIAN MED SYS INCVARIAN MED SYS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 5,235 shares; 2017Q2: 4,485 shares; 2017Q3: 4,285 shares; 2017Q4: 3,869 shares 3,869$430K0.08%-416
GSGOLDMAN SACHS GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 1,500 shares; 2017Q2: 1,500 shares; 2017Q3: 1,500 shares; 2017Q4: 1,500 shares 1,500$382K0.07%0Timeline
PIIMPINJ INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: 6,190 shares; 2017Q3: 16,735 shares; 2017Q4: 16,835 shares 16,835$379K0.07%+100Timeline
MOALTRIA GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 5,000 shares; 2017Q2: 5,000 shares; 2017Q3: 5,000 shares; 2017Q4: 5,000 shares 5,000$357K0.06%0Timeline
PRICELINE GRP INCPRICELINE GRP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 200 shares; 2017Q2: 200 shares; 2017Q3: 200 shares; 2017Q4: 200 shares 200$348K0.06%0
AXPAMERICAN EXPRESS COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 3,544 shares; 2017Q2: 3,544 shares; 2017Q3: 3,344 shares; 2017Q4: 3,344 shares 3,344$332K0.06%0Timeline
DOWDUPONT INCDOWDUPONT INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: not reported; 2017Q3: 4,187 shares; 2017Q4: 4,187 shares 4,187$298K0.05%0
AMATAPPLIED MATLS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: 5,400 shares; 2017Q3: 5,400 shares; 2017Q4: 5,400 shares 5,400$276K0.05%0Timeline
PFEPFIZER INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 7,098 shares; 2017Q2: 7,098 shares; 2017Q3: 7,098 shares; 2017Q4: 7,098 shares 7,098$257K0.05%0Timeline
AMGNAMGEN INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 1,275 shares; 2017Q2: 1,275 shares; 2017Q3: 1,275 shares; 2017Q4: 1,275 shares 1,275$222K0.04%0Timeline
DRRSFARIANNE PHOSPHATE INC ORD SHSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 12,000 shares; 2017Q2: 19,000 shares; 2017Q3: 19,000 shares; 2017Q4: 19,000 shares 19,000$9K<0.01%0Timeline
EXCEL CORPORATIONEXCEL CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 232,619 shares; 2017Q2: 232,619 shares; 2017Q3: 232,619 shares; 2017Q4: 232,619 shares 232,619$3K<0.01%0

Principal amounts

Notes and convertibles filed as a face amount (PRN). A face amount is never added to a share count (H6).

SecurityTypeAmountValueChange
SPYSTATE STR SPDR S&P 500 ETF T SHSprincipal49,430$13.2M-576
VWOVANGUARD INTL EQUITY INDEX F SHSprincipal285,608$13.1M+239,610
GLDSPDR GOLD TR GOLD SHSprincipal57,835$7.15M-2,055
CURRENCYSHARES EURO TRUSTCURRENCYSHARES EURO TRUST COMMON STOCKprincipal32,875$3.8M-3,150
VOVANGUARD INDEX FDS SHSprincipal24,014$3.72M0
IJHISHARES TR COMprincipal18,008$3.42M-497
VIGVANGUARD SPECIALIZED FUNDS SHSprincipal31,018$3.17M-50
VBVANGUARD INDEX FDS SHSprincipal21,395$3.16M-15
VOOVANGUARD INDEX FDS COMprincipal7,682$1.88M+42
IJRISHARES TR SHSprincipal17,210$1.32M0
IJTISHARES TR S&P SML 600 GWTprincipal7,520$1.28M0
IJKISHARES TR S&P MC 400GR ETFprincipal5,625$1.21M0
SUBISHARES TR ETFprincipal7,000$734K-5,000
VBKVANGUARD INDEX FDS SHSprincipal2,965$477K-50
IVWISHARES TR SHSprincipal2,970$454K0
EFAISHARES TR MSCI EAFE ETFprincipal5,640$397K+600
VOTVANGUARD INDEX FDS SHSprincipal3,065$391K-100
VYMVANGUARD WHITEHALL FDS SHSprincipal4,515$387K0
MUBISHARES TR NATIONAL MUN ETFprincipal2,800$310K0
BONDPIMCO ETF TR ACTIVE BD ETFprincipal2,701$286K-200
PowerShares QQQ Trust Unit …PowerShares QQQ Trust Unit Ser COMprincipal1,350$210Knew

Sold out in Q4 2017

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

SecurityShares beforeValue beforeType
TIPISHARES TR30,000$3.41Mprincipal
TAPMOLSON COORS BEVERAGE CO6,180$505Kshares
TSLATESLA INC629$215Kshares

How Q4 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).

FilingRoleAmendmentFiledAcceptedIngested
13F-HR 0001442173-18-000001 base2018-01-29acceptance time not in the bulk data set