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
SENSEX83,116.1981,534.2981,523.1681,930.1882,962.711,439.551.7780,302.7180,598.8881,061.0281,357.1981,819.3382115.582577.6480895.0581653.3681523.16Bull
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
AARTIIND576.35566.00570.65573.50567.85-2.80-0.49553.40570.35570.50587.45587.60604.55604.7587.3604.4570.65Bull
8
ABFRL327.40315.65317.35316.80326.359.002.84297.23300.12308.73311.62320.23323.12331.73303314.5317.35Bear
9
ACC2,475.002,423.402,440.652,445.102,473.7533.101.362,319.432,353.422,397.032,431.022,474.632508.622552.232387.424652440.65Bull
10
ADANIENT3,000.002,917.152,937.852,950.002,980.9043.051.472,874.072,900.682,919.272,945.882,964.472991.083009.672927.32972.52937.85BullBuyBUY2967.432952.612994.112991.08
11
ADANIPORTS1,475.001,440.201,430.601,444.001,468.5537.952.651,383.271,397.131,413.871,427.731,444.471458.331475.0714111441.61430.6Bull
12
ALKEM6,428.906,281.456,277.956,297.356,340.0062.050.996,142.506,196.456,237.206,291.156,331.906385.856426.66250.46345.16277.95BullBuyBUY6338.236306.576395.226385.85
13
AMARAJABAT#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
14
AMBUJACEM629.70620.60623.00626.10628.905.900.95597.92606.33614.67623.08631.42639.83648.17614.75631.5623Bull
15
APLLTD1,278.001,211.101,247.701,240.001,218.75-28.95-2.321,051.351,079.101,163.401,191.151,275.451303.21387.51106.851218.91247.7Bear
16
APOLLOHOSP7,096.456,915.006,900.256,943.007,025.80125.551.826,730.256,775.356,837.806,882.906,945.356990.457052.96820.4569286900.25Bull
17
APOLLOTYRE528.50515.70523.65525.05518.00-5.65-1.08496.93498.02510.83511.92524.73525.82538.63499.1513523.65Bull
18
ASHOKLEY247.90242.00241.55244.45246.104.551.88234.07238.08239.82243.83245.57249.58251.32242.1247.85241.55BullBuyBUY245.81244.58248.02249.58
19
ASIANPAINT3,393.003,340.303,367.453,370.003,368.951.500.043,256.303,257.153,312.303,313.153,368.303369.153424.3325833143367.45BullBuyBUY3371.673354.833401.983369.15
20
ASTRAL1,948.401,926.651,923.101,930.001,937.7014.600.761,846.831,862.171,892.631,907.971,938.431953.771984.231877.51923.31923.1Bull
21
AUBANK727.85717.80722.25727.85721.90-0.35-0.05687.25692.05707.15711.95727.05731.85746.95696.85716.75722.25Bull
22
AUROPHARMA1,578.001,521.501,507.401,521.501,564.1556.753.761,472.851,492.801,500.101,520.051,527.351547.31554.61512.7515401507.4Bull
23
AXISBANK1,205.701,176.751,186.101,190.101,202.6016.501.391,131.601,138.301,162.201,168.901,192.801199.51223.411451175.61186.1Bull
24
BAJAJ-AUTO11,779.2511,443.3511,420.7511,480.7511,721.20300.452.6311,043.9710,911.9811,166.3711,034.3811,288.7711156.7811411.171078010902.411420.75Bull
25
BAJAJFINSV1,860.001,816.801,833.151,850.701,849.0015.850.861,788.851,813.951,823.551,848.651,858.251883.351892.951839.051873.751833.15Bull
26
BAJFINANCE7,440.007,296.607,345.557,420.007,417.0071.450.977,164.437,213.627,279.587,328.777,394.737443.927509.887262.87377.957345.55BullBuyBUY7402.137365.157468.687443.92
27
BALKRISIND3,114.003,065.403,063.453,066.003,106.3042.851.402,941.282,934.522,998.982,992.223,056.683049.923114.382927.752985.453063.45Bull
28
BANDHANBNK197.73195.30195.69197.50197.031.340.68191.33192.50194.09195.26196.85198.02199.61193.66196.42195.69BullBuyBUY197.05196.07198.82198.02
29
BANKBARODA237.90233.20232.80235.00237.254.451.91224.77228.13230.47233.83236.17239.53241.87231.5237.2232.8BullBuyBUY236.4235.22238.53239.53
30
BATAINDIA1,431.751,419.951,417.201,420.001,429.7512.550.891,337.331,359.171,388.181,410.021,439.031460.871489.8813811431.851417.2Bull
31
BEL292.50289.00288.05290.90291.253.201.11272.28274.02281.03282.77289.78291.52298.53275.75284.5288.05BullBuyBUY290.07288.62292.68291.52
32
BERGEPAINT626.90615.25618.00621.00618.400.400.06594.75594.20606.10605.55617.45616.9628.8593.65605618Bull
33
BHARATFORG1,594.101,566.301,561.701,569.001,585.1523.451.501,500.981,512.871,537.281,549.171,573.581585.471609.881524.751561.051561.7BullBuyBUY1575.161567.291589.321585.47
34
BHARTIARTL1,652.801,590.101,577.801,596.151,634.0056.203.561,528.281,525.771,551.781,549.271,575.281572.771598.781523.251546.751577.8Bull
35
BHEL266.50259.65258.75260.15265.757.002.71248.43253.32256.03260.92263.63268.52271.23258.2265.8258.75BullBuyBUY263.9262.58266.27268.52
36
BIOCON393.85374.85385.30389.10377.00-8.30-2.15360.92363.53374.42377.03387.92390.53401.42366.15379.65385.3Bull
37
BOSCHLTD34,280.0033,437.9033,209.6033,440.0034,074.00864.402.6031,498.9231,826.8332,518.2232,846.1333,537.5233865.4334556.8232154.7533174.0533209.6Bull
38
BPCL346.20340.40340.25343.45342.402.150.63333.93340.52340.38346.97346.83353.42353.28347.1353.55340.25Bull
39
BRITANNIA6,128.706,004.706,008.656,018.656,081.3572.701.215,801.175,823.685,916.175,938.686,031.176053.686146.175846.25961.26008.65Bull
40
CADILAHC#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
41
CANBK104.30101.92101.75102.70103.902.152.1196.5398.61100.18102.26103.83105.91107.48100.69104.34101.75BullBuyBUY103.93103.41104.87105.91
42
CHOLAFIN1,579.001,541.601,521.451,549.951,569.4047.953.151,476.281,493.821,507.631,525.171,538.981556.521570.331511.351542.71521.45Bull
43
CIPLA1,660.001,630.551,628.351,635.001,652.0023.651.451,586.501,598.251,613.301,625.051,640.101651.851666.916101636.81628.35Bull
44
COALINDIA497.25482.25483.95487.00494.3010.352.14468.05473.05478.50483.50488.95493.95499.4478.05488.5483.95Bull
45
COFORGE6,929.006,810.056,841.106,898.006,867.5026.400.396,355.326,393.236,617.176,655.086,879.026916.937140.876431.1566936841.1Bull
46
COLPAL3,675.353,632.253,653.703,661.003,638.00-15.70-0.433,584.223,619.433,636.573,671.783,688.923724.133741.273654.6537073653.7Bull
47
CONCOR954.00938.10937.05941.45950.7013.651.46909.28920.42928.73939.87948.18959.32967.63931.55951937.05BullBuyBUY949.13944.39957.67959.32
48
COROMANDEL1,713.401,686.751,697.551,710.851,690.75-6.80-0.401,627.521,647.281,672.421,692.181,717.321737.081762.221667.051711.951697.55Bull
49
CUB167.49164.15164.01165.00166.172.161.32158.69161.62162.82165.75166.95169.88171.08164.56168.69164.01Bull
50
CUMMINSIND3,832.153,750.003,797.403,825.003,820.0022.600.603,613.683,637.473,717.433,741.223,821.183844.973924.933661.2537653797.4Bull
51
DABUR669.50663.00663.90663.95665.651.750.26629.48636.77650.33657.62671.18678.47692.03644.05664.9663.9Bull
52
DEEPAKNTR2,951.502,910.102,919.302,919.302,925.005.700.202,810.932,845.972,882.632,917.672,954.332989.373026.0328812952.72919.3Bull
53
DIVISLAB5,513.005,396.205,439.305,450.005,471.2531.950.595,170.805,126.505,282.905,238.605,395.005350.75507.15082.25194.35439.3Bull
54
DLF837.05827.30824.00830.00834.9010.901.32793.02802.53813.27822.78833.52843.03853.77812.05832.3824BullBuyBUY834.35830.18841.85843.03
55
DRREDDY6,712.206,580.306,612.506,700.006,663.7051.200.776,458.236,530.476,571.486,643.726,684.736756.976797.986602.76715.956612.5Bull
56
EICHERMOT4,895.004,717.704,726.654,744.904,857.90131.252.784,637.934,677.024,701.834,740.924,765.734804.824829.634716.147804726.65Bull
57
ESCORTS3,801.603,748.503,761.553,779.953,794.8033.250.883,618.703,619.853,690.703,691.853,762.703763.853834.7362136933761.55Bull
58
EXIDEIND481.70474.20472.20475.85479.507.301.55447.30456.90464.55474.15481.80491.4499.05466.5483.75472.2Bull
59
FEDERALBNK184.79181.73183.18184.17183.300.120.07177.72180.09181.63184.00185.54187.91189.45182.45186.36183.18Bull
60
GAIL220.97217.61217.19218.20220.263.071.41207.13211.46214.33218.66221.53225.86228.73215.8223217.19Bull
61
GLENMARK1,754.351,729.951,725.651,729.951,749.0023.351.351,665.601,676.951,701.301,712.651,737.001748.351772.71688.317241725.65Bull
62
GMRINFRA94.3092.7092.5494.0094.111.571.7088.5888.8990.7291.0392.8693.179589.2191.3592.54Bull
63
GODREJCP1,535.001,501.501,499.951,508.701,505.255.300.351,337.551,381.351,440.651,484.451,543.751587.551646.851425.151528.251499.95Bull
64
GODREJPROP2,887.002,822.402,832.902,833.952,875.0042.101.492,748.472,796.732,814.822,863.082,881.172929.432947.5228452911.352832.9Bull
65
GRANULES690.00562.10676.70678.65565.25-111.45-16.47637.87646.93661.82670.88685.77694.83709.72656679.95676.7Bull
66
GRASIM2,765.002,678.752,681.152,690.602,760.1078.952.942,623.402,648.652,664.902,690.152,706.402731.652747.92673.92715.42681.15Bull
67
GUJGASLTD650.50636.85644.60647.05639.30-5.30-0.82612.38627.17635.88650.67659.38674.17682.88641.95665.45644.6Bull
68
HAVELLS2,000.951,970.301,957.601,975.902,000.0042.402.171,870.151,864.601,911.101,905.551,952.051946.519931859.0519001957.6Bull
69
HCLTECH1,814.201,777.101,778.751,800.001,795.6016.850.951,732.681,736.921,757.831,762.071,782.981787.221808.131741.151766.31778.75Bull
70
HDFC#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
71
HDFCAMC4,433.404,367.904,401.854,401.854,395.00-6.85-0.164,327.174,348.584,375.224,396.634,423.274444.684471.3243704418.054401.85Bull
72
HDFCBANK1,670.001,647.051,643.901,654.001,661.4517.551.071,614.771,622.431,633.171,640.831,651.571659.231669.971630.11648.51643.9Bull
73
HDFCLIFE715.95698.30700.15703.15711.6511.501.64686.85709.05704.60726.80722.35744.55740.1731.25749700.15Bull
74
HEROMOTOCO5,818.005,655.005,654.455,700.005,800.00145.552.575,552.755,619.455,636.955,703.655,721.155787.855805.355686.155770.355654.45Bull
75
HINDALCO677.90651.50647.70658.00674.6026.904.15631.47641.23644.47654.23657.47667.23670.47651664647.7Bull
76
HINDPETRO417.65410.00409.45415.00413.053.600.88393.87406.98408.22421.33422.57435.68436.92420.1434.45409.45Bull
77
HINDUNILVR2,963.402,894.202,904.152,911.002,945.2541.101.422,757.172,800.182,852.172,895.182,947.172990.183042.172843.22938.22904.15Bull
78
IBULHSGFIN#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
79
ICICIBANK1,257.001,226.351,236.351,238.001,246.009.650.781,173.921,187.181,211.771,225.031,249.621262.881287.471200.451238.31236.35Bull
80
ICICIGI2,157.002,112.002,129.952,141.952,118.55-11.40-0.542,025.372,103.682,116.822,195.132,208.272286.582299.7221822273.452129.95Bull
81
ICICIPRULI762.20748.80750.90752.40754.103.200.43727.33738.37744.63755.67761.93772.97779.23749.4766.7750.9Bull
82
IDEA13.6512.8313.1413.3613.520.382.8912.2912.6312.8913.2313.4913.8314.0912.9813.5813.14BullBuyBUY13.513.4313.6213.83
83
IDFCFIRSTB72.8771.8371.5271.8372.841.321.8568.9470.5271.0272.6073.1074.6875.1872.174.1871.52Bull
84
IGL532.40521.50527.85530.00524.95-2.90-0.55502.23514.22521.03533.02539.83551.82558.63526.2545527.85Bull
85
INDHOTEL703.75685.10684.75691.05697.7012.951.89652.00651.65668.20667.85684.40684.05700.6651.3667.5684.75Bull
86
INDIGO5,035.004,925.004,900.404,958.504,977.3076.901.574,697.004,707.704,804.054,814.754,911.104921.85018.154718.44825.454900.4Bull
87
INDUSINDBK1,446.501,420.151,421.201,425.151,444.0022.801.601,372.971,386.531,403.871,417.431,434.771448.331465.671400.114311421.2BullBuyBUY1436.21429.031449.111448.33
88
INDUSTOWER437.10429.00428.00430.90432.104.100.96412.00414.40421.20423.60430.40432.8439.6416.8426428BullBuyBUY430.83428.68434.7432.8
89
INFY1,956.401,910.801,910.151,925.001,943.8033.651.761,860.631,874.821,892.481,906.671,924.331938.521956.1818891920.851910.15Bull
90
IOC173.70170.07169.74171.49173.203.462.04166.30169.97169.86173.53173.42177.09176.98173.65177.21169.74Bull
91
IRCTC932.90920.00923.25925.60929.306.050.66903.35911.15917.20925.00931.05938.85944.9918.95932.8923.25Bull
92
ITC520.50508.55514.35515.10518.053.700.72493.28496.82505.58509.12517.88521.42530.18500.35512.65514.35BullBuyBUY518.4515.81523.06521.42
93
JINDALSTEL1,014.00972.15966.90980.951,006.5539.654.10912.47922.73944.82955.08977.17987.431009.52933965.35966.9Bull
94
JSWSTEEL957.60929.00927.75935.80955.0027.252.94901.32910.18918.97927.83936.62945.48954.27919.05936.7927.75Bull
95
JUBLFOOD673.15657.55663.10664.05669.706.601.00638.67636.73649.92647.98661.17659.23672.42634.8646.05663.1Bull
96
KOTAKBANK1,834.151,795.151,789.251,803.901,831.0041.752.331,731.651,745.051,767.151,780.551,802.651816.051838.151758.451793.951789.25Bull
97
L&TFH#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
98
LALPATHLAB3,436.103,405.103,396.153,409.703,421.0024.850.733,329.423,340.283,368.223,379.083,407.023417.883445.823351.153389.953396.15Bull
99
LICHSGFIN706.60683.00676.30683.00704.4528.154.16647.13664.77670.53688.17693.93711.57717.33682.4705.8676.3BullBuyBUY694.63691.16700.87711.57
100
LT3,638.053,534.003,536.953,558.003,620.0583.102.353,489.053,521.453,529.203,561.603,569.353601.753609.53553.8535943536.95Bull