13F-HR filed by Tranquilli Financial Advisor LLC
Tranquilli Financial Advisor LLC filed this 13F-HR for the quarter ended 2024-06-30, filed 2024-08-13, with 109 holding rows worth $149,361,892.
- Accession
- 0001214659-24-014273
- Filer
- CIK 1847769
- Filed
- 2024-08-13
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q2 2024
A holdings report, 109 entries on the cover page, a total value of $149,361,892 stated on the cover page (in dollars after the unit check, H1), rows summing to $149,361,892 with VALUE read as dollars as filed, 13F file number 028-21071. The quarter's positions are built on this report. The resolved quarter.
The information table after summing rows of one CUSIP and put or call (H4), with the CUSIP and issuer name as filed. Values in dollars after the unit check (method).
| Issuer as filed | CUSIP | Class | Amount | Value | Value read as | Type |
|---|---|---|---|---|---|---|
| SPDR Portfolio S&P 500 Growth ETF | 78464A409 | SHS | 96,535 | $7,791,340 | dollars as filed | |
| ISHARES MSCI USA QUALITY FACTOR ETF | 46432F339 | ETF | 33,806 | $5,761,557 | dollars as filed | |
| VGT | 92204A702 | SHS | 9,342 | $5,439,380 | dollars as filed | |
| DIMENSIONAL ETF TRUST | 25434V880 | WORLD EX US CORE | 212,904 | $5,420,536 | dollars as filed | |
| Vanguard Communication Services ETF | 92204A884 | SHS | 38,227 | $5,264,240 | dollars as filed | |
| SPDW | 78463X889 | COM | 136,684 | $4,798,975 | dollars as filed | |
| VANGUARD WORLD FD | 92204A405 | FINANCIALS ETF | 47,900 | $4,793,832 | dollars as filed | |
| Vanguard Energy ETF | 92204A306 | SHS | 37,400 | $4,770,744 | dollars as filed | |
| Vanguard Utilities ETF | 92204A876 | SHS | 32,257 | $4,730,166 | dollars as filed | |
| VANGUARD WORLD FD | 92204A603 | INDUSTRIAL ETF | 20,071 | $4,658,881 | dollars as filed | |
| VANGUARD HEALTH CARE ETF | 92204A504 | ETF | 17,085 | $4,523,254 | dollars as filed | |
| INVESCO QQQ TR | 46090E103 | COM | 9,339 | $4,500,651 | dollars as filed | |
| Vanguard Materials ETF | 92204A801 | SHS | 23,122 | $4,390,637 | dollars as filed | |
| SPDR SER TR | 78464A508 | PRTFLO S&P500 VL | 88,870 | $4,311,084 | dollars as filed | |
| Vanguard Real Estate | 922908553 | SHS | 51,310 | $4,257,191 | dollars as filed | |
| Vanguard Consumer Discretionary ETF | 92204A108 | SHS | 13,519 | $4,222,119 | dollars as filed | |
| Vanguard Consumer Staples ETF | 92204A207 | SHS | 20,658 | $4,168,165 | dollars as filed | |
| DIMENSIONAL ETF TRUST | 25434V708 | US CORE EQUITY 2 | 96,261 | $3,099,604 | dollars as filed | |
| SPDR Portfolio Emerging Markets ETF | 78463X509 | SHS | 69,234 | $2,612,891 | dollars as filed | |
| SPDR SERIES TRUST | 78464A474 | ST SHOR CORP ETF | 79,865 | $2,362,407 | dollars as filed | |
| Berkshire Hathaway Inc | 084670702 | COM | 5,312 | $2,152,369 | dollars as filed | |
| SPDR Bloomberg 1-3 Month T-Bill ETF | 78468R663 | SHS | 17,413 | $1,591,896 | dollars as filed | |
| Amazon.com, Inc | 023135106 | COM | 7,601 | $1,498,917 | dollars as filed | |
| VANECK ETF TRUST | 92189F437 | COM | 52,613 | $1,478,951 | dollars as filed | |
| META PLATFORMS INC CL A | 30303M102 | COM | 2,917 | $1,472,152 | dollars as filed | |
| iShares MSCI USA Min Vol Factor ETF | 46429B697 | SHS | 16,345 | $1,369,057 | dollars as filed | |
| DBX ETF TR | 233051432 | XTRACK USD HIGH | 38,685 | $1,364,033 | dollars as filed | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 28,143 | $1,362,684 | dollars as filed | |
| SSGA ACTIVE ETF TR | 78467V848 | ST STR TOTAL ETF | 34,362 | $1,352,832 | dollars as filed | |
| Booking Holdings Inc. | 09857L108 | COM | 344 | $1,336,399 | dollars as filed | |
| Microsoft Corp | 594918104 | COM | 2,707 | $1,236,368 | dollars as filed | |
| JANUS DETROIT STR TR | 47103U852 | HENDERSON MTG | 27,858 | $1,229,374 | dollars as filed | |
| BERKSHIRE HATHAWAY INC DEL | 084670108 | CL A | 2 | $1,220,920 | dollars as filed | |
| IJH | 464287507 | COM | 20,288 | $1,176,095 | dollars as filed | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 6,370 | $1,175,201 | dollars as filed | |
| JPMorgan Chase & Co | 46625H100 | COM | 5,482 | $1,126,277 | dollars as filed | |
| SPY | 78462F103 | SHS | 2,048 | $1,116,856 | dollars as filed | |
| INVESCO EXCHANGE-TRADED FD TR S&P 500 EQUAL WEIGHT ETF | 46137V357 | COM | 6,735 | $1,097,468 | dollars as filed | |
| iShares Core Dividend Growth ETF | 46434V621 | SHS | 18,841 | $1,082,792 | dollars as filed | |
| Charles Schwab Corp | 808513105 | COM | 14,411 | $1,058,056 | dollars as filed | |
| Oracle Corporation | 68389X105 | COM | 7,184 | $1,027,959 | dollars as filed | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 19,629 | $943,370 | dollars as filed | |
| Wells Fargo & Company | 949746101 | COM | 15,362 | $930,784 | dollars as filed | |
| Vanguard Intermediate-Term Bond ETF | 921937819 | SHS | 12,458 | $925,131 | dollars as filed | |
| VANGUARD BD INDEX FDS | 921937793 | LONG TERM BOND | 12,987 | $898,181 | dollars as filed | |
| Philip Morris International Inc. | 718172109 | COM | 7,892 | $799,065 | dollars as filed | |
| ISHARES TR | 464288661 | 3 7 YR TREAS BD | 6,944 | $796,685 | dollars as filed | |
| EXXON MOBIL CORP | 30231G102 | COM | 6,838 | $786,096 | dollars as filed | |
| VANGUARD WORLD FD | 921910709 | EXTENDED DUR | 10,910 | $771,664 | dollars as filed | |
| Comcast Corp | 20030N101 | COM | 19,881 | $758,858 | dollars as filed | |
| iShares MSCI Japan ETF | 46434G822 | SHS | 10,959 | $742,911 | dollars as filed | |
| CARMAX INC COM | 143130102 | Stock | 9,762 | $695,152 | dollars as filed | |
| Visa Inc | 92826C839 | COM | 2,613 | $687,846 | dollars as filed | |
| ISHARES TR | 46435G326 | CORE MSCI INTL | 10,365 | $681,395 | dollars as filed | |
| iShares MSCI USA Momentum Factor ETF | 46432F396 | SHS | 3,486 | $680,467 | dollars as filed | |
| ConocoPhillips | 20825C104 | COM | 5,715 | $653,567 | dollars as filed | |
| Elevance Health, Inc. | 036752103 | COM | 1,221 | $652,686 | dollars as filed | |
| HARTFORD FDS EXCHANGE TRADED | 41653L305 | TOTAL RTRN ETF | 18,650 | $620,859 | dollars as filed | |
| FIRST TRUST TCW OPPORTUNISTIC | 33740F805 | TCW OPPORTUNIS | 14,414 | $617,928 | dollars as filed | |
| PIMCO ETF TR | 72201R775 | ACTIVE BD ETF | 6,790 | $611,168 | dollars as filed | |
| BANK OF NY MELLON CORP COM | 064058100 | Stock | 10,089 | $606,450 | dollars as filed | |
| ISHARES MSCI EAFE MIN VOL FACTOR ETF | 46429B689 | ETF | 7,913 | $548,450 | dollars as filed | |
| GENERAL DYNAMICS CORP COM | 369550108 | Stock | 1,845 | $531,120 | dollars as filed | |
| Analog Devices,Inc. | 032654105 | COM | 2,300 | $517,914 | dollars as filed | |
| EBAY INC. COM | 278642103 | Stock | 9,467 | $498,722 | dollars as filed | |
| iShares TIPS Bond ETF | 464287176 | SHS | 4,661 | $493,693 | dollars as filed | |
| ISHARES 10 Y INVE GRADE COR B | 464289511 | 10+ YR INVST GRD | 9,859 | $486,837 | dollars as filed | |
| NOVARTIS AG SPONSORED ADR | 66987V109 | ADR | 4,382 | $466,858 | dollars as filed | |
| TAIWAN SEMICONDUCTOR MFG | 874039100 | SPONSORED ADS | 2,689 | $463,395 | dollars as filed | |
| AMNEAL PHARMACEUTICALS INC | 03168L105 | COM STK CL A | 71,414 | $458,478 | dollars as filed | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 2,502 | $457,841 | dollars as filed | |
| UNILEVER PLC | 904767704 | SPON ADR NEW | 7,940 | $434,318 | dollars as filed | |
| SANOFI SA SPONSORED ADR | 80105N105 | ADR | 8,549 | $423,945 | dollars as filed | |
| BECTON DICKINSON & CO | 075887109 | COM | 1,819 | $417,042 | dollars as filed | |
| Medtronic Plc | G5960L103 | COM | 5,163 | $398,171 | dollars as filed | |
| J P MORGAN EXCHANGE TRADED F BETABUILDERS EUR | 46641Q191 | BETABUILDERS EUR | 6,548 | $387,806 | dollars as filed | |
| MCKESSON CORP COM | 58155Q103 | Stock | 647 | $379,362 | dollars as filed | |
| ISHARES TR | 464287432 | 20 YR TR BD ETF | 4,024 | $361,798 | dollars as filed | |
| Qualcomm Incorporated | 747525103 | COM | 1,788 | $357,654 | dollars as filed | |
| IQVIA HLDGS INC COM | 46266C105 | Stock | 1,654 | $344,842 | dollars as filed | |
| Johnson & Johnson | 478160104 | COM | 2,306 | $337,691 | dollars as filed | |
| PepsiCo,Inc. | 713448108 | COM | 1,842 | $300,043 | dollars as filed | |
| SPDR S&P Metals & Mining ETF | 78464A755 | SHS | 4,973 | $299,474 | dollars as filed | |
| MasterCard, Inc | 57636Q104 | COM | 673 | $294,512 | dollars as filed | |
| Energy Select Sector SPDR Fund | 81369Y506 | SHS | 3,199 | $291,749 | dollars as filed | |
| VANECK ETF TRUST | 92189F676 | COM | 1,103 | $287,894 | dollars as filed | |
| Lockheed Martin Corporation | 539830109 | COM | 595 | $277,532 | dollars as filed | |
| Bank of America Corp | 060505104 | COM | 6,781 | $271,308 | dollars as filed | |
| Starbucks Corporation | 855244109 | COM | 3,462 | $267,024 | dollars as filed | |
| ENBRIDGE INC COM | 29250N105 | Stock | 7,509 | $264,842 | dollars as filed | |
| Apple Inc | 037833100 | COM | 1,199 | $259,883 | dollars as filed | |
| FISERV INC | 337738108 | COM | 1,701 | $250,285 | dollars as filed | |
| OMNICOM GROUP INC COM | 681919106 | Stock | 2,822 | $247,461 | dollars as filed | |
| DIAGEO PLC SPON ADR NEW | 25243Q205 | ADR | 1,840 | $231,601 | dollars as filed | |
| Walt Disney Co | 254687106 | COM | 2,333 | $228,727 | dollars as filed | |
| CVS Health Corporation | 126650100 | COM | 3,834 | $222,947 | dollars as filed | |
| INVESCO EXCHANGE TRADED FD T | 46137V118 | GBL LISTED PVT | 3,610 | $219,849 | dollars as filed | |
| INGREDION INC COM | 457187102 | Stock | 1,900 | $216,163 | dollars as filed | |
| Raytheon Technologies Corporation | 75513E101 | COM | 2,169 | $215,924 | dollars as filed | |
| Bristol-Myers Squibb Company | 110122108 | COM | 5,156 | $212,943 | dollars as filed | |
| EVERSOURCE ENERGY COM | 30040W108 | Stock | 3,716 | $210,177 | dollars as filed | |
| NEW YORK COMMUNITY BANCORP | 649445103 | COM | 64,665 | $209,515 | dollars as filed | |
| AIR PRODS & CHEMS INC | 009158106 | COM | 845 | $209,002 | dollars as filed | |
| CHECK POINT SOFTWARE TECH LTD ORD | M22465104 | Stock | 1,265 | $208,725 | dollars as filed | |
| CENCORA INC COM | 03073E105 | Stock | 903 | $201,848 | dollars as filed | |
| Adobe Inc | 00724F101 | COM | 359 | $201,044 | dollars as filed | |
| LLOYDS BANKING GROUP PLC SPONSORED ADR | 539439109 | ADR | 50,333 | $140,429 | dollars as filed | |
| HANESBRANDS INC | 410345102 | COM | 12,776 | $61,964 | dollars as filed | |
| AMBEV SA SPONSORED ADR | 02319V103 | ADR | 13,979 | $28,517 | dollars as filed |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001214659-24-014273 | this filing | 2024-08-13 | acceptance time not in the bulk data set |