Export odds every x number of minutes
-
atherton93
- Posts: 4
- Joined: Mon Sep 26, 2016 9:15 pm
Is there any way to export odds from Guardian to excel every minute or so to compile a list of odds to reflect market movement?
Watch bet angel's video playlist explaining how to connect to spreadsheet
https://www.youtube.com/watch?v=EF0UQm- ... 48EDF522F6
Once you've connected, you essentially need a data capture spreadsheet. if you dont want to make your own, there seem to be plenty on this forum.
If you want to build your own and are familiar with VBA id suggest using the built in 'Worksheet_Calculate' excel procedure. Any code in this function will execute whenever data is recalculated (which from my observations is at a rate of around 100 milliseconds between bet angel). Using this method also means no spreadsheet lag.
You can slow it down to a second or longer, by using conditional statement which detects when the clock changes.
never use functions like 'sleep' , they will freeze your spreadsheet.
https://www.youtube.com/watch?v=EF0UQm- ... 48EDF522F6
Once you've connected, you essentially need a data capture spreadsheet. if you dont want to make your own, there seem to be plenty on this forum.
If you want to build your own and are familiar with VBA id suggest using the built in 'Worksheet_Calculate' excel procedure. Any code in this function will execute whenever data is recalculated (which from my observations is at a rate of around 100 milliseconds between bet angel). Using this method also means no spreadsheet lag.
You can slow it down to a second or longer, by using conditional statement which detects when the clock changes.
never use functions like 'sleep' , they will freeze your spreadsheet.