Thanks for the review and critiques. You're right, I did follow the book formula but changed Buy/Sell limits especially when backtesting.
As for using the spreadsheet in Excel, It won't work the same. The formulas should translate but Sheets and Excel's stock data function syntax is not the same and I'm not sure about the charts. As well, it seems to be only available in the Office.com version as some sort of beta release or slow roll out.