ASPIRIANT, LLC - Q4 2017 holdings

$341 Million is the total value of ASPIRIANT, LLC's 82 reported holdings in Q4 2017. The portfolio turnover from Q3 2017 to Q4 2017 was 62.2% .

 Value Shares↓ Weighting
ACWV SellISHARES INCmin vol gbl etf$46,924,000
-60.9%
556,496
-62.2%
13.78%
+37.0%
MLPI SellUBS AG JERSEY BRHalerian infrst$40,039,000
-63.0%
1,655,190
-61.6%
11.75%
+29.5%
IVV SellISHARES TRcore s&p500 etf$22,231,000
-38.4%
82,690
-42.0%
6.53%
+115.7%
IUSV SellISHARES TRcore s&p us vlu$19,858,000
-69.4%
358,448
-71.1%
5.83%
+7.2%
SPY SellSPDR S&P 500 ETF TRtr unit$16,953,000
-39.6%
63,527
-43.1%
4.98%
+111.7%
VNQI SellVANGUARD INTL EQUITY INDEX Fglb ex us etf$13,758,000
-64.9%
227,403
-65.5%
4.04%
+22.9%
BRKB SellBERKSHIRE HATHAWAY INC DELcl b new$12,768,000
-39.2%
64,411
-43.8%
3.75%
+112.8%
VNQ SellVANGUARD INDEX FDSreit etf$12,686,000
-65.9%
152,875
-65.9%
3.72%
+19.4%
VOO SellVANGUARD INDEX FDS$12,245,000
-71.9%
49,922
-73.6%
3.60%
-1.6%
VIG SellVANGUARD SPECIALIZED FUNDSdiv app etf$11,544,000
-71.7%
113,138
-73.7%
3.39%
-0.9%
VEU SellVANGUARD INTL EQUITY INDEX Fallwrld ex us$11,539,000
-46.1%
210,869
-48.1%
3.39%
+88.7%
IEMG SellISHARES INCcore msci emkt$10,360,000
-58.2%
182,069
-60.3%
3.04%
+46.3%
IWB SellISHARES TRrus 1000 etf$9,378,000
-47.2%
63,103
-50.3%
2.75%
+84.9%
BND SellVANGUARD BD INDEX FD INCtotal bnd mrkt$9,328,000
-68.6%
114,362
-68.4%
2.74%
+10.1%
CINF SellCINCINNATI FINL CORP$8,539,000
-6.0%
113,900
-4.0%
2.51%
+229.4%
FB SellFACEBOOK INCcl a$7,601,000
-33.3%
43,076
-35.5%
2.23%
+133.4%
EEM SellISHARES TRmsci emg mkt etf$5,613,000
-39.4%
119,115
-42.4%
1.65%
+112.4%
IEFA SellISHARES TRcore msci eafe$4,814,000
-48.7%
72,842
-50.2%
1.41%
+79.8%
IWM SellISHARES TRrussell 2000 etf$4,302,000
-82.8%
28,218
-83.3%
1.26%
-39.7%
VWO SellVANGUARD INTL EQUITY INDEX Fftse emr mkt etf$4,272,000
-49.8%
93,061
-52.3%
1.25%
+75.9%
EEMV SellISHARES INCmin vol emrg mkt$4,267,000
-65.1%
70,231
-66.6%
1.25%
+22.4%
VEA SellVANGUARD TAX MANAGED INTL FDftse dev mkt etf$4,083,000
-88.2%
91,022
-88.6%
1.20%
-58.7%
IWD SellISHARES TRrus 1000 val etf$3,124,000
-69.5%
25,128
-70.9%
0.92%
+6.9%
EFA SellISHARES TRmsci eafe etf$2,831,000
-88.5%
40,267
-88.8%
0.83%
-59.6%
MUB SellISHARES TRnational mun etf$2,555,000
-7.6%
23,073
-7.5%
0.75%
+223.3%
JNJ SellJOHNSON & JOHNSON$2,405,000
-60.7%
17,215
-63.4%
0.71%
+37.6%
EFAV SellISHARES TRmin vol eafe etf$2,107,000
-4.6%
28,871
-7.1%
0.62%
+234.6%
USMV SellISHARES TRmin vol usa etf$1,955,000
-83.8%
37,050
-84.5%
0.57%
-43.2%
AAPL SellAPPLE INC$1,905,000
-90.3%
11,256
-91.2%
0.56%
-66.0%
VCSH SellVANGUARD SCOTTSDALE FDSshrt trm corp bd$1,833,000
-89.6%
23,115
-89.5%
0.54%
-63.6%
IFGL SellISHARES TRintl dev re etf$1,237,000
-59.3%
41,249
-60.4%
0.36%
+42.4%
EFV SellISHARES TReafe value etf$1,175,000
-33.7%
21,292
-34.4%
0.34%
+133.1%
RWX SellSPDR INDEX SHS FDSdj intl rl etf$1,154,000
-94.0%
28,498
-94.3%
0.34%
-79.0%
BSV SellVANGUARD BD INDEX FD INCshort trm bond$1,114,000
-64.9%
14,088
-64.6%
0.33%
+22.9%
SCHZ SellSCHWAB STRATEGIC TRus aggregate b$1,111,000
-81.9%
21,343
-81.8%
0.33%
-36.7%
MMM Sell3M CO$1,003,000
-67.7%
4,261
-71.2%
0.29%
+12.6%
VTI SellVANGUARD INDEX FDStotal stk mkt$828,000
-72.9%
6,031
-74.5%
0.24%
-5.1%
IWR SellISHARES TRrus mid cap etf$769,000
-80.2%
3,695
-81.3%
0.23%
-30.7%
SCHM SellSCHWAB STRATEGIC TRus mid-cap etf$757,000
-91.1%
14,218
-91.7%
0.22%
-69.0%
SCHX SellSCHWAB STRATEGIC TRus lrg cap etf$712,000
-92.3%
11,166
-92.8%
0.21%
-73.1%
CVX SellCHEVRON CORP NEW$701,000
-83.1%
5,597
-84.2%
0.21%
-41.0%
GWX SellSPDR INDEX SHS FDSs&p intl smlcp$685,000
-57.9%
19,295
-58.5%
0.20%
+47.8%
ACWI SellISHARES TRmsci acwi etf$624,000
-97.1%
8,649
-97.2%
0.18%
-89.7%
MSFT SellMICROSOFT CORP$572,000
-83.9%
6,683
-86.0%
0.17%
-43.6%
TOTL SellSSGA ACTIVE ETF TRspdr tr tactic$527,000
-82.5%
10,835
-82.3%
0.16%
-38.5%
GOOGL SellALPHABET INCcap stk cl a$516,000
-90.8%
490
-91.5%
0.15%
-67.8%
PEP SellPEPSICO INC$498,000
-87.2%
4,153
-88.1%
0.15%
-55.1%
VTV SellVANGUARD INDEX FDSvalue etf$485,000
-41.8%
4,560
-45.4%
0.14%
+102.9%
USB SellUS BANCORP DEL$482,000
-90.6%
9,004
-90.5%
0.14%
-67.1%
AMZN SellAMAZON COM INC$462,000
-41.2%
395
-51.7%
0.14%
+106.1%
PG SellPROCTER AND GAMBLE CO$448,000
-93.2%
4,878
-93.3%
0.13%
-76.2%
CMCSA SellCOMCAST CORP NEWcl a$393,000
-85.3%
9,807
-85.9%
0.12%
-48.7%
AMJ SellJPMORGAN CHASE & COalerian ml etn$389,000
-80.2%
14,146
-79.7%
0.11%
-30.9%
VCIT SellVANGUARD SCOTTSDALE FDSint-term corp$384,000
-89.4%
4,397
-89.3%
0.11%
-62.7%
DATA SellTABLEAU SOFTWARE INCcl a$368,000
-35.2%
5,325
-29.8%
0.11%
+125.0%
JPM SellJPMORGAN CHASE & CO$338,000
-91.8%
3,159
-92.7%
0.10%
-71.5%
IWF SellISHARES TRrus 1000 grw etf$329,000
-81.9%
2,446
-83.2%
0.10%
-36.2%
DIS SellDISNEY WALT CO$313,000
-89.7%
2,914
-90.5%
0.09%
-63.8%
IWN SellISHARES TRrus 2000 val etf$299,000
-82.9%
2,378
-83.1%
0.09%
-40.1%
IWV SellISHARES TRrussell 3000 etf$298,000
-91.2%
1,881
-91.7%
0.09%
-69.3%
SCHE SellSCHWAB STRATEGIC TRemrg mkteq etf$297,000
-89.5%
10,648
-89.8%
0.09%
-63.1%
AMGN SellAMGEN INC$288,000
-64.2%
1,654
-61.7%
0.08%
+26.9%
SCHW SellSCHWAB CHARLES CORP NEW$282,000
-88.2%
5,492
-90.0%
0.08%
-58.7%
VGT SellVANGUARD WORLD FDSinf tech etf$281,000
-90.1%
1,706
-90.9%
0.08%
-65.5%
TJX SellTJX COS INC NEW$275,000
-88.4%
3,592
-88.8%
0.08%
-59.3%
DHR SellDANAHER CORP DEL$256,000
-87.7%
2,758
-88.6%
0.08%
-56.9%
VZ SellVERIZON COMMUNICATIONS INC$241,000
-90.6%
4,548
-91.2%
0.07%
-66.8%
RTN SellRAYTHEON CO$228,000
-92.9%
1,214
-93.0%
0.07%
-75.2%
PFE SellPFIZER INC$228,000
-81.4%
6,306
-81.7%
0.07%
-35.0%
NEE SellNEXTERA ENERGY INC$225,000
-86.6%
1,441
-87.5%
0.07%
-53.2%
ABT SellABBOTT LABS$222,000
-89.7%
3,895
-90.4%
0.06%
-64.1%
QCOM SellQUALCOMM INC$222,000
-88.9%
3,461
-91.0%
0.06%
-61.3%
UNP SellUNION PAC CORP$216,000
-92.1%
1,610
-93.1%
0.06%
-72.4%
CVS SellCVS HEALTH CORP$212,000
-89.2%
2,923
-87.9%
0.06%
-62.2%
F SellFORD MTR CO DEL$137,000
+3.0%
11,000
-1.2%
0.04%
+263.6%
ZIXI ExitZIX CORP$0-16,000
-100.0%
0.00%
SPRT ExitSUPPORT COM INC$0-20,649
-100.0%
-0.00%
GMZ ExitGOLDMAN SACHS MLP INC OPP FD$0-10,590
-100.0%
-0.01%
MLPX ExitGLOBAL X FDSglb x mlp enrg i$0-13,025
-100.0%
-0.02%
LQD ExitISHARES TRiboxx inv cp etf$0-1,702
-100.0%
-0.02%
VPU ExitVANGUARD WORLD FDSutilities etf$0-1,759
-100.0%
-0.02%
WMT ExitWAL-MART STORES INC$0-2,608
-100.0%
-0.02%
PFF ExitISHARES TRs&p us pfd stk$0-5,245
-100.0%
-0.02%
PSA ExitPUBLIC STORAGE$0-994
-100.0%
-0.02%
EMN ExitEASTMAN CHEM CO$0-2,364
-100.0%
-0.02%
ED ExitCONSOLIDATED EDISON INC$0-2,602
-100.0%
-0.02%
SCHV ExitSCHWAB STRATEGIC TRus lcap va etf$0-4,413
-100.0%
-0.02%
QQQ ExitPOWERSHARES QQQ TRUSTunit ser 1$0-1,558
-100.0%
-0.02%
IGE ExitISHARES TRnorth amern nat$0-6,737
-100.0%
-0.02%
VBR ExitVANGUARD INDEX FDSsm cp val etf$0-1,776
-100.0%
-0.02%
SCG ExitSCANA CORP NEW$0-4,754
-100.0%
-0.02%
CRM ExitSALESFORCE COM INC$0-2,376
-100.0%
-0.02%
WBA ExitWALGREENS BOOTS ALLIANCE INC$0-3,022
-100.0%
-0.02%
HON ExitHONEYWELL INTL INC$0-1,720
-100.0%
-0.02%
OXY ExitOCCIDENTAL PETE CORP DEL$0-3,932
-100.0%
-0.02%
DVY ExitISHARES TRselect divid etf$0-2,694
-100.0%
-0.02%
NAC ExitNUVEEN CA QUALTY MUN INCOME$0-17,556
-100.0%
-0.02%
PII ExitPOLARIS INDS INC$0-2,529
-100.0%
-0.02%
ES ExitEVERSOURCE ENERGY$0-4,291
-100.0%
-0.02%
WDAY ExitWORKDAY INCcl a$0-2,446
-100.0%
-0.02%
SRE ExitSEMPRA ENERGY$0-2,338
-100.0%
-0.02%
HYMB ExitSPDR SERIES TRUSTnuv hghyld mun$0-4,907
-100.0%
-0.02%
MRO ExitMARATHON OIL CORP$0-20,083
-100.0%
-0.02%
DTV ExitDTE ENERGY COunit 99/99/9999$0-5,000
-100.0%
-0.02%
SDY ExitSPDR SERIES TRUSTs&p divid etf$0-3,019
-100.0%
-0.02%
CAH ExitCARDINAL HEALTH INC$0-4,223
-100.0%
-0.02%
BA ExitBOEING CO$0-1,105
-100.0%
-0.02%
ACN ExitACCENTURE PLC IRELAND$0-2,204
-100.0%
-0.02%
RYH ExitRYDEX ETF TRUSTgug s&p500eqwthc$0-1,733
-100.0%
-0.02%
BDX ExitBECTON DICKINSON & CO$0-1,497
-100.0%
-0.02%
MCD ExitMCDONALDS CORP$0-1,956
-100.0%
-0.03%
EZU ExitISHARES INCmsci eurzone etf$0-7,160
-100.0%
-0.03%
UNH ExitUNITEDHEALTH GROUP INC$0-1,594
-100.0%
-0.03%
VPL ExitVANGUARD INTL EQUITY INDEX Fftse pacific etf$0-4,500
-100.0%
-0.03%
SBUX ExitSTARBUCKS CORP$0-5,817
-100.0%
-0.03%
VDC ExitVANGUARD WORLD FDSconsum stp etf$0-2,365
-100.0%
-0.03%
VREX ExitVAREX IMAGING CORP$0-9,610
-100.0%
-0.03%
COST ExitCOSTCO WHSL CORP NEW$0-2,045
-100.0%
-0.03%
CLX ExitCLOROX CO DEL$0-2,573
-100.0%
-0.03%
TROW ExitPRICE T ROWE GROUP INC$0-3,672
-100.0%
-0.03%
BIV ExitVANGUARD BD INDEX FD INCintermed term$0-4,050
-100.0%
-0.03%
GILD ExitGILEAD SCIENCES INC$0-4,418
-100.0%
-0.03%
V ExitVISA INC$0-3,466
-100.0%
-0.03%
ADBE ExitADOBE SYS INC$0-2,554
-100.0%
-0.03%
ABBV ExitABBVIE INC$0-4,262
-100.0%
-0.03%
VFC ExitV F CORP$0-6,220
-100.0%
-0.03%
PAYX ExitPAYCHEX INC$0-6,466
-100.0%
-0.03%
BAC ExitBANK AMER CORP$0-16,481
-100.0%
-0.04%
SPLV ExitPOWERSHARES ETF TR IIs&p500 low vol$0-9,636
-100.0%
-0.04%
IWP ExitISHARES TRrus md cp gr etf$0-3,925
-100.0%
-0.04%
GPC ExitGENUINE PARTS CO$0-4,779
-100.0%
-0.04%
ILMN ExitILLUMINA INC$0-2,347
-100.0%
-0.04%
VBK ExitVANGUARD INDEX FDSsml cp grw etf$0-3,066
-100.0%
-0.04%
MA ExitMASTERCARD INCORPORATEDcl a$0-3,359
-100.0%
-0.04%
QAI ExitINDEXIQ ETF TRhedge mlti etf$0-16,046
-100.0%
-0.04%
MPC ExitMARATHON PETE CORP$0-8,729
-100.0%
-0.04%
VB ExitVANGUARD INDEX FDSsmall cp etf$0-3,589
-100.0%
-0.04%
SO ExitSOUTHERN CO$0-10,797
-100.0%
-0.04%
PX ExitPRAXAIR INC$0-3,853
-100.0%
-0.04%
DBEU ExitDBX ETF TRdb xtr msci eur$0-18,740
-100.0%
-0.04%
GLD ExitSPDR GOLD TRUST$0-4,843
-100.0%
-0.05%
XLE ExitSELECT SECTOR SPDR TRenergy$0-8,861
-100.0%
-0.05%
NVS ExitNOVARTIS A Gsponsored adr$0-7,058
-100.0%
-0.05%
PSTG ExitPURE STORAGE INCcl a$0-38,748
-100.0%
-0.05%
O ExitREALTY INCOME CORP$0-11,259
-100.0%
-0.05%
BOX ExitBOX INCcl a$0-34,822
-100.0%
-0.06%
CWB ExitSPDR SERIES TRUSTblmbrg brc cnvrt$0-13,859
-100.0%
-0.06%
ESRX ExitEXPRESS SCRIPTS HLDG CO$0-11,465
-100.0%
-0.06%
HD ExitHOME DEPOT INC$0-4,439
-100.0%
-0.06%
AEP ExitAMERICAN ELEC PWR INC$0-10,549
-100.0%
-0.06%
HYG ExitISHARES TRiboxx hi yd etf$0-8,267
-100.0%
-0.06%
MON ExitMONSANTO CO NEW$0-7,180
-100.0%
-0.07%
AGG ExitISHARES TRcore us aggbd et$0-7,874
-100.0%
-0.07%
NKE ExitNIKE INCcl b$0-16,752
-100.0%
-0.07%
DUK ExitDUKE ENERGY CORP NEW$0-10,484
-100.0%
-0.07%
UPS ExitUNITED PARCEL SERVICE INCcl b$0-7,436
-100.0%
-0.08%
EMR ExitEMERSON ELEC CO$0-14,398
-100.0%
-0.08%
PM ExitPHILIP MORRIS INTL INC$0-8,337
-100.0%
-0.08%
IJR ExitISHARES TRcore s&p scp etf$0-12,694
-100.0%
-0.08%
ORCL ExitORACLE CORP$0-19,466
-100.0%
-0.08%
SLB ExitSCHLUMBERGER LTD$0-13,689
-100.0%
-0.08%
IVE ExitISHARES TRs&p 500 val etf$0-8,992
-100.0%
-0.08%
BMY ExitBRISTOL MYERS SQUIBB CO$0-15,340
-100.0%
-0.08%
TD ExitTORONTO DOMINION BK ONT$0-18,319
-100.0%
-0.09%
EOG ExitEOG RES INC$0-11,332
-100.0%
-0.09%
IBM ExitINTERNATIONAL BUSINESS MACHS$0-7,608
-100.0%
-0.09%
AGN ExitALLERGAN PLC$0-5,486
-100.0%
-0.09%
PYPL ExitPAYPAL HLDGS INC$0-17,801
-100.0%
-0.10%
VYM ExitVANGUARD WHITEHALL FDS INChigh div yld$0-14,105
-100.0%
-0.10%
RGI ExitRYDEX ETF TRUSTgug s&p500 eq wt$0-10,268
-100.0%
-0.10%
KO ExitCOCA COLA CO$0-26,726
-100.0%
-0.10%
WFCPRL ExitWELLS FARGO CO NEWperp pfd cnv a$0-925
-100.0%
-0.10%
MGK ExitVANGUARD WORLD FDmega grwth ind$0-11,575
-100.0%
-0.10%
MRK ExitMERCK & CO INC$0-20,341
-100.0%
-0.11%
CELG ExitCELGENE CORP$0-9,014
-100.0%
-0.11%
INTC ExitINTEL CORP$0-36,143
-100.0%
-0.12%
ENB ExitENBRIDGE INC$0-32,872
-100.0%
-0.12%
QEMM ExitSPDR INDEX SHS FDSmsci emrg mkts$0-22,659
-100.0%
-0.12%
T ExitAT&T INC$0-35,208
-100.0%
-0.12%
SCHC ExitSCHWAB STRATEGIC TRintl sceqt etf$0-39,965
-100.0%
-0.12%
CSCO ExitCISCO SYS INC$0-44,586
-100.0%
-0.13%
SCHP ExitSCHWAB STRATEGIC TRus tips etf$0-29,979
-100.0%
-0.14%
XOM ExitEXXON MOBIL CORP$0-22,246
-100.0%
-0.15%
GE ExitGENERAL ELECTRIC CO$0-79,056
-100.0%
-0.16%
VAW ExitVANGUARD WORLD FDSmaterials etf$0-15,840
-100.0%
-0.17%
BBH ExitVANECK VECTORS ETF TRbiotech etf$0-15,903
-100.0%
-0.18%
GOOG ExitALPHABET INCcap stk cl c$0-2,296
-100.0%
-0.18%
WFC ExitWELLS FARGO CO NEW$0-43,402
-100.0%
-0.20%
BRKA ExitBERKSHIRE HATHAWAY INC DELcl a$0-11
-100.0%
-0.25%
ACWX ExitISHARES TRmsci acwi ex us$0-117,717
-100.0%
-0.48%
BNDX ExitVANGUARD CHARLOTTE FDSintl bd idx etf$0-106,832
-100.0%
-0.49%
RY ExitROYAL BK CDA MONTREAL QUE$0-77,000
-100.0%
-0.50%
IGSB ExitISHARES TR1 3 yr cr bd etf$0-63,188
-100.0%
-0.56%
VV ExitVANGUARD INDEX FDSlarge cap etf$0-71,533
-100.0%
-0.69%
VTIP ExitVANGUARD MALVERN FDSstrm infproidx$0-171,440
-100.0%
-0.71%
XLF ExitSELECT SECTOR SPDR TRsbi int-finl$0-652,605
-100.0%
-1.42%
IYR ExitISHARES TRu.s. real es etf$0-411,646
-100.0%
-2.76%
Original filings

