Vanguard Specialized Funds - Vanguard Real Estate ETF
US ˙ ARCA ˙ US9229085538

SecurityVNQ / Vanguard Specialized Funds - Vanguard Real Estate ETF
InstitutionHoyleCohen, LLC
Latest Disclosed Ownership5,134 shares
Latest Disclosed Value $ 430,060
HoyleCohen, LLC reports 2.97% decrease in ownership of VNQ / Vanguard Specialized Funds - Vanguard Real Estate ETF

On July 19, 2024 - HoyleCohen, LLC filed a 13F-HR form disclosing ownership of 5,134 shares of Vanguard Specialized Funds - Vanguard Real Estate ETF (US:VNQ) valued at $430,024 USD as of June 30, 2024. The entity filed a previous 13F-HR on May 15, 2024 disclosing 5,291 shares of Vanguard Specialized Funds - Vanguard Real Estate ETF. This represents a change in shares of -2.97% during the quarter. The current value of the position is $496,920 USD.

Institutional Ownership: 13F and NPORT Filings

The Security and Class in the table below are shown exactly as filed by the investor. We do our best to track continuity of investments through acquisitions, and this will be reflected in the table as changes in names. In addition to descriptive data, performance of the investment is shown over time. To calculate quarterly performance, we first calculate cost basis of the shares purchased during the quarter, then use that to calculate gross profit. Quarterly return is Gross Profit / Starting Portfolio value.

Note that cost basis is calculated and stored in thousands, so small quarterly changes in shares frequently result in a cost basis of zero.

Upgrade to unlock premium data and export to Excel .

Disclosed Equity Positions (from 13F/NPORT Filings)
File
Date		 Effective
Date		Form Security Class ID Avg Price
Paid (Est)		 Reported
Shares		 ΔShares ΔShares
(%)		 Reported
Value
(x1000)		 ΔValue
(%)		 Alloc
(%)		 ΔAlloc ΔAlloc (%) Cost Basis
(x1000)		 Unrealized
Gain/Loss
(x1000)
2024-07-19 2024-06-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,134 -157 -2.97 430 -5.91 0.0325
2024-05-15 2024-03-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,291 0 0.00 458 -2.14 0.0349
2024-02-09 2023-12-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,291 -100 -1.85 468 14.74 0.0382
2023-11-02 2023-09-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,391 -575 -9.64 408 -18.27 0.0378
2023-08-07 2023-06-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,966 -173 -2.82 499 -2.16 0.0440
2023-05-05 2023-03-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 6,139 731 13.52 510 14.13 0.0476
2023-02-14 2022-12-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,408 0 0.00 446 2.76 0.0444
2022-11-02 2022-09-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,408 0 0.00 434 -11.97 0.0475
2022-07-27 2022-06-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,408 -10 -0.18 493 -16.01 0.0513
2022-05-03 2022-03-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,418 10 0.18 587 -6.38 0.0503
2022-02-11 2021-12-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,408 100 1.88 627 16.11 0.0521
2021-11-10 2021-09-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,308 0 0.00 540 0.00 0.0513
2021-08-12 2021-06-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,308 -143 -2.62 540 7.78 0.0420
2021-05-14 2021-03-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,451 247 4.75 501 13.35 0.0510
2021-02-12 2020-12-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,204 74 1.44 442 9.14 0.0510
2020-11-13 2020-09-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,130 58 1.14 405 1.76 0.0596
2020-07-29 2020-06-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,072 0 0.00 398 12.43 0.0665
2020-05-08 2020-03-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,072 -225 -4.25 354 -28.05 0.0706
2020-02-10 2019-12-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,297 0 0.00 492 -0.40 0.0782
2019-11-15 2019-09-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,297 442 9.10 494 16.51 0.0843
2019-08-09 2019-06-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 4,855 0 0.00 424 0.47 0.0736
2019-05-13 2019-03-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 4,855 -85 -1.72 422 14.67 0.0744
2019-02-14 2018-12-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 4,940 0 0.00 368 -7.77 0.0752
2018-11-09 2018-09-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 4,940 137 2.85 399 2.05 0.0753
2018-08-06 2018-06-30 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 4,803 -446 -8.50 391 -1.26 0.0789
2018-05-15 2018-03-31 13F VANGUARD INDEX FDS REAL ESTATE ETF 922908553 5,249 1,055 25.15 396 13.79 0.0803
2018-02-14 2017-12-31 13F VANGUARD INDEX FDS REIT ETF 922908553 4,194 4,194 348 0.0688
Legend
Shares
The total number of shares held by the institution at the end of the reporting period (the effective date). This is provided in the filing.
Value
The total value of the shares as of the effective date. This is provided in the filing.
Avg. Share Price
The weighted average share price of the shares held by the institution. We use FIFO accounting to determine this price
Class
This is the security class as indicated by the filer. There are a variety of values for this field. Common values include "EC" = equity common, "EP" - equity preferred
Allocation (%)
The percent of the institution's portfolio that this position represents. This is provided in NPORT filings. For 13F filings, we calculate it.
Change in Allocation
The change in allocation from the prior reporting period. This is calculated as current allocation - prior allocation.
Change in Allocation (%)
The percent change in allocation from the prior reporting period. This is calculated as (current allocation - prior allocation) / prior allocation.
Cost Basis
The total cost of the shares held. This is calculated as reported shares * avg. share price
Unrealized Gain/Loss
This is the market value of the position as of the effective date minus the cost basis.