Best way to calculate average (dollar/stock) volume?

• 03/19/2021 at 8:09 AM #164627
  marie123

  Hello,

  I made this loop to calculate the average dollar and stock volume over the last 60 days. Is this the best way to do it or can I do it without a loop?

  for i=60 downto 0 do totalDollarVol=totalDollarVol+volume[i]*close[i] totalStockVol=totalStockVol+volume[i] next averageDollarVol=totalDollarVol/60 averageStockVol=totalStockVol/60

  1 2 3 4 5 6

  for i=60 downto 0 do totalDollarVol=totalDollarVol+volume[i]*close[i] totalStockVol=totalStockVol+volume[i] next averageDollarVol=totalDollarVol/60 averageStockVol=totalStockVol/60

   

  

  marie123

  Participant

  Topics: 13

  Replies: 30

  Been thanked: 5 times
  03/19/2021 at 8:27 AM #164629
  JC_Bywan

  Good morning, you can use the “average” keyword applied to “volume” and “volume*close”:

  averageDollarVol=average[60](volume*close) averageStockVol=average[60](volume)

  1 2	averageDollarVol=average[60](volume*close) averageStockVol=average[60](volume)

   

  1 user thanked author for this post.

  marie123

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2689

  Been thanked: 963 times
  03/19/2021 at 8:38 AM #164630
  marie123

  Great, thank you!

  One last question: is this also possible when you want to check the volume from day 50 to day 100? So can I use a different day to start the calculation?

  

  marie123

  Participant

  Topics: 13

  Replies: 30

  Been thanked: 5 times
  03/19/2021 at 8:44 AM #164633
  JC_Bywan

  Not sure to understand the question, if “check the volume from day 50” was a way to just accessing it, it’s volume[50]… but if you meant accessing the values from previous post on day 50, it’s same formula and using averageDollarVol[50] and averageStockVol[50]. If you meant something else, sorry I don’t understand could you please rephrase? Thanks.

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2689

  Been thanked: 963 times
  03/19/2021 at 8:53 AM #164634
  marie123

  When I use your formula I get the average volumes from today until day 60. That’s what I need when I analyze the current situation.

  But I also need this for a backtest:

  for i=110 downto 50 do totalDollarVol=totalDollarVol+volume[i]*close[i] totalStockVol=totalStockVol+volume[i] next averageDollarVol=totalDollarVol/60 averageStockVol=totalStockVol/60

  1 2 3 4 5 6

  for i=110 downto 50 do totalDollarVol=totalDollarVol+volume[i]*close[i] totalStockVol=totalStockVol+volume[i] next averageDollarVol=totalDollarVol/60 averageStockVol=totalStockVol/60

  Here I check another 60 days for the average volume but I start with a different day.

   

  

  marie123

  Participant

  Topics: 13

  Replies: 30

  Been thanked: 5 times
  03/19/2021 at 8:58 AM #164635
  JC_Bywan

  ok, 50 to 110 (not 100) so that you have a 60 too, but starting earlier in the past. Then it is indeed the second case: ” … but if you meant accessing the values from previous post on day 50, it’s same formula and using averageDollarVol[50] and averageStockVol[50]” :

  averageDollarVol = average[60](volume*close) averageStockVol = average[60](volume) x=averageDollarVol[50] y=averageStockVol[50]

  1 2 3 4 5

  averageDollarVol = average[60](volume*close) averageStockVol = average[60](volume)   x=averageDollarVol[50] y=averageStockVol[50]

  NB: stricly speaking, it would have been 60 to 1, or 59 to 0, or 109 to 50 to get 60. If you really needed 60 to 0 / 110 to 50, then you can replace 60 by 61.

  1 user thanked author for this post.

  marie123

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2689

  Been thanked: 963 times
  03/19/2021 at 9:17 AM #164638
  marie123

  That helps me a lot, thank you very much!!

  1 user thanked author for this post.

  JC_Bywan

  

  marie123

  Participant

  Topics: 13

  Replies: 30

  Been thanked: 5 times
• Author
  Posts