תיאור ⋅ 4 אוג׳ 2022 13:06 Intraday Buy/Sell Levels using Gann Angles based on Todays Open/previous Day High/Low/Close prices How to use this : The Buy/Sell levels will be calculated on 1 of 4 things (you can choose any one which you prefer) 1. Todays Open price 2. Previous Day High 3. Previous Day Low 4. Previous Day Close The Buy/Sell levels will be displayed in these ways 1. In a Table 2. on the Chart You can turn them on/off according to your preference! I can't seem to find the original documentation or a link to it. i have it's excel file, in which we have to enter following data : 1. Todays Open price 2. Previous Day High 3. Previous Day Low 4. Previous Day Close and the buy/sell levels are calculated by using the above data in following manner : Based On Today's Opening Price (lets call it TDO) Degree's````````````````` Degree Factor```````````````````````` Buy````````````````````````` Sell 11.25```````````````````` =degree/180=11.25/180=0.0625````````` =(sqrt(TDO)-0.0625)^2``````` =(sqrt(TDO)+0.0625)^2````` SL 22.5````````````````````` =degree/180=22.5/180=0.125``````````` =(sqrt(TDO)+0.125)^2```````` =(sqrt(TDO)-0.125)^2`````` Buy/Sell At 45``````````````````````` =degree/180=45/180=0.25`````````````` =(sqrt(TDO)+0.25)^2````````` =(sqrt(TDO)-0.25)^2``````` Target-1 90``````````````````````` =degree/180=90/180=0.5``````````````` =(sqrt(TDO)+0.5)^2`````````` =(sqrt(TDO)-0.5)^2```````` Target-2 135`````````````````````` =degree/180=135/180=0.75````````````` =(sqrt(TDO)+0.75)^2````````` =(sqrt(TDO)-0.75)^2``````` Target-3 180`````````````````````` =degree/180=180/180=1```````````````` =(sqrt(TDO)+1)^2```````````` =(sqrt(TDO)-1)^2`````````` Target-4 225`````````````````````` =degree/180=225/180=1.25````````````` =(sqrt(TDO)+1.25)^2````````` =(sqrt(TDO)-1.25)^2``````` Target-5 270`````````````````````` =degree/180=270/180=1.5`````````````` =(sqrt(TDO)+1.5)^2`````````` =(sqrt(TDO)-1.5)^2```````` Target-6 315`````````````````````` =degree/180=315/180=1.75````````````` =(sqrt(TDO)+1.75)^2````````` =(sqrt(TDO)-1.75)^2``````` Target-7 360`````````````````````` =degree/180=360/180=2```````````````` =(sqrt(TDO)+2)^2```````````` =(sqrt(TDO)-2)^2`````````` Target-8 sqrt = square root TDO = Today's Opening Price PDH = Previous Days High PDL = Previous Days Low PDC = Previous Days Close Based On Previous Days High Price (lets call it PDH) Degree's````````````````` Degree Factor```````````````````````` Buy````````````````````````` Sell 11.25```````````````````` =degree/180=11.25/180=0.0625````````` =(sqrt(PDH)-0.0625)^2``````` =(sqrt(PDH)+0.0625)^2````` SL 22.5````````````````````` =degree/180=22.5/180=0.125``````````` =(sqrt(PDH)+0.125)^2```````` =(sqrt(PDH)-0.125)^2`````` Buy/Sell At 45``````````````````````` =degree/180=45/180=0.25`````````````` =(sqrt(PDH)+0.25)^2````````` =(sqrt(PDH)-0.25)^2``````` Target-1 90``````````````````````` =degree/180=90/180=0.5``````````````` =(sqrt(PDH)+0.5)^2`````````` =(sqrt(PDH)-0.5)^2```````` Target-2 135`````````````````````` =degree/180=135/180=0.75````````````` =(sqrt(PDH)+0.75)^2````````` =(sqrt(PDH)-0.75)^2``````` Target-3 180`````````````````````` =degree/180=180/180=1```````````````` =(sqrt(PDH)+1)^2```````````` =(sqrt(PDH)-1)^2`````````` Target-4 225`````````````````````` =degree/180=225/180=1.25````````````` =(sqrt(PDH)+1.25)^2````````` =(sqrt(PDH)-1.25)^2``````` Target-5 270`````````````````````` =degree/180=270/180=1.5`````````````` =(sqrt(PDH)+1.5)^2`````````` =(sqrt(PDH)-1.5)^2```````` Target-6 315`````````````````````` =degree/180=315/180=1.75````````````` =(sqrt(PDH)+1.75)^2````````` =(sqrt(PDH)-1.75)^2``````` Target-7 360`````````````````````` =degree/180=360/180=2```````````````` =(sqrt(PDH)+2)^2```````````` =(sqrt(PDH)-2)^2`````````` Target-8 Based On Previous Days Low Price (lets call it PDL) Degree's````````````````` Degree Factor```````````````````````` Buy````````````````````````` Sell 11.25```````````````````` =degree/180=11.25/180=0.0625````````` =(sqrt(PDL)-0.0625)^2``````` =(sqrt(PDL)+0.0625)^2````` SL 22.5````````````````````` =degree/180=22.5/180=0.125``````````` =(sqrt(PDL)+0.125)^2```````` =(sqrt(PDL)-0.125)^2`````` Buy/Sell At 45``````````````````````` =degree/180=45/180=0.25`````````````` =(sqrt(PDL)+0.25)^2````````` =(sqrt(PDL)-0.25)^2``````` Target-1 90``````````````````````` =degree/180=90/180=0.5``````````````` =(sqrt(PDL)+0.5)^2`````````` =(sqrt(PDL)-0.5)^2```````` Target-2 135`````````````````````` =degree/180=135/180=0.75````````````` =(sqrt(PDL)+0.75)^2````````` =(sqrt(PDL)-0.75)^2``````` Target-3 180`````````````````````` =degree/180=180/180=1```````````````` =(sqrt(PDL)+1)^2```````````` =(sqrt(PDL)-1)^2`````````` Target-4 225`````````````````````` =degree/180=225/180=1.25````````````` =(sqrt(PDL)+1.25)^2````````` =(sqrt(PDL)-1.25)^2``````` Target-5 270`````````````````````` =degree/180=270/180=1.5`````````````` =(sqrt(PDL)+1.5)^2`````````` =(sqrt(PDL)-1.5)^2```````` Target-6 315`````````````````````` =degree/180=315/180=1.75````````````` =(sqrt(PDL)+1.75)^2````````` =(sqrt(PDL)-1.75)^2``````` Target-7 360`````````````````````` =degree/180=360/180=2```````````````` =(sqrt(PDL)+2)^2```````````` =(sqrt(PDL)-2)^2`````````` Target-8 Based On Previous Days Close Price (lets call it PDC) Degree's````````````````` Degree Factor```````````````````````` Buy````````````````````````` Sell 11.25```````````````````` =degree/180=11.25/180=0.0625````````` =(sqrt(PDC)-0.0625)^2``````` =(sqrt(PDC)+0.0625)^2````` SL 22.5````````````````````` =degree/180=22.5/180=0.125``````````` =(sqrt(PDC)+0.125)^2```````` =(sqrt(PDC)-0.125)^2`````` Buy/Sell At 45``````````````````````` =degree/180=45/180=0.25`````````````` =(sqrt(PDC)+0.25)^2````````` =(sqrt(PDC)-0.25)^2``````` Target-1 90``````````````````````` =degree/180=90/180=0.5``````````````` =(sqrt(PDC)+0.5)^2`````````` =(sqrt(PDC)-0.5)^2```````` Target-2 135`````````````````````` =degree/180=135/180=0.75````````````` =(sqrt(PDC)+0.75)^2````````` =(sqrt(PDC)-0.75)^2``````` Target-3 180`````````````````````` =degree/180=180/180=1```````````````` =(sqrt(PDC)+1)^2```````````` =(sqrt(PDC)-1)^2`````````` Target-4 225`````````````````````` =degree/180=225/180=1.25````````````` =(sqrt(PDC)+1.25)^2````````` =(sqrt(PDC)-1.25)^2``````` Target-5 270`````````````````````` =degree/180=270/180=1.5`````````````` =(sqrt(PDC)+1.5)^2`````````` =(sqrt(PDC)-1.5)^2```````` Target-6 315`````````````````````` =degree/180=315/180=1.75````````````` =(sqrt(PDC)+1.75)^2````````` =(sqrt(PDC)-1.75)^2``````` Target-7 360`````````````````````` =degree/180=360/180=2```````````````` =(sqrt(PDC)+2)^2```````````` =(sqrt(PDC)-2)^2`````````` Target-8 example based On Today's Opening Price = 4339 Degree's```````` Degree Factor```````` Buy`````````` Sell 11.25``````````` 0.0625``````````````` 4330.77`````` 4347.24```````` SL 22.5```````````` 0.125```````````````` 4355.48`````` 4322.55```````` Buy/Sell At 45`````````````` 0.25````````````````` 4372.00`````` 4306.13```````` Target-1 90`````````````` 0.5`````````````````` 4405.12`````` 4273.38```````` Target-2 135````````````` 0.75````````````````` 4438.37`````` 4240.76```````` Target-3 180````````````` 1```````````````````` 4471.74`````` 4208.26```````` Target-4 225````````````` 1.25````````````````` 4505.24`````` 4175.88```````` Target-5 270````````````` 1.5`````````````````` 4538.86`````` 4143.64```````` Target-6 315````````````` 1.75````````````````` 4572.61`````` 4111.51```````` Target-7 360````````````` 2```````````````````` 4606.48`````` 4079.52```````` Target-8 Note : ignore the '`' , inserted them to fill up the spaces , it was looking very weird!, tried to fix it as much as I can. Note :- Please correct me if I'm wrong , as I've already mentioned I don't have it's original documentation. if anyone can find it or already has it then please feel free to share it.
הערות שחרור ⋅ 8 אוג׳ 2022 11:57 Updated script on 08-08-2022 Updatess :- Added Option to change Line Style Added Option to change position of Labels Added Option to change size of Labels the cell in whose range LTP is present will be highlighted with Black background.
הערות שחרור ⋅ 20 ספט׳ 2022 17:05 Changelog :- Provided option to choose the colors for Buy/Sell Levels & Labels.
הערות שחרור ⋅ 6 אפר׳ 2023 17:46 Changelog :- Added option to show/hide Historical Buy/Sell Levels.
הערות שחרור ⋅ 6 אפר׳ 2023 18:07 Changelog :- Fixed the Symbol name for futures contracts.