line=None and other line errors in MLB data

[Jim Donovan]

Just documenting that there are 29 games in the MLB database where line=None.

SDQL: line=None and date<today

I am primarily documenting this in case I have the opportunity to fix this some day or in case someone else is interested in fixing it.

Also, the line for the Mets on 20210813 is incorrectly listed as 50.  I believe this should be 150 based on the opposing Dodgers line at -160.

Also, the line for the Mets on 20210616 is incorrectly listed as -30.  I believe this should be -300 based on the opposing Cubs line at 285.

Also there are 10 games where the lines must be incorrect based on their values.  Note that the calculation (-line-o:line) should always result in a positive number since the Favorite line (negative) should always be larger than the Underdog line (positive).

SDQL: -line-o:line<0 and line and o:line and H

Also there are 15 additional games where I assume the lines must be incorrect based on their values.  Note that the calculation (-line-o:line) should not = 0 if we are assuming that we are choosing one bookmaker and that bookmaker is trying to make a profit.

SDQL: -line-o:line=0 and line and o:line and H

There are also 15 games where the (-line-o:line) in in the range (1,2,3,4,5).  I suppose this is possible if a bookie is offering a special "no margin" offer on a game but my hunch is that it is not the intention of the SDQL database to include such anomalies.  I will need Joe's guidance on all this.

regards

Jim Donovan