ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Advanced Intraday Pivot Calculator (Sagaci)All sheets: https://tinyurl.com/2277777Disclaimer: I am not sebi registered financial advisor. I have made this excel for persoanl use and shared in lieu of money or free. Losses do occur and they are part of trading. I am just sharing strategy to minimize losses. Keep in mind, stoploss do hit and you yourself are responsible for losses. You may loose all your invested money.
2
written by: Ajeet Singh Valid till: 31 Dec 2025This sheet: https://tinyurl.com/22737187
3
SymbolHighLowClosedOpenLTPChangeChg%S3S2S1PIVOTR1R2R3Prev.lowPrev.HighPre. CloseTrendWk. SignalWk. SignalStrong SignalWk. SignalTriggerSl1% targetTGT 2
4
NIFTY#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
5
SENSEX60,045.4859,504.7260,098.8260,045.4859,526.67-572.15-0.9560,064.5760,586.0960,342.4560,863.9760,620.3361141.8560898.2161107.661385.4860098.82Bear
6
BANKNIFTY#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
7
AARTIIND1,090.001,055.401,072.301,070.001,063.50-8.80-0.821,045.781,069.371,070.831,094.421,095.881119.471120.931092.9511181072.3Bear
8
ABFRL317.70309.35314.30314.00311.50-2.80-0.89300.07303.53308.92312.38317.77321.23326.62307315.85314.3Bear
9
ACC2,285.252,230.002,231.802,230.002,242.1510.350.462,134.872,217.932,224.872,307.932,314.872397.932404.87230123912231.8Bear
10
ADANIENT1,864.701,847.001,849.301,855.001,859.6510.350.561,790.421,823.031,836.171,868.781,881.921914.531927.671855.651901.41849.3Bull
11
ADANIPORTS747.90739.00744.20744.00744.500.300.04733.43753.67748.93769.17764.43784.67779.93773.9789.4744.2Bear
12
ALKEM3,519.953,485.003,496.053,500.003,500.003.950.113,381.423,475.883,485.973,580.433,590.523684.983695.073570.353674.93496.05Bull
13
AMARAJABAT649.00635.10646.25645.50636.05-10.20-1.58612.53626.62636.43650.52660.33674.42684.23640.7664.6646.25BearSELLSELLSELL635.8638.98630.07626.62
14
AMBUJACEM379.80374.85374.85375.25375.250.400.11363.30379.15377.00392.85390.70406.55404.4395408.7374.85Bull
15
APLLTD793.45785.00789.35793.30788.60-0.75-0.10764.52777.68783.52796.68802.52815.68821.52790.85809.85789.35Bull
16
APOLLOHOSP4,725.004,490.004,515.954,525.004,678.00162.053.594,531.034,715.524,615.734,800.224,700.434884.924785.1349004984.74515.95Bull
17
APOLLOTYRE231.75224.00233.15227.95226.35-6.80-2.92216.27223.98228.57236.28240.87248.58253.17231.7244233.15BearSELLSELLSELL228.34229.48226.28223.98
18
ASHOKLEY141.40137.50137.45138.30139.301.851.35131.68134.62136.03138.97140.38143.32144.73137.55141.9137.45Bull
19
ASIANPAINT3,299.003,236.003,280.403,282.003,245.10-35.30-1.083,189.933,255.473,267.933,333.473,345.933411.473423.93332133993280.4Bull
20
ASTRAL2,446.002,384.002,391.352,398.752,410.2518.900.792,323.382,390.422,390.882,457.922,458.382525.422525.882457.452524.952391.35Bull
21
AUBANK1,277.001,257.501,264.151,266.901,272.408.250.651,228.921,244.281,254.221,269.581,279.521294.881304.821259.651284.951264.15Bull
22
AUROPHARMA673.75664.00670.50670.55664.10-6.40-0.95654.83669.67670.08684.92685.33700.17700.58684.5699.75670.5Bull
23
AXISBANK737.15723.70729.60731.05724.10-5.50-0.75708.10708.80719.20719.90730.30731741.4709.5720.6729.6Bull
24
BAJAJ-AUTO3,448.003,331.153,436.803,398.903,339.25-97.55-2.843,311.953,373.003,404.903,465.953,497.853558.93590.83434.0535273436.8Bear
25
BAJAJFINSV18,262.0017,681.0518,077.3018,075.0017,696.05-381.25-2.1117,839.8718,030.4318,053.8718,244.4318,267.8718458.4318481.87182211843518077.3Bear
26
BAJFINANCE7,650.007,483.307,571.807,610.007,530.00-41.80-0.557,503.787,652.677,612.237,761.127,720.687869.577829.137801.5579107571.8Bull
27
BALKRISIND2,509.802,460.552,504.252,489.902,486.00-18.25-0.732,425.522,447.782,476.022,498.282,526.522548.782577.022470.052520.552504.25Bear
28
BANDHANBNK308.75304.50303.60304.50305.251.650.54290.98293.57298.58301.17306.18308.77313.78296.15303.75303.6Bull
29
BANKBARODA97.0095.5595.8595.9596.400.550.5792.8893.0294.4394.5795.9896.1297.5393.1594.795.85Bull
30
BATAINDIA2,045.002,025.002,030.902,030.002,033.102.200.111,963.851,985.502,008.202,029.852,052.552074.22096.92007.152051.52030.9Bear
31
BEL210.75207.50208.15209.00207.75-0.40-0.19201.37208.58208.37215.58215.37222.58222.37215.8222.8208.15Bull
32
BERGEPAINT751.55743.00748.45748.80748.600.150.02724.95741.75745.10761.90765.25782.05785.4758.55778.7748.45Bull
33
BHARATFORG763.15750.05758.35762.10751.00-7.35-0.97739.07754.58756.47771.98773.87789.38791.27770.1787.5758.35Bull
34
BHARTIARTL712.30705.25703.70706.00710.807.101.01688.72704.13703.92719.33719.12734.53734.32719.55734.75703.7Bull
35
BHEL62.2061.2061.8562.0061.35-0.50-0.8161.0262.2862.0763.3363.1264.3864.1763.5564.661.85Bull
36
BIOCON367.90362.35367.35366.00363.55-3.80-1.03352.73353.12360.23360.62367.73368.12375.23353.5361367.35Bear
37
BOSCHLTD17,127.0016,721.0016,970.0017,000.0016,750.10-219.90-1.3016,739.2317,169.3717,069.6817,499.8217,400.1317830.2717730.5817599.517929.9516970Bull
38
BPCL397.55394.25394.35395.00396.301.950.49388.03393.32393.83399.12399.63404.92405.43398.6404.4394.35Bull
39
BRITANNIA3,624.003,576.503,575.653,590.003,606.2030.550.853,503.953,573.153,574.403,643.603,644.853714.053715.33642.353712.83575.65Bull
40
CADILAHC427.00419.10423.70424.50419.95-3.75-0.89418.80427.90425.80434.90432.80441.9439.8437444423.7Bull
41
CANBK232.40227.90228.40229.20230.151.750.77223.63225.37226.88228.62230.13231.87233.38227.1230.35228.4BullBuyBUY230.36229.21232.43231.87
42
CHOLAFIN651.95608.15612.10612.00646.9534.855.69580.00583.50597.80601.30615.60619.1633.4587604.8612.1Bear
43
CIPLA899.90883.60895.65895.00884.30-11.35-1.27885.17897.08896.37908.28907.57919.48918.77909920.2895.65Bear
44
COALINDIA167.95163.85163.90164.50166.652.751.68157.88159.97161.93164.02165.98168.07170.03162.05166.1163.9BullBuyBUY166.15165.32167.64168.07
45
COFORGE5,440.005,281.105,408.255,398.005,298.90-109.35-2.025,334.335,473.825,441.035,580.525,547.735687.225654.435613.357205408.25Bear
46
COLPAL1,451.151,430.501,447.451,449.801,432.15-15.30-1.061,423.181,438.221,442.831,457.871,462.481477.521482.131453.251472.91447.45Bull
47
CONCOR670.55659.40671.20668.00659.55-11.65-1.74661.53673.57672.38684.42683.23695.27694.08685.6696.45671.2Bear
48
COROMANDEL787.20778.75781.60787.20785.003.400.44734.25759.00770.30795.05806.35831.1842.4783.75819.8781.6Bull
49
CUB145.50143.50143.95144.00145.051.100.76138.28141.72142.83146.27147.38150.82151.93145.15149.7143.95Bull
50
CUMMINSIND964.00946.00964.55964.00952.50-12.05-1.25940.77963.38963.97986.58987.171009.781010.379861009.2964.55Bear
51
DABUR569.00561.50568.55568.95561.75-6.80-1.20555.93562.42565.48571.97575.03581.52584.58568.9578.45568.55Bull
52
DEEPAKNTR2,602.002,567.752,567.752,568.002,579.1511.400.442,531.502,581.252,574.502,624.252,617.502667.252660.5263126742567.75Bull
53
DIVISLAB4,496.004,405.004,481.504,496.004,408.85-72.65-1.624,365.334,463.174,472.334,570.174,579.334677.174686.33456146684481.5Bull
54
DLF409.55404.55408.25408.40406.50-1.75-0.43394.17403.68405.97415.48417.77427.28429.57413.2425408.25Bull
55
DRREDDY4,712.004,621.004,684.954,712.004,623.00-61.95-1.324,532.534,569.024,626.984,663.474,721.434757.924815.884605.54699.954684.95BullSELL
56
EICHERMOT2,756.002,712.102,718.702,725.002,726.858.150.302,645.802,724.902,721.802,800.902,797.802876.92873.8280428802718.7Bull
57
ESCORTS1,868.001,860.251,866.501,865.001,863.10-3.40-0.181,834.301,845.401,855.951,867.051,877.601888.71899.251856.51878.151866.5Bear
58
EXIDEIND181.30178.60179.95179.35178.75-1.20-0.67167.07171.28175.62179.83184.17188.38192.72175.5184.05179.95Bear
59
FEDERALBNK99.1598.0098.5598.4098.20-0.35-0.3697.0398.1298.3399.4299.63100.72100.9399.2100.598.55BearSELLSELLSELL98.2498.7397.3598.12
60
GAIL148.25146.25147.95147.60147.85-0.10-0.07139.48140.12144.03144.67148.58149.22153.13140.75145.3147.95Bear
61
GLENMARK499.00491.20498.15498.40492.60-5.55-1.11480.43492.72495.43507.72510.43522.72525.43505520498.15Bull
62
GMRINFRA44.4043.5544.0544.0043.65-0.40-0.9142.2343.4243.7344.9245.2346.4246.7344.646.144.05BearSELLSELLSELL43.6943.9143.343.42
63
GODREJCP940.75912.70937.55940.75913.85-23.70-2.53891.97899.98918.77926.78945.57953.58972.37908934.8937.55BullSELL
64
GODREJPROP1,879.451,842.501,851.201,860.501,848.45-2.75-0.151,810.931,874.471,862.831,926.371,914.731978.271966.6319381989.91851.2Bull
65
GRANULES326.35314.40317.30317.30322.505.201.64273.95297.90307.60331.55341.25365.2374.9321.85355.5317.3Bull
66
GRASIM1,836.751,814.301,806.501,817.001,826.8020.301.121,709.001,777.501,792.001,860.501,875.001943.51958184619291806.5Bull
67
GUJGASLTD704.50673.30696.75700.00694.20-2.55-0.37665.85675.45686.10695.70706.35715.95726.6685.05705.3696.75Bull
68
HAVELLS1,317.451,301.001,308.751,310.001,304.00-4.75-0.361,283.321,302.481,305.621,324.781,327.921347.081350.221321.651343.951308.75BullSELL
69
HCLTECH1,201.401,175.301,199.201,200.001,176.90-22.30-1.861,174.471,208.931,204.071,238.531,233.671268.131263.271243.412731199.2Bull
70
HDFC2,630.002,558.002,620.252,612.652,560.25-60.00-2.292,590.202,641.352,630.802,681.952,671.402722.5527122692.52733.12620.25Bear
71
HDFCAMC2,393.952,367.002,394.202,388.002,367.30-26.90-1.122,375.502,419.402,406.802,450.702,438.1024822469.42463.32494.62394.2Bear
72
HDFCBANK1,528.501,508.051,518.451,528.451,510.05-8.40-0.551,469.551,494.351,506.401,531.201,543.251568.051580.11519.1515561518.45Bull
73
HDFCLIFE660.60651.00656.05654.60651.85-4.20-0.64649.97658.98657.52666.53665.07674.08672.62668675.55656.05Bear
74
HEROMOTOCO2,759.252,700.002,699.802,700.002,733.0533.251.232,486.352,538.902,619.352,671.902,752.352804.92885.352591.452724.452699.8Bull
75
HINDALCO508.00502.30504.80503.85502.95-1.85-0.37484.53490.27497.53503.27510.53516.27523.53496509504.8Bear
76
HINDPETRO328.95322.20324.35323.00328.454.101.26318.03321.72323.03326.72328.03331.72333.03325.4330.4324.35BearBuy
77
HINDUNILVR2,325.552,271.402,309.902,325.002,273.40-36.50-1.582,256.002,300.502,305.202,349.702,354.402398.92403.623452394.22309.9Bull
78
IBULHSGFIN222.40219.00218.80219.50221.302.501.14214.62217.63218.22221.23221.82224.83225.42220.65224.25218.8Bull
79
ICICIBANK810.00795.40808.60803.00803.65-4.95-0.61791.45803.00805.80817.35820.15831.7834.5814.55828.9808.6BearSELLSELLSELL804.99809.02797.74803
80
ICICIGI1,394.001,318.101,423.001,394.001,360.00-63.00-4.431,355.521,385.531,404.271,434.281,453.021483.031501.771415.551464.31423Bear
81
ICICIPRULI579.75571.40573.80573.80575.201.400.24539.53565.27569.53595.27599.53625.27629.53591621573.8Bull
82
IDEA12.3511.8511.9511.9012.150.201.6711.4511.9511.9512.4512.4512.9512.9512.4512.9511.95Bear
83
IDFCFIRSTB48.9048.2548.9548.8048.35-0.60-1.2347.8048.3548.6549.2049.5050.0550.3548.949.7548.95Bear
84
IGL443.80437.50438.60441.75439.801.200.27433.10443.50441.05451.45449.00459.4456.95453.9461.85438.6Bull
85
INDHOTEL209.45205.80207.45207.45207.05-0.40-0.19201.72204.98206.22209.48210.72213.98215.22208.25212.75207.45Bull
86
INDIGO2,089.702,055.002,079.502,085.002,056.40-23.10-1.112,048.472,092.232,085.872,129.632,123.272167.032160.6721362173.42079.5Bull
87
INDUSINDBK898.45883.20893.25895.00884.40-8.85-0.99873.38892.82893.03912.47912.68932.12932.33912.25931.9893.25Bull
88
INDUSTOWER271.60267.70270.70270.50268.30-2.40-0.89265.80268.10269.40271.70273.00275.3276.6270.4274270.7BearSELLSELLSELL269.13270.48266.71268.1
89
INFY1,848.001,822.701,867.051,844.001,828.45-38.60-2.071,857.001,893.751,880.401,917.151,903.801940.551927.21930.51953.91867.05Bear
90
IOC125.85124.80125.10125.10125.450.350.28122.07122.63123.87124.43125.67126.23127.47123.2125125.1Bull
91
IRCTC882.70870.00875.95875.75870.75-5.20-0.59844.52867.88871.92895.28899.32922.68926.72891.25918.65875.95BearSELLSELLSELL871.04875.4863.2867.88
92
ITC222.15220.15220.35220.55220.25-0.10-0.05215.02218.18219.27222.43223.52226.68227.77221.35225.6220.35Bull
93
JINDALSTEL417.75407.85409.00411.45414.755.751.41398.78406.67407.83415.72416.88424.77425.93414.55423.6409Bull
94
JSWSTEEL683.55672.40674.65679.00678.353.700.55635.63655.52665.08684.97694.53714.42723.98675.4704.85674.65Bull
95
JUBLFOOD3,766.703,692.703,741.503,753.903,701.95-39.55-1.063,617.333,739.573,740.533,862.773,863.733985.973986.933861.839853741.5Bull
96
KOTAKBANK1,925.001,894.301,905.651,925.001,897.70-7.95-0.421,864.171,891.381,898.521,925.731,932.871960.081967.221918.61952.951905.65BullSELL
97
L&TFH79.1078.0078.4078.6078.00-0.40-0.5177.1878.2778.3379.4279.4880.5780.6379.3580.578.4Bull
98
LALPATHLAB3,265.003,162.153,265.253,262.003,220.45-44.80-1.373,126.233,309.123,287.183,470.073,448.133631.023609.0834923652.953265.25Bear
99
LICHSGFIN374.05367.25371.05372.25367.45-3.60-0.97354.40366.25368.65380.50382.90394.75397.15378.1392.35371.05BullSELL
100
LT2,035.002,000.002,020.902,020.002,003.30-17.60-0.871,988.002,015.002,017.952,044.952,047.902074.92077.8520422071.952020.9Bear