Dividend Liberty Application Update (July 2016)

Its been a while since I’ve made an update but I’ve made some significant changes to my Dividend Liberty Application. You can download the latest version on this page for free. A few major changes includes:

  • Added the ability to cache stock information. Dramatically increases the speed of the application after initial load.
  • Changed the design of the application. Instead of a horizontal view it is now a vertical view.
  • The generated Excel sheet now includes formulas for the annual dividends paid column (calculated from the shares multiplied by annual dividend paid from the stock).

 

Cached Stock Information:

Before the update, every time the user double clicked on a stock, the application would ping Yahoo Finance to gather the stock’s information. Now with the cached features, this is done before the initial load of the application. All of your stock’s information in your list before the application loads will be cached for use. This dramatically speeds up the overall experience.

Another issue that caching resolves is the errors for calculating your stock’s information due to Yahoo’s server being down. This would cause the application to be unusable until the server is back up. Now if Yahoo is down, the previously cached information would be used. Also, once the server is back up and the next time you launch the application (also have the option to refresh yahoo while the app is running), the application will update the necessary information with the latest information.

The third advantage from caching is the speed of moving your stocks in and out of your my portfolio section. It is almost instantaneous now since it reads the data to make calculations from the cached file instead of making the live connection to Yahoo Finance.

One disadvantage is that it takes a bit longer than usual on the initial load of the application. The reason being is that on the initial load, the app is connected to Yahoo’s server to gather all the relevant information for your list of stocks and to update the cached file respectively. For example, if EPS for the stock hasn’t changed then it will not update that information in the cached file. The same loading time goes up when you add a new stock or updating stock information.

 

Design Change:

DividendLibertyNewLookJuly2016

I’ve changed the design so that the application will be used vertically instead of horizontally. The reason for this change was when I realized that the application would not be view-able in every resolution. I noticed this when I was developing on my 27″ monitor with a high resolution then in the middle of the day, I jumped to my 15″ monitor. I realized that the application could not fully fit onto my screen. I resolved this issue by stacking the “My Portfolio” section below the “Not In Portfolio” section. I thought the result was a more pleasant experience as your eyes did not have to span across the screen as much in this view.

Another major change is that now the application will show you the live version of the total portfolio cost basis and annual dividends. Also the table will show you the cost basis of each stock, weight, annual dividend, and quarterly dividend.

 

Generated Excel Sheet:

DividendLibertyAppExcelJuly2016

I’ve made some changes to the generated spreadsheet where the yearly dividend amount paid to you is now a formula calculated from the number of shares column multiplied by the annual dividend received by the stock column. The reason why I did this was to take into consideration of the user so that they can reused the excel sheet. Now the user will be able to plug in and change their number of shares and the yearly dividend amount paid will be calculated due to the formula. I thought this excel sheet could be useful to the users who can generate this spreadsheet and plug it into their blogs instead of trying to update their existing spreadsheets manually. I plan on using this feature to generate my excel sheet and to plug it into the “My Portoflio” section of my blog. I’m currently using a free version of WordPress so I can’t use any plugins to include an excel sheet but in the future I will opt to use it. I hope to get some feedback with this application, thanks everyone!

June & July 2016 Buys!

Clorox_Product_logo.svgbw-hormel-lgaltria-share-logo

 

June has already come and gone and I’ve made some new purchases! I’ve also made changes to my 401k plan to start a brokerage link account to buy individual stocks.

I purchased 14 shares of MO (Altria) @ $67.47 for a total of $944.58. I’ve always wanted to own some Altria and I’ve finally done it! From my research, I don’t see a reason for me to wait until this stock has gone down in price because in viewing the history, this stock almost always never go down in price! Well except for the 2008 crash of course but then every stock went down during that time. I myself is not a smoker but even if I don’t believe in the product itself, it doesn’t mean that it will not do well in the future. I have friends who tried quitting and it is nearly impossible!

