Recording market odds and traded volumes spreadsheet - capturing data

[ShaunWhite]

maybe we need some master accounts of something as the data would be the same for each of us as its centralised. Then if we want to store is market, for example, we could archive the sheets by just saving them with different names.

Then wait for a knock on the door. These aren't new ideas Gary, have a think why people don't just chat about it on an open forum.

[GaryCook]

maybe we need some master accounts of something as the data would be the same for each of us as its centralised. Then if we want to store is market, for example, we could archive the sheets by just saving them with different names.

Then wait for a knock on the door. These aren't new ideas Gary, have a think why people don't just chat about it on an open forum.

Fair enough. Point taken.

[tb_smoelf]

Hi.
I have used this spread sheet with joy. BUT suddently I get this error message.
See image.
Anyone that can help?
Best, Tim

BetAngel_record_datav2 Support.PNG

[tb_smoelf]

Someone just nudged me about this. I've updated the sheet so you can specify an interval. Remember to untick 'Record data' before changing the value.

I've not tested with all intervals from 1 second to 5 mins but it should be ok. Post up here if you find any problems or have a go at sorting it yourself. There is nothing hidden.

BetAngel_Record_datav2.zip

Hi i_XL.
I have used your great spread sheet with joy, but suddently I get this message. Car you help me with this?
Best, Tim

[nigelk]

Press debug and it'll show you the line thats causing the error. Just a guess but from the pic it looks like you've got the name of the match in A1, but that should be linked to the tickbox and only show TRUE/FALSE

[tb_smoelf]

Press debug and it'll show you the line thats causing the error. Just a guess but from the pic it looks like you've got the name of the match in A1, but that should be linked to the tickbox and only show TRUE/FALSE

Hi.
It shows this. Anything I can do?
Best, Tim

BetAngel_record_datav2 Support Debug.PNG

[nigelk]

A1 should only show TRUE/FALSE, clear whatever you've got in there now. When you check the tickbox A1 should change to show either TRUE/FALSE, not the name of a team/tennis match etc.

[tb_smoelf]

A1 should only show TRUE/FALSE, clear whatever you've got in there now. When you check the tickbox A1 should change to show either TRUE/FALSE, not the name of a team/tennis match etc.

Hi.
Seems to work now. Thanks for taking the time.
Have a nice day.
Best

[tb_smoelf]

Press debug and it'll show you the line thats causing the error. Just a guess but from the pic it looks like you've got the name of the match in A1, but that should be linked to the tickbox and only show TRUE/FALSE

Hi again.
I have some troble with this sheet. When I press "Connect" and select "Data" in the "Excel Sheet" tab in guardian, the sheet show the error.
The match name ends up in cell B1.
Can you see from the pic. of the debug screan what dto do?

Best, Tim

[firlandsfarm]

This is just what I wanted but … I'm having trouble with it I cannot change the Interval setting if the worksheet is connected to a market maybe because whatever the value I have in cell G1 of the Data sheet the data is recording at 2 lines per second and every time a new line of prices is created it 'closes' the editing of G1. Here is a pic of the Interval preset to 60 seconds before linking the worksheet but with the Countdown column showing 2 price lines per second. Help please, it's like an unstoppable monster!

IXL Data Capture Multi Market screengrab.JPG

[firlandsfarm]

OK I'll give that a try, thanks Callum. I can't actually say if there is a correlation between when I change something and Connected/Not Connected because I often forget to change things before Connecting so it could be both or either! But if I do want to change something then I should disconnect, make the change, re-save the spreadsheet and then re-Connect … yes?

I also sometimes get a VBA error …

DataCaptureVBError01.JPG

DataCaptureVBError02.JPG

After these errors the only way to close the spreadsheet is to use Task Manager. To get these screen pics I set everything up as suggested before Connecting the spreadsheet. I Connected the spreadsheet in Guardian and then selected the Data sheet for the event. All was OK until I clicked the tab in the spreadsheet to switch the sheet view from Data to BetAngel (or it could have been the other way around). Anyway, I then get the error message and on selecting Debug I always get the same line indicated. (If I select End in the error message the message box just keeps repeating.)

[gstar1975]

Is it possible to add my custom columns that I have added to the one click screen to also display these in Excel?

[bebenmmv]

wonderful, ths!

[gubbinator500]

Chaning the time interval does not seem to have an effect for me. The data always updates with the BA refresh rate. Any ideas how to fix this? I tried using the spreadhseet with BetDAQ, but it should not make a difference.

[humanoid769]

hi

Is there a way to capture the BSP in this sheet?

Thanks