Pivot Points All with HLC

[Lancer]

Here's two broadly useful ones; one for US equities, and one for index futures.

Take the existing PivotPointsAll formula and enhance it:

1) Add display of High, Low, and Close lines; (dash, 2).

2) Add display of pivot lines S3 and R3; (solid, 1).
(There are various formulas for calculating S3 and R3 floating around, and the correct one needs to be identified. The calculation used for S3/R3 in EFS pivots files in File Sharing may be incorrect.)

3) When the formula is first loaded in the current day premarket (prior to 9:30 AM ET) or in regular session, or if it is re-loaded in premarket or in regular session, it uses the prior day's regular session HLC for calculation and display of HLC and pivots. This is applicable also to all-session symbols ES #F, NQ #F, and the like.

4) At the end of the current day regular session (4:00 PM ET for equities; 4:15 PM ET for index futures):

a) Formula A, for equities: At 4:00 PM ET, the formula recalculates pivots and displays pivots and HLC lines based on the current day regular session HLC just ended. (If it is not possible for the formula to recalculate automatically at 4:00 PM ET, then it should recalculate as described if the formula is manually reloaded after 4:00.)

b) Formula B, for index futures: At 4:15 PM ET, the formula recalculates pivots and displays pivots and HLC lines based on the current day regular session HLC just ended. (If it is not possible for the formula to recalculate automatically at 4:15 PM ET, then it should recalculate as described if the formula is manually reloaded after 4:15.)

5) When the formula is first loaded in the current day's post-market (after 4:00 or 4:15 PM ET, but prior to midnight), or if it is re-loaded in the current day's post-market, it uses the current day's regular session HLC for calculation and display of HLC and pivots.

When trying to do this myself, the problems I'm running into are these:
A) The correct calculation of S3 and R3 is uncertain.
B) The formula uses the wrong HLC for all-session symbols (e.g. ES, NQ).
C) For the current day, at or after the current day's regular session close, the formula does not recalculate using the current day's regular session HLC.

Thanks in advance for your help.

[eSignal_JasonK]

Hello Lancer,

Have you seen Chris Kryza's PivotConsole.efs? It has R3, S3, High, Low, and Close. It also has an option to force RTH data for the ES and NQ. It does not recalculate the pivots for the current day after the regular trading session ends. That may be an option Chris could add to the formula. If not, perhaps we'll look into making a new version. Check this formula out if you haven't already. It has lots of other options you can turn off and on.

[Lancer]

Thanks for the referral to that formula. I took a look at it, but it's not what I'm looking for; also, its calculation of R3/S3 is incorrect. The correct calculation of R3/S3 is:

R3 = (P - S1) + R2; //Also same result: (P + R2) - S1
S3 = P - (R2 - S1); //Also same result: (P - R2) + S1