My second purchase (actually, July 11th) was in BF.B (Brown Forman). I bought 5 shares of BF.B @ 98.11 for a total of $490.55. I wanted to add more consumer staples and since I’ve already have beverage companies such as PEP (PepsiCo) and KO (Coca Cola), I wanted to buy an alcohol beverage company. Strong brand recognition such as Jack Daniels is all I needed to hear to invest in such a company. I think that the United States will have some hardships coming in the future and I’m trying to build my strength with consumer staples. People will want more alcohol during the next recession, possibly a depression! BF.B is also a dividend aristocrat with a low yield of 1.38%. With the low payout ratio of 26.82%, I think BF.B is a great growth stock.

Now the next two stocks that I bought is inside my 401k account. I recently started a new job back in the middle of March of this year and I found out that my company offers a brokerage link account from Fidelity. So I sold off a lot of my index fund and transferred over to buy some more dividend stocks! I decided to mimic my taxable account but added a couple of new stocks. I bought 8 shares of CLX (Clorox) @ $137.20 for a total of $1097.63. I really wanted to initiate a position in CLX for the longest and finally did it in my retirement account. One advantage is that I will not have to pay tax on the dividends received!

The second stock that I bought was HRL (Hormel Foods). I bought 19 shares of HRL @ $35.81 for a total of $680.39. Again this stock has a low yield but the payout ratio of 40% will allow this stock to have great growth in the future! The rest of the stocks in this portfolio is very similar to my taxable account, which is shown below:

Screen Shot 2016-07-12 at 8.14.38 PM

I started my 401k brokerage link account with a couple of gold and silver mining stocks, ABX (Barrick Gold) and SLW (Silver Wheaton). Well SLW is technically not a miner but they work with silver miners. I already have positions in my taxable account with EMR (Emerson Electric) and WMT (Walmart) but I’ve decided to add them because I find that these two companies are currently under valued. JNJ (Johnson & Johnson) is a bit over priced but I wanted to initiate a position and just because it has reached the 52 week high does not mean that it will not go any higher! I wanted to buy a position in T (AT&T) but I decided early on to chase growth rather than high yield with this account.

I hope to add more in the later half of July and in August. Every day I’m tempted to sell my Gold Miners and to add different dividend stocks from its profits but I will try to hold off a little bit longer before doing so!

Gold & Silver Miners Up in 2016, Brexit

gold mining

 

Before I go into gold and silver miners and my own personal investment strategy, I am not advocating anyone to follow my strategy nor to load up on gold mining stocks.

I haven’t made a post since my last buys but I wanted to talk a little bit about my gold and silver mining stocks and the status of my strategy of holding the miners to sell for a hefty profit to fund my dividend portfolio.

I own ABX (Barrick Gold Corp) and GDX (VanEck Vectors Gold Miners ETF) and so far in 2016 both are up significantly. My initial ABX position is up more than 200% and GDX is up almost 100%! I bought 150 shares of ABX @$7.095 back last October 2015. Since then I bought more shares because even at a much higher price now, I still believe that the price of gold is on a new bull run. Currently ABX sits at $22.21 a share. This price could easily double or triple as the world’s central bankers continue to devalue their currencies. Not to mention that back in 2008-2009, the price of gold rallied in a low interest rate environment.

Now there are many talking heads on the mainstream media saying that due to the outcome of Brexit, the Federal Reserve or specifically Janet Yellen would use it as a perfect excuse to cut rates back to zero. Yellen could potentially cut rates into the negative territory! Once that happens I expect physical gold and silver, and miners to significantly rally. Actually, the first person to say that the FED will start cutting rates with QE4 is from Peter Schiff. I heard him back late last year calling that the FED might not even raise interest rates but to cut them. I follow him regularly and listen to his podcast and to me his reasoning makes the most sense from any economist out there.

As of this writing, the 10 year Japanese and German bonds are yielding negative returns. I expect something similar to happen here in the United States. Can you imagine paying the banks to eventually hold your cash? The future plans from banks is to charge you small fees (regardless of having a minimum deposit on a linked savings account) to give you the ability to hold your cash. When we reach that point and I think that we will, people will want to park their cash into safe havens such as physical gold and silver, and miners. Not to mention dividend safe haven stocks. Funny thing happened after the decision of Brexit. Companies such as Clorox and AT&T shot up in just two days. I suspect that many investors sold their risky assets especially in the financial sector and mitigated into these companies. I expect the same to continue in the future months ahead.

