Similar to Exponential Moving Average
-
Hi,
I'm looking for the name of an indicator but I don't know whether it exists.
It should be similar to Exponential Moving Average but it divides the price at each day by the stock's cost on that day. In this way, it's possible to compare the average of different stocks and see which one has grown most in the recent past.
-
@marsario Can you give an example?
-
Hi!
Could you check this link:
https://docs.google.com/spreadsheets/d/1WRUfJC3VWcxCKAlXdaYAjszViJkFx__q36GKveJjEAU/edit?usp=sharingI'm looking for an indicator for what I called "Geometric average daily increase" (probably it's not the right name).
I wrote a formula that creates weights so that the most recent weight is 1 and they are halved every X days (in this case every 30 days). The last weight comes after Y days (in this case 493)
Also I take the prices of the last 494 days and do the following (basically I multiply together 493 weighted daily increases):
product((price today/price yesterday)^today's weight)Finally, the 493 weights are summed all together and they root the total product above.
Any idea, whether there exists anything similar?
-
Sorry I haven't seen that indicator. But it shouldn't be unreasonable to code. Let us know how your efforts go.