BDC GOOGLE SHEETS
There are currently 25 BDCs included:
AINV, ARCC, BBDC, CCT, CGBD, FDUS, FSIC, GAIN, GBDC, GLAD, GSBD, HTGC, MAIN, MCC, MRCC, NMFC, OCSL, PFLT, PNNT, PSEC, SUNS, TCPC, TCRD, TPVG, and TSLX
Also included are the following Preferred Stocks and Baby Bonds:
GAINL, GAINM, AFC, AIY, CPTAL, HCXY, HCXZ, HTGX, KAP, MCV, MCX, NEWTZ, OCSLL, OSLE, PBB, TCRX, TCRZ, TPVY, WHFBL
Please allow up to 24 hours (on weekends and holidays) to receive
information to access all reports or links. E-mail me directly if
you have questions: firstname.lastname@example.org
- Currently, there are various worksheets as shown below including Suggested BDC Portfolios,
BDC Ranking Tiers and Baby Bonds. BDC pricing can be volatile and Google Sheets
tracks real-time changes to pricing compared to my price targets so that investors can
make quick decisions.
- Recommendation Categories: After investors have identified BDCs that fit their risk profile,
I categorize investors’ needs for each BDC holding using the following:
- Investors looking to start a position. Dipping your toe in.
- Investors looking to grow a position to a full/appropriate allocation.
- Investors looking to opportunistically add to a position beyond a full/appropriate allocation.
- Mostly for dividend income.
- Dividend income + 5% capital gains within 12 months.
- Dividend income + 10% capital gains within 12 months.
- This is for investors that do not currently have a meaningful position in a certain BDC and would like to “dip their toe in” with a starter position and then continue to buy more on the dips. I suggest buying a small number of shares closer to its short-term target price.
- This is for investors that already have smaller positions and would like to grow them to a full/proper allocation for a diversified portfolio. I suggest adding to these positions at prices closer to 5% below its short-term target price potentially after equity offerings as discussed in previous articles.
- This is for investors that already have full positions and would likely only add at opportunistic prices of around 10% below target prices potentially during general market volatility and pullbacks. Active traders might choose to sell these shares for capital gains at a later date to re-balance the portfolio.
Relative Strength Index (RSI):
“The relative strength index (RSI) is a momentum indicator developed by noted technical analyst Welles Wilder, that compares the magnitude of recent gains and losses over a specified time period to measure speed and change of price movements of a security. It is primarily used to attempt to identify overbought or oversold conditions in the trading of an asset. Traditional interpretation and usage of the RSI is that RSI values of 70 or above indicate that a security is becoming overbought or overvalued, and therefore may be primed for a trend reversal or corrective pullback in price. On the other side of RSI values, an RSI reading of 30 or below is commonly interpreted as indicating an oversold or undervalued condition that may signal a trend change or corrective price reversal to the upside.”
This is a complicated formula because it takes into account changes in daily pricing over a rolling 365 days which takes time to process (as the price changes). I have not found this indicator available in table format with other online services.
I have color coded the RSI values with green showing closer to 30 (indicating oversold), yellow showing near 50 and red showing closer to 70 (indicating overbought). I include a chart with stock pricing and RSI in my “Deep Dive” reports for each BDC showing that I have made many purchases when its RSI is closer to 30.
I have found a way to measure the average volume being traded for all BDCs to see if it is an active or slow trading day for the sector and then look at individual BDCs to see if they are trading above or below that average (given the time of day).
This is important because investors should know when volumes might be indicating something meaningful is going on with the stock, whether positive or negative.