NexusFi: Find Your Edge


Home Menu

 





Pivot Point Calculation


Discussion in Traders Hideout

Updated
      Top Posters
    1. looks_one Fat Tails with 27 posts (37 thanks)
    2. looks_two trendisyourfriend with 18 posts (3 thanks)
    3. looks_3 vikstock with 2 posts (0 thanks)
    4. looks_4 josh with 2 posts (0 thanks)
    1. trending_up 36,521 views
    2. thumb_up 41 thanks given
    3. group 4 followers
    1. forum 54 posts
    2. attach_file 12 attachments




 
Search this Thread

Pivot Point Calculation

  #1 (permalink)
 
trendisyourfriend's Avatar
 trendisyourfriend 
Quebec Canada
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader
Broker: AMP/CQG
Trading: ES, NQ, YM
Frequency: Daily
Duration: Minutes
Posts: 4,527 since Oct 2009
Thanks Given: 4,176
Thanks Received: 6,020

What levels do you consider to calculate the Floor Pivots for the day ?

Previous Day High (including the overnight Action)
Previous Day Low (including the overnight Action)
Previous Day Close or Settlement

or

Previous Session High (Regular Trading Hours)
Previous Session Low (Regular Trading Hours)
Previous Day Close or Settlement

Which of these two groups is the correct one ?

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Better Renko Gaps
The Elite Circle
Quant vue
Trading Reviews and Vendors
What broker to use for trading palladium futures
Commodities
How to apply profiles
Traders Hideout
REcommedations for programming help
Sierra Chart
 
  #3 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103



trendisyourfriend View Post
What levels do you consider to calculate the Floor Pivots for the day ?

Previous Day High (including the overnight Action)
Previous Day Low (including the overnight Action)
Previous Day Close or Settlement

or

Previous Session High (Regular Trading Hours)
Previous Session Low (Regular Trading Hours)
Previous Day Close or Settlement

Which of these two groups is the correct one ?

There is nothing correct in trading. It is a game of n market participants using n different approaches. The floor pivot was used by floor traders because they did not have calculators and computers. So they relied on information available prior to the session. For the floor pivots you would take the settlement price, not the close. The floor traders calculated their floor pivots using the RTH (floor) session.

Now floor pivots are nothing special. They work as a self-fulfilling prophecy. A gathering point for initiated traders to take the bus back into the valley after having enjoyed the panorama of the peak.

So the question is, which pivots are used by the majority of the traders, or let us say the traders, who make up for most of the volume. Professional traders tend to take the official numbers from the stock exchange, so the correct values for open high and settlement for ES can be found under www.cmegroup.com every day. The values published there refer to the trading session. A trading session is characterized by a common settlement date. Pay attention, there are a number of two-day-sessions around holidays, so you need to calculate the two-day-session pivots (5 days for ES per year). For ES the published high and low is the Globex full session high and low, the settlement would be the weighted average price of all trades during the last 30 seconds of the regular session, so for ES the settlement price is rarely more than 3 ticks off the close.

For bonds and agricultural commodities the settlement price is often a couple of hours earlier than the closing price. So there is a significant difference. I would opt for the settlement price.

For currency futures, however, I would not take the settlement price. The currency futures market is relatively small compared to the FOREX market, so it will follow FOREX anyhow and nobody cares about the settlement time of GLOBEX. The correct close for FOREX would be the New York close at 5 PM Eastern Time.

Practical Application to Trading

You cannot generate the settlement times easily from intraday data. You would need an indicator that "knows" the settlement period of each futures contract, stored in a data base, and calculates the settlement price from tick data by averaging all trades over the settlement period. Therefore all pivot indicators that work with intraday data take the close instead of the settlement price. This is fine for

- index futures (3 ticks off means that the pivots are only 1 tick off)
- currency futures and FOREX (you want the close anyhow)

but it is bad for

- bonds and commodities

If you want better than this, you have two options:

(a) you work (look up correct values on the website and enter them manually into the indicator panel)
(b) you pay for it (pay a decent data feed that delivers daily data with settlement prices)

In case you use Ninjatrader, and you are both lazy and poor, there is a third option:

You can use the free daily Kinetick data. As far as I have seen, it has the settlement price for bonds and commodities (you would need to check this).

Close all your intraday charts and open one daily default chart. Connect to Kinetick Daily Data. Reload the chart data. Your daily data now shows the settlement prices. Disconnect. Connect to your regular data feed. Now open intraday chart and apply the standard NinjaTrader pivots indicator or the SessionPivots indicator in DailyBars mode and you are done.

Reply With Quote
  #4 (permalink)
 
trendisyourfriend's Avatar
 trendisyourfriend 
Quebec Canada
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader
Broker: AMP/CQG
Trading: ES, NQ, YM
Frequency: Daily
Duration: Minutes
Posts: 4,527 since Oct 2009
Thanks Given: 4,176
Thanks Received: 6,020

Thanks Fat for your excellent reply.

You wrote:
For ES the published high and low is the Globex full session high and low

