Cymatic Trader Community

[nig299]

If you need to import a list of todays runners along with the generally available prices that you can use with the Cymatic sheet, please see attached.

Ths was run at 11:15 Sunday night ready for racing Monday 31/08/2015. (Takes about 2 or 3 mins).

When you switch from race to race, you can compare the current price against the prices at the time the programe was run. The first race and prices are already shown.
You may find this useful as a measurement of how far a price has drifted/contracted in a certain time.

As mentioned, the prices shown (taken from here): http://www.oddschecker.com/horse-racing/racing-coupon are ones that are generally availble and not Betfair specific (The prices in the sheet have been converted to decimal).

Any non runners have been removed, although of course, this is liable to change nearer the time.

There are a couple of sheets that are hidden that hold the data imports.

[Gavin]

Very nice work there Nigel!
Gavin

[xplayer]

Very nice work there Nigel!
Gavin

Hi Nigel,

Just want to second the above.

When you get a chance can you check out my post and confirm if all was well in your bots decision making process.

topic816.html#p3848

Ray

[tony95]

Nice work Nigel. How do you trigger bets from the sheet?

Best regards
Tony95

[stiggits]

Hi,
This is just what i am looking for,
but am new to this and am having problems getting it to work.
I can open the sheet from cymatic and get the list from 31/8/2015
but when i press update i get a VB error

[nig299]

Hi Stiggits

What's the error saying and what verison of Excel have you got 2003, 2007 etc?

Press ALT/F11 to open up the editor, see what line is highlighted and post here.

Thanks,Nigel.

[nig299]

Hi Tony,

You can find a list of commands here that explains it much better than I could.

http://www.cymatic.co.uk/UserManual/ExcelCommands.aspx

Nigel.

[tony95]

Hi Nigel,

Thanks for the reply. I didn't realise that you had to unhide columns.
All sorted now.

Best regards
Tony95

[stiggits]

hi, this was the error i had, using excel 2010 x64.


Im new to this and do not have much spare time at the moment, but in a couple of months i will
have a lot more and can sit down and learn both cymatic and excel properly, but in the mean time I would
like to start collecting data.
Most details of race results and SPs i can look up later, but the early prices from evening before
are the ones I am most interested in collecting now, as they are lost after the moment.
So sorry for the newbe questions.

not sure if image worked so here is URL
https://www.dropbox.com/s/nbd63jmvgzsm5 ... 1.jpg?dl=0

[nig299]

Hi Stiggits

Where it says

Code: Select all

Dim cel As Range, StartRow As Integer, EndRow As Integer

add X as integer to the end so it becomes

Code: Select all

Dim cel As Range, StartRow As Integer, EndRow As Integer, X As Integer