Cymatic Trader Community

[wbi]

This is my basic odds recorder using VBA, should be very simple to adapt with indicators in view of developing a bot based on past price movement etc

Regards WBI

http://www.filedropper.com/workingwithoddsv001a_1
(This link seems to have expired, so please see the later message below by Gavin about an alternative spreadsheet that is available)

[Gavin]

Hi WBI,

Thanks for making your spreadsheet available!

I couldn't get it to work initially, without making a change.

I commented this part out and it started working:

For R = 1 To UBound(arr, 1) ' First array dimension is rows.
For C = 1 To UBound(arr, 2) ' Second array dimension is columns.
Debug.Print arr(R, C)
Next C
Next R


Thanks again and kind regards,

Gavin

[Gavin]

Edited 17/4/2022:

I have a new odds recorder spreadsheet available, with more features.

For details on how to obtain a copy of the file, please email me on the usual support address (support@cymatic.....) (co.uk). The file is not available for download from the forum.

Kind regards,

Gavin

[xplayer]

I have just downloaded the spreadsheet - big thanks to WBI and Gavin for making this available.

I am looking forward to using and learning about Excel from it.

Regards,

Ray

PS Was it really 3.40am when Gavin posted this...

[Gavin]

You are very welcome xplayer.

Yes is was 3:40am when I posted that and yes I am in the UK! Sometimes I find it hard to stop work until a task is completed and out of my head! It took me several hours change the code and add some of those new nuances, before finally posting it.

I also did quite a bit of testing to look at other techniques in Excel to log the data even faster and with less flicker. The only way I found to log the data faster was to copy the row at the bottom of the existing data, rather than inserting it at the top, but I think it looks better at the top and the speed is acceptable so I left it like that.

I think an odds logger is a really useful thing, so hopefully folks will get a lot of benefit from all that hard work

Best wishes,

Gavin

[xplayer]

Hi Gavin,

Really appreciate your hard work on polishing the contribution made by WBI.

I know perfectly what you mean about

Sometimes I find it hard to stop work until a task is completed and out of my head!

as I have the same problem...

Cheers,

Ray

[Gavin]

Thanks Ray. Yes, stuff gets done which is good, but we drive ourselves round the bend in the process, lol!
Cheers,
Gavin

[battyburg]

Hi wbi,
This is a great tool for recording odds.Is there a chance that betfair might close my account if I used it on every race.I read somewhere the BF dont like too many hits on their server.
Kind Regards
Batty

[Gavin]

Hi Batty,

Betfair claim that they monitor the API to ensure that people aren't sneakily trying to take their data for commercial purposes. So it might be wise to ensure that you make some real bets that get matched, rather than just using their data without ever making bets.

Kind regards,

Gavin

[battyburg]

Hi gavin.

many thanks for that:)

Batters