Skip to content
Disclosery

NSI Retail Advisors, LLC

Follow

13F filer, CIK 1866574, WARRENDALE, PA

NSI Retail Advisors, LLC reported $596,750,000 across 52 holdings for the quarter ended 2023-06-30, in a 13F-HR filed 2023-08-14. Its ten largest share positions make up 82.27% of the portfolio.

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

Period
2023-06-30
Reported value
$597M
Holdings
52
Top 10 weight
82.27%
New
6
Sold out
0

Largest buys vs the previous quarter

SecurityShares changeApprox. value
EMBnew+274,100$23.7M
EWJnew+383,000$23.7M
BNDXnew+481,500$23.5M
QQQadded+40,700$15M
IVVnew+17,900$7.98M

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
ORSIXreduced-122,826-$1.49M
LLYreduced-1,000-$469K
ADVGXreduced-37,049-$370K
SPDWreduced-10,700-$348K
GWWreduced-300-$237K

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 2023

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

SecurityHistorySharesValue% of portfolioChangeLatest eventTimeline
VTVVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 666,298 shares; 2023Q2: 666,298 shares 666,298$94.7M16.04%0Timeline
VUGVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 281,887 shares; 2023Q2: 281,887 shares 281,887$79.8M13.52%0Timeline
QQQINVESCO QQQ TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 168,575 shares; 2023Q2: 209,275 shares 209,275$77.3M13.1%+40,700Timeline
SPYSTATE STR SPDR S&P 500 ETF TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 129,590 shares; 2023Q2: 129,440 shares 129,440$57.4M9.72%-150Timeline
ORSIXNRTH SQ DYN SM CAP-IQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,658,749 shares; 2023Q2: 4,535,923 shares 4,535,923$55M9.32%-122,826Timeline
ITAISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 215,300 shares; 2023Q2: 215,300 shares 215,300$25.1M4.26%0Timeline
EWWISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 398,000 shares; 2023Q2: 398,000 shares 398,000$24.7M4.19%0Timeline
VGKVANGUARD INTL EQUITY INDEX FQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 390,400 shares; 2023Q2: 390,400 shares 390,400$24.1M4.08%0Timeline
EMBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: 274,100 shares 274,100$23.7M4.02%newTimeline
EWJISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: 383,000 shares 383,000$23.7M4.02%newTimeline
BNDXVANGUARD CHARLOTTE FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: 481,500 shares 481,500$23.5M3.99%newTimeline
ADVGXNORTH SQ SEL SM CAP-IQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 1,452,736 shares; 2023Q2: 1,415,687 shares 1,415,687$14.1M2.39%-37,049Timeline
SPYMSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 185,400 shares; 2023Q2: 181,300 shares 181,300$9.45M1.6%-4,100Timeline
NORTH SQ INVSTMNTS TNORTH SQ INVSTMNTS TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 687,174 shares; 2023Q2: 744,105 shares 744,105$8.65M1.47%+56,931
IVVISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: 17,900 shares 17,900$7.98M1.35%newTimeline
DIASTATE STR SPDR DOW JONES INDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: 21,000 shares 21,000$7.22M1.22%newTimeline
SPDWSPDR INDEX SHS FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 154,700 shares; 2023Q2: 144,000 shares 144,000$4.69M0.79%-10,700Timeline
SPIBSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 134,800 shares; 2023Q2: 134,800 shares 134,800$4.33M0.73%0Timeline
MBBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 26,400 shares; 2023Q2: 26,400 shares 26,400$2.46M0.42%0Timeline
SPSBSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 83,500 shares; 2023Q2: 83,500 shares 83,500$2.46M0.42%0Timeline
SPEMSPDR INDEX SHS FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 48,100 shares; 2023Q2: 45,100 shares 45,100$1.55M0.26%-3,000Timeline
SPSMSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 26,200 shares; 2023Q2: 32,700 shares 32,700$1.27M0.22%+6,500Timeline
ANGLVANECK ETF TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 45,500 shares; 2023Q2: 45,500 shares 45,500$1.26M0.21%0Timeline
SPLBSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 54,200 shares; 2023Q2: 54,200 shares 54,200$1.26M0.21%0Timeline
VIGVANGUARD SPECIALIZED FUNDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 7,434 shares; 2023Q2: 6,834 shares 6,834$1.11M0.19%-600Timeline
DGROISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 22,520 shares; 2023Q2: 21,120 shares 21,120$1.09M0.18%-1,400Timeline
SCHDSCHWAB STRATEGIC TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 14,782 shares; 2023Q2: 14,682 shares 14,682$1.07M0.18%-100Timeline
AAPLAPPLE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 6,216 shares; 2023Q2: 5,416 shares 5,416$1.05M0.18%-800Timeline
MSFTMICROSOFT CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,902 shares; 2023Q2: 2,702 shares 2,702$920K0.16%-200Timeline
IWMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,400 shares; 2023Q2: 4,400 shares 4,400$824K0.14%0Timeline
LLYELI LILLY & COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,607 shares; 2023Q2: 1,607 shares 1,607$754K0.13%-1,000Timeline
WMWASTE MGMT INC DELQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,119 shares; 2023Q2: 3,819 shares 3,819$662K0.11%-300Timeline
MCDMCDONALDS CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,403 shares; 2023Q2: 2,203 shares 2,203$657K0.11%-200Timeline
USHYISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 17,650 shares; 2023Q2: 17,650 shares 17,650$623K0.11%0Timeline
MRKMERCK & CO INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 5,288 shares; 2023Q2: 4,588 shares 4,588$529K0.09%-700Timeline
AFLAFLAC INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 8,647 shares; 2023Q2: 7,547 shares 7,547$527K0.09%-1,100Timeline
WMTWALMART INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 3,413 shares; 2023Q2: 3,313 shares 3,313$521K0.09%-100Timeline
SOSOUTHERN COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 8,526 shares; 2023Q2: 7,326 shares 7,326$515K0.09%-1,200Timeline
LHXL3HARRIS TECHNOLOGIES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 1,910 shares; 2023Q2: 1,910 shares 1,910$374K0.06%0Timeline
PFEPFIZER INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 10,369 shares; 2023Q2: 9,869 shares 9,869$362K0.06%-500Timeline
GWWWW GRAINGER INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 756 shares; 2023Q2: 456 shares 456$360K0.06%-300Timeline
PGPROCTER & GAMBLE COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,298 shares; 2023Q2: 2,298 shares 2,298$349K0.06%0Timeline
SYYSYSCO CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,523 shares; 2023Q2: 3,523 shares 3,523$261K0.04%-1,000Timeline
ABTABBOTT LABORATORIESQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,581 shares; 2023Q2: 2,381 shares 2,381$260K0.04%-200Timeline
HDHOME DEPOT INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 1,025 shares; 2023Q2: 825 shares 825$256K0.04%-200Timeline
JNJJOHNSON & JOHNSONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,097 shares; 2023Q2: 1,497 shares 1,497$248K0.04%-600Timeline
TFCTRUIST FINL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 10,791 shares; 2023Q2: 8,091 shares 8,091$246K0.04%-2,700Timeline
ITWILLINOIS TOOL WKS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 933 shares; 2023Q2: 933 shares 933$233K0.04%0Timeline
GISGENERAL MILLS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 3,744 shares; 2023Q2: 3,044 shares 3,044$233K0.04%-700Timeline
ESEVERSOURCE ENERGYQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 3,195 shares; 2023Q2: 3,195 shares 3,195$227K0.04%0Timeline
DDOMINION ENERGY INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q3: restricted; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,211 shares; 2023Q2: 2,211 shares 2,211$115K0.02%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 SHSput150$6.65Mnew

How Q2 2023 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-23-000003 base2023-08-14acceptance time not in the bulk data set