I am trying to capture the top 4 horses prices in each race (just for info) to the Bet angel(xlsm copy) spreadsheet
I have set Row1 : Row4 to export SV, Each row is set as JPG, all refresh rates at 20 mS.
Each time I run it, the Capture JPG shows the problem, the rows are staggered and Row4 is mostly in the wrong .....Row on the spreadsheet.
Am I doing something wrong ?
This is really confusing me
-
goldfinch77
- Posts: 246
- Joined: Wed Aug 05, 2020 11:45 am
You do not have the required permissions to view the files attached to this post.
-
jamesedwards
- Posts: 4130
- Joined: Wed Nov 21, 2018 6:16 pm
Attach your rulesfile here and most likely someone will be able to tell you what you need to do to fix.goldfinch77 wrote: ↑Thu Oct 03, 2024 4:55 pmI am trying to capture the top 4 horses prices in each race (just for info) to the Bet angel(xlsm copy) spreadsheet
I have set Row1 : Row4 to export SV, Each row is set as JPG, all refresh rates at 20 mS.
Each time I run it, the Capture JPG shows the problem, the rows are staggered and Row4 is mostly in the wrong .....Row on the spreadsheet.
Am I doing something wrong ?
RULES.JPG
Capture.JPG
SETTINGS.JPG
Without seeing the whole market, I'm guessing that the 4th fav is in row 5, so the market order is slightly out of sync in excel.
I think the order in Excel is set to the betfair order but 100% sure. I don't know if you can change it.
It looks like its doing what your asking.
I think the order in Excel is set to the betfair order but 100% sure. I don't know if you can change it.
It looks like its doing what your asking.
-
jamesedwards
- Posts: 4130
- Joined: Wed Nov 21, 2018 6:16 pm
I mean attach the .baf file here. Then someone else can load up your rulesfile and find the issue. Your .baf files can be exported by clicking "export rulesfile" in the 'automation' tab of guardian.
-
goldfinch77
- Posts: 246
- Joined: Wed Aug 05, 2020 11:45 am
Ok, here is the baf, called ANDY
You do not have the required permissions to view the files attached to this post.
-
jamesedwards
- Posts: 4130
- Joined: Wed Nov 21, 2018 6:16 pm
Your RW2 is set to lay price rather than back price.
You might need to add a rule to "fix the order of market selections".
Is there a reason why you are called all the SVs something different? I would have thought you should call them all RW then they should all appear in the same column.
You might need to add a rule to "fix the order of market selections".
Is there a reason why you are called all the SVs something different? I would have thought you should call them all RW then they should all appear in the same column.
-
goldfinch77
- Posts: 246
- Joined: Wed Aug 05, 2020 11:45 am
Yes, I want RW2 torecord the lay price, whereas the other 3 the back price.
I had'nt thought about calling them all just RW, will try that tomorrow,
thanks for looking, at least my hair will grow back.
I had'nt thought about calling them all just RW, will try that tomorrow,
thanks for looking, at least my hair will grow back.
-
goldfinch77
- Posts: 246
- Joined: Wed Aug 05, 2020 11:45 am
OK, so thanks for the tip, it works.
So for any others who maybe watching, I set the rules to Export all SV's for each row (by favouritsm) as RW for the current selection.
In the Excel settings I ticked the shared SV's in the left hand drop down, in the selections I just added 1 RW for selection.
Goldfinch
So for any others who maybe watching, I set the rules to Export all SV's for each row (by favouritsm) as RW for the current selection.
In the Excel settings I ticked the shared SV's in the left hand drop down, in the selections I just added 1 RW for selection.
Goldfinch