SEC 13F Intelligence

Managers / Q2 2023 · view latest →

Cetera Advisors LLC

CIK 0001534400 · 4600 S. SYRACUSE ST., SUITE 600, DENVER, CO, 80237 · 720-509-2446

Reported Value
$6.3B
Q2 2023
Positions
1,652
Filings on Record
23
2019–present window
Filed
Aug 10, 2023
original filing

Summary

Cetera Advisors LLC reported $6.3B in U.S.-listed holdings across 1,652 positions for Q2 2023.

The portfolio is heavily concentrated: IVV alone accounts for 21.9% of reported value.

Compared with Q1 2023, the fund opened 148 new positions and exited 147.

Portfolio Metrics

Turnover
+8.1%
vs prior filed quarter
Top-10 Concentration
+43.7%
share of reported value
Largest Position
+21.9%
Ishares Tr
New / Exited
148 / 147
positions this quarter

Methodology: turnover is min(value bought, value sold) ÷ average reported value across the two quarters — value-based, so market moves inflate it slightly versus a share-based measure. Concentration and largest position are shares of the filing’s total reported value, options excluded, with multiple share classes and repeated sub-manager rows for the same issuer combined into one position — the same rule the holdings table uses by default. New/exited counts compare against the prior filed quarter. All figures derive solely from the fund’s 13F filings.

Reported Value by Quarter

13F Reported Value
Q4 ’18: $1.7BQ4 ’18Q1 ’19: $2.0BQ2 ’19: $2.3BQ3 ’19: $2.3BQ3 ’19Q4 ’19: $2.3BQ1 ’20: $1.9BQ2 ’20: $2.3BQ2 ’20Q3 ’20: $2.7BQ4 ’20: $3.1BQ1 ’21: $3.6BQ1 ’21Q2 ’21: $4.2BQ3 ’21: $5.1BQ4 ’21: $4.9BQ4 ’21Q1 ’22: $5.0BQ2 ’22: $4.4BQ3 ’22: $3.8BQ3 ’22Q4 ’22: $5.5BQ1 ’23: $6.0BQ2 ’23: $6.3BQ2 ’23Q3 ’23: $6.4BQ4 ’23: $7.2BQ1 ’24: $0Q1 ’24filingsflow.com

Portfolio Composition

By security type
ETP: 65.7%Common Stock: 30.5%REIT: 1.4%Other: 0.7%Closed-End Fund: 0.7%Other: 1.0%
  • ETP · 65.7% · $4.2B
  • Common Stock · 30.5% · $1.9B
  • REIT · 1.4% · $91M
  • Other · 0.7% · $46M
  • Closed-End Fund · 0.7% · $44M
  • Other · 1.0% · $63M

Quarter-over-Quarter Changes full breakdown →

vs Q1 2023 (amended baseline)

IssuerMoveShare ΔShares nowValue ΔValue now
XMARFIRST TR EXCHNG TRADED FD VINEW+594.0K594.0K+$19M$19M
CGCPCAPITAL GRP FIXED INCM ETF TNEW+732.6K732.6K+$16M$16M
AIM ETF PRODUCTS TRUSTNEW+158.0K158.0K+$4M$4M
FITESPDR SER TRNEW+42.1K42.1K+$2M$2M
PIZINVESCO EXCH TRADED FD TR IINEW+62.1K62.1K+$2M$2M
PKSTPEAKSTONE REALTY TRUSTNEW+57.9K57.9K+$2M$2M
CPCANADIAN PACIFIC KANSAS CITYNEW+17.0K17.0K+$1M$1M
ARTYISHARES TRNEW+38.7K38.7K+$1M$1M

Value changes conflate price moves with buying and selling — share changes are the real signal. Share counts are not split-adjusted.

Holdings — Q2 2023

