Log close soccer back and lay price matches with OddsRelay and Google Sheets

## Log close back and lay prices and their moves in Google Sheets ### How it works For people in the UK and Ireland who log bookmaker back prices that sit close to exchange lay prices. On a schedule, Check the price asks the OddsRelay API what the Standard matched board call costs (free), and the board is read only within your cap. Compare with the log rates each back price against the lowest exchange lay with enough money available, after your commission, and keeps pairs at or above your rating. A pair gets a row when the sheet has none for it, or when its back or lay price has moved since its last row, so repeat runs add no duplicates. A failing API call is tried three times, then the run stops with its error code, leaving the sheet unchanged. The log only grows, so archive old rows now and then. ### Setup 1. Sign up at app.oddsrelay.io and copy your API key. Free gives you 50,000 tokens for 14 days from sign-up, with no card, then no tokens until you choose a plan, on the same key. 2. Create a Header Auth credential with Name x-api-key and your key as the Value, and pick it in both HTTP Request nodes. 3. Put an empty Google Sheet's URL in sheetUrl in Settings (its tab in sheetName) and connect Google Sheets in both sheet nodes. 4. Run it once, check the sheet, then publish it. ### Customization In Settings: sport or competitions, markets, bookmakers and exchanges (keys from /v2/sports and /v2/bookmakers), commissionPercent, minRating, minLayAvailable, minMovePercent and maxTokensPerRun. Each run spends the call's price: schedule it to suit your plan. Paid plans are for your own use; a tool that serves other people needs Enterprise.