loudnoiseman
Board Regular
- Joined
- Dec 31, 2004
- Messages
- 218
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
I'm doing some amateur stock analysis and have a system set up to return price gains/losses 100 days forward in time based on various factors of pressure looking 100 days back.
My B column lists forward looking positive/negative values and columns C thru L are backward looking factor values and I need a formula in $M$1 that will count how many negatives appear in B column before the first positive, each time I sort factor columns.
I need to repeat a zillion times with macros so I think this solution will greatly speed up many weeks worth of work.
Thanks so much!!
I'm doing some amateur stock analysis and have a system set up to return price gains/losses 100 days forward in time based on various factors of pressure looking 100 days back.
My B column lists forward looking positive/negative values and columns C thru L are backward looking factor values and I need a formula in $M$1 that will count how many negatives appear in B column before the first positive, each time I sort factor columns.
I need to repeat a zillion times with macros so I think this solution will greatly speed up many weeks worth of work.
Thanks so much!!