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
Bookmarks