You seem to imply these numbers are used to calculate the floor pivots. I trade with other traders who select the High/Low from the regular trading hours between 9:30 to 4:15 which produce different levels. I would tend to believe that more traders use the RTH High/Low than the full trading day including the Globex part for the High and Low. But again it's not something easy to determine.

Started this thread Reply With Quote
  #5 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103

You are absolutely right. Many traders use RTH pivots, and also many traders use ETH pivots. The original floor pivots were calculated from the RTH session (of course), so traditionalists may continue to use them.

If you want to know, which ones work better, you would have to put them on your chart and examine price action. I have done this several times and have found, that price reacted to both types of pivots. In the end I decided to use Globex pivots. But this choice is not at all obvious.

If you have time to do the comparison, I would be interested in your conclustions.



trendisyourfriend View Post
Thanks Fat for your excellent reply.

You wrote:
For ES the published high and low is the Globex full session high and low

You seem to imply these numbers are used to calculate the floor pivots. I trade with other traders who select the High/Low from the regular trading hours between 9:30 to 4:15 which produce different levels. I would tend to believe that more traders use the RTH High/Low than the full trading day including the Globex part for the High and Low. But again it's not something easy to determine.


Reply With Quote
Thanked by:
  #6 (permalink)
 
trendisyourfriend's Avatar
 trendisyourfriend 
Quebec Canada
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader
Broker: AMP/CQG
Trading: ES, NQ, YM
Frequency: Daily
Duration: Minutes
Posts: 4,527 since Oct 2009
Thanks Given: 4,176
Thanks Received: 6,020

Can anyone tell me what numbers you have for the pivot numbers today on the ES ?

Using Regular Trading Hours ONLY:

Yest High = 1090,50
Yest Low = 1079,25
Yest Settlement = 1089,50
Yest open = 1081,75

Can you confirm if these numbers are correct ?

PP = 1086,50
R1 = 1093,75
R2 = 1097,75
R3 = 1105,00
R4 = 1112,00
S1 = 1082,50
S2 = 1075,25
S3 = 1071,25
S4 = 1067,00

Started this thread Reply With Quote
Thanked by:
  #7 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103


trendisyourfriend View Post
Can anyone tell me what numbers you have for the pivot numbers today on the ES ?

Using Regular Trading Hours ONLY:

Yest High = 1090,50
Yest Low = 1079,25
Yest Settlement = 1089,50
Yest open = 1081,75

Can you confirm if these numbers are correct ?

PP = 1086,50
R1 = 1093,75
R2 = 1097,75
R3 = 1105,00
R4 = 1112,00
S1 = 1082,50
S2 = 1075,25
S3 = 1071,25
S4 = 1067,00

Yes, these levels are correct - except for rounding errors. Note that there are two different forumulae for calculating S3 and S4. The left chart below shows the narrow pivots that you used. The right chart shows the wide pivots.

Attached Thumbnails
Click image for larger version

Name:	Narrow.jpg
Views:	364
Size:	99.1 KB
ID:	19660   Click image for larger version

Name:	Wide.jpg
Views:	317
Size:	97.6 KB
ID:	19661  
Reply With Quote
  #8 (permalink)
 
trendisyourfriend's Avatar
 trendisyourfriend 
Quebec Canada
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader
Broker: AMP/CQG
Trading: ES, NQ, YM
Frequency: Daily
Duration: Minutes
Posts: 4,527 since Oct 2009
Thanks Given: 4,176
Thanks Received: 6,020


Fat Tails View Post
Yes, these levels are correct - except for rounding errors. Note that there are two different forumulae for calculating S3 and S4. The left chart below shows the narrow pivots that you used. The right chart shows the wide pivots.

That explain why one of my friend has different numbers than i have. I must admit, i find all these different methods and calculus a pain in the ass to handle. I never know if what i am using is pertinent.

Which method do you use the narrow or wide ?

Started this thread Reply With Quote
  #9 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103


trendisyourfriend View Post
That explain why one of my friend has different numbers than i have. I must admit, i find all these different methods and calculus a pain in the ass to handle. I never know if what i am using is pertinent.


Trading is a n-person game and there are no wirtten rules, which pivots to use.

Camouflage, fallacies and illusions are part of the game. You are free to choose the pivots you like best!

Reply With Quote
  #10 (permalink)
 
trendisyourfriend's Avatar
 trendisyourfriend 
Quebec Canada
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader
Broker: AMP/CQG
Trading: ES, NQ, YM
Frequency: Daily
Duration: Minutes
Posts: 4,527 since Oct 2009
Thanks Given: 4,176
Thanks Received: 6,020


Fat, would you mind checking this Excel file. I have put my formulas to calculate the daily pivots (rounded to the nearest tick). Could you edit it so that i can compute the narrow pivots too for S3/R3 and S4/R4 ?



Excel file included below.

Attached Files
Elite Membership required to download: DailyPivots_Calculation.xls
Started this thread Reply With Quote




Last Updated on May 31, 2011


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts