first five SDQL question

[figue]

How can i sdql for a team the first five over /under results ??

[JMon]

Hey figue, sorry I didn't get back to you in the other thread. I've been out on business. Anyway, it's my understanding the SDQL database do not input first five odds into the database therefore I will not be able to provide info on this one.

Anything else you may need?
Anyone else want a situation looked up they would like historical numerical info on?

[figue]

im learning if i have any other issue for sure i will ask you for your help,thanks amigo.

[figue]

Hey figue, sorry I didn't get back to you in the other thread. I've been out on business. Anyway, it's my understanding the SDQL database do not input first five odds into the database therefore I will not be able to provide info on this one.

Anything else you may need?
Anyone else want a situation looked up they would like historical numerical info on?

Jmon i want to know how SDQL divisional dogs playing at home +100 to +120 or more....thanks.

[JMon]

Jmon i want to know how SDQL Home divisional dogs playing at home +100 to +120 or more....thanks.

I may be confused on your question. You want home divisional dogs from +100 to +120 and then +120 or more? If not let me know... Also keep in mind you can break down each query by season simply by typing 'and season' at the end of the query.



H and DIV and 120 >= line >= 100

			800-861 (-0.38, 48.2%) avg line: 108.9 / -118.9 on / against: +$876 / -$8,871 ROI: +0.5% / -4.5% 655-470 (0.96, 58.2%) avg line: -144.4 / 130.1 on / against: -$2,144 / -$4,183 ROI: -1.3% / -3.5% 769-818-72 (0.32, 48.5%) avg total: 8.8 over / under: -$12,145 / -$3,060 ROI: -6.7% / -1.7%

[JMon]

MLB database goes back to 2004.

H and DIV and line >= 120

687-989 (-1.20, 41.0%)	avg line: 142.8 / -155.1	on / against: -$2,349 / -$5,626	ROI: -1.4% / -2.2%
542-526 (0.13, 50.7%)	avg line: -122.4 / 110.1	on / against: -$10,103 / +$3,727	ROI: -7.6% / +3.4%
851-762-62 (0.66, 52.8%)	avg total: 8.7	over / under: +$1,970 / -$17,465	ROI: +1.1% / -9.4%

[figue]

thanks amigo .

[figue]

have another for nfl :

previous game team lose and score less than 11 points and opoponent margin of victory is greater than 9.what is winning record of that losing team for their next game ??

thanks.

[JMon]

figue..let me know if this is what you are looking for? You can back test it back to 1989 if you wish, but here is the


Last five years:

SDQL Off a loss of more than 9, scoring less than 11.

p:L and p: points<11 and po:margin>9 and 2008<=season





SU: 108-161-1 (-2.6)
ATS: 148-122-3 (.08) ave line: 3.3
OU: 138-129-6 (1.0) ave total: 41.9

[figue]

yeah thanks amigo JMon

[Kevin Garnett]

I have also a question cause sdql, I post it here in, cause here're already some replys. If I want review one season or the whole data sdq it only shows max. 100 entries. Which code does I need to see the complete schedules?

[JMon]

I have also a question cause sdql, I post it here in, cause here're already some replys. If I want review one season or the whole data sdq it only shows max. 100 entries. Which code does I need to see the complete schedules?

There are salient URL parameters that apply if you wish to see games played or unplayed games than the set 100 match ups. You MUST type after the URL (or web address). NOT after the query itself, so don't get it confused. Also there needs to be a space between the URL and the parameter.

They are:

&show_games
&show_unplayed

I will use an example using a SBR url...

forum.sbrforum.com/handicapper-think-tank/2409816 &show_games=200

Notice in bold...a query will show 200 games now instead of 100!

Same works with URL parameter &show_unplayed. This will show unplayed games. For instance, if you want to see upcoming divisional game schedule within the database.

You simply query

division=o:division

after the database performs the search and provides info., simply go to the URL or web address and provide a space, then type &show_unplayed=100. after refreshing your browser, the database will provide the next 100 "unplayed" divisional match ups

[figue]

Anothers nfl :

=fade team going into bye week that game

=take team after bye week

=fade the team the game before their bye week

=take team after bye week


what is the record SU ??

[Kevin Garnett]

There are salient URL parameters that apply if you wish to see games played or unplayed games than the set 100 match ups. You MUST type after the URL (or web address). NOT after the query itself, so don't get it confused. Also there needs to be a space between the URL and the parameter.

They are:

&show_games
&show_unplayed

I will use an example using a SBR url...

forum.sbrforum.com/handicapper-think-tank/2409816 &show_games=200

Notice in bold...a query will show 200 games now instead of 100!

Same works with URL parameter &show_unplayed. This will show unplayed games. For instance, if you want to see upcoming divisional game schedule within the database.

You simply query

division=o:division

after the database performs the search and provides info., simply go to the URL or web address and provide a space, then type &show_unplayed=100. after refreshing your browser, the database will provide the next 100 "unplayed" divisional match ups

Thanks, it works.

[Kevin Garnett]

@ jmon, do you also know how to review each division in sdql separately?

[JMon]

@ jmon, do you also know how to review each division in sdql separately?

Sure..

division= (what ever division you want to isolate)

EX.

division= AL West

word of caution watch your capitalization.

[JMon]

Anothers nfl :

=fade team going into bye week that game

=take team after bye week

=fade the team the game before their bye week

=take team after bye week


what is the record SU ??

You can query a lot situations using NFL's bye week. I have several bye week situations that are great money makers every year!

For example you want to play on a road favorite coming off a bye week. Since the 2007 season they are:

SDQL: week = p:week + 2 and AF and playoffs=0 and 2007<=season

29-6-0 (12.06, 82.9%)
27-7-1 (7.41, 79.4%)	avg line: -4.6
16-19-0 (-1.07, 45.7%)	avg total: 42.3

SDQL for bye week is

week=p:week + 2

If you want to eliminate rest within playoffs and focus on reg season add, playoff=0

so if we query

week=p:week + 2 and playoff=0

teams coming off a bye are since 1990:

394-352-3 (1.30, 52.8%)
380-353-14 (0.86, 51.8%)	avg line: -0.4
348-389-10 (0.24, 47.2%)	avg total: 41.0

Teams going into their bye week are SDQL by using the game reference 'n' or next game

SDQL of is:

week + 2 = n:week and n: playoffs=0

Since 1990, they are

372-377-0 (-0.47, 49.7%)
360-367-22 (-0.61, 49.5%)	avg line: -0.1
383-352-14 (1.16, 52.1%)	avg total: 41.0

Again, if you want to see individual season, simply type 'and season' at the end of a query

[Kevin Garnett]

Sure..

division= (what ever division you want to isolate)

EX.

division= AL West

word of caution watch your capitalization.

thanks

[figue]

thanks Jmon