Hi edymurph, thank you for your reply.
I see you’re using the last 4 numbers to determine high-low range
Position 8On position 8 the high should be 457 as it was the highest of the last 4 numbers, low should be 430 and close is 443 which is the latest figure
High 457, Low 430, Close 443 (457 is the high of the last 3 numbers (also the last 4 numbers))Using those numbers the Fibonacci R1 is 453.6473, the Camarilla R3.5 is 452.9 they average 453, which is 1 off the answer of 452.
As to which columns are the best to use, it would be nice if there was a perfect answer to this!
Sometimes a high – low range of about 10-15 may give better results (as larger or smaller ranges may or may not give accurate results). So you can look at the last 2 or 3 or 4 numbers and experiment with the answers, eg you may try and make your high-low range around 10-15 and see if you get better answers. (Close will always be the latest number)
So you may get this sized range from the last 2 numbers, the last 3 or the last 4. Sometimes this may not be possible with the answers eg if the high- low was about 20 or 30, or very small like 5, these numbers may or may not give the best answers
As to which column to choose, you have to make an educated guess as to where it is likely to go (after you’ve guessed the direction). You may see if 1 column such as Floor R1 is 456.666, Camarilla R4 is 457.85, as the 2 numbers seem close you may choose 457 as your prediction for example.
Or on the expanded customized calculations box, Fibonacci R1 is 453.6473, Camarilla R3.5 is 452.9, you may choose 453 as your prediction (and this was close but off by 1 as the answer was 452)
High 443, Low 430, Close 443 (443 is the high of the last 2 numbers)But to try this again with High 443, Low 430 , Close being the latest of 443, in the main pivot points used box, Floor R1 was 451.6667, Fibonacci R3 was 451.6667, rounding up to 452. The answer was 452 for game 1822 at position 8.
This is a much better example where the high- low range was between 10-15 (it was actually 13) and the 2 numbers aligned the same and the answer hit this level.
Also on this same calculation, Camarilla R3 was 446.575, Fibonacci R2 was 446.7007, Floor R1 was 447.333. These 3 calculations averaged around 447 which wasn’t the correct answer. The 3 of them approximated 447, however Floor R1 and Fibonacci R3 were both exactly the same at 451.6667 and the answer ended up being 452.
So you have to make an educated guess as to which number to use, in this case the 2 that were exact were the answer, but that may or may not always be the case each game.
Going through the other two positions from your screenshotsPosition 10On position 10 High should be 425, Low 395 and Close is 425
(out of the last 4 numbers the Low could be: last 2 numbers 406, last 3 numbers 397, last 4 numbers 395)
On you screenshot using the last 4 numbers 395 would be the low
High 425, Low 395, Close 425 (answer 397)Using these numbers in the main pivots box, Fibonacci S2 is 396.46, there are no other levels that come near this number. Fibonacci S3 and Floor S2 both give 385 and this would be the wrong predicted answer. So it is an educated guess as to which level to use
High 425, Low 406 and Close 425The high- low range is 19 (425-406)
Fibonacci S3 and Floor S2 both give 399.667 and this would be closer (rounded up to 400) but still be the wrong predicted answer.
High 425, Low 397 and Close 425In the main pivots box Fibonacci S3 and Floor S2 both give 387.667 and this would be the wrong predicted answer. Fibonacci S2 came the closest at 398.627
Position 9 These were the last 4 numbers entered correctly (on the screenshot) with High at 592, Low 571 and Close 576.
High at 592, Low 571 and Close 576. (high – low range is 22)In the main pivots box both Floor S2 & Fibonacci S3 were 558.667. This would give the wrong predicted answer.
Camarilla S4 was 564.45, Fibonacci S2 was 566.6887, the answer of 565 could be found from approximating an average of these 2 numbers.
However Fibonacci S2 was 566.6887 and Floor S1 was 567.333, these 2 figures would give a predicted figure of 567 which is 2 off the answer of 565.
High at 592, Low 578 and Close 576. (578 is the low of the last 3 numbers) High - Low range is 14
Both Fibonacci S3 and Floor S3 are 568 which is 3 off the correct answer of 565.
Also in this game the direction prediction failed, as for level 9 if the latest (or close) is below 586, the next number is often higher than the latest. Projecting upward both Fibonacci R3 and Floor R1 were 596, Fibonacci R1 was 587.348 and Floor R1 was 586, and Camarilla R1 was 577.2833, Camarilla R2 was 578.5667. Both Fibonacci R3 and Floor R1 at 596 may have been a prediction, but all of these upward predictions ended up being wrong.
Using High 592, Low 576, Close 576 (576 is the low of the last 2 numbers, high – low range is 16)Both Floor S2 and Fibonacci S3 found the answer at 565.3333. This is a good example of a high - low range at 16 and the 2 levels being aligned. And this was found from using the last 2 numbers eg 592 and 576
However the upward projection could be Fibonacci R3 & Floor R2 both at 597.333 and this was wrong as the direction failed this game (in reverse the downward projection was 565.333 & was the correct answer)
Also in the Pivot Point Calculations Spreadsheet, in cell Q15, the Camarilla 2 in red should say S 1.5 not R 1.5 (sorry my mistake!) the calculations are still accurate.
Hope this helps
Thanks