When betfair change the order of runners due to changeing odds, the data imported directly from betangel to my spreadsheet, ie the runners names and current betfair odds etc, change with it, but any data that I have input myself does not.
Is there a way to either prevent the order from changing or lock my data to the data imported from betangel?
Any help greatly appreciated.
john
Order of runners changing creates a problem
I'm sure there are a couple of threads where this has been discussed before. But the quick way to do this is to create a lookup table of fixed values where you can create the bet before passing it to the main sheet. Or you could define criteria that have to be matched before trigger a function in a call. It all depends on what you are trying to do and how your triggers are created.