NexusFi: Find Your Edge


Home Menu

 





Proper Data To Caluculate Pivot Points For Daily, Weekly, Momthly, Yearly


Discussion in Emini and Emicro Index

Updated
      Top Posters
    1. looks_one searchman with 3 posts (0 thanks)
    2. looks_two MedianVelocity with 2 posts (2 thanks)
    3. looks_3 Quick Summary with 1 posts (0 thanks)
    4. looks_4 srgtroy with 1 posts (1 thanks)
    1. trending_up 3,236 views
    2. thumb_up 5 thanks given
    3. group 4 followers
    1. forum 7 posts
    2. attach_file 1 attachments




 
Search this Thread

Proper Data To Caluculate Pivot Points For Daily, Weekly, Momthly, Yearly

  #1 (permalink)
searchman
los angeles, ca., u.s.a.
 
Posts: 6 since Jan 2014
Thanks Given: 5
Thanks Received: 3

Hello, Everyone.
I have few questions regarding pivot points. The questions are based on hypothetical scenarios. The questions are as follows below. The involved market is ES.
1. Let's suppose that today is 03/13/2014, the second Thursday of the expiration month(the rollover day). Which contract month should I use to derive the Daily pivot points to trade on this day? The data points of 03/12/2014(the day before the rollover day)of March contract(the expiring contract), The data points of 03/12/2014 of June contract, or synthetic contract series such as some sort of Continuous contract? I know that some of you do not agree with the idea of trading on rollover days. However, please remember that this is only a hypothetical scenario.
2. On the same day(03/13/2014), which contract month should I utilize to calculate the Weekly pivot points? The data points of prior week from 03/03/2014 to 03/07/2014 of March contract, the data points of prior week from 03/03/2014 to 03/07/2014 of June contract, or from Continuous contract?
3. Let's suppose that today is 03/17/2014. Which contract month should I use to come up with Weekly pivot points for trading this particular trading week starting from 03/17/2014 to 03/21/2014? The data points of prior week from 03/10/2014 to 03/14/2014 of March contract, The data points of prior week from 03/10/2014 to 03/14/2014 of June contract, or Continuous contract?
4. Let's suppose that today is 03/31/2014, the last trading day of the month of March. On this day, should I use the Monthly pivot point values derived from calculation based on the data points from the period running from 02/03/2014 to 02/28/2014 of March contract? I know that this question may seem very odd to a lot of you but please bear with me on this conjectural exercise. The reason for this question is that, as you are aware, 03/31/2014 is the first trading day of the week as well as the last trading day of the month of March.
5. On the day of 04/01/2014, which contract month should I use to calculate the Monthly pivot points? March contract or June contract? Or some other data series?
6. What are your thoughts and opinions in regards to using Cash data in place of Futures data to calculate the pivot points? Also, I would like to know your thoughts and opinions on using Pit-traded S&P 500 futures contract data to calculate the pivot points to use to trade ES.
7. Is it really difficult to trade on Expiration day? Or is this just another market myth?
8. What is the logical way to calculate Yearly pivot points? I know this question seems like a trick question but, as you all know, Yearly pivot points involve five separate contract months.
Please read the questions very carefully before answering them. I got confused myself. Thank you very much.
Very best regards.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
Futures True Range Report
The Elite Circle
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Deepmoney LLM
Elite Quantitative GenAI/LLM
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
Battlestations: Show us your trading desks!
26 thanks
The Program
18 thanks
  #3 (permalink)
 MedianVelocity 
 
Posts: 135 since Dec 2013


The most valid ones during these periods would be to watch the SPX500 pivots off the FXCM feed, or the $SPX Pivots off one of the index feeds.

I have generally found that the most valid longer term pivots are the SPX500/$SPX ones. However, the pivots generated off the ES#(Continuous) are fine. They don't have to be perfect.

Reply With Quote
  #4 (permalink)
 MedianVelocity 
 
Posts: 135 since Dec 2013

I think nearly everyone has slightly different numbers for longer term pivots because of all of the different feeds.

You can hardly say which pivots matched up better. Yearly pivots, standard floor formula = dark blue. Halves are dotted.

On the plus side... Probably a lot of traders are mixed up about weekly/monthly pivot calculations during contract transition periods resulting in weaker pivot support/resistance areas.


Reply With Quote
  #5 (permalink)
 
srgtroy's Avatar
 srgtroy 
Los Angeles, California Republic
Legendary  R.I.P. 1965-2023 
 
Experience: None
Platform: Sierra Chart
Broker: CQG
Trading: ES
Posts: 1,928 since Jan 2011
Thanks Given: 1,375
Thanks Received: 3,722

I basically agree with @MedianVelocity. If all calculations are based on the same contract, using ES is fine. Anytime at least one "rollover" or more is concerned, I look to the SPX chart.

Reply With Quote
Thanked by:
  #6 (permalink)
searchman
los angeles, ca., u.s.a.
 
Posts: 6 since Jan 2014
Thanks Given: 5
Thanks Received: 3

Hello, MedianVelocity and srgtroy
Thank you very much for your answers to my questions
Best Regards.

Reply With Quote
  #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,102


