Betfair Tennis trading - Profit graphs

[1856]

Looking for some guidance, I have seen a video of Peter called "Betfair Tennis trading - Profit graphs".

Where over the period of a Tennis match the P/L is captured. Thats where Im unsure what are the steps. Could anyone offer some direction thanks.
Cheers
Michael

[Dallas]

Looking for some guidance, I have seen a video of Peter called "Betfair Tennis trading - Profit graphs".

Where over the period of a Tennis match the P/L is captured. Thats where Im unsure what are the steps. Could anyone offer some direction thanks.
Cheers
Michael

Here you go
viewtopic.php?f=54&t=16632

[eightbo]

If you want a more lightweight / non-excel option, you can also use the Rule Type 'Export All Stored Values' to achieve the same end.

1. Define SV for Current Market Green All
2. Have export rule fire as desired
3. Open your .csv data in Excel, create a new sheet to manipulate the data (fetch the start & end rows for each market's P&L values)
4. Use a line graph to display the P&L, by updating the graph data (reference your start & end rows)

Code: Select all

ActiveChart.SetSourceData Source:=Range("data!K" & Range("O34").Value & ":data!K" & Range("Q34").Value)

Example below:
(Horse Racing set to export SV's every 1sec in-play if Matched Bets > 0, until the market is suspended)

Exported .csv data + examples

◘.png

◘◘.png

◘◘◘.png

[1856]

Tanks Dallas, and eightbo for your replies and help, brilliant!

Michael

[1856]

Im back again.

Ive downloaded the recorder file, set up thought all was going well when I check the data in Sheet 1 it seems to stopped working, not sure what I have done?
There is also some other data Horse or Dogs names possibly?
Attached are images of the setup and data collection. Any ideas or help appreciated.

Thanks
Michael

Sheet 1 2023-09-04 125859.png

Bet Angel 2023-09-04 130008.png

[Dallas]

Im back again.

Ive downloaded the recorder file, set up thought all was going well when I check the data in Sheet 1 it seems to stopped working, not sure what I have done?
There is also some other data Horse or Dogs names possibly?
Attached are images of the setup and data collection. Any ideas or help appreciated.

Thanks
MichaelSheet 1 2023-09-04 125859.pngBet Angel 2023-09-04 130008.png

Probably best you post that to the end of the thread it refers to
The file was created by another user, but by adding it to the end of the thread someone else using it might also be able to advise

[1856]

Ok will do, thanks Dallas