Sunday, August 2, 2009

Bot Problems

As a part time trader I am thinking that my time might best be spent designing a bot that can trade for me when I am at work. So currently I am in the process of trying to design one that will work on the Bet Angel Spreadsheet. I am making a bit of progress however my biggest problem is that I only want to trade in the last 5 mins of racing and then clear the status cells for the next race.

At the moment I have copied this bit of code from the Bet Angel forum and this clears the cells every time a bet is placed.

Private Sub Worksheet_Calculate()

Dim i As Integer
For i = 9 To 67 Step 2
If Range("O" & i).Value = "placed" Then _
Range("O" & i).ClearContents
Next i
End Sub

However at the moment this will fire too many bets into the market for me. So I am trying to write a macro that will clear the cells when cell I5 shows true. I have tried several things so far but they don't work in practice. I am sure it is possible so I will keep trying because if I can get this to work then I hope it will be profitable.

5 comments:

  1. You lost me after 'Private...'

    :-)

    Hope the trading is going well and good to see the blog alive and kicking!

    Leonthefixer.

    ReplyDelete
  2. Leon

    Yes I am trying to learn a new language! Doesn't make much sense to me but hopefully it will be worth it.

    Trading is steady at the moment. Had a great day on Saturday. I usually do well when there is a change in the going at some courses. It is much easier to identify the Drifters and Steamers.


    Drifter

    ReplyDelete
  3. Hi Drifter,
    Not really a post - apologies.
    I have a blog at betting-exchanges.com - wondered if you would like to swap links?
    let me know.
    thanks
    Dan

    ReplyDelete
  4. Hi Dan

    I have added your blog to My Blog list. However it doesn't want to update.

    Drifter

    ReplyDelete
  5. This comment has been removed by a blog administrator.

    ReplyDelete