Portfolio Slicer

Fixed Income ETF Selection

January 30, 2021 by Roger Kobel

Bucket 2 in the ETF Retirement Strategy is Fixed Income. For this bucket, we attempted to pick a “best in class” ETF for each of the five (5) categories:

Morningstar /Schwab Fund Category	ETF
Long Government Bonds	EDV – Vanguard Extended Duration Treasury Index Fund ETF Shares
Emerging Market Bonds	EMB – Shares JPMorgan USD Emerging Markets Bond ETF
Municipal Bonds	MUB – iShares National Muni Bond ETF
Long Term Bonds	VCLT – Vanguard Long Term Corporate Bond ETF
World Bond – US Hedged	BNDX – Vanguard Total International Bond Index Fund ETF Shares

As with the Equity ETF’s, our desire is for the asset correlation to be less then .70. read more

Equity ETF Selection

January 30, 2021 by Roger Kobel

As I shared in a previous post, Mark and I have been on a journey of selecting a portfolio of ETF’s to include in the modified three bucket approach.

After various iterations and experiments, we have settled on a “Magic 8” as the Equity portion of the portfolio (our buckets 3 and 4). At the core of the eight (8) are a set of five (5) sector ETFs from George Dagnino with one substitution: read more

Algorithm Comparison to Previous Versions

January 21, 2021January 18, 2021 by Roger Kobel

Attached are comparison’s of the latest algorithm to two previous versions. In version 44, we attempted to replace and remove select ETF’s to see the impact. Overall Annual RoR increased from 8.34% to 8.41%.

In version 45.2, Annual RoR increased to 9.49% by Mark introducing economic indicators into the model. I will let “the Dr.” go into more detail about the changes.

For those who want to explore the data/results in more detail, I will post/share the Power BI report in the Portfolio Slicer topic area. The latest data from v45.2 is already loaded into the model. I will elaborate in more detail about the Power BI report in that post. read more

V45.2 Trading Report Portfolio slicer

January 20, 2021January 18, 2021 by Roger Kobel

Attached is a customized version of the Portfolio Slicer Power BI report containing v45.2 of the trading model. Attempts to refresh will fail since the data connections point to the Excel spreadsheet and PSData folders where data from external data sources are loaded (e.g. quotes and dividends).

The first several pages are additions to v2.4 of the PBI report from the Portfolio Slicer site. Some of the original pages have been modified and others are in development… the latter should be obvious.

I am still learning the data model and the meaning of many measures and am not an expert. I know enough about Power BI and Power Query to be somewhat productive and a little DAX. If anyone has DAX or MDX experience, please let me know so I can reach out to you for assistance if/when needed.

I will attempt to answer any question and welcome requests to improve the reporting which is evolving. read more

V45.2 Profitability

January 20, 2021January 18, 2021 by Roger Kobel

This is the profitability by ETF from the latest iteration (v45.2) of the model trades from a page in a customized Power BI (PBI) version of Portfolio Slicer (PS). Trades from the model are loaded into the PS Excel workbook using some semi-automation we have developed.

Shown is overall profitability based upon trading the ETF (Sales Capital Gain), Dividends and Unrealized Capital Gains for those ETF’s currently being held. Dividends are from Yahoo using the external date scripts available as part of PS.

A comparison to previous iterations will be posted shortly. read more

January 20, 2021January 16, 2021 by Mark Bates

I use this software to give me an aggregate look at the overall investment status on a daily basis by bucket. It is free, and uses Excel and Power BI as its toolset so it will be around a while, and my data stays local on my machine.

Not sure I mentioned it before.

I updated the Power BI view to also give me a stock chart, so I can run this daily to update the quotes (free) and look at both allocations and individual stock prices.

Probably been using it for 3 years give or take. Replaced Quicken with it. Also just to humor myself I loaded every stock trade I made over the past 15 years so I can see some aggregate data.

