Skip to content

Tandem Wealth Advisors LLC

Follow

13F filer, CIK 1842557, PHOENIX, AZ

Tandem Wealth Advisors LLC reported $197,355,083 across 49 holdings for the quarter ended 2024-09-30, in a 13F-HR filed 2024-11-13. Its ten largest share positions make up 78% of the portfolio.

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

Period
2024-09-30
Reported value
$197M
Holdings
49
Top 10 weight
78%
New
1
Sold out
2

Largest buys vs the previous quarter

SecurityShares changeApprox. value
RSPadded+8,423$1.51M
DGROadded+20,213$1.27M
AVGOadded+3,116$538K
AMZNadded+1,824$340K
METAadded+556$318K

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
EFAreduced-42,055-$3.52M
DEexited-645-$241K
FTNTexited-3,624-$218K
Vreduced-602-$166K
SPYreduced-211-$121K

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 2024

Share positions as resolved from 13F-HR 0001986042-24-000019, largest first. % of portfolio is the value over $197,355,083, the sum of the share positions whose value is usable for ratios (method).

SecurityHistorySharesValue% of portfolioChangeLatest eventTimeline
AGGISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 364,935 shares 364,935$37M18.73%+3,135Timeline
MDYSTATE STR SPDR S&P MIDCAP 40Quarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 32,805 shares 32,805$18.7M9.47%+94Timeline
EFAISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 208,921 shares 208,921$17.5M8.85%-42,055Timeline
MBBISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 138,340 shares 138,340$13.3M6.72%+2,532Timeline
DGROISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 211,311 shares 211,311$13.2M6.71%+20,213Timeline
VCSHVANGUARD SCOTTSDALE FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 159,719 shares 159,719$12.7M6.43%+1,174Timeline
SPYSTATE STR SPDR S&P 500 ETF TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 20,368 shares 20,368$11.7M5.92%-211Timeline
RSPINVESCO EXCHANGE TRADED FD TQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 65,198 shares 65,198$11.7M5.92%+8,423Timeline
QQQINVESCO QQQ TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 19,758 shares 19,758$9.64M4.89%-152Timeline
IJRISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 73,790 shares 73,790$8.63M4.37%-248Timeline
VGTVANGUARD WORLD FDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 11,956 shares 11,956$7.01M3.55%-128Timeline
EEMISHARES TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 139,372 shares 139,372$6.39M3.24%+1,282Timeline
VTIVANGUARD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 18,836 shares 18,836$5.33M2.7%+93Timeline
XLVSELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 31,657 shares 31,657$4.88M2.47%-145Timeline
BNDVANGUARD BD INDEX FDSQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 32,642 shares 32,642$2.45M1.24%+1,010Timeline
MSFTMICROSOFT CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 2,951 shares 2,951$1.27M0.64%+222Timeline
AAPLAPPLE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 4,589 shares 4,589$1.07M0.54%+6Timeline
AMZNAMAZON COM INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 5,593 shares 5,593$1.04M0.53%+1,824Timeline
GOOGLALPHABET INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 4,961 shares 4,961$823K0.42%-36Timeline
METAMETA PLATFORMS INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 1,394 shares 1,394$798K0.4%+556Timeline
COSTCOSTCO WHOLESALE CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 884 shares 884$784K0.4%+65Timeline
NVDANVIDIA CORPORATIONQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 5,115 shares 5,115$621K0.31%-345Timeline
AVGOBROADCOM INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 3,473 shares 3,473$599K0.3%+3,116Timeline
LLYELI LILLY & COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 653 shares 653$579K0.29%-40Timeline
PNCPNC FINL SVCS GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 3,018 shares 3,018$558K0.28%0Timeline
XLESELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 6,315 shares 6,315$554K0.28%+109Timeline
KLACKLA CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 713 shares 713$552K0.28%+64Timeline
ICEINTERCONTINENTAL EXCHANGE INQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 3,087 shares 3,087$496K0.25%+445Timeline
TMOTHERMO FISHER SCIENTIFIC INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 791 shares 791$489K0.25%+10Timeline
UNHUNITEDHEALTH GROUP INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 834 shares 834$488K0.25%+53Timeline
PGPROCTER & GAMBLE COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 2,676 shares 2,676$463K0.23%+96Timeline
LINLINDE PLCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 891 shares 891$425K0.22%+66Timeline
JPMJPMORGAN CHASE & COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 1,980 shares 1,980$418K0.21%-20Timeline
GEHCGE HEALTHCARE TECHNOLOGIES IQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 4,195 shares 4,195$394K0.2%-29Timeline
CATCATERPILLAR INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 995 shares 995$389K0.2%-11Timeline
CBCHUBB LIMITEDQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 1,342 shares 1,342$387K0.2%-15Timeline
NEENEXTERA ENERGY INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 4,578 shares 4,578$387K0.2%+374Timeline
ETNEATON CORP PLCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 1,143 shares 1,143$379K0.19%+31Timeline
BXBLACKSTONE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 2,395 shares 2,395$367K0.19%-31Timeline
ADBEADOBE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 677 shares 677$351K0.18%+50Timeline
TJXTJX COS INC NEWQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 2,773 shares 2,773$326K0.17%-32Timeline
SHWSHERWIN WILLIAMS COQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 841 shares 841$321K0.16%-5Timeline
PHPARKER-HANNIFIN CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 503 shares 503$318K0.16%newTimeline
BACBANK OF AMER CORPQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 7,736 shares 7,736$307K0.16%-23Timeline
XLRESELECT SECTOR SPDR TRQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 6,636 shares 6,636$296K0.15%+23Timeline
HDHOME DEPOT INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 715 shares 715$290K0.15%-10Timeline
VVISA INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 1,041 shares 1,041$286K0.15%-602Timeline
AZOAUTOZONE INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 84 shares 84$265K0.13%0Timeline
HONHONEYWELL INTL INCQuarterly shares; oldest to newest; scale is this security's eight-quarter maximum; 2022Q4: restricted; 2023Q1: restricted; 2023Q2: restricted; 2023Q3: restricted; 2023Q4: restricted; 2024Q1: restricted; 2024Q2: restricted; 2024Q3: 1,243 shares 1,243$257K0.13%+50Timeline

Sold out in Q3 2024

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

SecurityShares beforeValue beforeType
DEDEERE & CO645$241Kshares
FTNTFORTINET INC3,624$218Kshares

How Q3 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 0001986042-24-000019 base2024-11-13acceptance time not in the bulk data set