No registration required! (Why?)

Using Excel to Back Test Trading Strategies

As a newbie to this board, may I start with "hello everyone"

I'm getting back into trading after some years and was interested in the use of MS Excel for back testing. I picked up the "Using Excel to Back Test Trading Strategies" article from this website via Google and downloaded the file

I spent an hour on it... 15 mins to understand the cell logic which I found most instructive.. and 45 more mins trying to figure out why the Averages and Totals at the bottom of the page were INCORRECT.

I've built lots of Excel spreadsheets over the years and made mistakes too! In the case of this spreadsheet ( it seems the totals / averages are calculated over rows 1 through 253 where they should be rows 2 through 253.
Row 1 is the headers and includes 1,2,3,4,5 for the days of the week (Mon - Fri)which are getting added in to the totals / averages in error.

Thought the author might want to correct it before it's downloaded too many more times

Emini Day Trading / Daily Notes / Forecast / Economic Events / Trading Indicators / Search / Terms and Conditions / Disclaimer / Books / Online Books / Site Map / Contact / Privacy Policy / Links / About / Day Trading Forum / Investment Calculators / Pivot Point Calculator / Market Profile Generator / Fibonacci Calculator / Mailing List / Advertise Here / Articles / Financial Terms / Brokers / Software / Holidays / Stock Split Calendar / Features / Mortgage Calculator / User Pages / Donate

Copyright © 2004-2019, MyPivots. All rights reserved.