Thanks for the comments regarding the Agg M stuff.
There are some snags in the spreadsheet. I'm certainly no expert in coding or VBA - For the auto download function I adjusted another spreadsheet I found at http://www.gummy-stuff.org/ - Lot of amazing stuff there. I'm sure someone who actually knows what they are doing with VBA will be able to sort them better than I can. Only really intended to use these myself so didn't anticipate other problems. All good though, the more eyes on this stuff the better.
Snags & fixes
1. 'Today' isn't downloading - The Macro only pulls data from the yahoo finance page for the previous day when its added to this page for example: http://uk.finance.yahoo.com/q/hp?s=^FTSE. Hopefully not too much of an issue though because the signals don't go long 'tonight's' close but tomorrow's close. So by the time the data because available tomorrow you should be able to have a signal for that day's close.
2. Sometimes line 8 is blank which messes things up. I've put some instructions on the modified spreadsheet below which gets around this.
3. Some pairs don't have enough data on yahoo finance and screw up the data. QQQQ is an example of this. The only way around this is a manual adjustment.
4. Column headings - added these to the adjusted spreadsheets below.
5. Manual version - Below you'll also find a different version of the Agg M (not leveraged, entry at 0.5). This time the data runs so that the most recent date is at the bottom. You can manually entry data or copy and paste from yahoo historical data. The signals should automatically update. Feel free to play around.
Downloads:
Revised auto spreadsheet. Download Agg M Scale
Spreadsheet for manual entry. Download PRSmanual