262 positions
Export to Excel
#IssuerClass% PortfolioValue ↓Shares
1IVVISHARES TRCORE S&P500 ETF · RUS 1000 GRW ETF · MSCI USA MIN VOL · SELECT DIVID ETF · RUS 1000 VAL ETF · S&P 500 VAL ETF · CORE TOTAL USD · CORE S&P MCP ETF · S&P 500 GRWT ETF · MSCI USA QLT FCT · MBS ETF · 10-20 YR TRS ETF · 0-5 YR TIPS ETF · CORE S&P SCP ETF · CORE DIV GRWTH · EAFE GRWTH ETF · NATIONAL MUN ETF · IBOXX INV CP ETF · US TREAS BD ETF · U.S. TECH ETF · CORE S&P TTL STK · RUSSELL 2000 ETF · CORE MSCI EAFE · CORE US AGGBD ET · SHORT TREAS BD · ESG AWR MSCI USA · EAFE VALUE ETF · RUS MID CAP ETF · 20 YR TR BD ETF · RUS 2000 GRW ETF · ISHS 1-5YR INVS · RUS MD CP GR ETF · MSCI EAFE ETF · CORE HIGH DV ETF · MSCI EAFE MIN VL · US AER DEF ETF · FALN ANGLS USD · 0-3 MNTH TREASRY · PFD AND INCM SEC · CORE S&P US GWT · RUS 1000 ETF · EXPANDED TECH · US HLTHCARE ETF · 1 3 YR TREAS BD · CORE MSCI INTL · CORE MSCI TOTAL · INTL DIV GRWTH · RUS MDCP VAL ETF · RUS 2000 VAL ETF · IBOXX HI YD ETF · GL CLEAN ENE ETF · IBONDS 25 TRM HG · JPMORGAN USD EMG · 7-10 YR TRSY BD · ISHS 5-10YR INVT · RUS TP200 GR ETF · S&P 100 ETF · US HLTHCR PR ETF · SHRT NAT MUN ETF · TIPS BD ETF · BLACKROCK ULTRA · CORE S&P US VLU · DOW JONES US ETF · CORE MSCI PAC · RUSSELL 3000 ETF · EXPND TEC SC ETF · IBOND DEC 2030 · FLTG RATE NT ETF · ISHARES SEMICDTR · COHEN STEER REIT · 3 7 YR TREAS BD · US HOME CONS ETF · US INFRASTRUC · MICRO-CAP ETF · MSCI USA MMENTM · MODERT ALLOC ETF · US REGNL BKS ETF · US CONSM STAPLES · MRGSTR MD CP ETF21.94%$1.4B14.68M
2VOOVANGUARD INDEX FDSS&P 500 ETF SHS · TOTAL STK MKT · MID CAP ETF · GROWTH ETF · VALUE ETF · SMALL CP ETF · SM CP VAL ETF · REAL ESTATE ETF · MCAP VL IDXVIP · EXTEND MKT ETF4.02%$255M1.08M
3AAPLAPPLE INChistory →COM3.66%$232M1.20M
4FTSMFIRST TR EXCHANGE-TRADED FDFIRST TR ENH NEW · CAP STRENGTH ETF · RISNG DIVD ACHIV · NASDAQ CYB ETF · MATERIALS ALPH · FT CBOE VEST S&P · TECH ALPHADEX · US EQTY OPPT ETF · CBOE VEST RISING · SENIOR LN FD · INDXX NAT RE ETF · NASD TECH DIV · FINLS ALPHADEX · FST LOW OPPT EFT · BUYWRIT INCM ETF · DORSEY WRT 5 ETF · FIRST TR TA HIYL2.94%$187M3.45M
5SPYSPDR S&P 500 ETF TRhistory →TR UNIT2.38%$151M339.9K
6XMARFIRST TR EXCHNG TRADED FD VIFT CBOE VEST US · CBOE VEST US EQ · CBOE VEST US EQT · FT CBOE VEST 100 · TCW OPPORTUNIS · US EQT BUFFER · CBOE VEST FD DEP · FT CBOE VEST MAR · CBOE VEST BUFERD · CBOE EQT BUFER · CBOE VEST NAS100 · FT CBOE EQTY BFR · CBOE VEST US BUF · CBOE EQT DEP NOV · FT CBOE VEST BFR · VEST US BUFFER2.11%$134M4.48M
7GSLCGOLDMAN SACHS ETF TRACTIVEBETA US LG · ACTIVEBETA INT · ACCES TREASURY1.88%$119M1.77M
8XLVSELECT SECTOR SPDR TRSBI HEALTHCARE · TECHNOLOGY · ENERGY · SBI CONS DISCR · FINANCIAL · SBI CONS STPLS · SBI INT-INDS · COMMUNICATION · SBI INT-UTILS · SBI MATERIALS1.69%$107M1.21M
9CWBSPDR SER TRBBG CONV SEC ETF · S&P REGL BKG · BLOOMBERG 1-3 MO · PORTFOLIO S&P500 · PRTFLO S&P500 VL · S&P DIVID ETF · S&P BIOTECH · S&P SEMICNDCTR · PRTFLO S&P500 GW · PORTFOLIO S&P600 · PORTFOLIO SHORT · PORTFOLIO INTRMD · PORTFOLIO SH TSR · PORTFOLIO LN TSR · S&P KENSHO FUTRE · PORTFOLIO AGRGTE · PORTFLI HIGH YLD · BLOOMBERG HIGH Y1.55%$98M1.84M
10SCHDSCHWAB STRATEGIC TRUS DIVIDEND EQ · US LCAP GR ETF · INTL EQTY ETF · INT-TRM U.S TRES · US LCAP VA ETF · US TIPS ETF · SHT TM US TRES1.50%$95M1.52M
11MSFTMICROSOFT CORPhistory →COM1.48%$94M276.5K
12BNDVANGUARD BD INDEX FDSTOTAL BND MRKT · SHORT TRM BOND · INTERMED TERM · LONG TERM BOND1.43%$91M1.22M
13DGRWWISDOMTREE TRUS QTLY DIV GRT · US LARGECAP FUND · FLOATNG RAT TREA · US LARGECAP DIVD · US SMALLCAP FUND · CURRNCY INT EQ · US MIDCAP FUND · US HIGH DIVIDEND · DYNAMIC INT EQ · EM EX ST-OWNED · EMG MKTS SMCAP1.41%$89M1.85M
14AMZNAMAZON COM INChistory →COM1.09%$69M529.6K
15COWZPACER FDS TRUS CASH COWS 100 · TRENDP US LAR CP · TRENDPILOT 100 · GLOBL CASH ETF · LUNT LRG CP ALTR · TRENDP US MID CP1.08%$69M1.59M
16GOOGLALPHABET INCCAP STK CL A · CAP STK CL C1.07%$68M565.8K
17RSPINVESCO EXCHANGE TRADED FD TS&P500 EQL WGT · S&P500 QUALITY · INTL DIVI ACHI · S&P 500 TOP 50 · S&P500 EQL TEC · S&P500 EQL HLT1.02%$65M894.5K
18JEPIJ P MORGAN EXCHANGE TRADED FEQUITY PREMIUM · ULTRA SHRT INC · CORE PLUS BD ETF0.93%$59M1.10M
19QQQINVESCO QQQ TRhistory →UNIT SER 10.89%$57M153.0K
20BRK/BBERKSHIRE HATHAWAY INC DELCL B NEW · CL A0.89%$56M157.1K
21VGSHVANGUARD SCOTTSDALE FDSSHORT TERM TREAS · INT-TERM CORP · SHRT TRM CORP BD · MTG-BKD SECS ETF · VNG RUS1000GRW0.82%$52M856.2K
22FDLFIRST TR MORNINGSTAR DIVID Lhistory →SHS0.76%$48M1.42M
23TSLATESLA INChistory →COM0.76%$48M183.3K
24NVDANVIDIA CORPORATIONhistory →COM0.66%$42M98.5K
25BSJPINVESCO EXCH TRD SLF IDX FDBULSHS 2023 HY · BULSHS 2025 HY · BULSHS 2024 HY · INVSCO BLSH 26 · BULETSHS 20270.63%$40M1.75M
26PNOVINNOVATOR ETFS TRUS EQTY PWR BUF · US EQTY PWR BF · INTRNL DEV APRL · US EQT PWR BUF · US EQTY BUF DEC · US EQTY BUFR FEB · US EQT ULTRA BF · US EQTY BUF OCT0.62%$39M1.22M
27VYMVANGUARD WHITEHALL FDSHIGH DIV YLD · INTL DVD ETF0.57%$36M347.2K
28HDHOME DEPOT INChistory →COM0.56%$36M115.2K
29SMHVANECK ETF TRUSTSEMICONDUCTR ETF · GOLD MINERS ETF · AGRIBUSINESS ETF · MRNGSTR WDE MOAT · FALLEN ANGEL HG0.54%$34M526.6K
30GLDSPDR GOLD TRhistory →GOLD SHS0.53%$33M187.4K
31JPMJPMORGAN CHASE & COhistory →COM0.51%$33M224.1K
32FVDFIRST TR VALUE LINE DIVID INhistory →SHS0.51%$32M809.1K
33VXUSVANGUARD STAR FDShistory →VG TL INTL STK F0.50%$32M566.0K
34QQQMINVESCO EXCH TRADED FD TR IINASDAQ 100 ETF · S&P500 HDL VOL · S&P500 LOW VOL · S&P GBL WATER · KBW BK ETF · DWA DEV MKTS0.50%$32M514.6K
35VHTVANGUARD WORLD FDSHEALTH CAR ETF · CONSUM STP ETF · INF TECH ETF · ENERGY ETF0.50%$32M138.0K
36CVXCHEVRON CORP NEWhistory →COM0.42%$27M170.1K
37IEMGISHARES INCCORE MSCI EMKT · MSCI GBL MIN VOL0.41%$26M493.2K
38VIGVANGUARD SPECIALIZED FUNDShistory →DIV APP ETF0.41%$26M158.8K
39JNJJOHNSON & JOHNSONhistory →COM0.39%$25M149.6K
40PGPROCTER AND GAMBLE COhistory →COM0.38%$24M157.4K
41EXMOCEXXON MOBIL CORPhistory →COM0.37%$24M219.7K
42VNLAJANUS DETROIT STR TRhistory →HENDRSN SHRT ETF0.37%$23M488.1K
43HONHONEYWELL INTL INChistory →COM0.36%$23M110.0K
44CGDVCAPITAL GROUP DIVIDEND VALUEhistory →SHS CREATION UNI0.35%$22M818.7K
45VVISA INChistory →COM CL A0.34%$22M91.4K
46LLYLILLY ELI & COhistory →COM0.33%$21M45.2K
47CRMSALESFORCE INChistory →COM0.32%$21M97.1K
48CGCPCAPITAL GRP FIXED INCM ETF TCORE PLUS INCM · SHORT DURATION0.32%$20M889.2K
49BNDXVANGUARD CHARLOTTE FDShistory →TOTAL INT BD ETF0.31%$20M406.5K
50PAVEGLOBAL X FDSUS INFR DEV ETF · LITHIUM BTRY ETF · NASDAQ 100 COVER · GLOBAL X COPPER0.31%$20M640.1K
51PECOPHILLIPS EDISON & CO INChistory →COMMON STOCK0.31%$20M579.6K
52CGUSCAPITAL GROUP CORE EQUITY EThistory →SHS CREATION UNI0.31%$20M766.1K
53MAMASTERCARD INCORPORATEDhistory →CL A0.31%$20M49.8K
54DISDISNEY WALT COhistory →COM0.31%$19M217.6K
55LMTLOCKHEED MARTIN CORPhistory →COM0.30%$19M41.3K
56DEDEERE & COhistory →COM0.29%$18M45.6K
57COSTCOSTCO WHSL CORP NEWhistory →COM0.28%$18M33.3K
58VOOGVANGUARD ADMIRAL FDS INC500 GRTH IDX F · SMLLCP 600 IDX · 500 VAL IDX FD · MIDCP 400 IDX0.28%$18M135.7K
59VEUVANGUARD INTL EQUITY INDEX FALLWRLD EX US · FTSE EMR MKT ETF · FTSE SMCAP ETF0.27%$17M307.3K
60METAMETA PLATFORMS INChistory →CL A0.27%$17M59.9K
61VEAVANGUARD TAX-MANAGED FDShistory →VAN FTSE DEV MKT0.27%$17M372.0K
62MCDMCDONALDS CORPhistory →COM0.27%$17M57.4K
63ABBVABBVIE INChistory →COM0.26%$16M122.0K
64MOALTRIA GROUP INChistory →COM0.25%$16M349.6K
65KOCOCA COLA COhistory →COM0.24%$16M257.4K
66UNHUNITEDHEALTH GROUP INChistory →COM0.24%$15M32.2K
67PEPPEPSICO INChistory →COM0.23%$15M80.4K
68LOWLOWES COS INChistory →COM0.22%$14M63.2K
69OREALTY INCOME CORPhistory →COM0.21%$13M221.2K
70MRKMERCK & CO INChistory →COM0.21%$13M113.9K
71CGGRCAPITAL GROUP GROWTH ETFhistory →SHS CREATION UNI0.20%$13M499.8K
72EPDENTERPRISE PRODS PARTNERS Lhistory →COM0.20%$12M470.7K
73VZVERIZON COMMUNICATIONS INChistory →COM0.19%$12M329.0K
74DIVOAMPLIFY ETF TRhistory →CWP ENHANCED DIV0.19%$12M336.1K
75SPDWSPDR INDEX SHS FDSPORTFOLIO DEVLPD · PORTFOLIO EMG MK · EURO STOXX 500.19%$12M341.6K
76BABOEING COhistory →COM0.19%$12M56.8K
77SMMUPIMCO ETF TRhistory →SHTRM MUN BD ACT0.19%$12M241.7K
78NLYANNALY CAPITAL MANAGEMENT INhistory →COM NEW0.18%$12M579.5K
79LATTICE STRATEGIES TRHARTFORD MLT DIV0.18%$11M444.1K
80PMPHILIP MORRIS INTL INChistory →COM0.18%$11M115.6K
81CATCATERPILLAR INChistory →COM0.18%$11M45.4K
82TXNTEXAS INSTRS INChistory →COM0.17%$11M61.3K
83IBMINTERNATIONAL BUSINESS MACHShistory →COM0.17%$11M82.1K
84ETNEATON CORP PLChistory →SHS0.17%$11M54.5K
85FBNDFIDELITY MERRIMACK STR TRhistory →TOTAL BD ETF0.17%$11M241.5K
86OKEONEOK INC NEWhistory →COM0.16%$10M169.3K
87TWO RDS SHARED TRCONDCTR GBL EQTY0.16%$10M789.2K
88AVGOBROADCOM INChistory →COM0.16%$10M11.8K
89WMTWALMART INChistory →COM0.16%$10M63.9K
90MDYSPDR S&P MIDCAP 400 ETF TRUTSER1 S&PDCRP0.16%$10M20.6K
91TAT&T INCCOM0.16%$10M618.8K
92STARBOARD INVT TRRH TACTICAL ROT · ADAPTIVE ALPHA · RH TACTICAL OUTL0.15%$10M639.4K
93ARKKARK ETF TRINNOVATION ETF · FINTECH INNOVA · GENOMIC REV ETF0.15%$10M320.9K
94RBB FD INCUS TREAS 3 MNTH0.15%$9M184.0K
95NEENEXTERA ENERGY INCCOM0.15%$9M124.1K
96NOBLPROSHARES TRS&P 500 DV ARIST · ONLINE RTL ETF0.14%$9M137.6K
97KMIKINDER MORGAN INC DELCOM0.14%$9M506.3K
98LEGG MASON ETF INVTFRANKLIN US LOW · FRANKLIN INTL LW0.14%$9M277.7K
99PFEPFIZER INCCOM0.14%$9M236.5K
100NOCNORTHROP GRUMMAN CORPCOM0.13%$8M18.2K

