Skip to content
Disclosery

Spruce Investment Advisors LLC

Follow

13F filer, CIK 1542179, Stamford, CT

Spruce Investment Advisors LLC reported $128,825,000 across 39 holdings for the quarter ended 2016-12-31, in a 13F-HR filed 2017-02-08. Its ten largest share positions make up 81.86% of the portfolio.

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

Period
2016-12-31
Reported value
$129M
Holdings
39
Top 10 weight
81.86%
New
15
Sold out
0

Largest buys vs the previous quarter

SecurityShares changeApprox. value
SUBnew+153,234$16.1M
IEFAadded+268,129$14.4M
VTInew+62,323$7.19M
IGSBnew+38,747$4.07M
VGKadded+16,511$792K

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
IDVreduced-680,603-$20.1M
MUBreduced-145,176-$15.7M
VWOreduced-329,599-$11.8M
VTreduced-136,297-$9.09M
BNDreduced-57,343-$4.64M

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 2016

Share positions as resolved from 13F-HR 0001172661-17-000288, largest first. % of portfolio is the value over $128,825,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; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 44,421 shares; 2016Q2: 407,995 shares; 2016Q3: 345,850 shares; 2016Q4: 332,408 shares 332,408$25.2M19.55%-13,442Timeline
IEFAISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 230,084 shares; 2016Q3: 201,346 shares; 2016Q4: 469,475 shares 469,475$25.2M19.54%+268,129Timeline
SUBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 153,234 shares 153,234$16.1M12.5%newTimeline
IJSISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 79,389 shares; 2016Q3: 77,912 shares; 2016Q4: 59,737 shares 59,737$8.36M6.49%-18,175Timeline
VTIVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 7,929 shares; 2016Q2: 7,322 shares; 2016Q3: not reported; 2016Q4: 62,323 shares 62,323$7.19M5.58%newTimeline
XLKSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 337,877 shares; 2016Q2: 206,969 shares; 2016Q3: 178,528 shares; 2016Q4: 126,305 shares 126,305$6.11M4.74%-52,223Timeline
SPYSTATE STR SPDR S&P 500 ETF TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 18,205 shares; 2016Q2: 16,139 shares; 2016Q3: 21,700 shares; 2016Q4: 21,700 shares 21,700$4.85M3.77%0Timeline
VCRVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 79,672 shares; 2016Q2: 50,969 shares; 2016Q3: 45,030 shares; 2016Q4: 34,304 shares 34,304$4.41M3.43%-10,726Timeline
IGSBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 38,747 shares 38,747$4.07M3.16%newTimeline
VGKVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 148,937 shares; 2016Q2: 89,395 shares; 2016Q3: 67,026 shares; 2016Q4: 83,537 shares 83,537$4M3.11%+16,511Timeline
VWOVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 439,083 shares; 2016Q2: 439,083 shares; 2016Q3: 439,083 shares; 2016Q4: 109,484 shares 109,484$3.92M3.04%-329,599Timeline
VFHVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 184,577 shares; 2016Q2: 106,236 shares; 2016Q3: 90,504 shares; 2016Q4: 46,788 shares 46,788$2.78M2.16%-43,716Timeline
XLPSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 130,017 shares; 2016Q2: 81,229 shares; 2016Q3: 67,679 shares; 2016Q4: 48,811 shares 48,811$2.52M1.96%-18,868Timeline
XLISELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 112,600 shares; 2016Q2: 61,063 shares; 2016Q3: 51,429 shares; 2016Q4: 32,731 shares 32,731$2.04M1.58%-18,698Timeline
IHFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 38,373 shares; 2016Q2: 22,438 shares; 2016Q3: 19,089 shares; 2016Q4: 12,752 shares 12,752$1.6M1.24%-6,337Timeline
VHTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 16,310 shares; 2016Q2: 12,516 shares; 2016Q3: 12,324 shares; 2016Q4: 11,898 shares 11,898$1.51M1.17%-426Timeline
VDEVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 42,251 shares; 2016Q2: 30,421 shares; 2016Q3: 24,879 shares; 2016Q4: 14,375 shares 14,375$1.5M1.17%-10,504Timeline
DXJWISDOMTREE TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 216,488 shares; 2016Q2: 64,198 shares; 2016Q3: 27,833 shares; 2016Q4: 27,079 shares 27,079$1.34M1.04%-754Timeline
XLVSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 55,530 shares; 2016Q2: 35,467 shares; 2016Q3: 29,435 shares; 2016Q4: 18,050 shares 18,050$1.24M0.97%-11,385Timeline
VOXVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 6,955 shares 6,955$697K0.54%newTimeline
VPUVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 17,631 shares; 2016Q2: 9,974 shares; 2016Q3: 8,382 shares; 2016Q4: 6,117 shares 6,117$655K0.51%-2,265Timeline
XLBSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 40,635 shares; 2016Q2: 23,936 shares; 2016Q3: 20,314 shares; 2016Q4: 12,448 shares 12,448$619K0.48%-7,866Timeline
VNQVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 7,176 shares 7,176$592K0.46%newTimeline
XLFSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 76,521 shares; 2016Q2: 26,272 shares; 2016Q3: 23,521 shares; 2016Q4: 20,514 shares 20,514$477K0.37%-3,007Timeline
MUBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 142,518 shares; 2016Q2: 175,589 shares; 2016Q3: 149,194 shares; 2016Q4: 4,018 shares 4,018$435K0.34%-145,176Timeline
IDVISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 789,515 shares; 2016Q3: 692,661 shares; 2016Q4: 12,058 shares 12,058$356K0.28%-680,603Timeline
VISVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 6,426 shares; 2016Q2: 3,582 shares; 2016Q3: 2,897 shares; 2016Q4: 2,448 shares 2,448$292K0.23%-449Timeline
BNDVANGUARD BD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 87,040 shares; 2016Q2: 70,024 shares; 2016Q3: 59,926 shares; 2016Q4: 2,583 shares 2,583$209K0.16%-57,343Timeline
XLESELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 8,344 shares; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 1,959 shares 1,959$148K0.11%newTimeline
XLRESELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 3,259 shares 3,259$100K0.08%newTimeline
VAWVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 3,189 shares; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 792 shares 792$89K0.07%newTimeline
XLUSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 1,717 shares 1,717$83K0.06%newTimeline
IXCISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 2,369 shares 2,369$82K0.06%newTimeline
VGTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 235 shares 235$29K0.02%newTimeline
SCZISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 500 shares 500$25K0.02%newTimeline
VDCVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 102 shares 102$14K0.01%newTimeline
IYFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 52 shares 52$5K<0.01%newTimeline
VTVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 159,758 shares; 2016Q2: 136,357 shares; 2016Q3: 136,357 shares; 2016Q4: 60 shares 60$4K<0.01%-136,297Timeline
IYHISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q1: restricted; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 16 shares 16$2K<0.01%newTimeline

How Q4 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-17-000288 base2017-02-08acceptance time not in the bulk data set