Floor Pivots.docx

Dear Sir, I need AFL for Expanded Floor Pivots with Top Central Pivot, Pivot, Bottom Central Pivot, as well as R1,R2,R3,R4 & S1,S2,S3,S4. I’m attaching you the source image of the formula from the Pivot Boss book written by Frank Ochea.

The below image is the perfect example which I got from a whatsapp group.

Further, I will tell you my requirement in this same AFL. Requirement 1: My main requirement in this AFL is, I should be able to check tomorrows pivot levels today itself after market hours. So that I can select favorable stocks to trade for tomorrow. Requirement 2: This AFL should show me a thin dotted line on previous day high and low and also for previous week (Mon-Fri) high and low, those lines I should be able to differentiate from usual pivot resistance and support level lines. Requirement 3: I should be able to do the following analysis to explore stocks with this AFL. Column-1 = Stock Name Column-2 = CMP Stocks which have narrow TC,PP,BC values. Condition “YES/NO” (Column-3) Stocks whose TC,PP,BC values lies within previous day TC,PP,BC values (like inside bar). Condition “YES/NO” (Column-4) Now in column 3& 4 I would have got some list of stocks does they have inside bar in daily candle? Condition “YES/NO” (Column-5) Now in column 3& 4 I would have got some list of stocks does they have two days inside bar in daily candle? Condition “YES/NO” (Column-6) The above stocks above or below 200/100/50/20 SMA. Condition “ABOVE/BELOW” (Column-7,8,9,10)

Kindly contact me, if you want any detail explanation over the phone. Please make the AFL which completely satisfies me.

Regards, K. GOMATHI SHANKAR, +917418499974, [email protected].