Yo,
I've checked and my value agrees with the book i.e. -45. The value just above it is 54 i.e. are you sure you're not just looking at the wrong line or something (no offense but it's REAL easy to make mistakes on this thing initially). Are you also sure that your functions are correctly set up i.e. the MAX() function for 'R' as this would make a difference.
As far as the 7 period EMA is concerned I'm not using it i.e. not for any good reason really i.e. just back to the SI System on its own i.e. purely 'mechanical' SI. While the 7 period EMA sometimes keeps you out of bad trades it also keeps you out of good trades especially on a stop and reverse so I've just 'kinda' dropped it and I let the SI System just 'do its thing'!!! To be hones: I don't think that this system needs any tweaks whatsoever (I know I said that it MAY at one time but it's proving itself over and over and over again to me). As 'boring' as that may sound it 'just works' so I'm done with 'messing with it'!!! The key to the SI System is to follow it 'religiously', trust it, never miss a signal or second guess the system, and do not overtrade your account i.e. stick to either Wilder's money management rules or mine and you cannot go wrong.
Let me know if you can't figure out what the problem with your calculations is and / or send me an email to
dpaterso@forexbrokersonline.net and I'll send you a copy of my worksheet that I used to check my set up with the book.