The following EDGAR filing(s) were analyzed to create this report:

  • View 13F-HR filed 2018-01-31
Signatures

The EDGAR filing(s) were signed by:

Top long-term holdings
NameQuarters ownedLatest quarter ownedMax weighting
ISHARES TR42Q3 202311.5%
ISHARES TR42Q3 202318.1%
SPDR S&P 500 ETF TR42Q3 202312.0%
BERKSHIRE HATHAWAY INC DEL42Q3 20238.3%
VANGUARD INTL EQUITY INDEX F42Q3 20236.7%
ISHARES TR42Q3 20232.8%
ISHARES TR42Q3 20234.4%
VANGUARD INDEX FDS42Q3 20234.2%
VANGUARD INTL EQUITY INDEX F42Q3 20233.6%
ISHARES TR42Q3 20232.1%

View ASPIRIANT, LLC's complete holdings history.

Latest filings
TypeFiled
13F-HR2024-04-15
13F-HR2024-01-26
13F-HR2023-10-18
13F-HR2023-07-19
13F-HR2023-04-27
13F-HR2023-01-23
13F-HR2022-10-28
13F-HR2022-07-25
13F-HR2022-05-06
13F-HR2022-02-14

View ASPIRIANT, LLC's complete filings history.

Compare quarters

Export ASPIRIANT, LLC's holdings