Skip to content
Disclosery

Spruce Investment Advisors LLC

Follow

13F filer, CIK 1542179, Stamford, CT

Spruce Investment Advisors LLC reported $51,827,000 across 33 holdings for the quarter ended 2017-09-30, in a 13F-HR filed 2017-11-09. Its ten largest share positions make up 64.78% of the portfolio.

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

Period
2017-09-30
Reported value
$51.8M
Holdings
33
Top 10 weight
64.78%
New
0
Sold out
5

Largest buys vs the previous quarter

SecurityShares changeApprox. value
EMGFadded+82,569$3.86M
VWOadded+83,935$3.66M
ISCFadded+59,530$1.83M
VPUadded+12,829$1.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.

Largest sells vs the previous quarter

SecurityShares changeApprox. value
MUBreduced-65,283-$7.24M
VTIexited-23,732-$2.95M
DXJexited-40,848-$2.12M
VGKexited-30,871-$1.7M
QUALexited-21,355-$1.59M

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 2017

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

SecurityHistorySharesValue% of portfolioChangeLatest eventTimeline
VWOVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 167,595 shares 167,595$7.3M14.09%+83,935Timeline
EMGFISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 27,974 shares; 2017Q3: 110,543 shares 110,543$5.17M9.97%+82,569Timeline
IEFAISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 51,155 shares 51,155$3.28M6.33%-1,934Timeline
ISCFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 41,512 shares; 2017Q3: 101,042 shares 101,042$3.11M6%+59,530Timeline
BKFISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 84,115 shares; 2017Q2: 64,630 shares; 2017Q3: 58,810 shares 58,810$2.52M4.87%-5,820Timeline
MTUMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 30,446 shares; 2017Q2: 27,301 shares; 2017Q3: 26,061 shares 26,061$2.49M4.81%-1,240Timeline
IMTMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 83,633 shares; 2017Q3: 81,097 shares 81,097$2.44M4.72%-2,536Timeline
VLUEISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 22,915 shares; 2017Q2: 32,188 shares; 2017Q3: 31,435 shares 31,435$2.43M4.69%-753Timeline
IDVISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 71,417 shares 71,417$2.41M4.65%-1,714Timeline
IVLUISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 96,690 shares; 2017Q3: 95,217 shares 95,217$2.41M4.65%-1,473Timeline
XLKSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 40,586 shares 40,586$2.4M4.63%-1,065Timeline
VPUVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 19,729 shares 19,729$2.3M4.45%+12,829Timeline
VFHVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 33,204 shares 33,204$2.17M4.19%-878Timeline
MUBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 18,412 shares 18,412$2.04M3.94%-65,283Timeline
DBEUDBX ETF TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: 809,916 shares; 2016Q2: 9,550 shares; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 153,493 shares; 2017Q2: 83,339 shares; 2017Q3: 64,189 shares 64,189$1.82M3.51%-19,150Timeline
IHFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 8,198 shares 8,198$1.21M2.34%-352Timeline
XLVSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 12,729 shares 12,729$1.04M2.01%-1,052Timeline
VCRVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 5,513 shares 5,513$790K1.52%-77Timeline
VOXVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 6,955 shares; 2017Q1: 18,550 shares; 2017Q2: 8,484 shares; 2017Q3: 8,433 shares 8,433$778K1.5%-51Timeline
XLPSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 14,250 shares 14,250$769K1.48%-113Timeline
XLISELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 10,738 shares 10,738$762K1.47%-479Timeline
XLBSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 13,326 shares 13,326$757K1.46%-612Timeline
VNQVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 7,176 shares; 2017Q1: 15,546 shares; 2017Q2: 8,336 shares; 2017Q3: 8,101 shares 8,101$673K1.3%-235Timeline
XLFSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 11,811 shares 11,811$305K0.59%-111Timeline
VHTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 1,106 shares 1,106$168K0.32%-4Timeline
XLRESELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 3,259 shares; 2017Q1: 15,338 shares; 2017Q2: 3,299 shares; 2017Q3: 3,299 shares 3,299$106K0.2%0Timeline
VISVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q3: 416 shares 416$56K0.11%0Timeline
VAWVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: 3,189 shares; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 792 shares; 2017Q1: 3,185 shares; 2017Q2: 423 shares; 2017Q3: 415 shares 415$53K0.1%-8Timeline
VGTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 235 shares; 2017Q1: 113 shares; 2017Q2: 152 shares; 2017Q3: 152 shares 152$23K0.04%0Timeline
IYFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 52 shares; 2017Q1: 97 shares; 2017Q2: 97 shares; 2017Q3: 97 shares 97$11K0.02%0Timeline
VDCVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 102 shares; 2017Q1: 107 shares; 2017Q2: 54 shares; 2017Q3: 54 shares 54$7K0.01%0Timeline
IYHISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: 16 shares; 2017Q1: 34 shares; 2017Q2: 34 shares; 2017Q3: 34 shares 34$6K0.01%0Timeline
VTVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2015Q4: restricted; 2016Q1: 159,758 shares; 2016Q2: 136,357 shares; 2016Q3: 136,357 shares; 2016Q4: 60 shares; 2017Q1: 60 shares; 2017Q2: 60 shares; 2017Q3: 60 shares 60$4K0.01%0Timeline

Sold out in Q3 2017

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

SecurityShares beforeValue beforeType
VTIVANGUARD INDEX FDS23,732$2.95Mshares
DXJWISDOMTREE TR40,848$2.12Mshares
VGKVANGUARD INTL EQUITY INDEX F30,871$1.7Mshares
QUALISHARES TR21,355$1.59Mshares
EPPISHARES INC12,039$535Kshares

How Q3 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-001916 base2017-11-09acceptance time not in the bulk data set