searchman View Post
Hello, Everyone.
I have few questions regarding pivot points. The questions are based on hypothetical scenarios. The questions are as follows below. The involved market is ES.
1. Let's suppose that today is 03/13/2014, the second Thursday of the expiration month(the rollover day). Which contract month should I use to derive the Daily pivot points to trade on this day? The data points of 03/12/2014(the day before the rollover day)of March contract(the expiring contract), The data points of 03/12/2014 of June contract, or synthetic contract series such as some sort of Continuous contract? I know that some of you do not agree with the idea of trading on rollover days. However, please remember that this is only a hypothetical scenario.
2. On the same day(03/13/2014), which contract month should I utilize to calculate the Weekly pivot points? The data points of prior week from 03/03/2014 to 03/07/2014 of March contract, the data points of prior week from 03/03/2014 to 03/07/2014 of June contract, or from Continuous contract?
3. Let's suppose that today is 03/17/2014. Which contract month should I use to come up with Weekly pivot points for trading this particular trading week starting from 03/17/2014 to 03/21/2014? The data points of prior week from 03/10/2014 to 03/14/2014 of March contract, The data points of prior week from 03/10/2014 to 03/14/2014 of June contract, or Continuous contract?
4. Let's suppose that today is 03/31/2014, the last trading day of the month of March. On this day, should I use the Monthly pivot point values derived from calculation based on the data points from the period running from 02/03/2014 to 02/28/2014 of March contract? I know that this question may seem very odd to a lot of you but please bear with me on this conjectural exercise. The reason for this question is that, as you are aware, 03/31/2014 is the first trading day of the week as well as the last trading day of the month of March.
5. On the day of 04/01/2014, which contract month should I use to calculate the Monthly pivot points? March contract or June contract? Or some other data series?
6. What are your thoughts and opinions in regards to using Cash data in place of Futures data to calculate the pivot points? Also, I would like to know your thoughts and opinions on using Pit-traded S&P 500 futures contract data to calculate the pivot points to use to trade ES.
7. Is it really difficult to trade on Expiration day? Or is this just another market myth?
8. What is the logical way to calculate Yearly pivot points? I know this question seems like a trick question but, as you all know, Yearly pivot points involve five separate contract months.
Please read the questions very carefully before answering them. I got confused myself. Thank you very much.
Very best regards.

@searchman: Trying to give a few answers.

1. Of course you can trade on rollover day. The daily pivots for the new contract on rollover day should be calculated from the prior day's high, low and settlement price for the new contract. Alternatively you can also calculate them from a backadjusted contract. The backadjusted contract aligns the close of the old contract to the close of the new contract, therefore the closing value for the day prior to rollover day for the backadjusted contract is always identical with the closing value for the new contract. Prior day's high and low may deviate by one or two ticks, but this does not really matter. This leaves you with the following options:

-> Floor pivots: calculate from prior day's regular high, regular low and settlement for the new contract
-> Floor pivots: alternatively calculate from prior day's regular high, regular low and settlement for the backadjusted contract
-> Globex pivots: calculate from prior day's full session high, regular low and settlement for the new contract
-> Globex pivots: alternatively calculate from prior day's full session high, regular low and settlement for the backadjusted contract

2. For weekly pivots the same logic applies. You can easier use the new contract or the backadjusted contract. I personally would prefer the backadjusted contract, if the liquidity of the new contract was still low during the prior week. A continuous contract can be anything including a backadjusted or perpetual contracts. You should not calculate pivots from perpetuals.

3. - 5. Either new contract or backadjusted contract.

6. You can use cash data if the underlying cash market is liquid and publicly quoted.

-> Index futures: You can also use the cash index in conjunction with the cash market hours
-> Currency futures: You can calculate the pivots for the larger FOREX cash market
-> Bond futures: The quotes for the underlying bonds are not comparable, therefore pivots can only be calculated for the futures.
-> Crude oil: The underlying quotes for physical crude are not comparable in terms of grades and locations, also quotes are not easily available to the public (subscription for OMR etc. required)

7. Trading on expiration can be a problem under certain conditions

-> If physical commodities are involved prices in the old contract maybe impacted by shortages, the shorts are occasionally squeezed, in particular if delivery can only be made in a single location which can only be accessed by pipelines (Cushing, Oklahoma).
-> Options expiry may contribute to volatility.
-> However, financial futures such as currency futures do not show any particular exciting behaviour on rollover day.

8. It is easy to calculate yearly pivots for the cash market. As far as futures are involved I would probably calculate them from a perpetual contract to avoid to find levels which are artificially high or low. But I have never used yearly pivots.

Reply With Quote
Thanked by:
  #8 (permalink)
searchman
los angeles, ca., u.s.a.
 
Posts: 6 since Jan 2014
Thanks Given: 5
Thanks Received: 3

Hello, Fat Tails.
Thank you very much. Your answer completely clarified the field.
By the way, I am sorry that I could not reply back to your last PM due to futures.io (formerly BMT)'s policy that I can PM only once every 60 minutes.
Best Regards.
From searchman.

Reply With Quote




Last Updated on January 29, 2014


© 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