Skip to content
Disclosery

Spruce Investment Advisors LLC

Follow

13F filer, CIK 1542179, Stamford, CT

Spruce Investment Advisors LLC reported $56,559,000 across 38 holdings for the quarter ended 2017-06-30, in a 13F-HR filed 2017-08-07. Its ten largest share positions make up 58.54% of the portfolio.

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

Period
2017-06-30
Reported value
$56.6M
Holdings
38
Top 10 weight
58.54%
New
5
Sold out
13

Largest buys vs the previous quarter

SecurityShares changeApprox. value
MUBadded+78,837$8.68M
IMTMnew+83,633$2.35M
IVLUnew+96,690$2.33M
QUALnew+21,355$1.59M
EMGFnew+27,974$1.19M

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
SUBexited-103,760-$11M
IEFAreduced-87,426-$5.32M
SPYexited-21,700-$5.12M
IGSBexited-28,980-$3.05M
VCRreduced-20,645-$2.93M

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 0001172661-17-001488, largest first. % of portfolio is the value over $56,559,000, the sum of the share positions whose value is usable for ratios (method).

SecurityHistorySharesValue% of portfolioChangeLatest eventTimeline
MUBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 142,518 shares; 2016Q2: 175,589 shares; 2016Q3: 149,194 shares; 2016Q4: 4,018 shares; 2017Q1: 4,858 shares; 2017Q2: 83,695 shares 83,695$9.22M16.29%+78,837Timeline
VWOVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 439,083 shares; 2016Q2: 439,083 shares; 2016Q3: 439,083 shares; 2016Q4: 109,484 shares; 2017Q1: 83,660 shares; 2017Q2: 83,660 shares 83,660$3.42M6.04%0Timeline
IEFAISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 230,084 shares; 2016Q3: 201,346 shares; 2016Q4: 469,475 shares; 2017Q1: 140,515 shares; 2017Q2: 53,089 shares 53,089$3.23M5.72%-87,426Timeline
VTIVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 7,929 shares; 2016Q2: 7,322 shares; 2016Q3: not reported; 2016Q4: 62,323 shares; 2017Q1: 23,732 shares; 2017Q2: 23,732 shares 23,732$2.95M5.22%0Timeline
MTUMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 30,446 shares; 2017Q2: 27,301 shares 27,301$2.43M4.29%-3,145Timeline
BKFISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 84,115 shares; 2017Q2: 64,630 shares 64,630$2.42M4.28%-19,485Timeline
IDVISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: 789,515 shares; 2016Q3: 692,661 shares; 2016Q4: 12,058 shares; 2017Q1: 88,069 shares; 2017Q2: 73,131 shares 73,131$2.39M4.23%-14,938Timeline
VLUEISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 22,915 shares; 2017Q2: 32,188 shares 32,188$2.37M4.19%+9,273Timeline
IMTMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 83,633 shares 83,633$2.35M4.16%newTimeline
IVLUISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 96,690 shares 96,690$2.33M4.12%newTimeline
DBEUDBX ETF TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 809,916 shares; 2016Q2: 9,550 shares; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 153,493 shares; 2017Q2: 83,339 shares 83,339$2.28M4.03%-70,154Timeline
XLKSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 337,877 shares; 2016Q2: 206,969 shares; 2016Q3: 178,528 shares; 2016Q4: 126,305 shares; 2017Q1: 74,526 shares; 2017Q2: 41,651 shares 41,651$2.28M4.03%-32,875Timeline
VFHVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 184,577 shares; 2016Q2: 106,236 shares; 2016Q3: 90,504 shares; 2016Q4: 46,788 shares; 2017Q1: 35,864 shares; 2017Q2: 34,082 shares 34,082$2.13M3.77%-1,782Timeline
DXJWISDOMTREE TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 216,488 shares; 2016Q2: 64,198 shares; 2016Q3: 27,833 shares; 2016Q4: 27,079 shares; 2017Q1: 61,017 shares; 2017Q2: 40,848 shares 40,848$2.12M3.76%-20,169Timeline
VGKVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 148,937 shares; 2016Q2: 89,395 shares; 2016Q3: 67,026 shares; 2016Q4: 83,537 shares; 2017Q1: 30,871 shares; 2017Q2: 30,871 shares 30,871$1.7M3.01%0Timeline
QUALISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 21,355 shares 21,355$1.59M2.81%newTimeline
IHFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 38,373 shares; 2016Q2: 22,438 shares; 2016Q3: 19,089 shares; 2016Q4: 12,752 shares; 2017Q1: 11,441 shares; 2017Q2: 8,550 shares 8,550$1.27M2.25%-2,891Timeline
EMGFISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 27,974 shares 27,974$1.19M2.11%newTimeline
ISCFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 41,512 shares 41,512$1.18M2.08%newTimeline
XLVSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 55,530 shares; 2016Q2: 35,467 shares; 2016Q3: 29,435 shares; 2016Q4: 18,050 shares; 2017Q1: 15,894 shares; 2017Q2: 13,781 shares 13,781$1.09M1.93%-2,113Timeline
VCRVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 79,672 shares; 2016Q2: 50,969 shares; 2016Q3: 45,030 shares; 2016Q4: 34,304 shares; 2017Q1: 26,235 shares; 2017Q2: 5,590 shares 5,590$794K1.4%-20,645Timeline
XLPSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 130,017 shares; 2016Q2: 81,229 shares; 2016Q3: 67,679 shares; 2016Q4: 48,811 shares; 2017Q1: 37,473 shares; 2017Q2: 14,363 shares 14,363$789K1.4%-23,110Timeline
VPUVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 17,631 shares; 2016Q2: 9,974 shares; 2016Q3: 8,382 shares; 2016Q4: 6,117 shares; 2017Q1: 17,507 shares; 2017Q2: 6,900 shares 6,900$788K1.39%-10,607Timeline
VOXVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 6,955 shares; 2017Q1: 18,550 shares; 2017Q2: 8,484 shares 8,484$779K1.38%-10,066Timeline
XLISELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 112,600 shares; 2016Q2: 61,063 shares; 2016Q3: 51,429 shares; 2016Q4: 32,731 shares; 2017Q1: 12,864 shares; 2017Q2: 11,217 shares 11,217$764K1.35%-1,647Timeline
XLBSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 40,635 shares; 2016Q2: 23,936 shares; 2016Q3: 20,314 shares; 2016Q4: 12,448 shares; 2017Q1: 31,730 shares; 2017Q2: 13,938 shares 13,938$750K1.33%-17,792Timeline
VNQVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 7,176 shares; 2017Q1: 15,546 shares; 2017Q2: 8,336 shares 8,336$694K1.23%-7,210Timeline
EPPISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 12,039 shares; 2017Q2: 12,039 shares 12,039$535K0.95%0Timeline
XLFSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 76,521 shares; 2016Q2: 26,272 shares; 2016Q3: 23,521 shares; 2016Q4: 20,514 shares; 2017Q1: 28,758 shares; 2017Q2: 11,922 shares 11,922$294K0.52%-16,836Timeline
VHTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 16,310 shares; 2016Q2: 12,516 shares; 2016Q3: 12,324 shares; 2016Q4: 11,898 shares; 2017Q1: 12,706 shares; 2017Q2: 1,110 shares 1,110$164K0.29%-11,596Timeline
XLRESELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 3,259 shares; 2017Q1: 15,338 shares; 2017Q2: 3,299 shares 3,299$106K0.19%-12,039Timeline
VISVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 6,426 shares; 2016Q2: 3,582 shares; 2016Q3: 2,897 shares; 2016Q4: 2,448 shares; 2017Q1: 1,540 shares; 2017Q2: 416 shares 416$53K0.09%-1,124Timeline
VAWVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 3,189 shares; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 792 shares; 2017Q1: 3,185 shares; 2017Q2: 423 shares 423$51K0.09%-2,762Timeline
VGTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 235 shares; 2017Q1: 113 shares; 2017Q2: 152 shares 152$21K0.04%+39Timeline
IYFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 52 shares; 2017Q1: 97 shares; 2017Q2: 97 shares 97$10K0.02%0Timeline
VDCVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 102 shares; 2017Q1: 107 shares; 2017Q2: 54 shares 54$8K0.01%-53Timeline
IYHISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 16 shares; 2017Q1: 34 shares; 2017Q2: 34 shares 34$6K0.01%0Timeline
VTVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q3: restricted; 2015Q4: restricted; 2016Q1: 159,758 shares; 2016Q2: 136,357 shares; 2016Q3: 136,357 shares; 2016Q4: 60 shares; 2017Q1: 60 shares; 2017Q2: 60 shares 60$4K0.01%0Timeline

Sold out in Q2 2017

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

SecurityShares beforeValue beforeType
SUBISHARES TR103,760$11Mshares
SPYSTATE STR SPDR S&P 500 ETF T21,700$5.12Mshares
IGSBISHARES TR28,980$3.05Mshares
IJSISHARES TR15,914$2.21Mshares
VOEVANGUARD INDEX FDS17,159$1.75Mshares
VDEVANGUARD WORLD FD15,750$1.52Mshares
VYMVANGUARD WHITEHALL FDS11,175$868Kshares
Rydex S&P 500 Pure Value EtfRydex S&P 500 Pure Value Etf9,226$543Kshares
XLESELECT SECTOR SPDR TR3,880$271Kshares
BNDVANGUARD BD INDEX FDS2,355$191Kshares
IXCISHARES TR5,528$184Kshares
GLOBAL X FDSGLOBAL X FDS9,362$138Kshares
XLUSELECT SECTOR SPDR TR1,717$88Kshares

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 0001172661-17-001488 base2017-08-07acceptance time not in the bulk data set