Referencia a datos trimestrales

• 05/09/2020 at 5:04 AM #130686
  efex77

  Que tal,

  Como puedo referirme a los datos de maximo, minimo y cierre del ultimo trimestre?

  Hay alguna forma de hacerlo? Quisiera calcular los pivots en base a ese timeframe.

  Hay posibilidad de agregar la opción de trimestre en el indicador que viene codificado en la plataforma?

   

  Saludos

  

  efex77

  Participant

  Topics: 1

  Replies: 1

  Been thanked: 0 times
  09/26/2020 at 11:03 AM #145443
  robertogozzi

  Esto muestra el trimestre anterior:

  Previous Quarter

  Quarter = ((OpenMonth MOD 3) = 1) IF Quarter AND Not Quarter[1] THEN PrevOP = CurOP PrevHI = CurHI PrevLO = CurLO PrevCL = CurCL CurHI = high CurLO = low CurCL = close CurOP = open ENDIF CurHI = max(high,CurHI) CurLO = min(low,CurLO) CurCL = close RETURN PrevHI coloured(0,0,255,255) AS "Quarter HIGH",PrevLO coloured(255,0,0,255) AS "Quarter LOW",PrevCL coloured(0,255,0,255) AS "Quarter CLOSE",PrevOP coloured(0,0,0,255) AS "Quarter OPEN"

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

  Quarter = ((OpenMonth MOD 3) = 1) IF Quarter AND Not Quarter[1] THEN    PrevOP  = CurOP    PrevHI  = CurHI    PrevLO  = CurLO    PrevCL  = CurCL    CurHI   = high    CurLO   = low    CurCL   = close    CurOP   = open ENDIF CurHI = max(high,CurHI) CurLO = min(low,CurLO) CurCL = close RETURN PrevHI coloured(0,0,255,255) AS "Quarter HIGH",PrevLO coloured(255,0,0,255) AS "Quarter LOW",PrevCL coloured(0,255,0,255) AS "Quarter CLOSE",PrevOP coloured(0,0,0,255) AS "Quarter OPEN"

  Esto muestra el trimestre actual:

  Current Quarter

  Quarter = ((OpenMonth MOD 3) = 1) IF Quarter AND Not Quarter[1] THEN CurHI = high CurLO = low CurOP = open ENDIF CurHI = max(high,CurHI) CurLO = min(low,CurLO) CurCL = close RETURN CurHI coloured(0,0,255,255) AS "Quarter HIGH",CurLO coloured(255,0,0,255) AS "Quarter LOW",CurCL coloured(0,255,0,255) AS "Quarter CLOSE",CurOP coloured(0,0,0,255) AS "Quarter OPEN"

  1 2 3 4 5 6 7 8 9 10

  Quarter = ((OpenMonth MOD 3) = 1) IF Quarter AND Not Quarter[1] THEN    CurHI   = high    CurLO   = low    CurOP   = open ENDIF CurHI = max(high,CurHI) CurLO = min(low,CurLO) CurCL = close RETURN CurHI coloured(0,0,255,255) AS "Quarter HIGH",CurLO coloured(255,0,0,255) AS "Quarter LOW",CurCL coloured(0,255,0,255) AS "Quarter CLOSE",CurOP coloured(0,0,0,255) AS "Quarter OPEN"

  También agregué OPEN, que no solicitó (puede hacerlo invisible con propiedades).

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17243

  Been thanked: 4108 times
• Author
  Posts