- This topic has 26 ข้อความตอบกลับ, 4 เสียง, and was last updated 6 years มาแล้ว by .
-
กระทู้
-
ผมมาเพิ่มในdatadeclarationใส่EPSเข้าไปดังนี้
{//EPS
for( i = 0; i < BarCount; i++ )//Quarterly
{
if( i > 0 )
{
if( SQQE[ i ] == 1 AND SQEPS[ i ] != SQEPS[ i – 1 ] ) SQEPS_Q1[ i ] = SQEPS[ i ];
else SQEPS_Q1[ i ] = SQEPS_Q1[ i – 1 ];
if( SQQE[ i ] == 2 AND SQEPS[ i ] != SQEPS[ i – 1 ] ) SQEPS_Q2[ i ] = SQEPS[ i ];
else SQEPS_Q2[ i ] = SQEPS_Q2[ i – 1 ];
if( SQQE[ i ] == 3 AND SQEPS[ i ] != SQEPS[ i – 1 ] ) SQEPS_Q3[ i ] = SQEPS[ i ];
else SQEPS_Q3[ i ] = SQEPS_Q3[ i – 1 ];
if( SQQE[ i ] == 4 AND SQEPS[ i ] != SQEPS[ i – 1 ] ) SQEPS_Q4[ i ] = SQEPS[ i ];
else SQEPS_Q4[ i ] = SQEPS_Q4[ i – 1 ];
}
else
{
SQEPS_Q1[ i ] = SQEPS_Q2[ i ] = SQEPS_Q3[ i ] = SQEPS_Q4[ i ] = 0;
if( SQQE[ i ] == 1 ) SQEPS_Q1[ i ] = SQEPS[ i ];
if( SQQE[ i ] == 2 ) SQEPS_Q2[ i ] = SQEPS[ i ];
if( SQQE[ i ] == 3 ) SQEPS_Q3[ i ] = SQEPS[ i ];
if( SQQE[ i ] == 4 ) SQEPS_Q4[ i ] = SQEPS[ i ];
}
}
for( i = 0; i < BarCount; i++ )//Accumulated
{
if( i > 0 )
{
if( SQQE[ i ] == 1 AND SQEPS[ i ] != SQEPS[ i – 1 ] ) SQEPS_ACC[ i ] = SQEPS_Q1[ i ];
else
{
if( SQQE[ i ] == 2 AND SQEPS[ i ] != SQEPS[ i – 1 ] ) SQEPS_ACC[ i ] = SQEPS_Q1[ i ] + SQEPS_Q2[ i ];
else
{
if( SQQE[ i ] == 3 AND SQEPS[ i ] != SQEPS[ i – 1 ] ) SQEPS_ACC[ i ] = SQEPS_Q1[ i ] + SQEPS_Q2[ i ] + SQEPS_Q3[ i ];
else
{
if( SQQE[ i ] == 4 AND SQEPS[ i ] != SQEPS[ i – 1 ] ) SQEPS_ACC[ i ] = SQEPS_Q1[ i ] + SQEPS_Q2[ i ] + SQEPS_Q3[ i ] + SQEPS_Q4[ i ];
else SQEPS_ACC[ i ] = SQEPS_ACC[ i – 1 ];
}
}
}
}
else SQEPS_ACC[ i ] = SQEPS[ i ];
}
SQEPS_ROLL= SQEPS_Q1 + SQEPS_Q2 + SQEPS_Q3 + SQEPS_Q4;//Rolling Last 4 Quarters
SQEPS_ANN= ValueWhen( SQQE == 4 AND ( SQEPS != Ref( SQEPS, -1 ) ), SQEPS_ACC );//Annual
SQEPS_QoQ= ValueWhen( SQEPS != Ref( SQEPS, -1 ), ROC( SQEPS, 1, True ) );//Quarter on Quarter
SQEPS_Q1YoY= ValueWhen( SQEPS_Q1 != Ref( SQEPS_Q1, -1 ), ROC( SQEPS_Q1, 1, True ) );//Quarter 1 Year on Year
SQEPS_Q2YoY= ValueWhen( SQEPS_Q2 != Ref( SQEPS_Q2, -1 ), ROC( SQEPS_Q2, 1, True ) );//Quarter 2 Year on Year
SQEPS_Q3YoY= ValueWhen( SQEPS_Q3 != Ref( SQEPS_Q3, -1 ), ROC( SQEPS_Q3, 1, True ) );//Quarter 3 Year on Year
SQEPS_Q4YoY= ValueWhen( SQEPS_Q4 != Ref( SQEPS_Q4, -1 ), ROC( SQEPS_Q4, 1, True ) );//Quarter 4 Year on Year
for( i = 0; i < BarCount; i++ )//Year on Year
{
if( i > 0 )
{
if( SQEPS_Q1YoY[ i ] != SQEPS_Q1YoY[ i – 1 ] ) SQEPS_YoY[ i ] = SQEPS_Q1YoY[ i ];
else
{
if( SQEPS_Q2YoY[ i ] != SQEPS_Q2YoY[ i – 1 ] ) SQEPS_YoY[ i ] = SQEPS_Q2YoY[ i ];
else
{
if( SQEPS_Q3YoY[ i ] != SQEPS_Q3YoY[ i – 1 ] ) SQEPS_YoY[ i ] = SQEPS_Q3YoY[ i ];
else
{
if( SQEPS_Q4YoY[ i ] != SQEPS_Q4YoY[ i – 1 ] ) SQEPS_YoY[ i ] = SQEPS_Q4YoY[ i ];
else SQEPS_YoY[ i ] = SQEPS_YoY[ i – 1 ];
}
}
}
}
else SQEPS_YoY[ i ] = Null;
}
}
}
- คุณต้องเข้าสู่ระบบเพื่อตอบกลับกระทู้นี้