Replies to post #43021 on A.I.M. Users Bulletin Board (AIMUSERS)

[SFSecurity]

Hi Gang, I finally found the way to look up the last date in a column! The formula is a bit strange but it works.

=LOOKUP(2,1/(B:B<>""),B:B)

You can adjust which column you are using by changing the "B" to whatever column you need.

BTW, it can also be used to find any ending data that you might want to look at without having to scroll through the whole page.

This is great because I have all the results in the top two lines and don't have to scroll to the bottom of my backtest anymore to see how I'm doing.

Now if I could figure out how to find any negative figure that might occur in the cash column it would make backtesting even easier.

[Adam]

Hi Allen, I agree with you that AIM works best with larger positions especially if you use diversified ETFs that are less volatile. That's why it's best not to have too many programs for the size of your account. I think for most people having just a small number of programs should work well. There's some optimal number for a portfolio as increasing the number of programs can also improve volatility as it increases the chance that some programs move out of step with each other.