kmcintyre Elite    Posts: 890 Joined: 10/11/2012 Location: Portland, OR  User Profile | I'm attaching an Excel 2010 .xlsm file. It won't work with early versions of Excel. So I'll attach a png of the two sheets as well. Mark, the tail is sooo long, I don't think STDEV.P would be very useful. But I'd love to hear your analysis (and others...) My takeaway is that I can expect some long periods (3 - 6 months) between new equity highs. I can further dice the data. For me, waiting a month for a new high starts to get uncomfortable, so I could sum the number of times that has happened. Just getting started. Having the data is very cool! Cheers Keith  Attached file : ARM4 Margin Equity Highs.xlsm (203KB - 352 downloads) Attached file : Data Sheet.png (96KB - 336 downloads) Attached file : Pivot Chart.png (78KB - 321 downloads) |
