Odds Recorder For Technical Analysis

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... :)

Odds Recorder For Technical Analysis

Postby wbi » 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 by Gavin which has version 2 attached)
wbi
 
Posts: 14
Joined: Tue Sep 24, 2013 3:33 pm

Re: Odds Recorder For Technical Analysis

Postby Gavin » 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
User avatar
Gavin
Site Admin
 
Posts: 3549
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Re: Odds Recorder For Technical Analysis

Postby Gavin » Mon Aug 24, 2015 2:40 am

I have reworked the spreadsheet and added new features which are explained in the Documentation sheet.

The new version 2 is attached to this message.

Kind regards,

Gavin
You do not have the required permissions to view the files attached to this post.
User avatar
Gavin
Site Admin
 
Posts: 3549
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Re: Odds Recorder For Technical Analysis

Postby xplayer » Mon Aug 24, 2015 7:04 am

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

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

Regards,

Ray

PS Was it really 3.40am when Gavin posted this... :o
xplayer
 
Posts: 89
Joined: Thu Aug 20, 2015 10:35 am

Re: Odds Recorder For Technical Analysis

Postby Gavin » 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
User avatar
Gavin
Site Admin
 
Posts: 3549
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Re: Odds Recorder For Technical Analysis

Postby xplayer » 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
xplayer
 
Posts: 89
Joined: Thu Aug 20, 2015 10:35 am

Re: Odds Recorder For Technical Analysis

Postby Gavin » 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 :)
User avatar
Gavin
Site Admin
 
Posts: 3549
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Re: Odds Recorder For Technical Analysis

Postby battyburg » 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
battyburg
 
Posts: 15
Joined: Wed Oct 07, 2015 9:53 pm

Re: Odds Recorder For Technical Analysis

Postby Gavin » 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
User avatar
Gavin
Site Admin
 
Posts: 3549
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Re: Odds Recorder For Technical Analysis

Postby battyburg » Thu Oct 15, 2015 10:48 am

Hi gavin.

many thanks for that:)

Batters
battyburg
 
Posts: 15
Joined: Wed Oct 07, 2015 9:53 pm

Next

Return to Excel - Sample Spreadsheets

Who is online

Users browsing this forum: No registered users and 0 guests