$867 Million is the total value of RAND WEALTH, LLC's 220 reported holdings in Q3 2017. The portfolio turnover from Q2 2017 to Q3 2017 was 8.0% .
| Value | Shares | ↓ Weighting | ||||||
|---|---|---|---|---|---|---|---|---|
| AGG | New | ISHARES TRcore us aggbd et | $59,837,000 | – | 546,009 | +100.0% | 6.90% | – |
| BSV | New | VANGUARD BD INDEX FD INCshort trm bond | $30,795,000 | – | 385,804 | +100.0% | 3.55% | – |
| SPSB | Buy | SPDR SERIES TRUSTblomberg brc srt | $28,836,000 | +7.9% | 940,206 | +7.8% | 3.33% | -8.1% |
| VSS | Buy | VANGUARD INTL EQUITY INDEX Fftse smcap etf | $23,163,000 | +6.4% | 201,542 | +0.1% | 2.67% | -9.4% |
| VGT | Sell | VANGUARD WORLD FDSinf tech etf | $22,094,000 | +6.2% | 145,365 | -1.6% | 2.55% | -9.6% |
| WFC | Sell | WELLS FARGO CO NEW | $21,754,000 | -0.9% | 394,452 | -0.5% | 2.51% | -15.7% |
| VEU | Sell | VANGUARD INTL EQUITY INDEX Fallwrld ex us | $21,319,000 | +5.1% | 404,459 | -0.3% | 2.46% | -10.5% |
| VFH | Sell | VANGUARD WORLD FDSfinancials etf | $20,070,000 | +4.2% | 307,070 | -0.3% | 2.32% | -11.3% |
| CVX | Sell | CHEVRON CORP NEW | $17,498,000 | +12.6% | 148,915 | -0.0% | 2.02% | -4.2% |
| JNJ | Sell | JOHNSON & JOHNSON | $15,926,000 | -3.0% | 122,501 | -1.3% | 1.84% | -17.4% |
| VO | Sell | VANGUARD INDEX FDSmid cap etf | $15,303,000 | +3.1% | 104,099 | -0.0% | 1.76% | -12.2% |
| AMLP | Buy | ALPS ETF TRalerian mlp | $14,280,000 | -4.7% | 1,272,693 | +1.5% | 1.65% | -18.9% |
| BND | Buy | VANGUARD BD INDEX FD INCtotal bnd mrkt | $13,521,000 | +5.5% | 164,970 | +5.3% | 1.56% | -10.2% |
| UTX | Sell | UNITED TECHNOLOGIES CORP | $12,868,000 | -5.0% | 110,853 | -0.0% | 1.48% | -19.1% |
| PG | Sell | PROCTER AND GAMBLE CO | $12,010,000 | +3.7% | 132,010 | -0.7% | 1.38% | -11.7% |
| AAPL | Sell | APPLE INC | $11,296,000 | +4.4% | 73,294 | -2.4% | 1.30% | -11.1% |
| VIS | Sell | VANGUARD WORLD FDSindustrial etf | $11,116,000 | +3.6% | 82,797 | -0.9% | 1.28% | -11.8% |
| GE | Buy | GENERAL ELECTRIC CO | $11,083,000 | -9.4% | 458,362 | +1.2% | 1.28% | -22.9% |
| EDIV | Buy | SPDR INDEX SHS FDSs&p em mkt div | $10,994,000 | +3.6% | 360,922 | +1.5% | 1.27% | -11.8% |
| INTC | Sell | INTEL CORP | $10,901,000 | +12.3% | 286,272 | -0.5% | 1.26% | -4.4% |
| JPM | Sell | JPMORGAN CHASE & CO | $10,828,000 | +3.0% | 113,368 | -1.4% | 1.25% | -12.3% |
| VWO | Buy | VANGUARD INTL EQUITY INDEX Fftse emr mkt etf | $10,802,000 | +6.9% | 247,921 | +0.2% | 1.25% | -9.0% |
| SCHZ | New | SCHWAB STRATEGIC TRus aggregate b | $9,677,000 | – | 184,816 | +100.0% | 1.12% | – |
| VHT | Sell | VANGUARD WORLD FDShealth car etf | $9,101,000 | +1.8% | 59,763 | -1.5% | 1.05% | -13.3% |
| V | Sell | VISA INC | $8,915,000 | +12.0% | 84,708 | -0.2% | 1.03% | -4.6% |
| VB | Sell | VANGUARD INDEX FDSsmall cp etf | $8,895,000 | +3.7% | 62,944 | -0.5% | 1.03% | -11.7% |
| PFE | Buy | PFIZER INC | $8,645,000 | +6.7% | 242,150 | +0.4% | 1.00% | -9.1% |
| VZ | Buy | VERIZON COMMUNICATIONS INC | $8,640,000 | +12.7% | 174,578 | +1.7% | 1.00% | -4.1% |
| T | Buy | AT&T INC | $8,099,000 | +5.0% | 206,766 | +1.2% | 0.93% | -10.6% |
| CSCO | Sell | CISCO SYS INC | $8,051,000 | +7.3% | 239,391 | -0.1% | 0.93% | -8.6% |
| VDE | Buy | VANGUARD WORLD FDSenergy etf | $7,956,000 | +7.0% | 85,020 | +1.2% | 0.92% | -8.9% |
| CAT | Sell | CATERPILLAR INC DEL | $7,864,000 | +8.1% | 63,059 | -6.9% | 0.91% | -8.0% |
| ADP | Sell | AUTOMATIC DATA PROCESSING IN | $7,779,000 | +3.4% | 71,158 | -3.1% | 0.90% | -12.1% |
| VDC | Buy | VANGUARD WORLD FDSconsum stp etf | $7,669,000 | -1.7% | 55,347 | +0.1% | 0.88% | -16.3% |
| APD | Buy | AIR PRODS & CHEMS INC | $7,378,000 | +11.6% | 48,790 | +5.6% | 0.85% | -5.0% |
| XOM | Buy | EXXON MOBIL CORP | $7,088,000 | +4.8% | 86,465 | +3.2% | 0.82% | -10.8% |
| USB | Sell | US BANCORP DEL | $6,763,000 | +2.8% | 126,196 | -0.4% | 0.78% | -12.5% |
| VCR | Sell | VANGUARD WORLD FDSconsum dis etf | $6,741,000 | +0.5% | 47,029 | -0.4% | 0.78% | -14.4% |
| MSFT | Buy | MICROSOFT CORP | $6,672,000 | +9.7% | 89,565 | +1.5% | 0.77% | -6.6% |
| BRKB | Sell | BERKSHIRE HATHAWAY INC DELcl b new | $6,377,000 | +0.5% | 34,784 | -7.2% | 0.74% | -14.5% |
| WBA | Sell | WALGREENS BOOTS ALLIANCE INC | $6,265,000 | -2.5% | 81,131 | -1.1% | 0.72% | -16.9% |
| FLOT | Sell | ISHARES TRfltg rate nt etf | $6,261,000 | -6.9% | 122,914 | -6.9% | 0.72% | -20.7% |
| BA | Sell | BOEING CO | $5,757,000 | +26.5% | 22,646 | -1.6% | 0.66% | +7.6% |
| CMCSA | Sell | COMCAST CORP NEWcl a | $5,748,000 | -1.9% | 149,365 | -0.7% | 0.66% | -16.5% |
| IEFA | Sell | ISHARES TRcore msci eafe | $5,738,000 | +2.9% | 89,416 | -2.3% | 0.66% | -12.3% |
| PEP | Buy | PEPSICO INC | $5,578,000 | -2.9% | 50,055 | +0.6% | 0.64% | -17.4% |
| FNCL | Sell | FIDELITYmsci finls idx | $5,451,000 | +4.1% | 143,566 | -0.4% | 0.63% | -11.4% |
| NVS | Buy | NOVARTIS A Gsponsored adr | $5,383,000 | +3.1% | 62,707 | +0.3% | 0.62% | -12.2% |
| PM | Sell | PHILIP MORRIS INTL INC | $5,342,000 | -5.7% | 48,119 | -0.3% | 0.62% | -19.8% |
| ANET | Buy | ARISTA NETWORKS INC | $5,285,000 | +32.4% | 27,872 | +4.5% | 0.61% | +12.8% |
| FTEC | Sell | FIDELITYmsci info tech i | $5,248,000 | +6.4% | 113,702 | -1.5% | 0.60% | -9.4% |
| MMM | 3M CO | $5,187,000 | +0.8% | 24,713 | 0.0% | 0.60% | -14.2% | |
| DUK | Sell | DUKE ENERGY CORP NEW | $4,763,000 | -0.9% | 56,752 | -1.3% | 0.55% | -15.7% |
| O | Buy | REALTY INCOME CORP | $4,727,000 | +4.6% | 82,656 | +1.0% | 0.54% | -10.9% |
| LQD | New | ISHARES TRiboxx inv cp etf | $4,659,000 | – | 38,428 | +100.0% | 0.54% | – |
| VYM | Buy | VANGUARD WHITEHALL FDS INChigh div yld | $4,554,000 | +3.9% | 56,175 | +0.1% | 0.52% | -11.6% |
| TMO | Sell | THERMO FISHER SCIENTIFIC INC | $4,472,000 | +7.8% | 23,639 | -0.6% | 0.52% | -8.2% |
| XBI | Sell | SPDR SERIES TRUSTs&p biotech | $4,203,000 | +10.8% | 48,553 | -1.2% | 0.48% | -5.6% |
| COST | Buy | COSTCO WHSL CORP NEW | $4,128,000 | +7.1% | 25,129 | +4.3% | 0.48% | -8.8% |
| FDX | Buy | FEDEX CORP | $4,056,000 | +4.2% | 17,981 | +0.4% | 0.47% | -11.2% |
| MO | Buy | ALTRIA GROUP INC | $4,046,000 | -10.7% | 63,804 | +4.8% | 0.47% | -23.9% |
| ABBV | Sell | ABBVIE INC | $4,027,000 | +22.1% | 45,314 | -0.4% | 0.46% | +3.8% |
| FENY | Sell | FIDELITYmsci energy idx | $4,011,000 | +0.7% | 211,662 | -4.5% | 0.46% | -14.3% |
| IDV | Buy | ISHARES TRintl sel div etf | $3,884,000 | +3.2% | 115,053 | +0.1% | 0.45% | -12.2% |
| IBM | Sell | INTERNATIONAL BUSINESS MACHS | $3,821,000 | -7.5% | 26,337 | -2.0% | 0.44% | -21.2% |
| BAC | BANK AMER CORP | $3,753,000 | +4.4% | 148,125 | 0.0% | 0.43% | -11.1% | |
| YUM | YUM BRANDS INC | $3,679,000 | -0.2% | 49,986 | 0.0% | 0.42% | -15.2% | |
| IEMG | Sell | ISHARES INCcore msci emkt | $3,677,000 | +7.0% | 68,065 | -0.9% | 0.42% | -9.0% |
| ABT | Sell | ABBOTT LABS | $3,663,000 | +8.8% | 68,653 | -0.9% | 0.42% | -7.5% |
| HYS | PIMCO ETF TR0-5 high yield | $3,579,000 | +0.2% | 35,247 | 0.0% | 0.41% | -14.7% | |
| IEZ | Buy | ISHARES TRus oil eq&sv etf | $3,523,000 | +8.7% | 99,662 | +3.8% | 0.41% | -7.5% |
| SCHF | Buy | SCHWAB STRATEGIC TRintl eqty etf | $3,488,000 | +5.4% | 104,223 | +0.1% | 0.40% | -10.3% |
| VAW | Sell | VANGUARD WORLD FDSmaterials etf | $3,479,000 | +5.0% | 27,068 | -0.6% | 0.40% | -10.7% |
| IJH | Buy | ISHARES TRcore s&p mcp etf | $3,463,000 | +3.5% | 19,359 | +0.6% | 0.40% | -11.9% |
| SAP | SAP SEspon adr | $3,407,000 | +4.8% | 31,069 | 0.0% | 0.39% | -10.9% | |
| VNQ | Buy | VANGUARD INDEX FDSreit etf | $3,271,000 | +0.9% | 39,370 | +1.0% | 0.38% | -14.1% |
| MCD | Sell | MCDONALDS CORP | $3,264,000 | +0.1% | 20,835 | -2.1% | 0.38% | -14.9% |
| AXP | AMERICAN EXPRESS CO | $2,953,000 | +7.4% | 32,646 | 0.0% | 0.34% | -8.6% | |
| FIDU | Sell | FIDELITYmsci indl indx | $2,919,000 | +3.8% | 79,892 | -1.2% | 0.34% | -11.5% |
| DON | Sell | WISDOMTREE TRus midcap divid | $2,886,000 | +1.5% | 28,875 | -0.7% | 0.33% | -13.5% |
| GOOG | Buy | ALPHABET INCcap stk cl c | $2,840,000 | +11.3% | 2,961 | +5.5% | 0.33% | -5.2% |
| CVS | Sell | CVS HEALTH CORP | $2,848,000 | -0.5% | 35,028 | -1.6% | 0.33% | -15.5% |
| BK | BANK NEW YORK MELLON CORP | $2,784,000 | +3.9% | 52,511 | 0.0% | 0.32% | -11.6% | |
| SCHE | Buy | SCHWAB STRATEGIC TRemrg mkteq etf | $2,773,000 | +8.4% | 103,061 | +0.2% | 0.32% | -7.5% |
| CLX | CLOROX CO DEL | $2,650,000 | -1.0% | 20,092 | 0.0% | 0.31% | -15.7% | |
| ITW | Sell | ILLINOIS TOOL WKS INC | $2,585,000 | +2.1% | 17,469 | -1.1% | 0.30% | -13.1% |
| DES | Sell | WISDOMTREE TRus smallcap divd | $2,576,000 | +3.9% | 30,656 | -0.5% | 0.30% | -11.6% |
| DVYE | Buy | ISHARES INCem mkts div etf | $2,533,000 | +5.5% | 61,094 | +2.3% | 0.29% | -10.2% |
| HD | HOME DEPOT INC | $2,530,000 | +6.7% | 15,466 | 0.0% | 0.29% | -9.0% | |
| BRKA | BERKSHIRE HATHAWAY INC DELcl a | $2,473,000 | +7.9% | 9 | 0.0% | 0.28% | -8.4% | |
| TTE | Sell | TOTAL S Asponsored adr | $2,455,000 | +6.0% | 45,873 | -1.7% | 0.28% | -9.9% |
| AMZN | Buy | AMAZON COM INC | $2,313,000 | +3.1% | 2,406 | +3.8% | 0.27% | -12.2% |
| FHLC | Sell | FIDELITYmsci hlth care i | $2,276,000 | +1.4% | 57,584 | -1.7% | 0.26% | -13.5% |
| GOOGL | Sell | ALPHABET INCcap stk cl a | $2,248,000 | -0.8% | 2,309 | -5.3% | 0.26% | -15.6% |
| LEG | Buy | LEGGETT & PLATT INC | $2,232,000 | -9.0% | 46,757 | +0.1% | 0.26% | -22.6% |
| MON | MONSANTO CO NEW | $2,210,000 | +1.2% | 18,445 | 0.0% | 0.26% | -13.9% | |
| SBUX | Buy | STARBUCKS CORP | $2,205,000 | -5.0% | 41,046 | +3.2% | 0.25% | -19.1% |
| GIS | Sell | GENERAL MLS INC | $2,190,000 | -14.3% | 42,319 | -8.2% | 0.25% | -26.9% |
| UNH | UNITEDHEALTH GROUP INC | $2,163,000 | +5.7% | 11,042 | 0.0% | 0.25% | -10.1% | |
| BDX | BECTON DICKINSON & CO | $2,157,000 | +0.4% | 11,009 | 0.0% | 0.25% | -14.4% | |
| IBB | ISHARES TRnasdaq biotech | $2,114,000 | +7.6% | 6,336 | 0.0% | 0.24% | -8.3% | |
| IJR | Sell | ISHARES TRcore s&p scp etf | $2,047,000 | +5.8% | 27,579 | -0.0% | 0.24% | -9.9% |
| YUMC | YUM CHINA HLDGS INC | $2,046,000 | +1.3% | 51,195 | 0.0% | 0.24% | -13.9% | |
| FSTA | Sell | FIDELITYconsmr staples | $1,925,000 | -2.5% | 59,379 | -0.6% | 0.22% | -16.9% |
| MCK | Sell | MCKESSON CORP | $1,917,000 | -10.0% | 12,477 | -3.6% | 0.22% | -23.3% |
| EMR | EMERSON ELEC CO | $1,895,000 | +5.5% | 30,148 | 0.0% | 0.22% | -9.9% | |
| COP | Sell | CONOCOPHILLIPS | $1,883,000 | +13.8% | 37,613 | -0.1% | 0.22% | -3.1% |
| EMLP | Sell | FIRST TR EXCHANGE TRADED FDno amer energy | $1,871,000 | +0.6% | 75,440 | -0.4% | 0.22% | -14.3% |
| IR | INGERSOLL-RAND PLC | $1,850,000 | -2.4% | 20,748 | 0.0% | 0.21% | -17.1% | |
| VRSN | VERISIGN INC | $1,820,000 | +14.5% | 17,107 | 0.0% | 0.21% | -2.3% | |
| SYK | Sell | STRYKER CORP | $1,824,000 | +0.8% | 12,843 | -1.5% | 0.21% | -14.3% |
| SPY | SPDR S&P 500 ETF TRtr unit | $1,757,000 | +3.9% | 6,994 | 0.0% | 0.20% | -11.4% | |
| FDIS | Sell | FIDELITYmsci consm dis | $1,728,000 | -0.6% | 48,197 | -1.6% | 0.20% | -15.3% |
| DGX | QUEST DIAGNOSTICS INC | $1,706,000 | -15.8% | 18,223 | 0.0% | 0.20% | -28.1% | |
| GM | Sell | GENERAL MTRS CO | $1,679,000 | +13.4% | 41,570 | -1.9% | 0.19% | -3.5% |
| NOV | Sell | NATIONAL OILWELL VARCO INC | $1,666,000 | +5.0% | 46,635 | -3.1% | 0.19% | -10.7% |
| BCE | BCE INC | $1,661,000 | +3.9% | 35,475 | 0.0% | 0.19% | -11.5% | |
| KO | COCA COLA CO | $1,589,000 | +0.3% | 35,309 | 0.0% | 0.18% | -14.9% | |
| ZBH | Sell | ZIMMER BIOMET HLDGS INC | $1,532,000 | -9.0% | 13,083 | -0.2% | 0.18% | -22.4% |
| ALL | ALLSTATE CORP | $1,512,000 | +3.9% | 16,450 | 0.0% | 0.17% | -11.7% | |
| ORCL | Sell | ORACLE CORP | $1,489,000 | -14.7% | 30,804 | -11.5% | 0.17% | -27.1% |
| HAIN | HAIN CELESTIAL GROUP INC | $1,452,000 | +6.0% | 35,294 | 0.0% | 0.17% | -10.2% | |
| GILD | Sell | GILEAD SCIENCES INC | $1,400,000 | -3.1% | 17,281 | -15.4% | 0.16% | -17.9% |
| CTSH | Sell | COGNIZANT TECHNOLOGY SOLUTIOcl a | $1,310,000 | +3.0% | 18,062 | -5.7% | 0.15% | -12.2% |
| BMY | Sell | BRISTOL MYERS SQUIBB CO | $1,305,000 | +11.1% | 20,477 | -2.9% | 0.15% | -5.0% |
| SHW | SHERWIN WILLIAMS CO | $1,298,000 | +2.0% | 3,625 | 0.0% | 0.15% | -12.8% | |
| AZO | AUTOZONE INC | $1,224,000 | +4.3% | 2,057 | 0.0% | 0.14% | -11.3% | |
| RDSA | Buy | ROYAL DUTCH SHELL PLCspons adr a | $1,210,000 | +15.6% | 19,979 | +1.5% | 0.14% | -1.4% |
| TGT | Sell | TARGET CORP | $1,210,000 | +3.6% | 20,497 | -8.3% | 0.14% | -11.4% |
| TXN | TEXAS INSTRS INC | $1,192,000 | +16.5% | 13,301 | 0.0% | 0.14% | -1.4% | |
| INTU | INTUIT | $1,126,000 | +7.0% | 7,920 | 0.0% | 0.13% | -9.1% | |
| MDLZ | Sell | MONDELEZ INTL INCcl a | $1,114,000 | -7.7% | 27,400 | -1.9% | 0.13% | -22.0% |
| KSS | Sell | KOHLS CORP | $1,093,000 | +15.7% | 23,938 | -2.0% | 0.13% | -1.6% |
| IWF | ISHARES TRrus 1000 grw etf | $1,069,000 | +5.1% | 8,547 | 0.0% | 0.12% | -10.9% | |
| IWR | ISHARES TRrus mid cap etf | $1,041,000 | +2.7% | 5,278 | 0.0% | 0.12% | -12.4% | |
| AAP | Sell | ADVANCE AUTO PARTS INC | $1,031,000 | -20.0% | 10,395 | -5.9% | 0.12% | -32.0% |
| ISTB | Buy | ISHARES TRcore 1 5 yr usd | $1,005,000 | +1.7% | 19,987 | +1.6% | 0.12% | -13.4% |
| KMB | Sell | KIMBERLY CLARK CORP | $988,000 | -9.9% | 8,392 | -1.2% | 0.11% | -23.5% |
| EWX | Sell | SPDR INDEX SHS FDSs&p emktsc etf | $959,000 | 0.0% | 19,360 | -5.8% | 0.11% | -14.6% |
| UNP | Sell | UNION PAC CORP | $963,000 | +1.9% | 8,308 | -4.3% | 0.11% | -13.3% |
| CB | CHUBB LIMITED | $920,000 | -1.9% | 6,455 | 0.0% | 0.11% | -16.5% | |
| FREL | Buy | FIDELITYmsci rl est etf | $908,000 | +1.7% | 37,440 | +1.5% | 0.10% | -13.2% |
| HPQ | Sell | HP INC | $899,000 | +12.0% | 45,039 | -2.0% | 0.10% | -4.6% |
| ANTM | ANTHEM INC | $884,000 | +0.9% | 4,655 | 0.0% | 0.10% | -14.3% | |
| FMAT | Sell | FIDELITYmsci matls index | $861,000 | +4.0% | 26,078 | -1.6% | 0.10% | -11.6% |
| CL | Sell | COLGATE PALMOLIVE CO | $839,000 | -2.7% | 11,522 | -0.9% | 0.10% | -17.1% |
| GWW | Sell | GRAINGER W W INC | $827,000 | -10.2% | 4,600 | -9.8% | 0.10% | -24.0% |
| CPB | CAMPBELL SOUP CO | $796,000 | -10.3% | 17,000 | 0.0% | 0.09% | -23.3% | |
| HCP | HCP INC | $787,000 | -12.9% | 28,292 | 0.0% | 0.09% | -25.4% | |
| APC | Sell | ANADARKO PETE CORP | $780,000 | +0.4% | 15,970 | -6.9% | 0.09% | -14.3% |
| AFL | Sell | AFLAC INC | $781,000 | +3.9% | 9,601 | -0.8% | 0.09% | -11.8% |
| CHD | CHURCH & DWIGHT INC | $775,000 | -6.6% | 16,000 | 0.0% | 0.09% | -20.5% | |
| LLY | LILLY ELI & CO | $719,000 | +4.1% | 8,400 | 0.0% | 0.08% | -11.7% | |
| DVY | Buy | ISHARES TRselect divid etf | $720,000 | +14.6% | 7,686 | +12.9% | 0.08% | -2.4% |
| DIS | Sell | DISNEY WALT CO | $707,000 | -8.1% | 7,176 | -0.8% | 0.08% | -21.2% |
| HPE | HEWLETT PACKARD ENTERPRISE C | $686,000 | -11.4% | 46,668 | 0.0% | 0.08% | -24.8% | |
| VTI | Buy | VANGUARD INDEX FDStotal stk mkt | $667,000 | +16.8% | 5,149 | +12.2% | 0.08% | 0.0% |
| IYW | Sell | ISHARES TRu.s. tech etf | $634,000 | +4.8% | 4,227 | -2.3% | 0.07% | -11.0% |
| EXPD | Sell | EXPEDITORS INTL WASH INC | $627,000 | +1.1% | 10,480 | -4.6% | 0.07% | -14.3% |
| KHC | Sell | KRAFT HEINZ CO | $594,000 | -11.3% | 7,660 | -2.1% | 0.07% | -24.2% |
| SUB | New | ISHARES TRshrt nat mun etf | $586,000 | – | 5,534 | +100.0% | 0.07% | – |
| LMT | LOCKHEED MARTIN CORP | $585,000 | +11.9% | 1,884 | 0.0% | 0.07% | -5.6% | |
| SCHW | SCHWAB CHARLES CORP NEW | $580,000 | +1.8% | 13,257 | 0.0% | 0.07% | -13.0% | |
| ALLE | ALLEGION PUB LTD CO | $583,000 | +6.6% | 6,748 | 0.0% | 0.07% | -9.5% | |
| IWD | ISHARES TRrus 1000 val etf | $570,000 | +1.8% | 4,807 | 0.0% | 0.07% | -13.2% | |
| TIP | New | ISHARES TRtips bd etf | $571,000 | – | 5,025 | +100.0% | 0.07% | – |
| SJNK | New | SPDR SER TRbloomberg srt tr | $576,000 | – | 20,580 | +100.0% | 0.07% | – |
| IWM | ISHARES TRrussell 2000 etf | $567,000 | +5.2% | 3,826 | 0.0% | 0.06% | -11.0% | |
| DE | DEERE & CO | $556,000 | +1.6% | 4,429 | 0.0% | 0.06% | -13.5% | |
| SPGI | Buy | S&P GLOBAL INC | $557,000 | +10.5% | 3,565 | +3.3% | 0.06% | -5.9% |
| J | Sell | JACOBS ENGR GROUP INC DEL | $514,000 | +2.4% | 8,824 | -4.3% | 0.06% | -13.2% |
| SYY | Sell | SYSCO CORP | $505,000 | -3.1% | 9,354 | -9.7% | 0.06% | -18.3% |
| CMF | Buy | ISHARES TRcalif mun bd etf | $475,000 | +27.7% | 4,011 | +26.9% | 0.06% | +10.0% |
| AWK | Buy | AMERICAN WTR WKS CO INC NEW | $460,000 | +3.8% | 5,690 | +0.2% | 0.05% | -11.7% |
| QCOM | Sell | QUALCOMM INC | $459,000 | -20.2% | 8,857 | -14.9% | 0.05% | -32.1% |
| XLE | SELECT SECTOR SPDR TRenergy | $452,000 | +5.6% | 6,597 | 0.0% | 0.05% | -10.3% | |
| MUB | New | ISHARES TRnational mun etf | $441,000 | – | 3,975 | +100.0% | 0.05% | – |
| BEN | FRANKLIN RES INC | $440,000 | -0.5% | 9,875 | 0.0% | 0.05% | -15.0% | |
| HDV | Sell | ISHARES TRcore high dv etf | $414,000 | -12.1% | 4,814 | -15.0% | 0.05% | -25.0% |
| HYG | New | ISHARES TRiboxx hi yd etf | $411,000 | – | 4,631 | +100.0% | 0.05% | – |
| IYJ | ISHARES TRus industrials | $382,000 | +5.2% | 2,760 | 0.0% | 0.04% | -10.2% | |
| AMGN | AMGEN INC | $380,000 | +8.3% | 2,040 | 0.0% | 0.04% | -8.3% | |
| FAST | Sell | FASTENAL CO | $376,000 | -6.7% | 8,240 | -10.9% | 0.04% | -21.8% |
| BAX | BAXTER INTL INC | $364,000 | +3.7% | 5,800 | 0.0% | 0.04% | -12.5% | |
| XLF | SELECT SECTOR SPDR TRsbi int-finl | $351,000 | +4.8% | 13,588 | 0.0% | 0.04% | -11.1% | |
| DXC | DXC TECHNOLOGY CO | $336,000 | +11.6% | 3,917 | 0.0% | 0.04% | -4.9% | |
| GLW | CORNING INC | $341,000 | -0.6% | 11,400 | 0.0% | 0.04% | -15.2% | |
| PDCO | PATTERSON COMPANIES INC | $339,000 | -17.5% | 8,760 | 0.0% | 0.04% | -30.4% | |
| PGX | New | POWERSHARES ETF TR IIpfd portfolio | $327,000 | – | 21,785 | +100.0% | 0.04% | – |
| HON | HONEYWELL INTL INC | $325,000 | +6.2% | 2,296 | 0.0% | 0.04% | -9.8% | |
| IYH | ISHARES TRus hlthcare etf | $318,000 | +3.2% | 1,852 | 0.0% | 0.04% | -11.9% | |
| IEI | ISHARES TR3 7 yr treas bd | $313,000 | 0.0% | 2,536 | 0.0% | 0.04% | -14.3% | |
| MRK | Buy | MERCK & CO INC | $301,000 | +4.5% | 4,695 | +4.4% | 0.04% | -10.3% |
| BP | BP PLCsponsored adr | $294,000 | +10.5% | 7,663 | 0.0% | 0.03% | -5.6% | |
| PAYX | PAYCHEX INC | $282,000 | +5.6% | 4,695 | 0.0% | 0.03% | -8.3% | |
| FGD | FIRST TR EXCHANGE TRADED FDdj glbl divid | $283,000 | +3.3% | 10,956 | 0.0% | 0.03% | -10.8% | |
| WMT | Buy | WAL-MART STORES INC | $283,000 | +37.4% | 3,621 | +33.1% | 0.03% | +17.9% |
| VT | Buy | VANGUARD INTL EQUITY INDEX Ftt wrld st etf | $277,000 | +26.5% | 3,916 | +21.0% | 0.03% | +6.7% |
| AEP | AMERICAN ELEC PWR INC | $266,000 | +1.1% | 3,780 | 0.0% | 0.03% | -13.9% | |
| CENTA | Sell | CENTRAL GARDEN & PET COcl a non-vtg | $267,000 | +16.6% | 7,180 | -5.9% | 0.03% | 0.0% |
| SCZ | Sell | ISHARES TReafe sml cp etf | $261,000 | +6.1% | 4,217 | -1.0% | 0.03% | -9.1% |
| SLB | Sell | SCHLUMBERGER LTD | $253,000 | -9.6% | 3,626 | -14.6% | 0.03% | -23.7% |
| NEE | NEXTERA ENERGY INC | $244,000 | +4.7% | 1,664 | 0.0% | 0.03% | -12.5% | |
| EMB | New | ISHARES TRjpmorgan usd emg | $234,000 | – | 2,009 | +100.0% | 0.03% | – |
| OMC | OMNICOM GROUP INC | $238,000 | -10.5% | 3,207 | 0.0% | 0.03% | -25.0% | |
| VCIT | VANGUARD SCOTTSDALE FDSint-term corp | $234,000 | +0.4% | 2,660 | 0.0% | 0.03% | -15.6% | |
| GSK | Buy | GLAXOSMITHKLINE PLCsponsored adr | $229,000 | -4.2% | 5,650 | +1.8% | 0.03% | -18.8% |
| VEA | VANGUARD TAX MANAGED INTL FDftse dev mkt etf | $218,000 | +4.8% | 5,024 | 0.0% | 0.02% | -10.7% | |
| DOL | Buy | WISDOMTREE TRintl lrgcap dv | $218,000 | +6.3% | 4,412 | +1.7% | 0.02% | -10.7% |
| APA | Sell | APACHE CORP | $213,000 | -19.0% | 4,650 | -15.4% | 0.02% | -30.6% |
| AIG | AMERICAN INTL GROUP INC | $215,000 | -1.8% | 3,500 | 0.0% | 0.02% | -16.7% | |
| SO | Buy | SOUTHERN CO | $215,000 | +7.0% | 4,380 | +4.2% | 0.02% | -7.4% |
| PSX | New | PHILLIPS 66 | $209,000 | – | 2,277 | +100.0% | 0.02% | – |
| IVW | Sell | ISHARES TRs&p 500 grwt etf | $200,000 | -2.4% | 1,397 | -6.7% | 0.02% | -17.9% |
| FCX | FREEPORT-MCMORAN INCcl b | $196,000 | +17.4% | 13,925 | 0.0% | 0.02% | 0.0% | |
| MDT | Sell | MEDTRONIC PLC | $201,000 | -13.4% | 2,585 | -1.0% | 0.02% | -25.8% |
| F | Sell | FORD MTR CO DEL | $171,000 | +1.2% | 14,300 | -5.4% | 0.02% | -13.0% |
| PCTI | PC-TEL INC | $163,000 | -10.9% | 25,839 | 0.0% | 0.02% | -24.0% | |
| NAC | NUVEEN CA QUALTY MUN INCOME | $158,000 | -1.2% | 10,612 | 0.0% | 0.02% | -18.2% | |
| RBS | ROYAL BK SCOTLAND GROUP PLCspons adr 2 ord | $109,000 | +11.2% | 15,000 | 0.0% | 0.01% | 0.0% | |
| BCS | Exit | BARCLAYS PLCadr | $0 | – | -10,250 | -100.0% | -0.02% | – |
| EEMS | Exit | ISHARESem mkt sm-cp etf | $0 | – | -4,744 | -100.0% | -0.03% | – |
| RAI | Exit | REYNOLDS AMERICAN INC | $0 | – | -4,046 | -100.0% | -0.04% | – |
| SPLS | Exit | STAPLES INC | $0 | – | -38,075 | -100.0% | -0.05% | – |
| DD | Exit | DU PONT E I DE NEMOURS & CO | $0 | – | -43,270 | -100.0% | -0.47% | – |
Original filings
The following EDGAR filing(s) were analyzed to create this report:
- View 13F-HR filed 2017-10-23
Top long-term holdings
| Name | Quarters owned | Latest quarter owned | Max weighting |
|---|---|---|---|
| VANGUARD INTL EQUITY INDEX F | 22 | Q3 2018 | 4.2% |
| WELLS FARGO & CO NEW COM | 22 | Q3 2018 | 3.5% |
| VANGUARD WORLD FDS | 22 | Q3 2018 | 3.4% |
| VANGUARD WORLD FDS | 22 | Q3 2018 | 3.1% |
| CHEVRON CORP NEW COM | 22 | Q3 2018 | 3.7% |
| JOHNSON & JOHNSON COM | 22 | Q3 2018 | 2.7% |
| VANGUARD MID CAP | 22 | Q3 2018 | 2.6% |
| GENERAL ELECTRIC CO COM | 22 | Q3 2018 | 2.8% |
| UNITED TECHNOLOGIES CORP COM | 22 | Q3 2018 | 2.4% |
| ALPS TRUST ETF ALERIAN MLP | 22 | Q3 2018 | 2.2% |
View RAND WEALTH, LLC's complete holdings history.
Latest filings
| Type | Filed |
|---|---|
| 13F-HR | 2018-11-13 |
| 13F-HR | 2018-07-17 |
| 13F-HR | 2018-04-16 |
| 13F-HR | 2018-02-05 |
| 13F-HR | 2017-10-23 |
| 13F-HR | 2017-07-31 |
| 13F-HR | 2017-04-26 |
| 13F-HR | 2017-02-09 |
| 13F-HR | 2016-11-04 |
| 13F-HR | 2016-08-05 |
View RAND WEALTH, LLC's complete filings history.
All filings
- Holdings (13F-HR)
- Significant ownership (13-D/G)
- Insider transactions (4, 5, 6)
- Events (8-K)
- Shareholder votes (proxy)
View complete filings history.