Affiance Financial, LLC Buys Flaherty & Crumrine Preferred Securities Income Fu, Vanguard Total Stock Market, Bio-Techne Corp, Sells SPDR Select Sector Fund - Consumer Staples, iShares U.S. Preferred Stock ETF, Vanguard Real Estate

• New Purchases: TECH, VWO, BNDX, IJT, FOX, TPR, DSL, USB, TXMD, GAB,
• Added Positions: FFC, VTI, IJH, BSV, MMM, MSFT, VEA, VYM, JNJ, VZ,
• Reduced Positions: XLP, PFF, VNQ, FB, MYD, BIV, PML, MUH, VGT, WMT,
• Sold Out: PGF,

For the details of Affiance Financial, LLC's stock buys and sells, go to http://www.gurufocus.com/StockBuy.php?GuruName=Affiance+Financial%2C+LLC

1. iShares Core S&P Mid-Cap (IJH) - 131,582 shares, 20.92% of the total portfolio. Shares added by 7.92%
2. Vanguard Short-Term Bond (BSV) - 238,109 shares, 15.2% of the total portfolio. Shares added by 6.72%
3. Vanguard Total Stock Market (VTI) - 52,096 shares, 5.97% of the total portfolio. Shares added by 41.70%
4. Flaherty & Crumrine Preferred Securities Income Fu (FFC) - 329,075 shares, 5.08% of the total portfolio. Shares added by 60.08%
5. Vanguard Real Estate (VNQ) - 45,605 shares, 3.03% of the total portfolio. Shares reduced by 23%

Affiance Financial, LLC initiated holding in Bio-Techne Corp. The purchase prices were between $144.9 and $165.58, with an estimated average price of $152.77. The stock is now traded at around $151.60. The impact to a portfolio due to this purchase was 1.2%. The holding were 9,944 shares as of 2018-06-30.

Affiance Financial, LLC initiated holding in Vanguard FTSE Emerging Markets. The purchase prices were between $41.13 and $47.04, with an estimated average price of $45.16. The stock is now traded at around $42.52. The impact to a portfolio due to this purchase was 0.59%. The holding were 17,041 shares as of 2018-06-30.

Affiance Financial, LLC initiated holding in Vanguard Total International Bond ETF. The purchase prices were between $54.1 and $54.76, with an estimated average price of $54.51. The stock is now traded at around $54.85. The impact to a portfolio due to this purchase was 0.57%. The holding were 12,840 shares as of 2018-06-30.

Affiance Financial, LLC initiated holding in iShares S&P Small-Cap 600 Growth ETF. The purchase prices were between $170.02 and $196.06, with an estimated average price of $183.61. The stock is now traded at around $194.71. The impact to a portfolio due to this purchase was 0.3%. The holding were 1,919 shares as of 2018-06-30.

Affiance Financial, LLC initiated holding in Twenty-First Century Fox Inc. The purchase prices were between $35.33 and $49.33, with an estimated average price of $39.11. The stock is now traded at around $46.55. The impact to a portfolio due to this purchase was 0.22%. The holding were 5,362 shares as of 2018-06-30.

Affiance Financial, LLC initiated holding in Tapestry Inc. The purchase prices were between $43.79 and $54.64, with an estimated average price of $48.19. The stock is now traded at around $46.89. The impact to a portfolio due to this purchase was 0.19%. The holding were 4,850 shares as of 2018-06-30.

Affiance Financial, LLC added to a holding in Flaherty & Crumrine Preferred Securities Income Fu by 60.08%. The purchase prices were between $18.33 and $18.98, with an estimated average price of $18.7. The stock is now traded at around $19.11. The impact to a portfolio due to this purchase was 1.91%. The holding were 329,075 shares as of 2018-06-30.

Affiance Financial, LLC added to a holding in Vanguard Total Stock Market by 41.70%. The purchase prices were between $132.63 and $144.42, with an estimated average price of $139.53. The stock is now traded at around $144.58. The impact to a portfolio due to this purchase was 1.76%. The holding were 52,096 shares as of 2018-06-30.

Affiance Financial, LLC added to a holding in 3M Co by 62.98%. The purchase prices were between $194.39 and $220.09, with an estimated average price of $204.21. The stock is now traded at around $201.21. The impact to a portfolio due to this purchase was 0.94%. The holding were 15,195 shares as of 2018-06-30.

Affiance Financial, LLC added to a holding in Microsoft Corp by 149.84%. The purchase prices were between $88.52 and $102.49, with an estimated average price of $96.89. The stock is now traded at around $105.22. The impact to a portfolio due to this purchase was 0.7%. The holding were 14,388 shares as of 2018-06-30.

Affiance Financial, LLC added to a holding in Vanguard FTSE Developed Markets by 211.19%. The purchase prices were between $42.43 and $45.59, with an estimated average price of $44.58. The stock is now traded at around $43.25. The impact to a portfolio due to this purchase was 0.64%. The holding were 27,279 shares as of 2018-06-30.

Affiance Financial, LLC added to a holding in Vanguard High Dividend Yield by 116.62%. The purchase prices were between $80.64 and $85.99, with an estimated average price of $83.75. The stock is now traded at around $84.81. The impact to a portfolio due to this purchase was 0.34%. The holding were 9,278 shares as of 2018-06-30.

Affiance Financial, LLC sold out a holding in Invesco Financial Preferred. The sale prices were between $18.18 and $18.55, with an estimated average price of $18.39.

Affiance Financial, LLC reduced to a holding in SPDR Select Sector Fund - Consumer Staples by 71.25%. The sale prices were between $48.98 and $53.28, with an estimated average price of $50.77. The stock is now traded at around $52.48. The impact to a portfolio due to this sale was -5.66%. Affiance Financial, LLC still held 48,733 shares as of 2018-06-30.

Affiance Financial, LLC reduced to a holding in iShares U.S. Preferred Stock ETF by 62.26%. The sale prices were between $36.91 and $37.71, with an estimated average price of $37.25. The stock is now traded at around $37.61. The impact to a portfolio due to this sale was -0.97%. Affiance Financial, LLC still held 17,506 shares as of 2018-06-30.

Affiance Financial, LLC reduced to a holding in Vanguard Real Estate by 23%. The sale prices were between $73.99 and $81.45, with an estimated average price of $77.48. The stock is now traded at around $81.99. The impact to a portfolio due to this sale was -0.92%. Affiance Financial, LLC still held 45,605 shares as of 2018-06-30.

Affiance Financial, LLC reduced to a holding in Facebook Inc by 41.21%. The sale prices were between $155.1 and $202, with an estimated average price of $180.53. The stock is now traded at around $207.80. The impact to a portfolio due to this sale was -0.52%. Affiance Financial, LLC still held 5,239 shares as of 2018-06-30.

Affiance Financial, LLC reduced to a holding in Vanguard Intermediate-Term Bond by 33.34%. The sale prices were between $79.95 and $81.64, with an estimated average price of $80.78. The stock is now traded at around $80.98. The impact to a portfolio due to this sale was -0.13%. Affiance Financial, LLC still held 3,613 shares as of 2018-06-30.