TheBramble
Legendary member
- Messages
- 8,394
- Likes
- 1,170
Attached.
Just hypothetical data in it, but you can use it to calc both vanilla and Camarilla Pivots for any instrument of your choice.
Just enter the OHLC (in blue boxes) and the vanilla and Camarilla (red boxes) will be calculated automatically.
Ignore the other stuff - the ramblings of a disordered mind.
Just hypothetical data in it, but you can use it to calc both vanilla and Camarilla Pivots for any instrument of your choice.
Just enter the OHLC (in blue boxes) and the vanilla and Camarilla (red boxes) will be calculated automatically.
Ignore the other stuff - the ramblings of a disordered mind.
Salty Gibbon
Experienced member
- Messages
- 1,535
- Likes
- 6
I am sure that Charles has already calculated Camarilla's pivot points.
:cheesy:
:cheesy:
TheBramble
Legendary member
- Messages
- 8,394
- Likes
- 1,170
Well, that's great. Glad I was able to help. Apart from the fact it doesn't calculate correctly and doesn't take decimal points...BF1 said:
Let me know if there's anything else I can help you with BF1....
Doh!
TheBramble
Legendary member
- Messages
- 8,394
- Likes
- 1,170
I was referring to the 'app' you provided via url. That one doesn't appear to calculate correctly nor does it seem to allow decimal points to be used. Whereas my offering does both - superbly.BF1 said:
I'm delighted with your grading of my effort and feel I can now sleep easily at long last. Many thanks....BF1 said:
I provided my calculator on an 'as is' basis. If it meets your needs in any way, feel free to modify to your satisfaction - such as changing the format of the cells to 4dp if required. (If you need assistance in doing that - just let me know).
Hi Bramble,
Well Ive just tried it again and it seems to work fine and also accepts decimal points, so not sure whats going wrong with the one you have downloaded.
Are the two programs looking at different types of pivot points, if different types exist, that is? The link I provided only requires HLC whereas yours requires Open as well.
When I go to 4 decimal places on yours, it cuts off the last 2 decimal places and rounds it up. So, 1.7777 becomes 1.78.
Im new to understanding pivot points so have probably got it all wrong! Regardless, I appreciate the response to my enquiry and your help.
Thanks.
Well Ive just tried it again and it seems to work fine and also accepts decimal points, so not sure whats going wrong with the one you have downloaded.
Are the two programs looking at different types of pivot points, if different types exist, that is? The link I provided only requires HLC whereas yours requires Open as well.
When I go to 4 decimal places on yours, it cuts off the last 2 decimal places and rounds it up. So, 1.7777 becomes 1.78.
Im new to understanding pivot points so have probably got it all wrong! Regardless, I appreciate the response to my enquiry and your help.
Thanks.
TheBramble said:I was referring to the 'app' you provided via url. That one doesn't appear to calculate correctly nor does it seem to allow decimal points to be used. Whereas my offering does both - superbly.
I'm delighted with your grading of my effort and feel I can now sleep easily at long last. Many thanks....
I provided my calculator on an 'as is' basis. If it meets your needs in any way, feel free to modify to your satisfaction - such as changing the format of the cells to 4dp if required. (If you need assistance in doing that - just let me know).
Camarilla
Bramble Sir,
Thanks for the post of your spreadsheet.
I was particularly interested in the Camarilla equation.
I too thought that surefire thing used open as well as HLC, it seems that looking at your formula's it does not.
Am I correct?
Thanks
Dave
Bramble Sir,
Thanks for the post of your spreadsheet.
I was particularly interested in the Camarilla equation.
I too thought that surefire thing used open as well as HLC, it seems that looking at your formula's it does not.
Am I correct?
Thanks
Dave
