SV to spreadsheet

[goldfinch77]

I am data capturing only, I have a small auto on guardian that captures 5 elements of a horse race, RUN, ROW 1-4, at 00:04:15 mins before the off, these are the stored Values in set/modify SV's
Is there any way I can get these to a spread sheet starting at A1,B1 C1 D1 E1
then on next race same SV's but to A2, B2, C2, D2,E2 ?

At the moment I am having to do thisby hand

[jamesedwards]

You can either;
> export SVs to a connected excel spreadsheet using settings in the settings \ excel tab.
> add the SVs to the Guardian markets list page using settings in guardian \ list tab, and export all data to excel in one go by right clicking on any market and selecting "export the contents of this market list".

[goldfinch77]

Thanks for the reply I am not sure how that would work, I should have said htat I wanted to cover all of a days racing, thus the need to store the SV in a row then when next race starts it saves the SV in the next row down, so I have all the 5 SV's across myy target spreadsheet

[sniffer66]

Are you any good with Python ?

It's possible to run a script to parse each output file and grab the SV's and create a line per race in a csv, but the formatting is a bugger in the Guardian output files so you have to jump through a few hoops. I use it to keep a track of P&L per race , where P&L etc are stored as SV's

Capture.JPG

[jamesedwards]

Thanks for the reply I am not sure how that would work, I should have said htat I wanted to cover all of a days racing, thus the need to store the SV in a row then when next race starts it saves the SV in the next row down, so I have all the 5 SV's across myy target spreadsheet

You can show any SV on the Guardian markets page. List tab \ edit custom columns. Then export all the data in one go at the end of the day.

[goldfinch77]

hmm. sounds ineresting, will look at that, ideally though the plan is to use the values of the SV in an excell workbook that will have some conditions placed on them thats why I looking to get the realtime data put in line by line

And now not familiar with python, just getting my brain around VBA

[goldfinch77]

Ok,I am now even more confused, I went right back to a simple idea, I have in Guardian 1 SV, its called RW1 and stores the back price of Row1 (favouritism),I then went to Excel settings and ticked stored values and added RW1
when I checked the Bet Angel (copy) spreadsheet, it showed in cell AF the value of RW1 but for all the horses.
Is this standard or have I missed something

[jamesedwards]

Ok,I am now even more confused, I went right back to a simple idea, I have in Guardian 1 SV, its called RW1 and stores the back price of Row1 (favouritism),I then went to Excel settings and ticked stored values and added RW1
when I checked the Bet Angel (copy) spreadsheet, it showed in cell AF the value of RW1 but for all the horses.
Is this standard or have I missed something

Share your rulesfile and someone might be able to spot the issue.

[goldfinch77]

As suggested.

Excel.JPG

Rules.JPG

[goldfinch77]

And this one.

RW1.JPG

[jamesedwards]

If you want to create an SV for a selection then you need to create it at selection level. Currently you're storing the best lay price of fav1 at market level.

[goldfinch77]

Thank you for that, so I have set the rules as export all stored values for the selections ( is this correct ?)
In the Excel settings I set RW1, RW2, RW3 and RW4, all back prices except RW2 which is Lay.

When I ran it I got what is shown, what I was hoping for was RW1 in AF, RW2 in AG etc.why is it writing vertically ?

Is there something else I need to do ?

Thks

NEW.JPG

EXCEL1.JPG

[goldfinch77]

I think I may have answered my own question, it is writing to AF, AG etc, will go and play some more, thanks for pointing me in the right direction

Goldfinch.

[Hepburn]

I think I may have answered my own question, it is writing to AF, AG etc, will go and play some more, thanks for pointing me in the right direction

Goldfinch.

You can copy each one and paste ( special ) elsewhere to get the ducks in a row. Then you can hide the columns.

[goldfinch77]

Thank you , I am just hoping the SV's are in the same stagger each , then yes I had thought of doing what you suggested ,basically I am learning VBA and am trying to build a Macro to to store the top 4 prices at say 4 mins before off but using the cells on the spread sheet for the back/lay values say are not always consistent, so hence my trying to do the above, then I can point my code at the ducks.