커뮤니티
관리자님 수식 부탁드립니다.
2026-10-07 21:44:03
80
글번호 233821
첨부 이미지
그림1
관리자님
21:51 분 ~ 22:10분
22:51분 ~ 23:10분
00:51분 ~ 01:10분
01:51분 ~ 02:10분
02:51분 ~ 03:10분
위에 있는 시간대 수직선 표시하는 수식과 ( 수직선 표시는 점선으로 표시 )
각시간 51분 시작가를 20분간 표시 수식을 부탁드립니다.
사진 첨부합니다.. 정말 감사합니다..
수고하세요...
- 2. 2026-10-08 00;02;21.PNG (0.08 MB)
답변 1
예스스탁 예스스탁 답변
2026-10-08 10:56:14
안녕하세요
예스스탁입니다.
input : S1(215100),E1(221000);
input : S2(225100),E2(231000);
input : S3(005100),E3(011000);
input : S4(015100),E4(021000);
input : S5(025100),E5(031000);
var : vTL1(0),otl1(0);
if (NextBarSdate != sDate and NextBarStime >= S1) or
(NextBarSdate == sDate and NextBarStime >= S1 and sTime < S1) Then
{
Condition1 = true;
var1 = O;
vTL1 = TL_New(sDate,sTime,0,sDate,sTime,999999999);
TL_SetColor(vtl1,Cyan);
TL_SetStyle(vtl1,3);
otl1 = TL_New(sDate,sTime,var1,NextBarSdate,NextBarStime,var1);
TL_SetColor(otl1,Yellow);
}
if (NextBarSdate != sDate and NextBarStime >= E1) or
(NextBarSdate == sDate and NextBarStime >= E1 and sTime < E1) Then
{
Condition1 = False;
}
if Condition1 == true Then
TL_SetEnd(otl1,NextBarSdate,NextBarStime,var1);
var : vTL2(0),otl2(0);
if (NextBarSdate != sDate and NextBarStime >= S2) or
(NextBarSdate == sDate and NextBarStime >= S2 and sTime < S2) Then
{
Condition2 = true;
var2 = O;
vTL2 = TL_New(sDate,sTime,0,sDate,sTime,999999999);
TL_SetColor(vtl2,Cyan);
TL_SetStyle(vtl2,3);
otl2 = TL_New(sDate,sTime,var2,NextBarSdate,NextBarStime,var2);
TL_SetColor(otl2,Yellow);
}
if (NextBarSdate != sDate and NextBarStime >= E2) or
(NextBarSdate == sDate and NextBarStime >= E2 and sTime < E2) Then
{
Condition2 = False;
}
if Condition2 == true Then
TL_SetEnd(otl2,NextBarSdate,NextBarStime,var2);
var : vTL3(0),otl3(0);
if (NextBarSdate != sDate and NextBarStime >= S3) or
(NextBarSdate == sDate and NextBarStime >= S3 and sTime < S3) Then
{
Condition3 = true;
var3 = O;
vTL3 = TL_New(sDate,sTime,0,sDate,sTime,999999999);
TL_SetColor(vtl3,Cyan);
TL_SetStyle(vtl3,3);
otl3 = TL_New(sDate,sTime,var3,NextBarSdate,NextBarStime,var3);
TL_SetColor(otl3,Yellow);
}
if (NextBarSdate != sDate and NextBarStime >= E3) or
(NextBarSdate == sDate and NextBarStime >= E3 and sTime < E3) Then
{
Condition3 = False;
}
if Condition3 == true Then
TL_SetEnd(otl3,NextBarSdate,NextBarStime,var3);
var : vTL4(0),otl4(0);
if (NextBarSdate != sDate and NextBarStime >= S4) or
(NextBarSdate == sDate and NextBarStime >= S4 and sTime < S4) Then
{
Condition4 = true;
var4 = O;
vTL4 = TL_New(sDate,sTime,0,sDate,sTime,999999999);
TL_SetColor(vtl4,Cyan);
TL_SetStyle(vtl4,3);
otl4 = TL_New(sDate,sTime,var4,NextBarSdate,NextBarStime,var4);
TL_SetColor(otl4,Yellow);
}
if (NextBarSdate != sDate and NextBarStime >= E4) or
(NextBarSdate == sDate and NextBarStime >= E4 and sTime < E4) Then
{
Condition4 = False;
}
if Condition4 == true Then
TL_SetEnd(otl4,NextBarSdate,NextBarStime,var4);
var : vTL5(0),otl5(0);
if (NextBarSdate != sDate and NextBarStime >= S5) or
(NextBarSdate == sDate and NextBarStime >= S5 and sTime < S5) Then
{
Condition5 = true;
var5 = O;
vTL5 = TL_New(sDate,sTime,0,sDate,sTime,999999999);
TL_SetColor(vtl5,Cyan);
TL_SetStyle(vtl5,3);
otl5 = TL_New(sDate,sTime,var5,NextBarSdate,NextBarStime,var5);
TL_SetColor(otl5,Yellow);
}
if (NextBarSdate != sDate and NextBarStime >= E5) or
(NextBarSdate == sDate and NextBarStime >= E5 and sTime < E5) Then
{
Condition5 = False;
}
if Condition5 == true Then
TL_SetEnd(otl5,NextBarSdate,NextBarStime,var5);
즐거운 하루되세요