Skip to content
Disclosery

NSI Retail Advisors, LLC

Follow

13F filer, CIK 1866574, WARRENDALE, PA

NSI Retail Advisors, LLC reported $572,820,000 across 39 holdings for the quarter ended 2024-06-30, in a 13F-HR filed 2024-08-14. Its ten largest share positions make up 89.01% of the portfolio.

Filed (acceptance time not in the bulk data set), ingested 13F-HR 0001866574-24-000005

Period
2024-06-30
Reported value
$573M
Holdings
39
Top 10 weight
89.01%
New
2
Sold out
6

Largest buys vs the previous quarter

SecurityShares changeApprox. value
IWMadded+129,100$26.2M
TLTnew+281,900$25.9M
LHXnew+910$204K

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
XBIexited-316,300-$30M
IWPexited-249,000-$28.4M
SMHexited-126,200-$28.4M
IWOexited-104,000-$28.2M
MUBexited-229,500-$24.7M

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, Q2 2024

Share positions as resolved from 13F-HR 0001866574-24-000005, largest first. % of portfolio is the value over $570,099,000, the sum of the share positions whose value is usable for ratios (method).

SecurityHistorySharesValue% of portfolioChangeLatest eventTimeline
QQQINVESCO QQQ TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 168,575 shares; 2023Q2: 209,275 shares; 2023Q3: 168,575 shares; 2023Q4: 205,475 shares; 2024Q1: 200,675 shares; 2024Q2: 197,275 shares 197,275$94.5M16.58%-3,400Timeline
SPYSTATE STR SPDR S&P 500 ETF TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 129,590 shares; 2023Q2: 129,440 shares; 2023Q3: 129,590 shares; 2023Q4: 161,290 shares; 2024Q1: 156,840 shares; 2024Q2: 156,140 shares 156,140$85M14.91%-700Timeline
VUGVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 281,887 shares; 2023Q2: 281,887 shares; 2023Q3: 281,887 shares; 2023Q4: 206,787 shares; 2024Q1: 206,787 shares; 2024Q2: 206,787 shares 206,787$77.3M13.57%0Timeline
VTVVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 666,298 shares; 2023Q2: 666,298 shares; 2023Q3: 666,298 shares; 2023Q4: 518,598 shares; 2024Q1: 354,498 shares; 2024Q2: 354,498 shares 354,498$56.9M9.97%0Timeline
ORSIXNRTH SQ DYN SM CAP-IQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,658,749 shares; 2023Q2: 4,535,923 shares; 2023Q3: 4,415,121 shares; 2023Q4: 4,249,626 shares; 2024Q1: 4,046,716 shares; 2024Q2: 3,602,988 shares 3,602,988$52.6M9.23%-443,728Timeline
IWMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,400 shares; 2023Q2: 4,400 shares; 2023Q3: 11,000 shares; 2023Q4: 11,000 shares; 2024Q1: 29,400 shares; 2024Q2: 158,500 shares 158,500$32.2M5.64%+129,100Timeline
IWVISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: not reported; 2023Q3: not reported; 2023Q4: 93,400 shares; 2024Q1: 93,400 shares; 2024Q2: 93,400 shares 93,400$28.8M5.06%0Timeline
XLFSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: not reported; 2023Q3: not reported; 2023Q4: 688,900 shares; 2024Q1: 688,900 shares; 2024Q2: 688,900 shares 688,900$28.3M4.97%0Timeline
EZUISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: not reported; 2023Q3: not reported; 2023Q4: 531,500 shares; 2024Q1: 531,500 shares; 2024Q2: 531,500 shares 531,500$25.9M4.55%0Timeline
TLTISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: not reported; 2023Q3: not reported; 2023Q4: not reported; 2024Q1: not reported; 2024Q2: 281,900 shares 281,900$25.9M4.54%newTimeline
ADVGXNORTH SQ SEL SM CAP-IQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 1,452,736 shares; 2023Q2: 1,415,687 shares; 2023Q3: 1,375,846 shares; 2023Q4: 1,387,526 shares; 2024Q1: 1,687,955 shares; 2024Q2: 1,687,955 shares 1,687,955$19.6M3.44%0Timeline
SPYMSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 185,400 shares; 2023Q2: 181,300 shares; 2023Q3: 177,700 shares; 2023Q4: 241,100 shares; 2024Q1: 232,800 shares; 2024Q2: 232,800 shares 232,800$14.9M2.61%0Timeline
SPDWSPDR INDEX SHS FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 154,700 shares; 2023Q2: 144,000 shares; 2023Q3: not reported; 2023Q4: 263,300 shares; 2024Q1: 239,200 shares; 2024Q2: 239,200 shares 239,200$8.39M1.47%0Timeline
SPIBSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 134,800 shares; 2023Q2: 134,800 shares; 2023Q3: 125,700 shares; 2023Q4: 106,600 shares; 2024Q1: 98,900 shares; 2024Q2: 95,500 shares 95,500$3.11M0.55%-3,400Timeline
SPEMSPDR INDEX SHS FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 48,100 shares; 2023Q2: 45,100 shares; 2023Q3: not reported; 2023Q4: 84,000 shares; 2024Q1: 79,400 shares; 2024Q2: 79,400 shares 79,400$2.99M0.52%0Timeline
SPSBSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 83,500 shares; 2023Q2: 83,500 shares; 2023Q3: 77,800 shares; 2023Q4: 68,100 shares; 2024Q1: 62,000 shares; 2024Q2: 59,900 shares 59,900$1.78M0.31%-2,100Timeline
SPSMSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 26,200 shares; 2023Q2: 32,700 shares; 2023Q3: not reported; 2023Q4: 42,100 shares; 2024Q1: 40,100 shares; 2024Q2: 40,100 shares 40,100$1.67M0.29%0Timeline
ANGLVANECK ETF TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 45,500 shares; 2023Q2: 45,500 shares; 2023Q3: 41,400 shares; 2023Q4: 34,700 shares; 2024Q1: 31,900 shares; 2024Q2: 31,300 shares 31,300$886K0.16%-600Timeline
SPLBSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 54,200 shares; 2023Q2: 54,200 shares; 2023Q3: 51,700 shares; 2023Q4: 41,900 shares; 2024Q1: 39,900 shares; 2024Q2: 39,100 shares 39,100$882K0.15%-800Timeline
VIGVANGUARD SPECIALIZED FUNDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 7,434 shares; 2023Q2: 6,834 shares; 2023Q3: 6,234 shares; 2023Q4: 5,934 shares; 2024Q1: 4,834 shares; 2024Q2: 4,734 shares 4,734$864K0.15%-100Timeline
DGROISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 22,520 shares; 2023Q2: 21,120 shares; 2023Q3: 19,420 shares; 2023Q4: 18,220 shares; 2024Q1: 15,220 shares; 2024Q2: 14,920 shares 14,920$860K0.15%-300Timeline
MSFTMICROSOFT CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,902 shares; 2023Q2: 2,702 shares; 2023Q3: 2,002 shares; 2023Q4: 2,002 shares; 2024Q1: 1,702 shares; 2024Q2: 1,702 shares 1,702$761K0.13%0Timeline
SCHDSCHWAB STRATEGIC TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 14,782 shares; 2023Q2: 14,682 shares; 2023Q3: 13,582 shares; 2023Q4: 12,182 shares; 2024Q1: 10,382 shares; 2024Q2: 9,382 shares 9,382$730K0.13%-1,000Timeline
AAPLAPPLE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 6,216 shares; 2023Q2: 5,416 shares; 2023Q3: 4,366 shares; 2023Q4: 4,166 shares; 2024Q1: 3,166 shares; 2024Q2: 2,966 shares 2,966$625K0.11%-200Timeline
LLYELI LILLY & COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,607 shares; 2023Q2: 1,607 shares; 2023Q3: 757 shares; 2023Q4: 757 shares; 2024Q1: 557 shares; 2024Q2: 557 shares 557$504K0.09%0Timeline
USHYISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 17,650 shares; 2023Q2: 17,650 shares; 2023Q3: 16,250 shares; 2023Q4: 13,750 shares; 2024Q1: 12,650 shares; 2024Q2: 12,250 shares 12,250$444K0.08%-400Timeline
GWWWW GRAINGER INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 756 shares; 2023Q2: 456 shares; 2023Q3: 456 shares; 2023Q4: 456 shares; 2024Q1: 456 shares; 2024Q2: 456 shares 456$411K0.07%0Timeline
WMTWALMART INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 3,413 shares; 2023Q2: 3,313 shares; 2023Q3: 2,713 shares; 2023Q4: 2,613 shares; 2024Q1: 6,139 shares; 2024Q2: 6,039 shares 6,039$409K0.07%-100Timeline
WMWASTE MGMT INC DELQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,119 shares; 2023Q2: 3,819 shares; 2023Q3: 2,719 shares; 2023Q4: 2,619 shares; 2024Q1: 1,919 shares; 2024Q2: 1,919 shares 1,919$409K0.07%0Timeline
AFLAFLAC INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 8,647 shares; 2023Q2: 7,547 shares; 2023Q3: 5,747 shares; 2023Q4: 5,647 shares; 2024Q1: 4,347 shares; 2024Q2: 4,047 shares 4,047$361K0.06%-300Timeline
SOSOUTHERN COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 8,526 shares; 2023Q2: 7,326 shares; 2023Q3: 6,226 shares; 2023Q4: 5,726 shares; 2024Q1: 4,626 shares; 2024Q2: 4,526 shares 4,526$351K0.06%-100Timeline
MRKMERCK & CO INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 5,288 shares; 2023Q2: 4,588 shares; 2023Q3: 3,388 shares; 2023Q4: 3,388 shares; 2024Q1: 2,888 shares; 2024Q2: 2,788 shares 2,788$345K0.06%-100Timeline
MCDMCDONALDS CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,403 shares; 2023Q2: 2,203 shares; 2023Q3: 1,553 shares; 2023Q4: 1,453 shares; 2024Q1: 1,153 shares; 2024Q2: 1,153 shares 1,153$294K0.05%0Timeline
PGPROCTER & GAMBLE COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,298 shares; 2023Q2: 2,298 shares; 2023Q3: 2,098 shares; 2023Q4: 2,098 shares; 2024Q1: 1,798 shares; 2024Q2: 1,698 shares 1,698$280K0.05%-100Timeline
HDHOME DEPOT INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 1,025 shares; 2023Q2: 825 shares; 2023Q3: 825 shares; 2023Q4: 825 shares; 2024Q1: 725 shares; 2024Q2: 725 shares 725$250K0.04%0Timeline
LHXL3HARRIS TECHNOLOGIES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 1,910 shares; 2023Q2: 1,910 shares; 2023Q3: 1,210 shares; 2023Q4: 1,010 shares; 2024Q1: not reported; 2024Q2: 910 shares 910$204K0.04%newTimeline
SYYSYSCO CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,523 shares; 2023Q2: 3,523 shares; 2023Q3: not reported; 2023Q4: 2,823 shares; 2024Q1: 2,323 shares; 2024Q2: 2,323 shares 2,323$166K0.03%0Timeline
ABTABBOTT LABORATORIESQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,581 shares; 2023Q2: 2,381 shares; 2023Q3: 2,081 shares; 2023Q4: 1,981 shares; 2024Q1: 1,581 shares; 2024Q2: 1,581 shares 1,581$164K0.03%0Timeline

Options

Puts and calls, as filed. The amount and value describe the underlying shares, not the option premium, so they stay out of % of portfolio (H5).

SecurityTypeAmountValueChange
SPYSTATE STR SPDR S&P 500 ETF T SHSput50$2.72M0

Sold out in Q2 2024

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

SecurityShares beforeValue beforeType
XBISPDR SERIES TRUST316,300$30Mshares
IWPISHARES TR249,000$28.4Mshares
SMHVANECK ETF TRUST126,200$28.4Mshares
IWOISHARES TR104,000$28.2Mshares
MUBISHARES TR229,500$24.7Mshares
EFGISHARES TR128,100$13.3Mshares

How Q2 2024 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 0001866574-24-000005 base2024-08-14acceptance time not in the bulk data set