Skip to content
Disclosery

NSI Retail Advisors, LLC

Follow

13F filer, CIK 1866574, WARRENDALE, PA

NSI Retail Advisors, LLC reported $471,932,000 across 40 holdings for the quarter ended 2023-09-30, in a 13F-HR filed 2023-11-13. Its ten largest share positions make up 92.05% of the portfolio.

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

Period
2023-09-30
Reported value
$472M
Holdings
40
Top 10 weight
92.05%
New
1
Sold out
13

Largest buys vs the previous quarter

SecurityShares changeApprox. value
VTInew+36,800$7.82M
IWMadded+6,600$1.17M
SPYadded+150$71.5K

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
ITAexited-215,300-$25.1M
VGKexited-390,400-$24.1M
EMBexited-274,100-$23.7M
QQQreduced-40,700-$14.6M
IVVexited-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.

Holdings, Q3 2023

Share positions as resolved from 13F-HR 0001863523-23-000005, largest first. % of portfolio is the value over $471,932,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; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 666,298 shares; 2023Q2: 666,298 shares; 2023Q3: 666,298 shares 666,298$91.9M19.47%0Timeline
VUGVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 281,887 shares; 2023Q2: 281,887 shares; 2023Q3: 281,887 shares 281,887$76.8M16.27%0Timeline
SPYSTATE STR SPDR S&P 500 ETF TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 129,590 shares; 2023Q2: 129,440 shares; 2023Q3: 129,590 shares 129,590$61.7M13.08%+150Timeline
QQQINVESCO QQQ TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 168,575 shares; 2023Q2: 209,275 shares; 2023Q3: 168,575 shares 168,575$60.4M12.8%-40,700Timeline
ORSIXNRTH SQ DYN SM CAP-IQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,658,749 shares; 2023Q2: 4,535,923 shares; 2023Q3: 4,415,121 shares 4,415,121$52M11.02%-120,802Timeline
EWWISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 398,000 shares; 2023Q2: 398,000 shares; 2023Q3: 398,000 shares 398,000$23.2M4.91%0Timeline
EWJISHARES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: 383,000 shares; 2023Q3: 383,000 shares 383,000$23.1M4.89%0Timeline
BNDXVANGUARD CHARLOTTE FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: 481,500 shares; 2023Q3: 481,500 shares 481,500$23M4.88%0Timeline
ADVGXNORTH SQ SEL SM CAP-IQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 1,452,736 shares; 2023Q2: 1,415,687 shares; 2023Q3: 1,375,846 shares 1,375,846$13.4M2.83%-39,841Timeline
SPYMSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 185,400 shares; 2023Q2: 181,300 shares; 2023Q3: 177,700 shares 177,700$8.93M1.89%-3,600Timeline
VTIVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: not reported; 2023Q2: not reported; 2023Q3: 36,800 shares 36,800$7.82M1.66%newTimeline
NORTH SQ INVSTMNTS TNORTH SQ INVSTMNTS TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 687,174 shares; 2023Q2: 744,105 shares; 2023Q3: 707,808 shares 707,808$7.38M1.56%-36,297
SPIBSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 134,800 shares; 2023Q2: 134,800 shares; 2023Q3: 125,700 shares 125,700$3.95M0.84%-9,100Timeline
SPSBSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 83,500 shares; 2023Q2: 83,500 shares; 2023Q3: 77,800 shares 77,800$2.28M0.48%-5,700Timeline
MBBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 26,400 shares; 2023Q2: 26,400 shares; 2023Q3: 25,200 shares 25,200$2.24M0.47%-1,200Timeline
IWMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,400 shares; 2023Q2: 4,400 shares; 2023Q3: 11,000 shares 11,000$1.94M0.41%+6,600Timeline
ANGLVANECK ETF TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 45,500 shares; 2023Q2: 45,500 shares; 2023Q3: 41,400 shares 41,400$1.12M0.24%-4,100Timeline
SPLBSPDR SERIES TRUSTQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 54,200 shares; 2023Q2: 54,200 shares; 2023Q3: 51,700 shares 51,700$1.1M0.23%-2,500Timeline
VIGVANGUARD SPECIALIZED FUNDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 7,434 shares; 2023Q2: 6,834 shares; 2023Q3: 6,234 shares 6,234$969K0.21%-600Timeline
DGROISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 22,520 shares; 2023Q2: 21,120 shares; 2023Q3: 19,420 shares 19,420$962K0.2%-1,700Timeline
SCHDSCHWAB STRATEGIC TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 14,782 shares; 2023Q2: 14,682 shares; 2023Q3: 13,582 shares 13,582$961K0.2%-1,100Timeline
AAPLAPPLE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 6,216 shares; 2023Q2: 5,416 shares; 2023Q3: 4,366 shares 4,366$748K0.16%-1,050Timeline
MSFTMICROSOFT CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,902 shares; 2023Q2: 2,702 shares; 2023Q3: 2,002 shares 2,002$632K0.13%-700Timeline
USHYISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 17,650 shares; 2023Q2: 17,650 shares; 2023Q3: 16,250 shares 16,250$564K0.12%-1,400Timeline
AFLAFLAC INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 8,647 shares; 2023Q2: 7,547 shares; 2023Q3: 5,747 shares 5,747$441K0.09%-1,800Timeline
WMTWALMART INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 3,413 shares; 2023Q2: 3,313 shares; 2023Q3: 2,713 shares 2,713$434K0.09%-600Timeline
WMWASTE MGMT INC DELQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 4,119 shares; 2023Q2: 3,819 shares; 2023Q3: 2,719 shares 2,719$414K0.09%-1,100Timeline
MCDMCDONALDS CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,403 shares; 2023Q2: 2,203 shares; 2023Q3: 1,553 shares 1,553$409K0.09%-650Timeline
LLYELI LILLY & COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,607 shares; 2023Q2: 1,607 shares; 2023Q3: 757 shares 757$407K0.09%-850Timeline
SOSOUTHERN COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 8,526 shares; 2023Q2: 7,326 shares; 2023Q3: 6,226 shares 6,226$403K0.09%-1,100Timeline
MRKMERCK & CO INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 5,288 shares; 2023Q2: 4,588 shares; 2023Q3: 3,388 shares 3,388$349K0.07%-1,200Timeline
GWWWW GRAINGER INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 756 shares; 2023Q2: 456 shares; 2023Q3: 456 shares 456$315K0.07%0Timeline
PGPROCTER & GAMBLE COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,298 shares; 2023Q2: 2,298 shares; 2023Q3: 2,098 shares 2,098$306K0.06%-200Timeline
HDHOME DEPOT INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 1,025 shares; 2023Q2: 825 shares; 2023Q3: 825 shares 825$249K0.05%0Timeline
ITWILLINOIS TOOL WKS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 933 shares; 2023Q2: 933 shares; 2023Q3: 933 shares 933$215K0.05%0Timeline
LHXL3HARRIS TECHNOLOGIES INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 1,910 shares; 2023Q2: 1,910 shares; 2023Q3: 1,210 shares 1,210$211K0.04%-700Timeline
ABTABBOTT LABORATORIESQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,581 shares; 2023Q2: 2,381 shares; 2023Q3: 2,081 shares 2,081$202K0.04%-300Timeline
JNJJOHNSON & JOHNSONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,097 shares; 2023Q2: 1,497 shares; 2023Q3: 1,297 shares 1,297$202K0.04%-200Timeline
TFCTRUIST FINL CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 10,791 shares; 2023Q2: 8,091 shares; 2023Q3: 6,991 shares 6,991$200K0.04%-1,100Timeline
DDOMINION ENERGY INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2021Q4: restricted; 2022Q1: restricted; 2022Q2: restricted; 2022Q3: restricted; 2022Q4: restricted; 2023Q1: 2,211 shares; 2023Q2: 2,211 shares; 2023Q3: 2,211 shares 2,211$99K0.02%0Timeline

Sold out in Q3 2023

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

SecurityShares beforeValue beforeType
ITAISHARES TR215,300$25.1Mshares
VGKVANGUARD INTL EQUITY INDEX F390,400$24.1Mshares
EMBISHARES TR274,100$23.7Mshares
IVVISHARES TR17,900$7.98Mshares
DIASTATE STR SPDR DOW JONES IND21,000$7.22Mshares
SPYSTATE STR SPDR S&P 500 ETF T150$6.65Mput
SPDWSPDR INDEX SHS FDS144,000$4.69Mshares
SPEMSPDR INDEX SHS FDS45,100$1.55Mshares
SPSMSPDR SERIES TRUST32,700$1.27Mshares
PFEPFIZER INC9,869$362Kshares
SYYSYSCO CORP3,523$261Kshares
GISGENERAL MILLS INC3,044$233Kshares
ESEVERSOURCE ENERGY3,195$227Kshares

How Q3 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 0001863523-23-000005 base2023-11-13acceptance time not in the bulk data set