Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

I need to create bollinger bands in Numbers

I am trying to chart a performance margin on a chart. I tried to chart a shaded area around a moving average using plus an minus STDEV's but the problem is that the STDEV cant show a negative number and this moving average travels into negative territory. Below is what i have.

User uploaded fileUser uploaded file

for the moving average: =SUM(X815:X838)/25

For the top and bottom areas for the shaded area: =AC839+STDEV(AC815:AC838)

=AC839-STDEV(AC815:AC838)

iMac, Mac OS X (10.6.7)

Posted on May 3, 2012 12:18 AM

Reply
Question marked as Best reply

Posted on May 3, 2012 3:03 AM

I've asked the mods to move this to the Numbers Forum where all the experts will see it.

17 replies

I need to create bollinger bands in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.