Comments for

Comment on Grabbing Pinnacle Lines with Excel and DOM by Sirio

Sirio — Wed, 20 Mar 2013 11:25:38 +0000

Buenos dias, desde Venezuela! Muchas gracias.. Me sirvio tu ejemplo!

Comment on Grabbing Pinnacle Lines with Excel and DOM by KMc101217

KMc101217 — Wed, 31 Oct 2012 19:45:02 +0000

Hi mate,

Nice article.

I am a complete VBA programming virgin, and am having a problem with the code above. I’m wondering if you could help?

I am getting a “Compile Error: Syntax Error” for the following two lines:

Sheets(“Sheet1″).Cells(Rows.Count, 3).End(xlUp)(2, 1) = events.LastChild.FirstChild.SelectSingleNode(“spread”).FirstChild.Text & ” ” & events.LastChild.FirstChild.SelectSingleNode(“spread”).ChildNodes(1).Text
Sheets(“Sheet1″).Cells(Rows.Count, 5).End(xlUp)(2, 1) = events.LastChild.FirstChild.SelectSingleNode(“spread”).ChildNodes(2).Text & ” ” & events.LastChild.FirstChild.SelectSingleNode(“spread”).ChildNodes(3).Text

Any idea what the problem may be?

Comment on How to Build a Line Database by sportsfan11

sportsfan11 — Fri, 08 Jun 2012 05:53:31 +0000

Would you be willing to do a piece on derivatives for the upcoming NFL season? Thanks for doing these.

Comment on Grabbing Pinnacle Lines with Excel and DOM by imabev

imabev — Mon, 25 Jul 2011 13:10:30 +0000

Nice article and good stuff on this blog as well. With BetJamaica totally changing their format my sports odds source that runs my website dried up. I am going to be testing the pinnacle xml scrape today…I need to grab all of the info from the xml but your code gives me some good ideas.

Comment on Adding Bullpen Variance to Creating an MLB Moneyline by mranderson65

mranderson65 — Sat, 23 Jul 2011 22:04:58 +0000

me too

Comment on Adding Bullpen Variance to Creating an MLB Moneyline by Pancho3

Pancho3 — Mon, 16 May 2011 19:46:18 +0000

I would be interested in your updated dynamic excel MLB linemaker that you offered.

Thank you in advance.

Pancho

Comment on Week 6 NFL Line Movement Picks by More on NFL Line Movement: Random Market Space | The Overround

More on NFL Line Movement: Random Market Space | The Overround — Tue, 30 Nov 2010 18:22:04 +0000

[...] Some requisite info here and here. [...]

Comment on More on NFL Line Movement: Random Market Space by NFL Openers, Market Optimization, and Game Theory | The Overround

NFL Openers, Market Optimization, and Game Theory | The Overround — Wed, 24 Nov 2010 04:48:02 +0000

[...] and hardly offers room for discussion. However, why this is relevant is the information I uncovered before about closers and line precision. To wit, closers are a stoppage of random variation and the direction of line movement serves no [...]

Comment on NFL Against the Spread Value and Z by NFL Value Monitor Update Week 12 | The Overround

NFL Value Monitor Update Week 12 | The Overround — Wed, 24 Nov 2010 01:22:54 +0000

[...] Here are this week’s numbers. Again these are z-score aggregations of Pythagorean over Against the Spread percentage, explained to capacity here. [...]

Comment on “Beating the Closing Line” by More on NFL Line Movement: Random Market Space | The Overround

More on NFL Line Movement: Random Market Space | The Overround — Sat, 16 Oct 2010 03:36:10 +0000

[...] requisite info here and [...]