up vs down volume ratio

• 12/17/2022 at 3:16 PM #205952
  Alfy

  Good afternoon guys, I’m trying to build a ratio of up vs down volume over the last 50 trading days. So I’m looking to calculate the ratio of volume on days when the stock closed higher on the day vs the volume on days when the stock closed lower. I’ve attempted to create the code but I don’t think I’ve done it correctly. Can someone take a look please? Any help much appreciated

  Ratio of volume on up days to down days

  if close/close [1]>1 then volup=Volume endif if close/close [1]<1 then voldn=Volume endif ratio=(summation[50](volup)) /(summation[50](voldn)) Return Ratio

  1 2 3 4 5 6 7 8

  if close/close [1]>1 then volup=Volume endif if close/close [1]<1 then voldn=Volume endif ratio=(summation[50](volup)) /(summation[50](voldn)) Return Ratio

   

   

   

  

  Alfy

  Participant

  Topics: 34

  Replies: 53

  Been thanked: 5 times
  12/17/2022 at 3:53 PM #205953
  GraHal

  What are you expecting to see that you are not seeing … presumably not attached (see at red arrowhead)?

   

  1 user thanked author for this post.

  Alfy

  

  GraHal

  Participant

  Topics: 220

  Replies: 9005

  Been thanked: 2295 times
  12/17/2022 at 3:53 PM #205955
  robertogozzi

  Add these two lines at the very beginning, as a variable which hasn’t been modified will retain the previous value so that it always happens that both variables have some value, be it the current one or a prior one:

  volup = 0 voldn = 0

  1 2	volup = 0 voldn = 0

  1 user thanked author for this post.

  Alfy

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17524

  Been thanked: 4278 times
  12/17/2022 at 3:56 PM #205956
  JS

  Hi @Alfy

  Try this…

   

  Volume Ratio

  If Close = Close[1] then VolUp = VolUp VolDown = VolDown EndIf If Close > Close[1] then VolUp = VolUp + Volume ElsIf Close < Close[1] then VolDown = VolDown + Volume EndIf Ratio = Summation[50](VolUp) / Summation[50](VolDown) Return Ratio

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

  If Close = Close[1] then VolUp = VolUp VolDown = VolDown EndIf   If Close > Close[1] then VolUp = VolUp + Volume ElsIf Close < Close[1] then VolDown = VolDown + Volume EndIf   Ratio = Summation[50](VolUp) / Summation[50](VolDown)   Return Ratio

  

  JS

  Participant

  Topics: 27

  Replies: 2043

  Been thanked: 1090 times
  12/17/2022 at 3:57 PM #205958
  Alfy

  Thanks Roberto, your advice fixed the problem and the numbers make much more sense now.

  Best regards

  1 user thanked author for this post.

  robertogozzi

  

  Alfy

  Participant

  Topics: 34

  Replies: 53

  Been thanked: 5 times
• Author
  Posts