Pour les pivots annuels, voici un indicateur maison pour PRT pour faire le travail des cartes sur le DAX cash :
Code : #
IF intradaybarindex =0 THEN
IF year = 2008 THEN
HighAnneePrecedente =8152
LowAnneePrecedente =6437
LastAnneePrecedente =8067
ENDIF
IF year = 2009 THEN
HighAnneePrecedente =8101
LowAnneePrecedente =4015
LastAnneePrecedente =4810
ENDIF
IF year = 2010 THEN
HighAnneePrecedente =6027
LowAnneePrecedente =3589
LastAnneePrecedente =5957
ENDIF
IF year = 2011 THEN
HighAnneePrecedente =7088
LowAnneePrecedente =5433
LastAnneePrecedente =6914
ENDIF
IF year = 2012 THEN
HighAnneePrecedente =7600
LowAnneePrecedente =4966
LastAnneePrecedente =5898
ENDIF
IF year = 2013 THEN
HighAnneePrecedente =7683
LowAnneePrecedente =5900
LastAnneePrecedente =7612
ENDIF
IF year = 2014 THEN
HighAnneePrecedente =9594
LowAnneePrecedente =7418
LastAnneePrecedente =9552
ENDIF
IF year = 2015 THEN
HighAnneePrecedente =10093
LowAnneePrecedente =8355
LastAnneePrecedente =9831
ENDIF
IF year = 2016 THEN
HighAnneePrecedente =12391
LowAnneePrecedente =9325
LastAnneePrecedente =10743
ENDIF
IF year = 2017 THEN
HighAnneePrecedente = 11482
LowAnneePrecedente = 8699
LastAnneePrecedente = 11481
ENDIF
IF year = 2018 THEN
HighAnneePrecedente = 13526
LowAnneePrecedente = 11415
LastAnneePrecedente = 12918
ENDIF
// PP annuel
PPAnnuel = (HighAnneePrecedente + LowAnneePrecedente + LastAnneePrecedente) / 3
R1Annuel = 2 * PPAnnuel - LowAnneePrecedente
R2Annuel = PPAnnuel + HighAnneePrecedente - LowAnneePrecedente
R3Annuel = HighAnneePrecedente + 2 * (PPAnnuel- LowAnneePrecedente)
S1Annuel = 2 * PPAnnuel- HighAnneePrecedente
S2Annuel = PPAnnuel - HighAnneePrecedente + LowAnneePrecedente
S3Annuel = LowAnneePrecedente - 2 * (HighAnneePrecedente - PPAnnuel)
mR1Annuel = (PPAnnuel+R1Annuel)/2
mR2Annuel = (R1Annuel+R2Annuel)/2
mR3Annuel = (R2Annuel+R3Annuel)/2
mS1Annuel = (PPAnnuel+S1Annuel)/2
mS2Annuel = (S1Annuel+S2Annuel)/2
mS3Annuel = (S2Annuel+S3Annuel)/2
ENDIF
// Return
RETURN PPAnnuel coloured (138,43,226,100) STYLE(line,4) as "PP Annuel (Indice)", R1Annuel coloured (255,0,0,100) STYLE(line,4) as "R1 Annuel (Indice)", R2Annuel coloured (255,0,0,100) STYLE(line,4) as "R2 Annuel (Indice)", R3Annuel coloured (255,0,0,100) STYLE(line,4) as "R3 Annuel (Indice)", S1Annuel coloured (0,100,0,100) STYLE(line,4) as "S1 Annuel (Indice)", S2Annuel coloured (0,100,0,100) STYLE(line,4) as "S2 Annuel (Indice)", S3Annuel coloured (0,100,0,100) STYLE(line,4) as "S3 Annuel (Indice)", mR1Annuel coloured (200,200,0,100) STYLE(line,4) as "mR1 Annuel (Indice)", mR2Annuel coloured (200,200,0,100) STYLE(line,4) as "mR2 Annuel (Indice)",mR3Annuel coloured (200,200,0,100) STYLE(line,4) as "mR3 Annuel (Indice)", mS1Annuel coloured (200,200,0,100) STYLE(line,4) as "mS1 Annuel (Indice)", mS2Annuel coloured (200,200,0,100) STYLE(line,4) as "mS2 Annuel (Indice)",mS3Annuel coloured (200,200,0,100) STYLE(line,4) as "mS3 Annuel (Indice)", LowAnneePrecedente coloured (0,100,0,100) STYLE(dottedline,4) as "Plus Bas Année Précédente (Indice)", HighAnneePrecedente coloured (255,0,0,100)STYLE(dottedline,4) as "Plus Haut Année Précédente (Indice)"
De mémoire, j'en étais arrivé à la conclusion que les niveaux entiers fonctionnaient sur l'UT 30 min, mais pas les mid.