ATP Stats - Power Query

Post Reply
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Now have all the tennis stats loaded into power query
so all details at my fingertips.

example win/loss query for andy murray and Rafa Nadal.

Capture.PNG
Capture1.PNG
Capture3.PNG
You do not have the required permissions to view the files attached to this post.
sniffer66
Posts: 1666
Joined: Thu May 02, 2019 8:37 am

Nice

Good to have these for current surface, last year/90/30/10 as well,. Plus predicted hold for H2H ;)
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: H2H = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: Confidence = 1
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: ServiceHold% = 75
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: ReturnPtsW% = 44.9
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: BPSave% = 56.4
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: BreakPtW% = 55.3
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: OppHold% = 61.8
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: ServicePtsW% = 60.4
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: 1stServe% = 57
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: 1stServePtsW% = 68
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: 2ndServe% = 80.3
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: 2ndServePtsW% = 50.8
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: ReturnGamesW% = 38.2
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: TieBreaks = 33
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: PredictedHolds = 73.1
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: BrokenInFirstServiceGame = 16.7
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: BrokenAndBreakBackBeforeEndOfSet = 25
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: GetTheFirstBreakOfServe = 66.7
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: ImmediatelyBrokenBackAfterBreaking = 20
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: HoldServeAt5-4 = 66.7
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: BrokenServingAt5-4LoseSet = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: HoldServeToWinSetAnyScore = 72.7
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: WinSet1WinsIn2Sets = 75
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: WonSet1WonMatch = 100
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: LostSet1WonSet2 = 50
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: LostSet1WonMatch = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: BrokenFirstInSet2AfterWinningSet1 = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: LostSet1Broken1stSet2WinSet2SetAndBreak = 50
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: LostSet1Get1stBreakInSet2 = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Jana Fett: WonSet1Winner3Sets = 100
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: H2H = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: Confidence = 1
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: ServiceHold% = 65.8
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: ReturnPtsW% = 42.7
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: BPSave% = 43.2
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: BreakPtW% = 52.2
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: OppHold% = 66.7
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: ServicePtsW% = 56.6
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: 1stServe% = 63.4
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: 1stServePtsW% = 62.1
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: 2ndServe% = 90.1
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: 2ndServePtsW% = 47.1
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: ReturnGamesW% = 33.3
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: TieBreaks = 100
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: PredictedHolds = 59
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: BrokenInFirstServiceGame = 50
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: BrokenAndBreakBackBeforeEndOfSet = 44.4
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: GetTheFirstBreakOfServe = 37.5
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: ImmediatelyBrokenBackAfterBreaking = 19.2
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: HoldServeAt5-4 = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: BrokenServingAt5-4LoseSet = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: HoldServeToWinSetAnyScore = 60
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: WinSet1WinsIn2Sets = 80
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: WonSet1WonMatch = 80
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: LostSet1WonSet2 = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: LostSet1WonMatch = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: BrokenFirstInSet2AfterWinningSet1 = 40
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: LostSet1Broken1stSet2WinSet2SetAndBreak = 0
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: LostSet1Get1stBreakInSet2 = 50
14/06/2022 18:30:08: [G_Auto 2] : Store Value for Shuai Zhang: WonSet1Winner3Sets = 0
14/06/2022 18:30:08: [G_Auto 2] : Automation Signal for market: Output = 1
Last edited by sniffer66 on Wed Jun 15, 2022 10:12 am, edited 1 time in total.
fxcarllos
Posts: 14
Joined: Thu Aug 19, 2010 8:58 pm

where do you guys get these stats from?
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.PNG
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Tennis Trading”