I have a few regrets for selling too early. I sold 114 shares of SIL (Global X Silver Miners ETF) @ $16.2579 back in February 2016 for a loss. Currently SIL sits at $45.95 a share! This sell was necessary as I used the funds to buy an engagement ring to propose to my now fiancé! The only regret is that I should have sold another asset. But what is done is done and I should look forward to the future than to dwell in the past. Same goes for my NEM (Newmont Mining Corporation) and GG (Gold Corp) holdings.

My original plan was to be levered up on gold and silver mining stocks for rapid growth so that I can sell it for a hefty profit and to fund my dividend portfolio. So far the plan has come into fruition. I’ve invested a total of $5,232.28 into gold miners and currently it is worth $10,148.81, a +$4,916.54 increase in 7 months! If I had not sold my other miners, I would be up higher than $10,000 in profits. So as of this writing, if I were to sell my miners, I could potentially invest $4900 more into my dividend portfolio. I could add more to my current positions or buy 5 new companies. It sure is tempting to do that right now but I believe that gold is just starting on a bull run. I plan to hang on longer and one day perhaps a couple to a few years from now, I could potentially profit more than $20,000 if ABX and GDX continues its run!

Not only is the plan working but the gold mining stocks have maintained my portfolios balance. I’ve invested about $24,600 into my portfolio but currently it is up to more than $33,500 total! Gold miners outweighed my losses when the rest of my dividend stocks went down from my Initial buy. Many people sell and hold cash in their money market account and wait for a fire sale on dividends when the market plunges but my strategy is to hold gold miners instead. History has shown gold mining stocks to significantly rise in such events and I plan to cash out at that moment and buy up the dividend stocks at a fire sale! That would shave off years of buying dividends.

I truly believe that the gold prices of $1900 an ounce from 2011 is going to look very cheap compared to where it’s headed. If you read the history of Homestake mining (ABX bought Homestake out since December of 2001) during the Great Depression on my site, I think something very similar will occur in our future. If so, we will see gold miners become ten baggers (up 1000%)!

Another nice thing about these mining stocks is that they do pay a dividend. If a depression does hit, the mining companies could potentially surge so much so that their yield could sky rocket as they did in the great depression. The past won’t dictate the future but sometimes history does repeat itself.

Verizon & PepsiCo Buys

First Stocks Buys in 2016:

I’ve finally added some new stocks! I’m very excited since its been over 6 months since my last buy! I started out this early afternoon and bought 4 shares of PepsiCo @ 103.3794.

The reason why I bought PepsiCo is due to the international exposure and the health brands. I just love what Pepsi manufactures. I see some of their brands every day and I know that they make great products.  Products such as Quaker, 7Up, Mountain Dew, Brisk, Gatorade, Ruffles, Fritos, Lays, Cheetos, Lipton just to name a few.

After adding PepsiCo, I took a look at my portfolio and POT (Potash Corporation of Saskatchewan Inc.) caught my eye again. I decided to do some research on how Potash was doing and found articles about its revenues and their dividend cuts. This was old news because the article was written back earlier this January. I decided to sell the shares and instead bought Verizon (15 shares @ 51.162). I should have done this from the very beginning.

I know that Verizon is not considered a dividend aristocrat but it has been raising dividends for nearly a decade now. I believe that it will be one by the time I’m near retirement. Hopefully I will be able to add more stocks each month for the rest of the year. Please check back for more updates!

2015 Goals – Results

2015 Goals:

 

Well 2016 is here (well it’s been here for the past 2 months) and it looks like I have failed almost all of my goals. The only success that I’ve had was to get initially started in investing my dividends.

My first failure was to keep my expenses at $600 a month. There were some months that I did meet this goal and even got under budget but ultimately I had important things come up.

