@nagavardhana chari This is an utility function in Excel/VBA to calculate High made between two time points. An example use case is, checking 'Highest High' made by NIFTY between 0930 to 0940 hours
Assume you have B1 = GetRTD("NFO", "NIFTY21DECFUT", "LAST") //Ltp C1 = 09:30:00 //BeginTime D1 = 09:40:00 //EndTime E1 = TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())) //TimeNow F1 = AND(E1>=C1, E1<D1) //IsCandleTime
G1 = GetCandleHigh("NIFTY", "S1", 1, F1, B1)
The BarNum parameter is used to store 'Highest High' for different time points Say, use 1 to capture 0930 to 0940 use 2 to capture 0940 to 0950, so on
This is an utility function in Excel/VBA to calculate High made between two time points. An example use case is, checking 'Highest High' made by NIFTY between 0930 to 0940 hours
Assume you have
B1 = GetRTD("NFO", "NIFTY21DECFUT", "LAST") //Ltp
C1 = 09:30:00 //BeginTime
D1 = 09:40:00 //EndTime
E1 = TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())) //TimeNow
F1 = AND(E1>=C1, E1<D1) //IsCandleTime
G1 = GetCandleHigh("NIFTY", "S1", 1, F1, B1)
The BarNum parameter is used to store 'Highest High' for different time points
Say,
use 1 to capture 0930 to 0940
use 2 to capture 0940 to 0950, so on