Nifty , bank nifty fibonacci retracement calculator excel sheet

Nifty , bank nifty fibonacci retracement calculator excel sheet

Stock futures July 30, 2019

Fibonacci calculator - Nifty Fibonacci

Trading in nifty and bank nifty options and futures is very risky and volatile therefore we need some tool to identify the direction of the nifty and bank nifty price. After reading this blog we can predict the nifty and bank nifty levels very easily.

Nifty, bank nifty Fibonacci retracement calculator excel sheet


Procedure to predict nifty and bank nifty levels



  • Download nifty and bank nifty excel file from this link
  • Visit nse.com
  • Check the trend of nifty and bank nifty using 20 days moving average 
  • If the nifty and bank nifty closing price is above 20 days moving average it is in an uptrend
  • If the nifty and bank nifty closing price is below 20 days moving average it is in a downtrend
  • Check the high and low levels of nifty and bank nifty
  • Fill the high and low levels of nifty and bank nifty in excel sheet

    • Example to predict nifty and bank nifty levels if it is a downtrend

    • Check the trend of nifty. 
    • It is in downgrade because it trading below 20 days moving average.
    • Nifty High is 11267 
    • Nifty low is 11072
    • Fill this data in excel sheet 
    • Since 50 % is the reversal level 
    • Sell nifty when price touches the 50 % level with the stop loss of 61 % level

    Example to predict nifty and bank nifty levels if it is Uptrend. 

    • Nifty low is 11072 
    • Nifty low is 11267
    • Fill this data in excel sheet 
    • Since 50 % is the reversal level 
    • Buy nifty when price touches the 38.2 % level with the stop loss of 50 % level

    Check This Video to understand the magic of Fibonacci numbers link

    https://www.youtube.com/watch?v=SjSHVDfXHQ4

    Tags

    Post a Comment

    4 Comments

    1. godbooksJuly 30, 2019 at 9:26 PM

      Update more excel sheets

      ReplyDelete
    2. Stock futuresAugust 22, 2019 at 7:00 PM

      Use this excel sheet for your trading

      ReplyDelete
    3. arjunAugust 25, 2019 at 9:18 PM

      thanks for the sheet plz write or video how to use this excel sheet
      thanks for sharing

      ReplyDelete
    4. Bruce DavidAugust 30, 2019 at 6:10 AM

      Hello everyone..Welcome to my free masterclass strategy where i teach experience and inexperience traders the secret behind a successful trade.And how to be profitable in trading I will also teach you how to make a profit of $12,000 USD weekly and how to get back all your lost funds feel free to email me on(brucedavid004@gmail.com) or whataspp number is +22999290178

























      Hello everyone..Welcome to my free masterclass strategy where i teach experience and inexperience traders the secret behind a successful trade.And how to be profitable in trading I will also teach you how to make a profit of $12,000 USD weekly and how to get back all your lost funds feel free to email me on(brucedavid004@gmail.com) or whataspp number is +22999290178

      ReplyDelete

    Thank you for your valuable comment