Filing History

QuarterReported ValuePositionsFiledTypeLinks
Q1 2024$01May 24, 2024RESTATEMENTchanges · EDGAR ↗
Q4 2023$7.2B1,788Feb 13, 202413F-HRchanges · EDGAR ↗
Q3 2023$6.4B1,700Nov 14, 202313F-HRchanges · EDGAR ↗
Q2 2023$6.3B1,652Aug 10, 202313F-HRchanges · EDGAR ↗
Q1 2023$6.0B1,650May 15, 202313F-HRchanges · EDGAR ↗
Q4 2022$5.5B1,603Feb 14, 202313F-HRchanges · EDGAR ↗
Q3 2022$3.8B1,367Nov 14, 202213F-HRchanges · EDGAR ↗
Q2 2022$4.4B1,363Aug 11, 202213F-HRchanges · EDGAR ↗
Q1 2022$5.0B1,409May 12, 202213F-HRchanges · EDGAR ↗
Q4 2021$4.9B1,436Feb 14, 202213F-HRchanges · EDGAR ↗
Q3 2021$5.1B1,408Nov 16, 202113F-HRchanges · EDGAR ↗
Q2 2021$4.2B1,321Aug 13, 202113F-HRchanges · EDGAR ↗
Q1 2021$3.6B1,211May 17, 202113F-HRchanges · EDGAR ↗
Q4 2020$3.1B1,034Feb 17, 202113F-HRchanges · EDGAR ↗
Q3 2020$2.7B953Nov 13, 202013F-HRchanges · EDGAR ↗
Q2 2020$2.3B913Aug 13, 202013F-HRchanges · EDGAR ↗
Q1 2020$1.9B808May 8, 202013F-HRchanges · EDGAR ↗
Q4 2019$2.3B918Feb 10, 202013F-HRchanges · EDGAR ↗
Q3 2019$2.3B889Nov 6, 201913F-HRchanges · EDGAR ↗
Q2 2019$2.3B932Aug 12, 201913F-HRchanges · EDGAR ↗
Q1 2019$2.0B1,230May 6, 201913F-HRchanges · EDGAR ↗
Q4 2018$1.7B844Feb 15, 201913F-HRchanges · EDGAR ↗

13F filings are due up to 45 days after quarter end, so holdings shown here lag the fund’s current book. Source: original SEC filing on EDGAR ↗.