Skip to content

Spruce Investment Advisors LLC

Follow

13F filer, CIK 1542179, Stamford, CT

Spruce Investment Advisors LLC reported $175,861,000 across 29 holdings for the quarter ended 2016-06-30, in a 13F-HR filed 2016-08-02. Its ten largest share positions make up 78.16% of the portfolio.

Filed (acceptance time not in the bulk data set), ingested 13F-HR 0001172661-16-003635

Period
2016-06-30
Reported value
$176M
Holdings
29
Top 10 weight
78.16%
New
3
Sold out
5

Largest buys vs the previous quarter

SecurityShares changeApprox. value
VYMadded+363,574$26M
IDVnew+789,515$22.6M
IEFAnew+230,084$11.9M
IJSnew+79,389$9.28M
MUBadded+33,071$3.77M

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
DBEUreduced-800,366-$19.6M
DXJreduced-152,290-$5.9M
XLKreduced-130,908-$5.68M
VFHreduced-78,341-$3.71M
VCRreduced-28,703-$3.5M

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 2016

Share positions as resolved from 13F-HR 0001172661-16-003635, largest first. % of portfolio is the value over $175,861,000, the sum of the share positions whose value is usable for ratios (method).

SecurityHistorySharesValue% of portfolioChangeLatest eventTimeline
VYMVANGUARD WHITEHALL FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 44,421 shares; 2016Q2: 407,995 shares 407,995$29.2M16.58%+363,574Timeline
IDVISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 789,515 shares 789,515$22.6M12.85%newTimeline
MUBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 142,518 shares; 2016Q2: 175,589 shares 175,589$20M11.37%+33,071Timeline
VWOVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 439,083 shares; 2016Q2: 439,083 shares 439,083$15.5M8.8%0Timeline
IEFAISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 230,084 shares 230,084$11.9M6.79%newTimeline
IJSISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 79,389 shares 79,389$9.28M5.27%newTimeline
XLKSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 337,877 shares; 2016Q2: 206,969 shares 206,969$8.98M5.1%-130,908Timeline
VTVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 159,758 shares; 2016Q2: 136,357 shares 136,357$7.92M4.5%-23,401Timeline
VCRVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 79,672 shares; 2016Q2: 50,969 shares 50,969$6.22M3.54%-28,703Timeline
BNDVANGUARD BD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 87,040 shares; 2016Q2: 70,024 shares 70,024$5.9M3.36%-17,016Timeline
VFHVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 184,577 shares; 2016Q2: 106,236 shares 106,236$5.03M2.86%-78,341Timeline
XLPSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 130,017 shares; 2016Q2: 81,229 shares 81,229$4.48M2.55%-48,788Timeline
VGKVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 148,937 shares; 2016Q2: 89,395 shares 89,395$4.17M2.37%-59,542Timeline
XLISELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 112,600 shares; 2016Q2: 61,063 shares 61,063$3.42M1.94%-51,537Timeline
SPYSTATE STR SPDR S&P 500 ETF TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 18,205 shares; 2016Q2: 16,139 shares 16,139$3.38M1.92%-2,066Timeline
VDEVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 42,251 shares; 2016Q2: 30,421 shares 30,421$2.89M1.65%-11,830Timeline
IHFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 38,373 shares; 2016Q2: 22,438 shares 22,438$2.86M1.63%-15,935Timeline
XLVSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 55,530 shares; 2016Q2: 35,467 shares 35,467$2.54M1.45%-20,063Timeline
DXJWISDOMTREE TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 216,488 shares; 2016Q2: 64,198 shares 64,198$2.49M1.42%-152,290Timeline
VHTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 16,310 shares; 2016Q2: 12,516 shares 12,516$1.63M0.93%-3,794Timeline
VPUVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 17,631 shares; 2016Q2: 9,974 shares 9,974$1.14M0.65%-7,657Timeline
XLBSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 40,635 shares; 2016Q2: 23,936 shares 23,936$1.11M0.63%-16,699Timeline
VTIVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 7,929 shares; 2016Q2: 7,322 shares 7,322$785K0.45%-607Timeline
XLFSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 76,521 shares; 2016Q2: 26,272 shares 26,272$600K0.34%-50,249Timeline
HEDJWISDOMTREE TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 24,152 shares; 2016Q2: 9,639 shares 9,639$487K0.28%-14,513Timeline
VEUVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 11,159 shares; 2016Q2: 11,159 shares 11,159$478K0.27%0Timeline
VISVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 6,426 shares; 2016Q2: 3,582 shares 3,582$381K0.22%-2,844Timeline
PowerShares QQQ Trust Unit …PowerShares QQQ Trust Unit SerQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 2,652 shares; 2016Q2: 2,652 shares 2,652$285K0.16%0
DBEUDBX ETF TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q3: restricted; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 809,916 shares; 2016Q2: 9,550 shares 9,550$234K0.13%-800,366Timeline

Sold out in Q2 2016

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

SecurityShares beforeValue beforeType
XLESELECT SECTOR SPDR TR8,344$516Kshares
VAWVANGUARD WORLD FD3,189$313Kshares
ISHARESISHARES27,200$310Kshares
FEZSPDR INDEX SHS FDS6,824$227Kshares
ISHARESISHARES10,160$159Kshares

How Q2 2016 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 0001172661-16-003635 base2016-08-02acceptance time not in the bulk data set