http://www.portfolioslicer.com/ read more

Miley Growth Fund

[stock_market_widget type=”table-portfolio” template=”basic” assets=”ANET,KLAC,LRCX,FTNT,AMAT,NVDA,KKR,KLIC,NFLX,NXST,LULU,ADBE,FB,FIVE,INTU,FND,AMZN,ARES,PYPL,PAYC” fields=”symbol,change_pct” search=”false” display_currency_symbol=”true” pagination=”true” rows_per_page=”30″ sort_field=”change_pct” sort_direction=”desc” alignment=”left” api=”yf” portfolio=”{‘ALGN’:{‘qty’:3.48,’p_price’:525.38},’FTNT’:{‘qty’:12.62,’p_price’:144.75},’ADBE’:{‘qty’:3.98,’p_price’:458.77},’SLM’:{‘qty’:131.65,’p_price’:13.88},’LULU’:{‘qty’:5.56,’p_price’:328.68},’NVDA’:{‘qty’:3.52,’p_price’:519.59},’NFLX’:{‘qty’:3.43,’p_price’:532.39},’ASML’:{‘qty’:3.42,’p_price’:534.16},’FB’:{‘qty’:7.07,’p_price’:258.33},’BLDR’:{‘qty’:47.77,’p_price’:38.25},’LAD’:{‘qty’:5.73,’p_price’:318.68},’VIPS’:{‘qty’:66.64,’p_price’:27.42},’FND’:{‘qty’:19.85,’p_price’:92.07},’OLLI’:{‘qty’:19.29,’p_price’:94.73},’MPWR’:{‘qty’:5.14,’p_price’:355.29},’EPAM’:{‘qty’:5.31,’p_price’:344.43},’BABA’:{‘qty’:7.2,’p_price’:253.83},’PYPL’:{‘qty’:7.8,’p_price’:234.31},’GOOGL’:{‘qty’:1,’p_price’:1827.36},’MKSI’:{‘qty’:11.56,’p_price’:158.07}}” ]

Miley Income Fund

[stock_market_widget type=”table-portfolio” template=”basic” assets=”XOM,PM,IRM,NNN,ABBV,FE,FHN,MRK,PDCO,AMGN,EOG,VTRS,RF,MET,PRU,CFG,OGE,DOW,LMT,JEPI” fields=”symbol,change_pct” search=”false” display_currency_symbol=”true” pagination=”false” rows_per_page=”30″ sort_field=”change_pct” sort_direction=”desc” alignment=”left” api=”yf” portfolio=”{‘PM’:{‘qty’:4.08,’p_price’:79.65},’PRU’:{‘qty’:4.15,’p_price’:78.28},’DOW’:{‘qty’:6.26,’p_price’:51.9},’OGE’:{‘qty’:10.64,’p_price’:30.52},’PFE’:{‘qty’:9.05,’p_price’:35.9},’CFG’:{‘qty’:8.92,’p_price’:36.44},’WU’:{‘qty’:14.59,’p_price’:22.27},’MET’:{‘qty’:6.75,’p_price’:48.15},’CC’:{‘qty’:12.33,’p_price’:26.34},’FITB’:{‘qty’:11.23,’p_price’:28.93},’DTE’:{‘qty’:2.73,’p_price’:118.86},’RF’:{‘qty’:19.1,’p_price’:17.01},’CAH’:{‘qty’:6.05,’p_price’:53.73},’SNV’:{‘qty’:8.73,’p_price’:37.2},’JEF’:{‘qty’:13.91,’p_price’:23.35},’MRK’:{‘qty’:4.22,’p_price’:77.07},’GPC’:{‘qty’:3.46,’p_price’:93.88},’MMM’:{‘qty’:1.85,’p_price’:175.66},’LMT’:{‘qty’:1,’p_price’:324.88},’JEPI’:{‘qty’:5.89,’p_price’:55.2}}” ]