: Volume Change comparitors I've put together a little market addin for excel and have been asked by the person commissioning the plugin to add the Volume Change for the last minute. That was easy enough using my API (alphavantage),

Vote Up Vote Down   0 Reactions

Login to give Reaction!

Volume Change comparitors
I've put together a little market addin for excel and have been asked by the person commissioning the plugin to add the Volume Change for the last minute. That was easy enough using my API (alphavantage), but they now want that number displayed as a percentage, which AV doesn't offer.

I don't know WHAT to compare the last minute Volume to. Currently I'm comparing it to the current trading volume (minuteVolume/currentVolume)*100, I feel that number could possible prove to be a false indicator, since the current Volume will update every 10 seconds (my code loops in 10 sec intervals) - causing the volumeChange % to decrease/increase artificially depending on the direction of change. Eventually it catches up, but for about 5 cycles it slowly decreases as the currentVolume increases.

I'm not very market savvy, so I'm kind of at a loss as to what to use for the divisor in the equation: (minuteVolume/x)*100 in order to achieve a more accurate representation of the percent change in volume. Last month's total volume? Last week's volume? Month to date total volume? I need a divisor that isn't going to just change every 10 seconds.

(1)

Login to post a comment!