Recording Bets On Excel

[paulm99]

Is there any way of recording each individual bet you make on a spreadsheet? On the Bet Angel spreadsheet it records them but as a total and not individually.

Many Thanks

Paul

[LinusP]

Betfair does that for you, go onto your account and then bet history. You can then download the spreadsheet.

[paulm99]

Thanks for replying!

However I would like to use the info immediately so need to record the bet as it happens, i.e. as soon as the bet is placed through Excel.

Paul

[LinusP]

You could modify the data record spreadsheet (search data record) to do this or make a macro to record the bet if it is updated but this will require some vb knowledge.

[paulm99]

Possibly out of my knowledge range then! Will keep trying!

If anyone does think of a way to help me out that would be great!!

Paul

[LinusP]

If you are able to say why you want to do this it might help.

[paulm99]

Just looking at ways of closing a trade depending on the price of the original bet and using other factors like whether the price has started coming back to the original price or amount of money available.

If there are more then one bets placed on a selection through Excel it averages the odds which doesn't help me.

Thanks for your time!

Paul