Dear Dawood,
I checked your excel sheet you have done a good job...but regarding the gann angle instead of entry at 30 deg it should be at 15 Deg and SL 3.75. this is my thoughts as most of the time one can see at 45 deg it would be a very big resistance and makes a turn around back to 18.75 deg. However your thoughts will be much appreciated. in case there is congestion you need to take midpoint for correct entry levels. for eg if sell entry is higher than buy entry and if it is difference of 5 point between buy and sell in this case one need to take mid point. in this area probably you can look into improving the excel sheet which you provided.
Also you can look into improving the excel sheet by it taking the first 15 min high low automatically( 09:15 Candle in 15 min TF or 4th candle - 09:30 in 5 min TF, idelly 15 Min TF would be better as per my thoughts) to show the direction. incase there is difference of 5 points or less it should take midpoint value automatically for giving correct buy entry and sell entry levels.
Thanks
Urs
I checked your excel sheet you have done a good job...but regarding the gann angle instead of entry at 30 deg it should be at 15 Deg and SL 3.75. this is my thoughts as most of the time one can see at 45 deg it would be a very big resistance and makes a turn around back to 18.75 deg. However your thoughts will be much appreciated. in case there is congestion you need to take midpoint for correct entry levels. for eg if sell entry is higher than buy entry and if it is difference of 5 point between buy and sell in this case one need to take mid point. in this area probably you can look into improving the excel sheet which you provided.
Also you can look into improving the excel sheet by it taking the first 15 min high low automatically( 09:15 Candle in 15 min TF or 4th candle - 09:30 in 5 min TF, idelly 15 Min TF would be better as per my thoughts) to show the direction. incase there is difference of 5 points or less it should take midpoint value automatically for giving correct buy entry and sell entry levels.
Thanks
Urs