4 ms·

People (and tool developers) forget that the purpose of a stock is to ultimately produce dividends. It is like buying a house for rental income and forgetting t

by maire 4y ago

People (and tool developers) forget that the purpose of a stock is to ultimately produce dividends. It is like buying a house for rental income and forgetting to include the rent. When I retired I had to switch from a growth-stock mindset to an income-stock mindset. I have made the switch but none of the free tools makes that easy. The closest I came was TOS will do this calculation for stocks but not ETFs. Oh well. I now have all the calculations in google sheets. I also now have a backtest that goes the the beginning of the Clinton administration to the end of the Trump administration. I added dividends to the backtest. I only went to the Clinton administration so that I could use ETFs to simplify the calculations. The backtest includes dividends - which I had to add manually.

temp_praneshp 4y ago
Out of curiosity: How do you test your sheets? I feel like I can arrive at such a sheet over a few days of reading, but unsure how I'd test I'm doing the right things (since there isn't a tool or a combination of tools that can act as oracle)
- maire 4y ago
  I used ETFs (and not stocks) to simplify the test. I was mostly looking for correlations of different investments across different scenarios. I then looked at severe market downturns to see how the correlations changed. As you can imagine - when there is a severe market drop, most investments are highly correlated to the S&P. The most negative correlation I could get was medium term bond ETFs. Short term bonds were still highly correlated and I am not sure why. The dot com bust was particularly interesting because each segment dropped at different times. Telecom dropped first, then tech. It took about a year for the drop to hit mid cap. In comparison - the 2008 crash hit everything quickly. Also - lately I have been using the backtesting tools in TOS. As I said earlier, this only works for stocks and not ETFs.
  - temp_praneshp 4y ago
    gotcha, thanks for answering!
    - maire 4y ago
      If you are using google sheets you can use ycharts to pull in the dividend data. Here is my calculation to get 1 year of dividends. =query(importhtml(concatenate("https://ycharts.com/companies/",$A4,"/dividend"),"table",0),$J$2 https://ycharts.com/companies/",$A4,"/dividend"),"table",0),...) where $J$2 is ="select Col6 where Col1 > date '"&TEXT(I2,"yyyy-mm-dd")&"' LIMIT 12"
imtringued 4y ago
>People (and tool developers) forget that the purpose of a stock is to ultimately produce dividends. It would be more accurate to say that they distribute profits back to shareholders. Buying shares back is equivalent to dividends. What's questionable are attempts to borrow money to boost the stock price as those then generate a hype cycle which lets the company sell its shares back for a profit which is exactly backwards to how it should work.

by maire 4y ago

temp_praneshp 4y ago

Out of curiosity: How do you test your sheets? I feel like I can arrive at such a sheet over a few days of reading, but unsure how I'd test I'm doing the right things (since there isn't a tool or a combination of tools that can act as oracle)

maire 4y ago
I used ETFs (and not stocks) to simplify the test. I was mostly looking for correlations of different investments across different scenarios. I then looked at severe market downturns to see how the correlations changed. As you can imagine - when there is a severe market drop, most investments are highly correlated to the S&P. The most negative correlation I could get was medium term bond ETFs. Short term bonds were still highly correlated and I am not sure why. The dot com bust was particularly interesting because each segment dropped at different times. Telecom dropped first, then tech. It took about a year for the drop to hit mid cap. In comparison - the 2008 crash hit everything quickly. Also - lately I have been using the backtesting tools in TOS. As I said earlier, this only works for stocks and not ETFs.
- temp_praneshp 4y ago
  gotcha, thanks for answering!
  - maire 4y ago
    If you are using google sheets you can use ycharts to pull in the dividend data. Here is my calculation to get 1 year of dividends. =query(importhtml(concatenate("https://ycharts.com/companies/",$A4,"/dividend"),"table",0),$J$2 https://ycharts.com/companies/",$A4,"/dividend"),"table",0),...) where $J$2 is ="select Col6 where Col1 > date '"&TEXT(I2,"yyyy-mm-dd")&"' LIMIT 12"

imtringued 4y ago

>People (and tool developers) forget that the purpose of a stock is to ultimately produce dividends. It would be more accurate to say that they distribute profits back to shareholders. Buying shares back is equivalent to dividends. What's questionable are attempts to borrow money to boost the stock price as those then generate a hype cycle which lets the company sell its shares back for a profit which is exactly backwards to how it should work.