First, let me say that it is nice to know that Spicer from twinspires looked into fixing the tote errors from Hong Kong races.
The information that follows is a little complicated to explain, but I hope I made it clear enough to be helpful in tracking down and fixing the errors for the upcoming HK meeting that begins early September.
I have spoken with a couple of racing colleagues about the HK tote feed from TS and they verified that there were errors on Sunday. One of my colleagues also confirmed my suspicions that tote errors had been occurring throughout the entire meeting.
FYI:
Attached are two GIFs of the tote data for Hong Kong race #11 at Sha Tin on Sunday, July 15, 2018.
The first GIF shows all the final win pool bets on each horse based on data retrieved from via a commercial tote service one colleague subscribes to. Note that #7 and #9 each have 8388607 bet on them. These amounts are incorrect. It also shows the final win pool total of 38168081. This amount is also incorrect.
The second GIF shows the final win pool total as it appeared on the HKJC.com website. The win pool total was 54999715. The difference between the TS win pool total and the HKJC win pool total is more 16 million dollars.
The odds on #7 on the HKJC site were listed at 2.2-1. This converts to 1.1-1 in U.S. odds. The odds on #9 were 2.4-1 in U.S. odds.
The twinspires tote showed the odds on #7 and #9 both to be 7.55-1 U.S. odds -- much higher than they actually were. Those two horses were the co-favorites, not middling longshots.
Here are the final win pool bets from TS on each horse in Race #11 at Sha Tin on Sunday, July 15, 2018 that I pulled from the XML data in their feed:
Code:
# 1 - 1417365
# 2 - 1381498
# 3 - 1056914
# 4 - 1725554
# 5 - 501949
# 6 - 2615371
# 7 - 8388607
# 8 - 3257500
# 9 - 8388607
#10 - 901818
#11 - 1928416
#12 - 4360084
#13 - 186704
#14 - 2057694
--------------
ttl - 38168081
==============
Note the win pool total from the XML data. It matches the win pool total for the TS data from the commercial service shown in the attached spreadsheet in GIF format. The TS win pool totals are wrong because #7 and #9 have incorrect win bet amounts shown for them.