08-18-2013, 08:52 PM
I used those sources before and track many of the same things you. Good stuff to know.
Once I learned to use conditional formatting spreadsheets really got fun for me. I've set up buy zones; I plug in a price where I think I should get interested in a stock, whether it be to buy more or just check things out. If the current price falls below my "get interested" price, the cell highlights green. It's like a wake up call. I do the same on the upside too, only I use the analysts' one year target price. I have it set so that if a stock gets within 2% of the estimate, the cell goes red, and I know I should give it a little extra attention.
Hehehehe, it delights me to no end knowing I can make a spreadsheet do that. I'm sure it's pretty basic stuff, but they didn't have excel went I went to college, so I'm a hack but I can get a few things done.
I also look at what next year's income will be, percent of the total income a stock throws off, how much it costs me to hold cash compared to a 3.5% dividend stock, the difference between the current yield and your yield on cost and some other things.
Once I learned to use conditional formatting spreadsheets really got fun for me. I've set up buy zones; I plug in a price where I think I should get interested in a stock, whether it be to buy more or just check things out. If the current price falls below my "get interested" price, the cell highlights green. It's like a wake up call. I do the same on the upside too, only I use the analysts' one year target price. I have it set so that if a stock gets within 2% of the estimate, the cell goes red, and I know I should give it a little extra attention.
Hehehehe, it delights me to no end knowing I can make a spreadsheet do that. I'm sure it's pretty basic stuff, but they didn't have excel went I went to college, so I'm a hack but I can get a few things done.
I also look at what next year's income will be, percent of the total income a stock throws off, how much it costs me to hold cash compared to a 3.5% dividend stock, the difference between the current yield and your yield on cost and some other things.