Stored values how are they captured ?

[goldfinch77]

Still struggling with SV's

Aim is to capture the prices of horses in row 1 (by favouritism) through to row4 at 00:04:13 before the off.
I have uploaded the Baf.
The screen shot show the problem I am having; the stored values copied to the spreadsheet are different to those on the automation.
See screen shot.
I want to get those SV’s from the automation to cells on to a spreadsheet.
Can anyone help ?

ANDY-SV.baf

SV's.JPG

[jimibt]

Still struggling with SV's

Aim is to capture the prices of horses in row 1 (by favouritism) through to row4 at 00:04:13 before the off.
I have uploaded the Baf.
The screen shot show the problem I am having; the stored values copied to the spreadsheet are different to those on the automation.
See screen shot.
I want to get those SV’s from the automation to cells on to a spreadsheet.
Can anyone help ?

ANDY-SV.baf

SV's.JPG

is this not simply down to the difference in ordering on the spreadsheet?? the values appear to be the same, but obviously, cannot see the runner names on the spreadsheet in the image you've captured.

[goldfinch77]

I have seen this so many times, the 4 stored values caught by the automation at Row1 : Row4 are generally different to those shown in the default cells on the copy of the Bet Angel spread sheet i.e AF10 : AF16

If they are both "stored values" why are they different ?

[goldfinch77]

Is there anyway I can get the 4 SV's catured by the automation to a spreadsheet ?

[Dallas]

Is there anyway I can get the 4 SV's catured by the automation to a spreadsheet ?

That's what you are already doing by the looks of it

The only way of storing a value is with an automation rule, it can then be pushed to the Bet Angel worksheet by entering its name on the 'Excel' settings tab
Each time that stored value is updated (if triggering more than once) it'll be pushed to the worksheet
You also have the option of having it written to the Bet Angel log for your reference (which you are also doing already).

I'd agree with Jim in that its just the way they've been ordered in the log, the actual stored values will match up to the selection names in both places

[goldfinch77]

Dallas, thanks

So would it be better to use the rule "store values" rather than "export stored values) as I am doing here ?

I have been working on this for weeks, its the actual price ( in order of favouritsm) at a specific time that I want to get to a spread sheet cell

Do you have any suggestions on how to do this .

[goldfinch77]

Just a note from my looking at everything, on the "one click" page, if you push the back button it puts everything in order, is there anything in guardian that can do this, i have tried fix the order but that doesnt seem to do anything.

For 2 weeks at least I have been trying to find some way of recording the top 4 horses price at a specific time before the off, seems impossible I think

[jamesedwards]

Just a note from my looking at everything, on the "one click" page, if you push the back button it puts everything in order, is there anything in guardian that can do this, i have tried fix the order but that doesnt seem to do anything.

For 2 weeks at least I have been trying to find some way of recording the top 4 horses price at a specific time before the off, seems impossible I think

Easier to do it in Guardian and export the page to excel at the end of the day.

[jamesedwards]

So it looks like this.

Screenshot 2024-10-16 203550.png

[goldfinch77]

s
Sorry but I don't understand what you have posted, I am still on a vertical learning curve.

So big picture is, I have a formula (in excel) that needs the top 4 horse prices per race, I want to be able to test different filters as i go each day (conditional formatting), my friend at ChatGpt has given me the VBA to interface with the Bet Angel spread sheet.
The VBA is looking at cells AF10 through AF16, so the stored values, problem is I cant figure out how to get the correct data into the SV's
Any ideas would be gratefully appreciated.

[jamesedwards]

s
Sorry but I don't understand what you have posted, I am still on a vertical learning curve.

So big picture is, I have a formula (in excel) that needs the top 4 horse prices per race, I want to be able to test different filters as i go each day (conditional formatting), my friend at ChatGpt has given me the VBA to interface with the Bet Angel spread sheet.
The VBA is looking at cells AF10 through AF16, so the stored values, problem is I cant figure out how to get the correct data into the SV's
Any ideas would be gratefully appreciated.

I believe the BA Excel sheet will rank selections in the same order as Betfair.

If so then a workaround could be to apply an SV as [price of Fav 1] to selection [Betfair order 1], etc etc.

Like this...

test4.baf

The prices won't match the selection but it should put the top 4 prices in the correct order against the top 4 selections.

[jamesedwards]

s
Sorry but I don't understand what you have posted, I am still on a vertical learning curve.

So big picture is, I have a formula (in excel) that needs the top 4 horse prices per race, I want to be able to test different filters as i go each day (conditional formatting), my friend at ChatGpt has given me the VBA to interface with the Bet Angel spread sheet.
The VBA is looking at cells AF10 through AF16, so the stored values, problem is I cant figure out how to get the correct data into the SV's
Any ideas would be gratefully appreciated.

Another way to do it which is probably easier:
Use an Excel formula to pull out the lowest, 2nd lowest, 3rd lowest, and 4th lowest numbers from your existing AF column using the formulas:
=SMALL(AF9:AF68,1)
=SMALL(AF9:AF68,2)
=SMALL(AF9:AF68,3)
=SMALL(AF9:AF68,4)

[goldfinch77]

Thank you for taking the time to help, it is really appreciated.

On the test4 baf you posted, It does exactly what I want, however, still the same dilema, how do I get those values into a spread sheet (Prob BA sheet2) ?

The other idea is Re using =small is very simple, (I had thought of that), I will try later and see if it will do what I am looking for.

Again thanks