Sidebar: Computing eVWMA by Christian P. Fries, Ph.D.
The sample spreadsheet in sidebar Figure 1 contains date (column C), volume (column D), opening price (column E), and closing price (column F). Cell B5
contains the number of shares floating (here, 1% of the total number of shares).
Since I do not have information on volume and price of each trade, I use the daily volume and closing price as an approximation. In cell G8, I enter the initial value for the eVWMA — that is, that day’s price, euro 23.10. . .