Hello everyone, first off regarding the EMA calculation thanks for all the effort put in by everyone! We finally figured it out with the help of a couple members!  Here's the deal

so apparently the EMA needs a lot more past data before you smooth out the data and get a proper result.  For example when you calculate a 9 day SMA, you simply average the last 9 day closing prices, however when calculating a 9 day EMA, you might need to use the past 30 data points before it smooths out enough to get a proper answer.

here's an answer I got back  from Stockcharts and this basically explains it

Stockcharts provides the answer:

Because an  EMA  begins with a simple moving average, its true value will not be realized until 20 or so periods later. In other words, the value on the excel spreadsheet may differ from the chart value because of the short look-back period. This spreadsheet only goes back 30 periods, which means the affect of the simple moving average has had 20 periods to dissipate.  Stockcharts .com goes back at least 250-periods (typically much further) for its calculations so the effects of the simple moving average in the first calculation have fully dissipated.

So, you probably need to go back at least 30 BPENER values, possibly more, before getting a precise (i.e. sufficiently dissipated) calculation...