help with trigger bettig!

[danjuma]

Hello.

After searching for a bot for my requirements without any success, I have decided to learn excel to enable me to write my own triggers to use with BA. I have done the easy bit - read a book, but now is the hard bit - apply it in real life, and I need a bit of guidance to start me off.

Objective - I have 4 different betting strategies that I would like to automate. Each of the strategies have its own set of criteria like when to start monitoring the market and how long before the start of a race before placing a bet.
I assume I would have one workbook that BA would log the prices of the markets I have selected to, and then have a worksheet each for each of the 4 strategies within the workbook. with their corresponding triggers, formulars etc

How do I get each strategy to start monitoring the markets at a specified time and place a bet at a specified time before the start time of a race?

Many thanks in advance.

[Shaun]

I only use 2 sheets "Data" for logging the prices and "CONTROL" on my Control sheet i use this formula to get the time =Data!f2 then in L5 i can place the number of minutes i want before a bet is placed then in B5 i have =L5/1440 then in D5 i have =IF(B3<B5,1,IF(B3>C5,1,0)) in C5 i have (-00:00:00) this keeps the trigger active when time elapses.

The number 1 is an active trigger 0 is inactive.

[laffo16]

have you had a looked at my bot Shaun?
http://www.gruss-software.co.uk/forum/v ... php?t=2857

if it is missing anything, im all ears to making improvements.

[laffo16]

i ment danjuma sry

[danjuma]

Shaun - many thanks for your reply.

Laffo16 - I had a brief look at your bot and I might give it a go later to see if it will be suitable for me. For now though, I just want to see whether this is something I could set up to work on my own, which would be a very valauble skill to have. Thanks.

[laffo16]

which language are you programming in? VBA i presume? what do you know so far? i suggest you start with creating a simple button script which places a bet for you based on certain critera. Once you are comfortable with reading and writing to cells, then look into converting the timer date into something you can measure or compare with an interger value, such as into a countdown timer until the off. You should learn about if you havent already varible types, loop statments (while, for), IF's, Arrays and Functions. Once you can grasp these, and how to use them effectively then your well on your way to botting hell ^^ lol.

but yeh, start with perhaps one system to begin with. do you have any code so far?

[danjuma]

Hello laffo16. I have actually learnt just Excel. Do I need to learn VBA as well to be able to write triggers to use with BA? Thanks

[laffo16]

I think Excel can handle most of the formula stuff, i think you could get quite far with just using excel alone, but eventually things will become tricky and you may hit a wall that you cant get around with excel alone.

im finding hard to find the point im trying to make lol, lets see.

comparing date/time (excel)
horse name matched from lookup (excel)
horse meets price requirements (excel)
-- critera met and trigger cell = 1 --
stake and odds go up (excel)
trigger (Q row) detects stake & odds and sends "BACK" (excel)
-- bet ref is returned
Q cell detects bet ref as a number format then sends "CLEAR" (excel)

At this point it gets a little tricky, you need your program to be aware that it has already made the bet, so it doesnt rebet. Now depending on how your selections are chosen whether by name or a price range, you need some sort of value inputed (VBA) which indicates that this system has now been used in this race and not to use it again. In excel alone, im not sure how this can be done with out possible floors when adding other systems.

Sorry its late here, i maybe off the mark on this one.

Suggestions anyone?