Samples developed by Cymatic and others. Please share your spreadsheets here.
Forum rules
Users can post their spreadsheets here, to share with others and for discussion purposes.
If you download a spreadsheet from here, please carefully test any strategies yourself before using it with real money. Cymatic accepts no liability for any spreadsheets in this forum.
Now bring on the robots! Happy automated trading...
Thu Jul 16, 2015 5:51 pm
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)
Thu Jul 16, 2015 9:10 pm
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
Mon Aug 24, 2015 2:40 am
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
Mon Aug 24, 2015 7:04 am
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...
Mon Aug 24, 2015 1:20 pm
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
Fri Aug 28, 2015 7:48 am
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
Fri Aug 28, 2015 12:04 pm
Thanks Ray. Yes, stuff gets done which is good, but we drive ourselves round the bend in the process, lol!
Cheers,
Gavin
Mon Oct 12, 2015 5:11 pm
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
Tue Oct 13, 2015 12:51 am
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
Thu Oct 15, 2015 10:48 am
Hi gavin.
many thanks for that:)
Batters
Powered by phpBB © phpBB Group.
phpBB Mobile / SEO by Artodia.