As for the second failure, which was directly related in result of the first failure, I could not invest $3000 more by the end of the year in 3 new stocks. Life changing expenses came up in my personal life and I even had to resort in selling my Silver ETFs (SIL).  Sometimes life changing events that allows you to grow in your personal life are more important than money.

As for the final failure, I have been tentatively monitoring, updating my portfolio, and  reinvesting my dividends but I’ve failed to update my blog once a month with new content. This blogging thing is a new experience for me but I hope to update my blog with new content as much as I can this year.

Now I have to write up new goals for myself to set for this year and even a simple thing such as this can be complicated. I should think very carefully of what goals I want to reach and make sure that it is realistic as well.

 

Dividend Income for 2015

Dividends Received

So the new year is here (well it’s been here for a while now) and for the three months in 2015, I’ve collected a total of $182.88! Below is a list of the dividends that I’ve received for each month.

October

  • ITW (Illinois Tool Works Inc) – $6.60 (.055 shares)
  • GG (Goldcorp Inc) – $1.54 (.062 shares)

 

November

  • CAT (Caterpillar Inc) – $12.32 (.173 shares)
  • CL (Colgate-Palmolive Company) – $6.08 (.093 shares)
  • GIS (General Mills Inc) – $7.92 (.1 shares)
  • PG (Procter & Gamble Company) – $9.28 (.123 shares)
  • POT (Potash Corporation Of Saskatchewan Inc) – $15.20 (.433 shares)
  • (AT&T) – $14.10 (.302 shares)

 

December

  • GDX (Barrick Gold Corp) – $19.37 (1.396 shares)
  • SO (Southern Co) – $11.94 (0.266 shares)
  • JNJ (Johnson & Johnson) – $8.25 (0.08 shares)
  • ADM (Archer Daniels Midland Co) – $6.72 (.19 shares)
  • EMR (Emerson Co) – $10.45 (.227 shares)
  • CVX (Chevron) – $14.98 (.172 shares)
  • XOM (Exxon) – $10.22 (.136 shares)
  • MMM (3M Co) – $7.18 (.048 shares)
  • ED (Consolidated Edison, Inc) – $9.10 (.142 shares)
  • KO (Cocal Cola) – $7.26 (.167 shares)
  • ABX (Barrick Gold Corp) – $3.06 (.343 shares)
  • GG (Goldcorp Inc) – $1.31 (.114 shares)

 

Since I’ve only started collecting in October of 2015 and not able to meet some of the ex-dividend dates, I hope to collect $700-$800 for the year 2016! I plan to add more dividend stocks to my portfolio but my budget has been taking a hit lately due to a recent purchase of a house with my girlfriend.

Recent Sell

I’ve recently sold my SIL (Global X Silver Miners ETF) because I needed the funds. It was painful to do so but some things need to be done to take care of business. I plan on not selling any of my current holdings in the future.

Dividend Liberty Application Release (Windows)

I’ve recently released my Dividend Liberty Application for free! You can download it here. The technical manual can be found in one of my blogs, https://dividendliberty.com/2016/02/03/dividend-liberty-application-release/. I hope this application can help others in managing their dividend portfolio, keep track of pay dates, dividends expected to receive, the generation of excel files for your own usages, and many more! I plan to update the application in the future to add new features and I hope that you guys can give me some feedback.

Dividend Liberty Design & New Features!

Latest release can be downloaded on this page! It is Windows 7 compatible. At this moment, I’m not sure if it is compatible with other versions of Windows but I would much appreciate it if you guys can test it out and give some feedback! Once you get to my google drive page, just hit the download image! I’ve been using this application for the past 2-3 months and it has been very useful! You can find the technical manual below!

New Look

newapp1

Here is the new application! The application now connects directly to Yahoo and it will retrieve the information live!

Portfolio Options

newappportfoliooptions

The “Portfolio Options” are the options for the right hand side of the application (My Portfolio).

Get Costs

newappgetcosts

Under the “Portfolio Options” we will go through the “Get Cost(s)” option first. You can highlight each stock (hold Ctrl+ mouse click) and select “Get Cost(s)”. The app will show you the costs.

 

