Skip to content
Disclosery

Spruce Investment Advisors LLC

Follow

13F filer, CIK 1542179, Stamford, CT

Spruce Investment Advisors LLC reported $86,735,000 across 46 holdings for the quarter ended 2017-03-31, in a 13F-HR filed 2017-05-10. Its ten largest share positions make up 55.91% of the portfolio.

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

Period
2017-03-31
Reported value
$86.7M
Holdings
46
Top 10 weight
55.91%
New
8
Sold out
1

Largest buys vs the previous quarter

SecurityShares changeApprox. value
DBEUnew+153,493$4.15M
BKFnew+84,115$3.06M
MTUMnew+30,446$2.52M
IDVadded+76,011$2.39M
VOEnew+17,159$1.75M

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-321,233-$25M
IEFAreduced-328,960-$19.1M
IJSreduced-43,823-$6.07M
SUBreduced-49,474-$5.22M
VTIreduced-38,591-$4.68M

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

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

SecurityHistorySharesValue% of portfolioChangeLatest eventTimeline
SUBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 153,234 shares; 2017Q1: 103,760 shares 103,760$11M12.63%-49,474Timeline
IEFAISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 230,084 shares; 2016Q3: 201,346 shares; 2016Q4: 469,475 shares; 2017Q1: 140,515 shares 140,515$8.14M9.39%-328,960Timeline
SPYSTATE STR SPDR S&P 500 ETF TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 18,205 shares; 2016Q2: 16,139 shares; 2016Q3: 21,700 shares; 2016Q4: 21,700 shares; 2017Q1: 21,700 shares 21,700$5.12M5.9%0Timeline
DBEUDBX ETF TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 809,916 shares; 2016Q2: 9,550 shares; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 153,493 shares 153,493$4.15M4.79%newTimeline
XLKSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 337,877 shares; 2016Q2: 206,969 shares; 2016Q3: 178,528 shares; 2016Q4: 126,305 shares; 2017Q1: 74,526 shares 74,526$3.97M4.58%-51,779Timeline
VCRVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 79,672 shares; 2016Q2: 50,969 shares; 2016Q3: 45,030 shares; 2016Q4: 34,304 shares; 2017Q1: 26,235 shares 26,235$3.63M4.19%-8,069Timeline
VWOVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 439,083 shares; 2016Q2: 439,083 shares; 2016Q3: 439,083 shares; 2016Q4: 109,484 shares; 2017Q1: 83,660 shares 83,660$3.32M3.83%-25,824Timeline
DXJWISDOMTREE TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 216,488 shares; 2016Q2: 64,198 shares; 2016Q3: 27,833 shares; 2016Q4: 27,079 shares; 2017Q1: 61,017 shares 61,017$3.09M3.56%+33,938Timeline
BKFISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 84,115 shares 84,115$3.06M3.52%newTimeline
IGSBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 38,747 shares; 2017Q1: 28,980 shares 28,980$3.05M3.52%-9,767Timeline
VTIVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 7,929 shares; 2016Q2: 7,322 shares; 2016Q3: not reported; 2016Q4: 62,323 shares; 2017Q1: 23,732 shares 23,732$2.88M3.32%-38,591Timeline
IDVISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 789,515 shares; 2016Q3: 692,661 shares; 2016Q4: 12,058 shares; 2017Q1: 88,069 shares 88,069$2.77M3.19%+76,011Timeline
MTUMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 30,446 shares 30,446$2.52M2.9%newTimeline
IJSISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 79,389 shares; 2016Q3: 77,912 shares; 2016Q4: 59,737 shares; 2017Q1: 15,914 shares 15,914$2.21M2.54%-43,823Timeline
VFHVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 184,577 shares; 2016Q2: 106,236 shares; 2016Q3: 90,504 shares; 2016Q4: 46,788 shares; 2017Q1: 35,864 shares 35,864$2.17M2.5%-10,924Timeline
XLPSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 130,017 shares; 2016Q2: 81,229 shares; 2016Q3: 67,679 shares; 2016Q4: 48,811 shares; 2017Q1: 37,473 shares 37,473$2.04M2.36%-11,338Timeline
VPUVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 17,631 shares; 2016Q2: 9,974 shares; 2016Q3: 8,382 shares; 2016Q4: 6,117 shares; 2017Q1: 17,507 shares 17,507$1.97M2.27%+11,390Timeline
VOXVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 6,955 shares; 2017Q1: 18,550 shares 18,550$1.76M2.03%+11,595Timeline
VHTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 16,310 shares; 2016Q2: 12,516 shares; 2016Q3: 12,324 shares; 2016Q4: 11,898 shares; 2017Q1: 12,706 shares 12,706$1.75M2.02%+808Timeline
VOEVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 17,159 shares 17,159$1.75M2.02%newTimeline
VLUEISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 22,915 shares 22,915$1.68M1.93%newTimeline
XLBSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 40,635 shares; 2016Q2: 23,936 shares; 2016Q3: 20,314 shares; 2016Q4: 12,448 shares; 2017Q1: 31,730 shares 31,730$1.66M1.92%+19,282Timeline
VGKVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 148,937 shares; 2016Q2: 89,395 shares; 2016Q3: 67,026 shares; 2016Q4: 83,537 shares; 2017Q1: 30,871 shares 30,871$1.59M1.84%-52,666Timeline
IHFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 38,373 shares; 2016Q2: 22,438 shares; 2016Q3: 19,089 shares; 2016Q4: 12,752 shares; 2017Q1: 11,441 shares 11,441$1.53M1.77%-1,311Timeline
VDEVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 42,251 shares; 2016Q2: 30,421 shares; 2016Q3: 24,879 shares; 2016Q4: 14,375 shares; 2017Q1: 15,750 shares 15,750$1.52M1.76%+1,375Timeline
VNQVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 7,176 shares; 2017Q1: 15,546 shares 15,546$1.28M1.48%+8,370Timeline
XLVSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 55,530 shares; 2016Q2: 35,467 shares; 2016Q3: 29,435 shares; 2016Q4: 18,050 shares; 2017Q1: 15,894 shares 15,894$1.18M1.36%-2,156Timeline
VYMVANGUARD WHITEHALL FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 44,421 shares; 2016Q2: 407,995 shares; 2016Q3: 345,850 shares; 2016Q4: 332,408 shares; 2017Q1: 11,175 shares 11,175$868K1%-321,233Timeline
XLISELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 112,600 shares; 2016Q2: 61,063 shares; 2016Q3: 51,429 shares; 2016Q4: 32,731 shares; 2017Q1: 12,864 shares 12,864$837K0.97%-19,867Timeline
XLFSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 76,521 shares; 2016Q2: 26,272 shares; 2016Q3: 23,521 shares; 2016Q4: 20,514 shares; 2017Q1: 28,758 shares 28,758$682K0.79%+8,244Timeline
Rydex S&P 500 Pure Value EtfRydex S&P 500 Pure Value EtfQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 9,226 shares 9,226$543K0.63%new
EPPISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 12,039 shares 12,039$538K0.62%newTimeline
MUBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 142,518 shares; 2016Q2: 175,589 shares; 2016Q3: 149,194 shares; 2016Q4: 4,018 shares; 2017Q1: 4,858 shares 4,858$529K0.61%+840Timeline
XLRESELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 3,259 shares; 2017Q1: 15,338 shares 15,338$485K0.56%+12,079Timeline
VAWVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 3,189 shares; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 792 shares; 2017Q1: 3,185 shares 3,185$379K0.44%+2,393Timeline
XLESELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 8,344 shares; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 1,959 shares; 2017Q1: 3,880 shares 3,880$271K0.31%+1,921Timeline
BNDVANGUARD BD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 87,040 shares; 2016Q2: 70,024 shares; 2016Q3: 59,926 shares; 2016Q4: 2,583 shares; 2017Q1: 2,355 shares 2,355$191K0.22%-228Timeline
VISVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 6,426 shares; 2016Q2: 3,582 shares; 2016Q3: 2,897 shares; 2016Q4: 2,448 shares; 2017Q1: 1,540 shares 1,540$191K0.22%-908Timeline
IXCISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 2,369 shares; 2017Q1: 5,528 shares 5,528$184K0.21%+3,159Timeline
GLOBAL X MLP & ENERGY INFRASGLOBAL X MLP & ENERGY INFRASQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 9,362 shares 9,362$138K0.16%new
XLUSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 1,717 shares; 2017Q1: 1,717 shares 1,717$88K0.1%0Timeline
VDCVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 102 shares; 2017Q1: 107 shares 107$15K0.02%+5Timeline
VGTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 235 shares; 2017Q1: 113 shares 113$15K0.02%-122Timeline
IYFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 52 shares; 2017Q1: 97 shares 97$10K0.01%+45Timeline
IYHISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 16 shares; 2017Q1: 34 shares 34$5K0.01%+18Timeline
VTVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q2: restricted; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 159,758 shares; 2016Q2: 136,357 shares; 2016Q3: 136,357 shares; 2016Q4: 60 shares; 2017Q1: 60 shares 60$4K<0.01%0Timeline

Sold out in Q1 2017

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

SecurityShares beforeValue beforeType
SCZISHARES TR500$25Kshares

How Q1 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 0001172661-17-000979 base2017-05-10acceptance time not in the bulk data set