Skip to content
Disclosery

Spruce Investment Advisors LLC

Follow

13F filer, CIK 1542179, Stamford, CT

Spruce Investment Advisors LLC reported $158,842,000 across 24 holdings for the quarter ended 2016-09-30, in a 13F-HR filed 2016-11-10. Its ten largest share positions make up 80.22% of the portfolio.

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

Period
2016-09-30
Reported value
$159M
Holdings
24
Top 10 weight
80.22%
New
0
Sold out
5

Largest buys vs the previous quarter

SecurityShares changeApprox. value
SPYadded+5,561$1.2M

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
VYMreduced-62,145-$4.48M
MUBreduced-26,395-$2.98M
IDVreduced-96,854-$2.9M
IEFAreduced-28,738-$1.58M
DXJreduced-36,365-$1.56M

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, Q3 2016

Share positions as resolved from 13F-HR 0001172661-16-004147, largest first. % of portfolio is the value over $158,842,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; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 44,421 shares; 2016Q2: 407,995 shares; 2016Q3: 345,850 shares 345,850$24.9M15.71%-62,145Timeline
IDVISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 789,515 shares; 2016Q3: 692,661 shares 692,661$20.8M13.07%-96,854Timeline
MUBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 142,518 shares; 2016Q2: 175,589 shares; 2016Q3: 149,194 shares 149,194$16.8M10.59%-26,395Timeline
VWOVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 439,083 shares; 2016Q2: 439,083 shares; 2016Q3: 439,083 shares 439,083$16.5M10.4%0Timeline
IEFAISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 230,084 shares; 2016Q3: 201,346 shares 201,346$11.1M6.99%-28,738Timeline
IJSISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 79,389 shares; 2016Q3: 77,912 shares 77,912$9.72M6.12%-1,477Timeline
XLKSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 337,877 shares; 2016Q2: 206,969 shares; 2016Q3: 178,528 shares 178,528$8.53M5.37%-28,441Timeline
VTVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 159,758 shares; 2016Q2: 136,357 shares; 2016Q3: 136,357 shares 136,357$8.3M5.22%0Timeline
VCRVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 79,672 shares; 2016Q2: 50,969 shares; 2016Q3: 45,030 shares 45,030$5.66M3.56%-5,939Timeline
BNDVANGUARD BD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 87,040 shares; 2016Q2: 70,024 shares; 2016Q3: 59,926 shares 59,926$5.04M3.17%-10,098Timeline
SPYSTATE STR SPDR S&P 500 ETF TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 18,205 shares; 2016Q2: 16,139 shares; 2016Q3: 21,700 shares 21,700$4.69M2.96%+5,561Timeline
VFHVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 184,577 shares; 2016Q2: 106,236 shares; 2016Q3: 90,504 shares 90,504$4.47M2.81%-15,732Timeline
XLPSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 130,017 shares; 2016Q2: 81,229 shares; 2016Q3: 67,679 shares 67,679$3.6M2.27%-13,550Timeline
VGKVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 148,937 shares; 2016Q2: 89,395 shares; 2016Q3: 67,026 shares 67,026$3.27M2.06%-22,369Timeline
XLISELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 112,600 shares; 2016Q2: 61,063 shares; 2016Q3: 51,429 shares 51,429$3M1.89%-9,634Timeline
VDEVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 42,251 shares; 2016Q2: 30,421 shares; 2016Q3: 24,879 shares 24,879$2.43M1.53%-5,542Timeline
IHFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 38,373 shares; 2016Q2: 22,438 shares; 2016Q3: 19,089 shares 19,089$2.37M1.49%-3,349Timeline
XLVSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 55,530 shares; 2016Q2: 35,467 shares; 2016Q3: 29,435 shares 29,435$2.12M1.34%-6,032Timeline
VHTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 16,310 shares; 2016Q2: 12,516 shares; 2016Q3: 12,324 shares 12,324$1.64M1.03%-192Timeline
DXJWISDOMTREE TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 216,488 shares; 2016Q2: 64,198 shares; 2016Q3: 27,833 shares 27,833$1.19M0.75%-36,365Timeline
XLBSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 40,635 shares; 2016Q2: 23,936 shares; 2016Q3: 20,314 shares 20,314$970K0.61%-3,622Timeline
VPUVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 17,631 shares; 2016Q2: 9,974 shares; 2016Q3: 8,382 shares 8,382$897K0.56%-1,592Timeline
XLFSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 76,521 shares; 2016Q2: 26,272 shares; 2016Q3: 23,521 shares 23,521$454K0.29%-2,751Timeline
VISVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2014Q4: restricted; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 6,426 shares; 2016Q2: 3,582 shares; 2016Q3: 2,897 shares 2,897$321K0.2%-685Timeline

Sold out in Q3 2016

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

SecurityShares beforeValue beforeType
VTIVANGUARD INDEX FDS7,322$785Kshares
HEDJWISDOMTREE TR9,639$487Kshares
VEUVANGUARD INTL EQUITY INDEX F11,159$478Kshares
PowerShares QQQ Trust Unit …PowerShares QQQ Trust Unit Ser2,652$285Kshares
DBEUDBX ETF TR9,550$234Kshares

How Q3 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-004147 base2016-11-10acceptance time not in the bulk data set