Those who know me will see this coming from a mile...Dallas wrote: ↑Thu Nov 24, 2022 11:14 pmThats pretty much the way I'm doing it when I need to but Paspuggie48 might have a better solution you could tryDanTheMan1 wrote: ↑Thu Nov 24, 2022 10:13 pmEvening all, what is the best way to export and organise data from stored values? i am currently copying the log and sorting it in excel using text to columns. I basically want something that gets the data into excel in a more user friendly way then i can analyse the data in pivot tables to see what the horses price and volume did during the time rules that i set. Any help would be much appreciated. I have managed to set this rule up in the one click screen with no problems but would like to be able to review the data in excel at a later time.
I use Power Query.
I used to get the data from the log files but as I have many data points throughout the day just one file can have thousands of lines of data. As there are a lot of races this becomes inefficient.
So, I export the BSP/Form/Status SV data and then "merge" that data to my existing Guardian export, which contains all the runners of each race, race details etc.