Recording odds increase/decrease in x seconds

[MiniBlueDragon]

I'm using Betting Assistant for Betdaq 1.0.9.0.

I load the application, open the spreadsheet, select Excel > Log Current Prices and choose TotalMatchedDiff.xls Sheet 1 and Enable Triggered Betting.

I'm seeing odds and Total Amount Matched updates but the Total matched increase never changes from 0.

[osknows]

Put a break point on the line Private Sub Worksheet_Change(ByVal Target As Range)

Does it stop on this line? If not then events are disabled.

Also, what refresh rate are you using, if it's 0.2 seconds are the updates too quick to see?

[MiniBlueDragon]

Nope; not hitting the BP at all for some reason. I tried swapping markets just to see if that kicked it and it hasn't.

Also un-commented Option Explicit and that hasn't worked.

Refresh is set at 1 second so it's easy to see any changes. The way I'd expect it to work would be:

Refresh 1 = Total Amount Matched £100 - Total Matched Increase £0
Refresh 2 = Total Amount Matched £150 - Total Matched Increase £50
Refresh 3 = Total Amount Matched £160 - Total Matched Increase £10

etc

[osknows]

Have you put the code in a sheet object? Don't put it in a module.

Try this - http://www.mediafire.com/?2i1b2lo9kq7378l

It's your code which I've added to a workbook which works in Betdaq.

[MiniBlueDragon]

I'm just using the sheet that Gary created referenced earlier in the thread.



Your download says "preparing download" so I'll try that when it's ready. Thanks for trying to help. :/

[MiniBlueDragon]

Well damned if I know what the problem was; your version works perfectly, thanks very much indeed!

[osknows]

I've no idea either? Strange.

[MiniBlueDragon]

Yep; haven't a clue at all.

All's well that ends well though; again really very much appreciated, thanks

[angelafmy]

For now all I want to do is get this speadsheet running and from there I'll be looking into*****customising it for odds movements.