Camarilla Pivot Points is one of the most popular Intraday Trading techniques used by beginners and professional traders. We have already introduced this method in one of our previous posts with an online calculator. Please find it here. We have also created Camarilla Pivot Points Excel Sheet for all F&O stocks in NSE. This sheet will be updated live based on market data. See below for details:
Scroll right and left to view all the pivot values. Below is the link for Camarilla Pivot points Excel sheet which you can view online.
How to Trade based on Camarilla Pivot Points Excel Sheet?
Look at the opening price for the stock/futures/commodities/currency.
Image Credits: https://sites.google.com/site/intradayautomatedsoftware/Intraday_Trading_Using_Camarilla_and_Advanced_Camarilla.pdf
Scenario 1
Open price is between H3 and L3
For Long
Wait for the price to go below L3 and then when it moves back above L3, buy. Stoploss will be when price moves below L4. Target1 – H1, Target2 – H2, Target3 – H3
For Short Sell
Wait for the price to go above H3 and then when the price moves back below H3, sell. Stoploss will be when price moves above H4. Target1 – L1, Target2 – L2, Target3- L3
Scenario 2
Open price is between H3 and H4
For Long
When price moves above H4, buy. Stoploss when price goes below H3. Target – 0.5% to 1%
For Short Sell
When the price goes below H3, sell. Stopless when prices moves above H4. Target1 – L1, Target2 – L2, Target3- L3
Scenario 3
Open price is between L3 and L4
For Long
When price moves above L3, buy. Stoploss when price moves below L4. Target1 – H1, Target2 – H2, Target3 – H3
For Short Sell
When the price goes below L4, sell. Stoploss when price moves above L3. Target – 0.5% to 1%
Scenario 4
Open price is above H4
For Long
Buying is not suggested in such scenarios.
For Short Sell
When the price goes below H3, sell. Stoploss when price moves above H4. Target1 – L1, Target2 – L2, Target3- L3
Scenario 5
Open price is below L4
For Long
When the price goes above L3. Stoploss when price moves below L3. Target1 – H1, Target2 – H2, Target3 – H3
For Short Sell
Short Selling is not suggested in such scenarios.
Please let us know in the comments section if you have any queries.
Hi ,
Thanks for posting this useful link
Is it possible to find the stocks that opens between L3 and L4
similary H3 and H4?
Hi Selva,
As of now, it is not possible automatically in the Excel sheet provided. You would require manual observation for that.
Sir can you clarify the multiplying factors i.e 0.55,0.275,0.183,0.0916 used in H1,H2,H3,H4 & L1,L2,L3,L4 what are this multiplying factors & where from they are derived as in fibinacci we can know where from & how .382,.618 etc are derived please clarify,
And explain what is pivot point trading & woodie point trading & difference between all the above three methods
Regards
Sir can you clarify the multiplying factors i.e 0.55,0.275,0.183,0.0916 used in H1,H2,H3,H4 & L1,L2,L3,L4 what are this multiplying factors & where from they are derived as in fibinacci we can know where from & how .382,.618 etc are derived please clarify,and are there only 4 support & resistance ao can it be extended as if the price breaks through H4 or L4 then what are the next points?
And explain what is pivot point trading & woodie point trading & difference between all the above three methods
Regards
Hi Sir is this sheet not working anymore , i tried this but it was left blank
Can you check now? I can see the values populated
Hello Sir yes now its coming Thanks for the prompt reply
Hello Sir 1st of all Thanks for This wonderful Tool But Sir few suggestions from my end that will make it more awesome since i am using it , Please Make the window smaller Upto the No of stocks only Because during the market hours it becomes difficult to scroll the same up and down , secondly on real time can you put a conditional formatting so that whenever the prices cross H4 and L4 there should be a change in Colour . Thanks in advance sir
Hi Nitesh,
Thanks for the great suggestion. Will try to incorporate the same.
Hello Sir,
The Kind of excel you have updated is it possible to Link it To real Time Prices , can you please Teach me this how to to sir , Will realy appreciate it will improve my Trading experience to a great extend .
this sheet not working anymore, I tried this but it was left blank, shows only 000
Works perfectly for me. Please try again
This sheet is not working ,showing values zero only
can u pls update
Hi Shiv,
The issue is fixed, please check
How do you get yesterday’s high low and close using google sheets. I tried with today()-1 and returned error.
Hi,
Is there a way to get this excel sheet so that we can write the buy formula and use it.
i want to subscribe
Will it be possible to add one more column at the end “Current Open Price” of the stocks please.
Date of data should be mentioned on the worksheet to avoid confusion as to whether data is updated after closing of market or otherwise.
Pls update Lastest F&O stocks.
Pls update latest F&O Stocks
Hi Janardhan,
Updated the sheet with latest F&O stocks, thanks for the feedback!
Hi Sir Thanks for your update F&O Current Stock list 141, but your sheet has 162 +2 Nifty & BN. Please do the correction.
Please include as below mentioned stocks. Which is not available in your sheet
BAJAJFINSV
BALKRISIND
BANDHANBNK
BERGEPAINT
CHOLAFIN
EQUITAS
ESCORTS
GODREJPROP
HDFCLIFE
ICICIPRULI
IDFCFIRSTB
INDIGO
MANAPPURAM
MFSL
MGL
MUTHOOTFIN
NATIONALUM
NAUKRI
NESTLEIND
NIITTECH
PEL
PVR
RAMCOCEM
RBLBANK
SBILIFE
SHREECEM
TATACONSUM
TORNTPOWER
UJJIVAN
Hi Janardhan,
Sure, we’ll add these stocks
Unable to read the first three column headings(previous day data) or probably I dont know how to manipulate the sheet.
Could u kindly let me know how it is done.
Can you make available in Goggle Sheet , like what you did in CPR . would be useful to download . Thanks.
Hi Garani,
Are you looking for access to this spreadsheet?
Hi,
Thank you for sharing very informative contents always.
Do you have AFL or Trading View Strategy for auto buy sell signals? Please provide. Will be appreciated.