Best way to convert spread to ML to determine closing line value?

[chilidog]

I initially started using the 1/2 pt calculator to determine this, but it's a PITA to do this all the time. With everything else I have automated in my spreadsheet, I wanted to do this the same, so I started brainstorming different ways. I also don't know how current the 1/2 pt calculator is kept up to date with fresh data on push probabilities.

One option is to record the ML price of the spread bet I make and get probability % based on that, then determine CLV based on closing ML.

Another option is that I scraped all the closing lines for all the main US sports since 2019 and have them in a table in a separate sheet of my spreadsheet. If I grabbed the average ML value for, for example, every time the spread was -7 -105 in the NFL, would that be close enough to determine CLV?

 

[turbobets]

There are tools at unabated you can use.

 

[hazliam]

I initially started using the 1/2 pt calculator to determine this, but it's a PITA to do this all the time. With everything else I have automated in my spreadsheet, I wanted to do this the same, so I started brainstorming different ways. I also don't know how current the 1/2 pt calculator is kept up to date with fresh data on push probabilities.

One option is to record the ML price of the spread bet I make and get probability % based on that, then determine CLV based on closing ML.

Another option is that I scraped all the closing lines for all the main US sports since 2019 and have them in a table in a separate sheet of my spreadsheet. If I grabbed the average ML value for, for example, every time the spread was -7 -105 in the NFL, would that be close enough to determine CLV?

A high total vs a low total can affect the ML value too.

 

[bottomofthe9th]

I've seen multiple different ML's vs. spreads
I always wondered why

 

[mikesmith99]

I initially started using the 1/2 pt calculator to determine this, but it's a PITA to do this all the time. With everything else I have automated in my spreadsheet, I wanted to do this the same, so I started brainstorming different ways. I also don't know how current the 1/2 pt calculator is kept up to date with fresh data on push probabilities.

One option is to record the ML price of the spread bet I make and get probability % based on that, then determine CLV based on closing ML.

Another option is that I scraped all the closing lines for all the main US sports since 2019 and have them in a table in a separate sheet of my spreadsheet. If I grabbed the average ML value for, for example, every time the spread was -7 -105 in the NFL, would that be close enough to determine CLV?

I think that with three season under the belt that's enough pool size to have a number you can trust. In case of a huge disparity between the first season and the last 2 figure out an error percentage to take into account