Quote:
|
{US2Real(range of US Odds)} or {Dec2Real(range of Decimal Odds)}: (array function) Returns an array of zero-vig probabilities based on an Excel range of US or decimal odds. So if cells A1 and A2 are both -110, if B1, B2, and B3 were set to the array formula {=US2Real(A1:A2)}, B1 and B2 would both have the value of 50%, and B3 would have the value of the theoretical hold (4.54545%).
|
This one doesn't work for me. If A1 and A2 are both -110, =us2real(a1:a2) gives me .52381 in each of b1 and b2, and b3 gives -0.00527. Am I using it correctly?
Thanks for this, btw. It is extremely helpful in cleaning up my ghetto spreadsheet with calculation cells everywhere. This is very helpful!
