It’s time for the weekly review of positions in the HYHRD (High Yield High Return Dividend) portfolio.
The spreadsheet for each individual account are now found in the Google docs spreadsheet.
This post examines the spreadsheet for all positions sold in the accounts. The only screenshot from the MS Excel workbook that I will post has all the aggregate information (the tradelogs spreadsheet).
I will also post screenshots (see below) from the Thomas Dividend Manager program (link below in the weekly update) for each account in our portfolio.
Not currently tracked or reported is my wife’s TSA, except for quarterly updates on the 2016 Balances sheet.
“Smithers, release the hounds!”
- To date:
- ind-PandA (formerly brokerage-A) shows Total Net Profit of $4,905.92.
- Roth-A shows Total Net Profit of $10,276.27.
- IRA-A shows Total Net Loss of -$5,281.17.
- PandAjoint (formerly Computershare, formerly brokerage-P) shows Total Net Profit of $1,875.85.
- Roth IRA-P shows Total Net Profit of $7,369.04.
- IRA-P shows Total Net Loss of -$3,301.11.
- Overall, the HYHRD (High Yield High Return Dividend) portfolio shows a Total Net Profit of $2,540.53.
- Expected Dividends now shows $14,811.78 per year (from the Google sheets, for all holdings).
All figures are ‘since inception in 2012’ and dates vary from account to account.
Let’s see how the rest of it breaks down;
Here’s what the #HYHRD (High Yield High Return Dividend) portfolio tradelogs spreadsheet looks like today;
This spreadsheet shows;
- Total NET Profit / Loss and breaks it down for each account
- Total Dividends Received each year and breaks it down for each account
- Due to adustments in cost basis from converting IRA holdings to Roth IRA holdings, losses have now been REALIZED.
- Of course, any REALIZED losses also resulted in a lower cost basis in the Roth IRA account(s).
- Losses have also been realized from sales of underperforming stocks. Proceeds have been invested in preferred shares.
This data is further broken down on each separate sheet in this spreadsheet (but not shown to save time and space).
- June 25th Update
- I continue to use the new program called TDM (Thomas Dividend Manager) from www.dividendsoftware.com.
- Monthly withdrawals from settled cash in our accounts continue to augment our income.
- Withdrawals are subject to a minimum withdrawal amount of $10.00 (No withdrawals will be taken if under $10.00).
- Most holdings show major declines in equity. I will no longer reinvest dividends except in my IRA and 1 other stock.
- Capital One Investing (sharebuilder) Automatic Investment Plan invested $119 each in cxe, mav, & mhi & $184 each in cmu, mfm & nmz on 6/7/16.
- Automatic investments will usually take place on the 2nd & 4th Tuesday of every month.
- No common stocks will be DRIPped. Preferred shares can NOT be DRIPped (They are, after all, for income & not growth).
- All CEFs in my IRA, my Roth IRA, and our joint taxable accounts will be DRIPped. Nothing in my wife’s Roth IRA will be DRIPped.
- On 3/23, STO 2 AI OCT 21 2016 15.00 CALLs for $.25 with $6.45 commission for net proceeds of $43.55
- On 4/12, STO 3 CNSL Oct 21 2016 $25 Calls for $1.20 with $7.20 commission for net proceeds of $352.80
- On 4/12, STO 1 DRAD Sep 16 2016 $7.50 Call for $.05 with $4.99 commission for net proceeds of $0.01
- On 5/23, STO 5 BGCP Aug 19 2016 $10 Calls for $.10 with $8.70 commission for net proceeds of $41.30
- On 6/20, STO 3 GSB Dec 16 2016 $5 Calls for $.25 with $7.20 commission for net proceeds of $67.80
- On 6/20, found & corrected several errors on the Google sheets where it was not counting the last item(s).
Here’s a look at our balances from the 2016 Balances sheet (updated ~monthly, and usually a week or so late);
And, here are the current screenshots of the accounts in our portfolio from the TDM program (monthly paying issues are highlighted);