Moderator: 2020vision
by alrodopial » Fri Oct 09, 2009 7:12 pm
by Norwegian Would » Sat Oct 10, 2009 12:16 pm
by alrodopial » Sat Oct 10, 2009 11:37 pm
by alrodopial » Sat Oct 10, 2009 11:55 pm
by osknows » Sun Oct 11, 2009 1:01 am
by alrodopial » Sun Oct 11, 2009 8:40 am
osknows wrote:Just a thought to simplify this... if I were to do this I would want to arrange all of my data in a common format in 1 worksheet which I could easily analyse and save.
I would probably..
1. Set up 2 dedicated rows in excel; 1 with Field names, 2 with live data in each worksheet linked to BA using just excel formula. These would be generic such as Date/Time, Event, Competitor1, Back odds1, layodds1 etc. Using excel 2003 I could collect up to 255 fields per market per timeframe.
2. In a completely seperate worksheet write a few lines of code that reads these specific rows from all open worksheets after defined intervals. Eg, every 10 seconds write 5 rows from 5 open worksheets into the next 5 empty rows.
Also, I suspect you may need to link this to other data as price movements alone won't help much in undestanding why prices have moved. Eg on average a 6f race will move differently to a 3m race. Also, transforming the data will probably be needed; depending on when data is recorded there may be vast amounts of data with very little movement
by danjuma » Sun Oct 11, 2009 10:27 am
alrodopial wrote:Sorry, here is the correct file:
http://www.mediafire.com/file/vyq4xdnmzqk/RECORDING ODDS WITH BA - many markets.xls
by osknows » Sun Oct 11, 2009 11:07 am
alrodopial wrote:What I really want you to explain is the second part of your post. I didn't get it.
Using a "fixed" field with formulas that gives you the recording lay out of the data you want to store in the same worksheet is what you are proposing?
Combined with storing the data every 5 or 10 sec and not at every refresh this will be really fast. What I don't get is how you store the data from refreshes between these lets say 10 sec.
Example:
I refresh market1 every single second and store the data every 10 sec. I copy paste the "fixed" field with the formulas - mentioned above - every 10 sec. But using formulas I can only have the data of the current moment-refresh. So copy paste will give me only the current data in the formulas.The previous 9 refreshes/data have been lost.
Am I missing something here?
The way I have set it is the refresh rate is also the recording rate.
I like your idea of storing the data from all markets in ONE worksheet and later group it by market (using rank?).
by osknows » Sun Oct 11, 2009 11:09 am
alrodopial wrote:I like your idea of storing the data from all markets in ONE worksheet and later group it by market (using rank?).
by danjuma » Fri Oct 30, 2009 10:38 am
by g06o » Tue Dec 29, 2009 6:31 pm
by alrodopial » Wed Mar 24, 2010 10:45 pm
The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.
Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.
Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.
He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.
We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.