Get Dividends

newappgetdivided

The next option “Get Dividend(s)”, will displays the monthly, quarterly, and yearly dividends for the selected stocks.

 

Show Sector Percentages

newappshowsectorpercentages

The “Show Sector Percentages” displays the count and percentages of the sectors that you have in your portfolio.

 

Generate Excel Portfolio

newappeditcolumnsscreen

newappgeneratedexcelfile

The “generate excel” option will generate a spreadsheet of the information in your portfolio section of the application. Under the “Edit Columns” option, you can select the columns that you want in the spreadsheet as well as renaming the column. In this case, I selected all of the columns to show for my excel file.

 

Calculated Results

newappcalculatedresults

The “Calculate Results” displays the total dividends for the monthly, quarterly, and annually. It also displays the total cost of your portfolio. The total cost is what you have spent on your portfolio (not current market value).

 

Non Portfolio Options

newapphighlightsectorsnonportfolio1

The “Non Portfolio Options” are the options for the left hand side of the application.

 

Next To Purchase

newappnextpurchasechkbx

The left hand side are stocks that are not in your portfolio. If you select an individual stock, you can check the “Next to purchase” check box to flag that stock for future purchases.

 

newappnextpurchasesresult

If you would like to see which stocks are your next purchases, you can select “Highlight Next Purchases”. By doing so, the app highlights all the stocks that you want to purchase next and displays how many have been saved. You can elect to move them over if you have purchased them to the right hand side.

 

Show Sector Percentages

newapphighlightsectorsnonportfolio

The “Show Sector Percentages” option displays the percentage and count of all the sectors in the left hand side of the application.

 

Main File Options

newappfile

The next group of options is under “File”.

 

Adding New Stocks

newappnewstockformrequired

Under “File–> New”, you can add a new stock to the non portfolio section. The required information to save are the symbol, industry, and dividend interval options. All other information is retrieved from Yahoo. The right hand side of this form allows you to change the date of the stock’s purchase and enter the shares and cost amounts.

 

Exporting your stocks

newappexportimportxml

 

newappsuccessfulexport

For backup reasons, you can export the XML file that this application uses to save your data. It will store all the not in portfolio and portfolio data.

 

Importing your stocks

newappxmlimport

newappxmlimportresult

Under the “Import” option, you can import the file that you have exported. So that in the future, if you want to install this application onto another computer, you can simply import your XML file back into the newly installed application!

 

Refresh Yahoo Data

newappyahoorefreshhighlight

As for the “Refresh Yahoo Stock Info” option, sometimes the application will fail to connect to Yahoo and will fail to retrieve the information. If this happens, you will receive an error message displaying that all data was not retrieved successfully and you can simply refresh it.

 

My Portfolio’s Industry Sector Percentages

newappindustryoptions

Other notable features is the industry highlight feature. If you want to select a sector to see what percentage of your stocks is in a particular sector, you can simply highlight the sector and press the highlight button.

 

newapponesectorhighlight

In this case, I’ve elected to select “Consumer Staples.” The application highlighted all the stocks in that sector and gives the count and percentage that makes up of your portfolio.

 

Dividend Pay Date Option

newapppaydateoption

One of my favorite features in the application is the Pay Date option. If you select the date and press highlight, it will display the expected dividends pay dates as well as the amount.

 

newapppaydateresults

I’ve selected 6 stocks in this example. I’ve already received 3 of them this morning! The amount for DE, GIS, and T has gone up compared to my most recent portfolio in my blog since I’ve already updated my shares and price!

 

Editing Stock Information

newappeditdividend

Finally, if you double click on any stocks, it will open the information for it. The right hand side is where you enter the number of shares that you own and the cost. When you press update, it will update your new information!

 

Conclusion

After having used this application for the past 2-3 months, I find that it is very handy to help me keep track of my portfolio. If you decide to try this application for free, please let me know if you like it or any feedback is much appreciated! After some feedback, I may go back and add new features or update this application, thanks!