sunil,
one suggestion. can you modify th excel to include 2D, 3D so that we can see all signals in one excel and its easy to take a call. otherwise, we need to maintain anothe excel or 'remember' the positions which is dangerous. since data entry is done here, it should be easy to include 2D, 3D in same excel
I have made the same in spot sheet.
Sunil,
you may like to see and correct if required.
Thanks Bandlab2 & LVGandhi for your suggestions & inputs.
I had initially thought of incorporating 2Day Swing & 3Day Swing Signals in the same excel file, but the problem was of data entered - the SPOT levels, which we enter in the Spot worksheet in excel file, are as per exchange-provided.
But for Day swing calls, I rely on actual chartical Highs and Lows, which may sometimes be different than the exchange provided ones. (A common known fact, that due to NSE policy, sometimes the opening high OR low - which ultimately remain the whole day's high or low, as case may be - are at times chartically invisible & due to freak calculations).
Hence, the excel file result will be different than the actual chartical levels.
Here, I'll be referring ONLY to SPOT values, to avoid break in flow on expiry/settlement days...
Also, I'll note only chartical highs & lows of SPOT and not the (sometimes) chartically invisible highs & lows made at open
There are two possible solutions to this:
1. We have another Spot's worksheet in the excel file with only Date, High, Low & Close Columns - here we enter the actual, chartical Sot's HOD & LOD.
2. No new worksheet; instead in the existing SPOT's worksheet, we enter the actual, chartical levels & not the exchange-provided one.
My argument against the second solution is that I need those exchange-provided highs & lows in pivot calculations & giving a different weightage to SPOT levels. Else, there won't be any difference between FUT & SPOT worksheet results.
Overall,
I am adding a new worksheet - but it won't be a double entry pain. All the values reqd. for Day swing signals - Date, High, Low & Close - will be automatically filled in from 1st worksheet of Spot.
Then, just verify whether the High & Low values are actual & as per INTRADAY chart. (A simple ya h00 website will also do - i have given an illustration in the very first page of this thread Post # 7)
It's not every day's case that the values will be different - ONLY SOMETIMES, ONE OF THE VALUES (EITHER HOD OR LOD) WILL HAVE TO BE MANUALLY TYPED IN THE NEW WORKSHEET - if there's no change in chartical levels, then let the values stay as it is. The next columns will have the 2day & 3day Swing signals with SAR (Stop-And-Reverse) levels.
I am modifying the chart accordingly, and I have also decided to UPDATE THE EXCEL FILE EVERY SUNDAY WITH THE REQD LEVELS FOR THE BENEFIT OF NEW VISITORS OF THE THREAD.