VWB - Average Range Spreadsheet

Attached is an Excel spreadsheet as outlined in Vegas Weath Builder II

All you have to enter is the daily open, high, & low and it will calculate the rest automatically.

I don't have sundays in the spreadsheet as I don't trade on weekends, but you can delete the date, open, high, & low information and put in whatever days and currancy pair information you want, it will still calculate the same.

Let me know if you think I need to change anything.

this is great. i dont know why no one has commented on this.

do you have any data for spot forex? id like to get a comprehensive list of the big spot forex pairs

we could split the data entry work up. id be willing to enter gbp/usd...someone else could take another pair, etc.

There is tons of free data online. I can't find the link right now but Yahoo has come CSV (coma seperated values) data somewhere and there are some other beter places out there. If I find the link I will post. In the mean time quit entering that stuff by hand the work has been done for you.

OK guys try this one: http://ratedata.gaincapital.com/

Sometimes the data is a bit flakey with gaps so check it over, but if you are doing daily stuff you should have no problems. I am still looking for the other links.

I have to split for the 12th century in a bit, (see sca.org) so if I don't get back for a while it is just because I am having problems with the way-back machine.

hey thanks mr whipple.

im kinda confused on some of the columns though. im looking at the GBP/USD from January, week 1.

here is one row


255908752 GBP/USD 59:31.0 1.8585 1.859 D


i dont know what the date is, but there are only two price columns. need open, high and low!

im seraching for more...tell me if you can find any others
<table x:str="" style="border-collapse: collapse; width: 285pt;" border="0" cellpadding="0" cellspacing="0" width="378"> <col style="width: 53pt;" width="70"><col> <tbody><tr><td style="height: 12.75pt; width: 53pt;" x:num="" align="right" height="17" width="70">255908752
</td> <td style="width: 50pt;" width="66">GBP/USD
</td> <td class="xl24" style="width: 38pt;" x:num="38865.707997685182" align="right" width="50">59:31.0
</td> <td style="width: 48pt;" x:num="1.8585" align="right" width="64">1.8585
</td> <td style="width: 48pt;" x:num="1.859" align="right" width="64">1.859
</td> <td style="width: 48pt;" width="64">D
</td></tr></tbody><col style="width: 50pt;" width="66"><col style="width: 38pt;" width="50"><col span="3" style="width: 48pt;" width="64"><tr style="height: 12.75pt;" height="17"></tr> </table> <table x:str="" style="border-collapse: collapse; width: 285pt;" border="0" cellpadding="0" cellspacing="0" width="378"> <col style="width: 53pt;" width="70"><col> <tbody><tr><td style="height: 12.75pt; width: 53pt;" x:num="" align="right" height="17" width="70">255908752
</td> <td style="width: 50pt;" width="66">GBP/USD
</td> <td class="xl22" style="width: 38pt;" x:num="38865.707997685182" align="right" width="50">59:31.0
</td> <td style="width: 48pt;" x:num="1.8585" align="right" width="64">1.8585
</td> <td style="width: 48pt;" x:num="1.859" align="right" width="64">1.859
</td> <td style="width: 48pt;" width="64">D
</td></tr></tbody><col style="width: 50pt;" width="66"><col style="width: 38pt;" width="50"><col span="3" style="width: 48pt;" width="64"><tr style="height: 12.75pt;" height="17"></tr> </table>

Historical data is available from your MT4. Press F2 and select the currency pair. Then the Daily timeframe. Open, High, Low, and Close going back to 2002 on my SBFX platform is avail. You could export and then import to a spreadsheet.

Thanks so much for this spreadsheet. Was gonna have to make my own but then stumbled across this one. Thanks!