Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Excel Help with calculating averages with custom input
Instead of a comma, the average function should be separated by a colon.......
Thanks for your help, it's working perfectly now. I transposed it wrong and used a comma instead of a colon and just my luck, it didn't give me an error.
"A dumb man never learns. A smart man learns from his own failure and success. But a wise man learns from the failure and success of others."
But I'd like to do a second average of the average to smooth out the MA.
So I'm adding a second input cell (next to the 1st iteration).
It's working, but it's averaging the null values from the first row (essentially, if I use a 20 MA and then try to calculate a 20 MA of that MA, it's spitting out values at row 20 and using the first 19 null values from the MA column).
How can I modify the IF statement to exclude the null values from the previous column?
"A dumb man never learns. A smart man learns from his own failure and success. But a wise man learns from the failure and success of others."