Login Page - Create Account

Support Board


Date/Time: Sun, 02 Feb 2025 19:13:53 +0000



Post From: Spreadshet EMA Custom Calculation fails

[2019-09-19 03:02:08]
User403758 - Posts: 25
Hello!

I tried to get familar with the spreadsheet study. So I made some formulas in column K - ... (SMA, etc,)
But I have no idea how to make the correct formula for EMA. I need the EMA in the formula columns because I want add
the spreadsheet study to other study collection, so I don't want to use EMA as single study, I need EMA as formula.

What I find in your documentation is this:
Spreadsheet Example Formulas and Usage: Common Formulas and Usage

But the presented formula suggests to use "P4", a cell which is empty by definition as I understand. So I get a long listing
of NaN error.

Can you help to implement the EMA via formula in the spreadsheet columns K - ...?

Thanks!