21
Triggered betting / Re: Read text from a file in a trigger
« Last post by fonecorp on 08 May 2024, 23:30 »Thankyou Mark
Bet # | Date/Time | Market | Winning Bet | Max Balance | Unit Price | Units | Stake | Back Price | Lay Price | If Wins | If Loses | P/L (AC) | Starting Balance | Ending Balance |
1 | 01/01/2023 13:08 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Tramore / Tramore 01/01/2023 12:55 2m Mdn Hrd - 2m Mdn Hrd | Back | £200.00 | £1.00 | 1.00 | £1.00 | 1.25 | 1.26 | £0.25 | -£1.00 | £0.25 | £200.00 | £200.25 |
2 | 01/01/2023 13:20 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Cheltenham / Cheltenham 01/01/2023 13:10 2m4f Mdn Hrd - 2m4f Mdn Hrd | Back | £200.25 | £1.00 | 1.00 | £1.00 | 2.40 | 2.42 | £1.37 | -£1.00 | £1.37 | £200.25 | £201.62 |
3 | 01/01/2023 13:34 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Musselburgh / Musselburgh 01/01/2023 13:25 1m7f Juv Hrd - 1m7f Juv Hrd | Back | £201.62 | £1.00 | 1.00 | £1.00 | 2.67 | 2.69 | £1.64 | -£1.00 | £1.64 | £201.62 | £203.25 |
4 | 01/01/2023 13:47 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fakenham / Fakenham 01/01/2023 13:35 3m5f Hcap Chs - 3m5f Hcap Chs | Lay | £203.25 | £1.00 | 1.00 | £1.00 | 3.25 | 3.30 | £2.21 | -£1.00 | -£1.00 | £203.25 | £202.25 |
5 | 01/01/2023 14:00 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fairyhouse / Fairyhouse 01/01/2023 13:50 2m4f Mdn Hrd - 2m4f Mdn Hrd | Back | £203.25 | £1.00 | 2.00 | £2.00 | 3.60 | 3.65 | £5.10 | -£2.00 | £5.10 | £202.25 | £207.35 |
6 | 01/01/2023 14:16 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Tramore / Tramore 01/01/2023 14:05 2m6f Mdn Hrd - 2m6f Mdn Hrd | Lay | £207.35 | £1.00 | 1.00 | £1.00 | 1.82 | 1.83 | £0.80 | -£1.00 | -£1.00 | £207.35 | £206.35 |
7 | 01/01/2023 14:31 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Cheltenham / Cheltenham 01/01/2023 14:20 2m4f Grd2 Nov Chs - 2m4f Grd2 Nov Chs | Lay | £207.35 | £1.00 | 2.00 | £2.00 | 2.68 | 2.70 | £3.29 | -£2.00 | -£2.00 | £206.35 | £204.35 |
8 | 01/01/2023 14:44 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Musselburgh / Musselburgh 01/01/2023 14:35 2m4f Hcap Chs - 2m4f Hcap Chs | Back | £207.35 | £1.00 | 3.00 | £3.00 | 3.60 | 3.65 | £7.64 | -£3.00 | £7.64 | £204.35 | £211.99 |
9 | 01/01/2023 14:54 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fakenham / Fakenham 01/01/2023 14:45 2m5f Nov Hcap Chs - 2m5f Nov Hcap Chs | Lay | £211.99 | £1.00 | 1.00 | £1.00 | 4.40 | 4.50 | £3.33 | -£1.00 | -£1.00 | £211.99 | £210.99 |
10 | 01/01/2023 15:12 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fairyhouse / Fairyhouse 01/01/2023 15:00 3m Hcap Hrd - 3m Hcap Hrd | Lay | £211.99 | £1.00 | 2.00 | £2.00 | 5.30 | 5.40 | £8.43 | -£2.00 | -£2.00 | £210.99 | £208.99 |
11 | 01/01/2023 15:26 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Tramore / Tramore 01/01/2023 15:15 2m6f Grd3 Chs - 2m6f Grd3 Chs | Lay | £211.99 | £1.00 | 3.00 | £3.00 | 1.87 | 1.88 | £2.56 | -£3.00 | -£3.00 | £208.99 | £205.99 |
12 | 01/01/2023 15:41 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Cheltenham / Cheltenham 01/01/2023 15:30 2m4f Grd2 Hrd - 2m4f Grd2 Hrd | Lay | £211.99 | £1.00 | 4.00 | £4.00 | 4.40 | 4.50 | £13.33 | -£4.00 | -£4.00 | £205.99 | £201.99 |
13 | 01/01/2023 15:56 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Musselburgh / Musselburgh 01/01/2023 15:45 1m7f Hcap Hrd - 1m7f Hcap Hrd | Lay | £211.99 | £1.00 | 5.00 | £5.00 | 4.20 | 4.30 | £15.68 | -£5.00 | -£5.00 | £201.99 | £196.99 |
14 | 01/01/2023 16:11 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Catterick / Catterick 01/01/2023 16:00 3m1f Hcap Chs - 3m1f Hcap Chs | Lay | £211.99 | £1.00 | 6.00 | £6.00 | 2.40 | 2.42 | £8.23 | -£6.00 | -£6.00 | £196.99 | £190.99 |
15 | 01/01/2023 16:26 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Exeter / Exeter 01/01/2023 16:15 2m3f Hcap Chs - 2m3f Hcap Chs | Back | £211.99 | £1.00 | 7.00 | £7.00 | 5.10 | 5.20 | £28.13 | -£7.00 | £28.13 | £190.99 | £219.12 |
16 | 01/01/2023 16:41 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fakenham / Fakenham 01/01/2023 16:30 3m Hcap Chs - 3m Hcap Chs | Lay | £219.12 | £1.00 | 1.00 | £1.00 | 2.75 | 2.77 | £1.72 | -£1.00 | -£1.00 | £219.12 | £218.12 |
17 | 01/01/2023 17:24 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fairyhouse / Fairyhouse 01/01/2023 16:45 2m INHF - 2m INHF | Lay | £219.12 | £1.00 | 2.00 | £2.00 | 1.79 | 1.80 | £1.55 | -£2.00 | -£2.00 | £218.12 | £216.12 |
18 | 01/01/2023 17:54 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Southwell / Southwell 01/01/2023 17:26 5f Nov Stks - 5f Nov Stks | Lay | £219.12 | £1.00 | 3.00 | £3.00 | 3.90 | 3.95 | £8.53 | -£3.00 | -£3.00 | £216.12 | £213.12 |
19 | 01/01/2023 18:24 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Southwell / Southwell 01/01/2023 17:56 5f Hcap - 5f Hcap | Lay | £219.12 | £1.00 | 4.00 | £4.00 | 4.70 | 4.80 | £14.50 | -£4.00 | -£4.00 | £213.12 | £209.12 |
20 | 01/01/2023 18:54 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Southwell / Southwell 01/01/2023 18:26 5f Hcap - 5f Hcap | Lay | £219.12 | £1.00 | 5.00 | £5.00 | 4.30 | 4.40 | £16.17 | -£5.00 | -£5.00 | £209.12 | £204.12 |
21 | 02/01/2023 13:21 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Southwell / Southwell 01/01/2023 18:56 1m3f Hcap - 1m3f Hcap | Back | £219.12 | £1.00 | 6.00 | £6.00 | 4.8 | 4.90 | £22.34 | -£6.00 | £22.34 | £204.12 | £226.46 |
22 | 02/01/2023 13:29 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Lingfield / Lingfield 02/01/2023 13:23 1m Hcap - 1m Hcap | Lay | £226.46 | £1.00 | 1.00 | £1.00 | 3.6 | 3.65 | £2.55 | -£1.00 | -£1.00 | £226.46 | £225.46 |
23 | 02/01/2023 13:43 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Plumpton / Plumpton 02/01/2023 13:30 2m4f Nov Chs - 2m4f Nov Chs | Back | £226.46 | £1.00 | 2.00 | £2.00 | 1.14 | 1.15 | £0.27 | -£2.00 | £0.27 | £225.46 | £225.74 |
24 | 02/01/2023 13:56 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Ayr / Ayr 02/01/2023 13:45 2m4f Nov Hrd - 2m4f Nov Hrd | Lay | £226.46 | £1.00 | 3.00 | £3.00 | 1.39 | 1.40 | £1.15 | -£3.00 | -£3.00 | £225.74 | £222.74 |
25 | 02/01/2023 14:13 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Plumpton / Plumpton 02/01/2023 14:00 2m Nov Hrd - 2m Nov Hrd | Lay | £226.46 | £1.00 | 4.00 | £4.00 | 1.7 | 1.71 | £2.74 | -£4.00 | -£4.00 | £222.74 | £218.74 |
26 | 02/01/2023 14:27 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Ayr / Ayr 02/01/2023 14:15 2m4f Hcap Hrd - 2m4f Hcap Hrd | Lay | £226.46 | £1.00 | 5.00 | £5.00 | 6.95 | 7.15 | £29.16 | -£5.00 | -£5.00 | £218.74 | £213.74 |
27 | 02/01/2023 14:43 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Plumpton / Plumpton 02/01/2023 14:30 2m4f Nov Hrd - 2m4f Nov Hrd | Back | £226.46 | £1.00 | 6.00 | £6.00 | 1.39 | 1.40 | £2.29 | -£6.00 | £2.29 | £213.74 | £216.03 |
28 | 02/01/2023 14:58 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Ayr / Ayr 02/01/2023 14:45 3m Hcap Chs - 3m Hcap Chs | Back | £226.46 | £1.00 | 7.00 | £7.00 | 2.68 | 2.70 | £11.52 | -£7.00 | £11.52 | £216.03 | £227.56 |
29 | 02/01/2023 15:13 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Plumpton / Plumpton 02/01/2023 15:00 2m4f Hcap Hrd - 2m4f Hcap Hrd | Lay | £227.56 | £1.00 | 1.00 | £1.00 | 3.25 | 3.30 | £2.21 | -£1.00 | -£1.00 | £227.56 | £226.56 |
HiHello Mark,
I've had a try testing this trigger and have not had any problems. The only way I can replicate the issue is if there is more than one tab character before the value to be imported. In this case the value of imported_1 is not greater than 0 and no bet is triggered for those imported selections with more than 1 tab character. Perhaps just check the formatting of your text file to make sure there is only 1 tab between selection name and the value.
You can also check the stats on the message after importing to see if the numbers match. As there is only one value per selection, the message should say the number of selections imported and that should match the number of values imported. If there is a difference then there is probably a fault in the text file.