Tracking a staking system problem, stop at x%

Hi guys thanks for taking the time to look at my problem.

I have created a betting system but i do not have the ability with either formulae or macros to track it over historic data. What i would like to do is to track this system as a "stop at %threshold profit system" This system would look at column H at the start of the day, if at any point during a given day it became x% higher than at the start of the day no further bets would be placed that day. This would need to take into account any other bets within a given event (each event array is seperated spatially in column A.) There is also one further problem to add to this task, in that the historic data i have goes down more than 300,000 rows which i believe maxes out any arrays in formulae of macros?

Please view example to understand further (hopefully)

Many thanks

Hi Tiger, thanks for taking a look and apologies it isn't clear enough.
- I would like the output either in this sheet as a list in one column or another sheet either is acceptable. It would be nice if any macros would reference a threshold cell, so that the model can easily be changed from 2% to 3% and so on, for optimization.
- With regard to day one shown, (25/10/11) the results are identical. On this particular day any stop at x%profit system wouldn't have 'got out.'
- With regards to my example you are correct the first time this occurs is row 898, however because there are several stakes within that event, at the end of that event it is sitting at 74.39, not above the 2% threshold ( each event is defined by the arrays shown in column A.)

I hope this makes sense.

Many thanks

Alan

Hmm could really use some help on this one. Many thanks

Alan

Sorry guys i have to bump this one. Many thanks

Alan

Hi Tiger, i know that if you cannot understand it then there is a problem with my explanation, normally you interpret the problem correctly every time. I have amended my example with annotations and a potential method to achieve the required result. Once you have understood the aim, you may know of a better way of achieving the goal. Any method would be acceptable, please let me know if there are ant parts you don't understand, its always so easy for the creator of a problem to overlook the fact that any reader may not be familiar with such a system/problem type. Apologies for this.

Thanks so much for your time.

Best regards

Alan

Wow, longest macro i have seen. Ill test it now, thanks soo much!

Alan

As far as how to prevent that, should the macro look at the end of day line first, and if it does not meet or exceed the profit threshold, there were no winners for the day? Even if, at some point during the day, the threshold was exceeded?

No the macro should not look at the end of each day. But it does need look at the end of each array (so for instance) in row 898 this is a false positive because at the end of that event (row 907) is not above the required threshold, the event arrays can be found by looking in column A.

The macro is close and i love the output table. Will make graphing very easy.

Also in my example i have manually put the 1's in column L to stop the staking being the same as the continuous bank (column g). The macro would need to identify the row below the end of an event array which achieved the 2%, it would then need to insert 1's into column L down until there was a new day. For instance threshold is achieved in row 1083 (end of event array) where as it is not achieved at the end of the event array related to the row 898 win. So in this case the macro would be required to put 1s in L970:L973. If the macro can be made to do this, and the line :

Please Login or Register  to view this content.

is turned to Column K instead.
Then i believe the macro will achieve the goal. Just for your interest columns F-H is a continuous staking plan, easy for me to model via formulae, where as columns I-K (Affected by the 1's in column L) is a stop at x% (in this case 2%) staking plan.

Essentially the difficult thing to do with 300,000 rows of data is to identify the bank at the start of the day and then identify the array end which is above x% and insert 1's in column L.

I really do hope this makes sense?

Thanks so much

Alan

Works a treat! Thanks so much!

Alan