Skip to content
Disclosery

Spruce Investment Advisors LLC

Follow

13F filer, CIK 1542179, Stamford, CT

Spruce Investment Advisors LLC reported $48,499,000 across 23 holdings for the quarter ended 2017-12-31, in a 13F-HR filed 2018-02-14. Its ten largest share positions make up 69.57% of the portfolio.

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

Period
2017-12-31
Reported value
$48.5M
Holdings
23
Top 10 weight
69.57%
New
0
Sold out
10

Largest buys vs the previous quarter

SecurityShares changeApprox. value
ISCFadded+8,657$281K

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
MUBexited-18,412-$2.04M
IEFAreduced-7,112-$470K
XLKreduced-6,862-$439K
MTUMreduced-3,043-$314K
VLUEreduced-3,268-$273K

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 2017

Share positions as resolved from 13F-HR 0001172661-18-000594, largest first. % of portfolio is the value over $48,499,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; 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; 2017Q4: 167,595 shares 167,595$7.69M15.86%0Timeline
EMGFISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 27,974 shares; 2017Q3: 110,543 shares; 2017Q4: 107,870 shares 107,870$5.34M11%-2,673Timeline
ISCFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 41,512 shares; 2017Q3: 101,042 shares; 2017Q4: 109,699 shares 109,699$3.56M7.34%+8,657Timeline
IEFAISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 44,043 shares 44,043$2.91M6%-7,112Timeline
BKFISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 84,115 shares; 2017Q2: 64,630 shares; 2017Q3: 58,810 shares; 2017Q4: 54,842 shares 54,842$2.44M5.03%-3,968Timeline
IMTMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 83,633 shares; 2017Q3: 81,097 shares; 2017Q4: 78,043 shares 78,043$2.38M4.91%-3,054Timeline
MTUMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 30,446 shares; 2017Q2: 27,301 shares; 2017Q3: 26,061 shares; 2017Q4: 23,018 shares 23,018$2.37M4.89%-3,043Timeline
IDVISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 69,740 shares 69,740$2.36M4.86%-1,677Timeline
VLUEISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: 22,915 shares; 2017Q2: 32,188 shares; 2017Q3: 31,435 shares; 2017Q4: 28,167 shares 28,167$2.35M4.86%-3,268Timeline
IVLUISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2016Q1: not reported; 2016Q2: not reported; 2016Q3: not reported; 2016Q4: not reported; 2017Q1: not reported; 2017Q2: 96,690 shares; 2017Q3: 95,217 shares; 2017Q4: 88,218 shares 88,218$2.33M4.81%-6,999Timeline
XLKSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 33,724 shares 33,724$2.16M4.45%-6,862Timeline
VPUVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 18,171 shares 18,171$2.12M4.37%-1,558Timeline
VFHVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 29,631 shares 29,631$2.08M4.28%-3,573Timeline
DBEUDBX ETF TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 56,697 shares 56,697$1.61M3.32%-7,492Timeline
IHFISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 7,475 shares 7,475$1.17M2.42%-723Timeline
XLVSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 11,568 shares 11,568$956K1.97%-1,161Timeline
VCRVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 5,068 shares 5,068$790K1.63%-445Timeline
XLPSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 13,138 shares 13,138$747K1.54%-1,112Timeline
XLISELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 9,778 shares 9,778$740K1.53%-960Timeline
VOXVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 8,011 shares 8,011$730K1.51%-422Timeline
XLBSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 12,037 shares 12,037$729K1.5%-1,289Timeline
VNQVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 7,432 shares 7,432$617K1.27%-669Timeline
XLFSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 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; 2017Q4: 11,271 shares 11,271$315K0.65%-540Timeline

Sold out in Q4 2017

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

SecurityShares beforeValue beforeType
MUBISHARES TR18,412$2.04Mshares
VHTVANGUARD WORLD FD1,106$168Kshares
XLRESELECT SECTOR SPDR TR3,299$106Kshares
VISVANGUARD WORLD FD416$56Kshares
VAWVANGUARD WORLD FD415$53Kshares
VGTVANGUARD WORLD FD152$23Kshares
IYFISHARES TR97$11Kshares
VDCVANGUARD WORLD FD54$7Kshares
IYHISHARES TR34$6Kshares
VTVANGUARD INTL EQUITY INDEX F60$4Kshares

How Q4 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-18-000594 base2018-02-14acceptance time not in the bulk data set

Filings

Every filing of this filer: 13F reports and notices, the 13D and 13G it filed or is a reporting person of, and Forms 3, 4 and 5 it reported as an owner.

FilingSubjectFiledAcceptedIngested
13F-HR 0001172661-18-000594 Quarter ended 2017-12-312018-02-14acceptance time not in the bulk data set
13F-HR 0001172661-17-001916 Quarter ended 2017-09-302017-11-09acceptance time not in the bulk data set
13F-HR 0001172661-17-001488 Quarter ended 2017-06-302017-08-07acceptance time not in the bulk data set
13F-HR 0001172661-17-000979 Quarter ended 2017-03-312017-05-10acceptance time not in the bulk data set
13F-HR 0001172661-17-000288 Quarter ended 2016-12-312017-02-08acceptance time not in the bulk data set
13F-HR 0001172661-16-004147 Quarter ended 2016-09-302016-11-10acceptance time not in the bulk data set
13F-HR 0001172661-16-003635 Quarter ended 2016-06-302016-08-02acceptance time not in the bulk data set
13F-HR 0001172661-16-003214 Quarter ended 2016-03-312016-05-10acceptance time not in the bulk data set
13F-HR 0001172661-16-002500 Quarter ended 2015-12-312016-02-09acceptance time not in the bulk data set
13F-HR 0001172661-15-001860 Quarter ended 2015-09-302015-11-03acceptance time not in the bulk data set
13F-HR 0001172661-15-001437 Quarter ended 2015-06-302015-08-06acceptance time not in the bulk data set
13F-HR 0001172661-15-001036 Quarter ended 2015-03-312015-05-12acceptance time not in the bulk data set
13F-HR 0001172661-15-000295 Quarter ended 2014-12-312015-02-09acceptance time not in the bulk data set
13F-HR 0001172661-14-001699 Quarter ended 2014-09-302014-11-10acceptance time not in the bulk data set
13F-HR 0001172661-14-001317 Quarter ended 2014-06-302014-08-06acceptance time not in the bulk data set
13F-HR 0001172661-14-000934 Quarter ended 2014-03-312014-05-05acceptance time not in the bulk data set
13F-HR/A 0001172661-14-000763 Quarter ended 2013-12-312014-03-10acceptance time not in the bulk data set
13F-HR 0001172661-14-000215 Quarter ended 2013-12-312014-02-04acceptance time not in the bulk data set
13F-HR 0001172661-13-001361 Quarter ended 2013-09-302013-10-22acceptance time not in the bulk data set
13F-HR 0001172661-13-001087 Quarter ended 2013-06-302013-08-09acceptance time not in the bulk data set