Skip to content
Disclosery

MACGUIRE, CHESWICK & TUTTLE INVESTMENT COUNSEL LLC

Follow

13F filer, CIK 1442173, DARIEN, CT

MACGUIRE, CHESWICK & TUTTLE INVESTMENT COUNSEL LLC reported $492,758,000 across 93 holdings for the quarter ended 2017-06-30, in a 13F-HR filed 2017-08-02. Its ten largest share positions make up 36.21% of the portfolio.

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

Period
2017-06-30
Reported value
$493M
Holdings
93
Top 10 weight
36.21%
New
5
Sold out
1

Largest buys vs the previous quarter

SecurityShares changeApprox. value
PIONEER NATURAL RESOURCES COadded+18,800$3M
SHOPnew+6,445$560K
ULTAadded+1,330$382K
PInew+6,190$301K
AMATnew+5,400$223K

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
TIME WARNER INCreduced-94,445-$9.48M
TAPreduced-60,820-$5.26M
NKEreduced-38,685-$2.28M
GENERAL ELEC COreduced-68,110-$1.84M
JPMreduced-15,832-$1.45M

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 0001442173-17-000003, largest first. % of portfolio is the value over $492,757,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; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 25,881 shares; 2017Q2: 24,609 shares 24,609$23.8M4.83%-1,272Timeline
JPMJPMORGAN CHASE & COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 257,929 shares; 2017Q2: 242,097 shares 242,097$22.1M4.49%-15,832Timeline
AAPLAPPLE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 157,595 shares; 2017Q2: 151,210 shares 151,210$21.8M4.42%-6,385Timeline
HDHOME DEPOT INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 126,840 shares; 2017Q2: 120,900 shares 120,900$18.5M3.76%-5,940Timeline
JNJJOHNSON & JOHNSONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 136,309 shares; 2017Q2: 134,559 shares 134,559$17.8M3.61%-1,750Timeline
HONHONEYWELL INTL INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 123,242 shares; 2017Q2: 112,817 shares 112,817$15M3.05%-10,425Timeline
FISVFISERV INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 129,615 shares; 2017Q2: 122,640 shares 122,640$15M3.04%-6,975Timeline
WFCWELLS FARGO & COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 290,411 shares; 2017Q2: 270,424 shares 270,424$15M3.04%-19,987Timeline
DHRDANAHER CORP DELQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 181,505 shares; 2017Q2: 175,255 shares 175,255$14.8M3%-6,250Timeline
GOOGALPHABET INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 16,892 shares; 2017Q2: 15,992 shares 15,992$14.5M2.95%-900Timeline
SBUXSTARBUCKS CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 259,321 shares; 2017Q2: 244,031 shares 244,031$14.2M2.89%-15,290Timeline
APHAMPHENOL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 200,027 shares; 2017Q2: 189,977 shares 189,977$14M2.85%-10,050Timeline
MRSHMARSH & MCLENNAN COS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 188,041 shares; 2017Q2: 178,591 shares 178,591$13.9M2.83%-9,450Timeline
COSTCOSTCO WHOLESALE CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 85,991 shares; 2017Q2: 84,356 shares 84,356$13.5M2.74%-1,635Timeline
METAMETA PLATFORMS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 91,719 shares; 2017Q2: 86,114 shares 86,114$13M2.64%-5,605Timeline
CBRECBRE GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 354,070 shares; 2017Q2: 342,585 shares 342,585$12.5M2.53%-11,485Timeline
CELGENE CORPCELGENE CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 92,374 shares; 2017Q2: 87,321 shares 87,321$11.3M2.3%-5,053
SLBSLB LIMITEDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 169,166 shares; 2017Q2: 157,986 shares 157,986$10.4M2.11%-11,180Timeline
UNITED TECHNOLOGIES CORPUNITED TECHNOLOGIES CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 78,608 shares; 2017Q2: 77,408 shares 77,408$9.45M1.92%-1,200
WALGREENS BOOTS ALLIANCE INCWALGREENS BOOTS ALLIANCE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 123,929 shares; 2017Q2: 117,844 shares 117,844$9.23M1.87%-6,085
XOMEXXON MOBIL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 117,388 shares; 2017Q2: 103,921 shares 103,921$8.39M1.7%-13,467Timeline
PGPROCTER & GAMBLE COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 106,015 shares; 2017Q2: 95,025 shares 95,025$8.28M1.68%-10,990Timeline
ORCLORACLE CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 175,054 shares; 2017Q2: 164,454 shares 164,454$8.25M1.67%-10,600Timeline
BLACKSTONE GROUP LP/THEBLACKSTONE GROUP LP/THEQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 257,540 shares; 2017Q2: 235,690 shares 235,690$7.86M1.6%-21,850
COFCAPITAL ONE FINL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 97,803 shares; 2017Q2: 93,318 shares 93,318$7.71M1.56%-4,485Timeline
MSFTMICROSOFT CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 113,701 shares; 2017Q2: 107,811 shares 107,811$7.43M1.51%-5,890Timeline
GILDGILEAD SCIENCES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 120,566 shares; 2017Q2: 103,721 shares 103,721$7.34M1.49%-16,845Timeline
URIUNITED RENTALS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 61,245 shares; 2017Q2: 59,805 shares 59,805$6.74M1.37%-1,440Timeline
MRKMERCK & CO INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 109,500 shares; 2017Q2: 100,700 shares 100,700$6.45M1.31%-8,800Timeline
KOCOCA COLA COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 159,219 shares; 2017Q2: 142,449 shares 142,449$6.39M1.3%-16,770Timeline
CVXCHEVRON CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 59,501 shares; 2017Q2: 58,561 shares 58,561$6.11M1.24%-940Timeline
PIONEER NATURAL RESOURCES COPIONEER NATURAL RESOURCES COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 14,660 shares; 2017Q2: 33,460 shares 33,460$5.34M1.08%+18,800
FTVFORTIVE CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 84,112 shares; 2017Q2: 84,079 shares 84,079$5.33M1.08%-33Timeline
MYLAN NVMYLAN NVQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 134,885 shares; 2017Q2: 124,185 shares 124,185$4.82M0.98%-10,700
ABTABBOTT LABORATORIESQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 106,228 shares; 2017Q2: 96,378 shares 96,378$4.68M0.95%-9,850Timeline
DISDISNEY WALT COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 41,065 shares; 2017Q2: 41,790 shares 41,790$4.44M0.9%+725Timeline
XPOXPO INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 66,530 shares; 2017Q2: 66,055 shares 66,055$4.27M0.87%-475Timeline
USBUS BANCORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 66,627 shares; 2017Q2: 66,052 shares 66,052$3.43M0.7%-575Timeline
NKENIKE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 92,165 shares; 2017Q2: 53,480 shares 53,480$3.15M0.64%-38,685Timeline
MCDMCDONALDS CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 20,203 shares; 2017Q2: 19,568 shares 19,568$3M0.61%-635Timeline
TIME WARNER INCTIME WARNER INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 120,671 shares; 2017Q2: 26,226 shares 26,226$2.63M0.53%-94,445
BRK-BBERKSHIRE HATHAWAY INC DELQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 14,616 shares; 2017Q2: 13,716 shares 13,716$2.32M0.47%-900Timeline
AMTAMERICAN TOWER CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 15,900 shares; 2017Q2: 17,365 shares 17,365$2.3M0.47%+1,465Timeline
GOOGLALPHABET INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 2,522 shares; 2017Q2: 2,367 shares 2,367$2.2M0.45%-155Timeline
BERRY GLOBAL GROUP INCBERRY GLOBAL GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 35,635 shares; 2017Q2: 35,335 shares 35,335$2.01M0.41%-300
ULTAULTA BEAUTY INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 5,116 shares; 2017Q2: 6,446 shares 6,446$1.85M0.38%+1,330Timeline
PEPPEPSICO INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 15,969 shares; 2017Q2: 15,019 shares 15,019$1.74M0.35%-950Timeline
BACBANK OF AMER CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 66,763 shares; 2017Q2: 71,388 shares 71,388$1.73M0.35%+4,625Timeline
GENERAL ELEC COGENERAL ELEC COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 123,623 shares; 2017Q2: 55,513 shares 55,513$1.5M0.3%-68,110
CSCOCISCO SYS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 44,296 shares; 2017Q2: 44,266 shares 44,266$1.39M0.28%-30Timeline
INTCINTEL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 32,275 shares; 2017Q2: 32,275 shares 32,275$1.09M0.22%0Timeline
ADBEADOBE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 6,050 shares; 2017Q2: 6,050 shares 6,050$856K0.17%0Timeline
CERNER CORPCERNER CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 11,330 shares; 2017Q2: 10,480 shares 10,480$697K0.14%-850
NOWSERVICENOW INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 4,285 shares; 2017Q2: 6,055 shares 6,055$642K0.13%+1,770Timeline
MMM3M COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 3,081 shares; 2017Q2: 3,081 shares 3,081$641K0.13%0Timeline
SHOPSHOPIFY INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: 6,445 shares 6,445$560K0.11%newTimeline
TAPMOLSON COORS BEVERAGE COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 67,000 shares; 2017Q2: 6,180 shares 6,180$534K0.11%-60,820Timeline
PMPHILIP MORRIS INTL INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 3,000 shares; 2017Q2: 4,200 shares 4,200$493K0.1%+1,200Timeline
VARIAN MED SYS INCVARIAN MED SYS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 5,235 shares; 2017Q2: 4,485 shares 4,485$463K0.09%-750
ABBVABBVIE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 5,700 shares; 2017Q2: 5,700 shares 5,700$413K0.08%0Timeline
PRICELINE GRP INCPRICELINE GRP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 200 shares; 2017Q2: 200 shares 200$374K0.08%0
MOALTRIA GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 5,000 shares; 2017Q2: 5,000 shares 5,000$372K0.08%0Timeline
NVDANVIDIA CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 1,945 shares; 2017Q2: 2,400 shares 2,400$347K0.07%+455Timeline
GSGOLDMAN SACHS GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 1,500 shares; 2017Q2: 1,500 shares 1,500$333K0.07%0Timeline
PIIMPINJ INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: 6,190 shares 6,190$301K0.06%newTimeline
AXPAMERICAN EXPRESS COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 3,544 shares; 2017Q2: 3,544 shares 3,544$299K0.06%0Timeline
TSLATESLA INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 829 shares; 2017Q2: 714 shares 714$258K0.05%-115Timeline
Dow Chemical CompanyDow Chemical CompanyQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 4,018 shares; 2017Q2: 4,018 shares 4,018$253K0.05%0
PFEPFIZER INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 7,098 shares; 2017Q2: 7,098 shares 7,098$238K0.05%0Timeline
AMATAPPLIED MATLS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: 5,400 shares 5,400$223K0.05%newTimeline
AMGNAMGEN INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 1,275 shares; 2017Q2: 1,275 shares 1,275$220K0.04%0Timeline
TREELENDINGTREE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: not reported; 2017Q2: 1,275 shares 1,275$220K0.04%newTimeline
DRRSFARIANNE PHOSPHATE INC ORD SHSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 12,000 shares; 2017Q2: 19,000 shares 19,000$13K<0.01%+7,000Timeline
EXCEL CORPORATIONEXCEL CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: restricted; 2016Q2: restricted; 2016Q3: restricted; 2016Q4: restricted; 2017Q1: 232,619 shares; 2017Q2: 232,619 shares 232,619$12K<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 SHSprincipal50,006$12.1M0
IJHISHARES TR COMprincipal35,410$6.16M-5,930
GLDSPDR GOLD TR GOLD SHSprincipal41,598$4.91M+10,688
VOVANGUARD INDEX FDS SHSprincipal23,939$3.41M-1,675
VBVANGUARD INDEX FDS SHSprincipal21,335$2.89M-1,625
VIGVANGUARD SPECIALIZED FUNDS SHSprincipal31,143$2.89M-5,775
TIPISHARES TR SHSprincipal20,000$2.27Mnew
VOOVANGUARD INDEX FDS COMprincipal6,697$1.49M-300
IJRISHARES TR SHSprincipal19,310$1.35M-1,440
IJTISHARES TR S&P SML 600 GWTprincipal7,520$1.17M+1,550
SUBISHARES TR ETFprincipal11,000$1.16M0
IJKISHARES TR S&P MC 400GR ETFprincipal5,625$1.11M+1,230
VWOVANGUARD INTL EQUITY INDEX F SHSprincipal19,993$816K-1,400
IVWISHARES TR SHSprincipal2,970$406K0
VBKVANGUARD INDEX FDS SHSprincipal2,785$406K0
VYMVANGUARD WHITEHALL FDS SHSprincipal4,515$353K-1,365
VOTVANGUARD INDEX FDS SHSprincipal2,865$337K0
MUBISHARES TR NATIONAL MUN ETFprincipal2,800$308K0
BONDPIMCO ETF TR ACTIVE BD ETFprincipal2,901$308K-2,314

Sold out in Q2 2017

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

SecurityShares beforeValue beforeType
SANBANCO SANTANDER SA63,065$383Kshares

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

FilingRoleAmendmentFiledAcceptedIngested
13F-HR 0001442173-17-000003 base2017-08-02acceptance time not in the bulk data set