Forex data spreadsheet

I just read larry Williams' long term secret for short tern trading, and it sounds pretty interesting. I was wondering if there is such spreadsheet on forex daya.

For example:

1. what is the best day to buy? what is the best day to sell? according to Larry, there are certain percetanges of certain day being a good buy or sell day

2.what is the average range of each pair?

3. how many days does a pair spend in consolidation? Joe Ross proposed that a 21-25 days range for BO. etc etc.

There are some interesting theories about time-based trading. It's probably one of the most overlooked variables in trading.

With that said, I think a lot depends on your system. I have a database of about 500 sample trades following my personal system rules. I'm able to go back and look at specific returns for specific days. Although I haven't done it in a while, I don't remember seeing one day better than another. I have observed, however, that there is a cycle between what I identify as "mixed" markets versus breakout markets (my own personal designations.) Your post will have me go back and look at my data differently to see if the cycle is quantifiable.

If you are interested, I have the daily stats for the EUR/USD in a spreadsheet going back to August 1 of last year. I could either upload that or just tell you the daily range. It might take some work to figure out the best days to buy or sell, but I will try to work on it.

andersenws

P.S. Since I only trade the EURUSD right now, that's the only pair I have stats for. Sorry!

Thanks. Actually, I can get that info out of MetaTrader. If you want to get other pairs, just grab a demo copy of MetaTrader and you'll have that data for all the pairs.

Sorry. I realize now you were probably talking to MoneyDude.

Alright, I crunched the numbers and found some things out.

First, I use FXSol. I used their daily stats, with each day starting at 5 pm est. I calculated from 8/4/05 to 8/7/06. 263 trading days.

Overall stats first.
Average range between open and close was 51.25 pips.
Average range between high and low was 100.82 pips.
I used absolute values for these ranges. (i.e. if daily change was -25, I counted that as 25.)
There were 145 positive days out of 263 = 55.13% positive.
The average change over the time period was +2.16 pips.

Mondays
53 days in this data set.
The average change was -10.38 pips.
The average range between open and close was 52.34 pips.
The average range between high and low was 97.58 pips.
54.72% of days were positive gains.

Tuesday
52 days in this data set.
The average change was 2.87 pips.
The average range between open and close was 48.56 pips.
The average range between high and low was 95.19 pips.
55.77% of days were positive gains.

Wednesday
52 days in this data set.
The average change was 6.1 pips.
The average range between open and close was 46.02 pips.
The average range between high and low was 99.9 pips.
55.77% of days were positive gains.

Thursday
53 days in this data set.
The average change was 13.87 pips.
The average range between open and close was 59.42 pips.
The average range between high and low was 108.74 pips.
54.72% of days were positive gains.

Friday
53 days in this data set.
The average change was -1.58 pips.
The average range between open and close was 49.77 pips.
The average range between high and low was 102.57 pips.
54.72% of days were positive gains.

So there you go. I'm not sure if this is a big enough data set to draw any conclusions off of. Ironically, there were 29 positive days for every day. 29 positive Mondays, 29 positive Tuesdays... I thought that was strange. Hope this helps a little.

andersenws

thanks for the great replies guys. is there a way to extract daily OHLC range to excel spreadsheet, so i can play with the data a bit. Timing the trade is no way the only aspect of trading. i mean we all have our personal systems. but I think it will be a great filter to make sure we have the best odds on the table.

G'day all,

Here's something you might find handy. It shows average pips traded for all the major pairs (sessions, hours of the day,days of the week, days of the month)..

Somebody posted this in another thread. I don't know any further details.

Cheers,
Art...

Not sure if this is what you are asking. But I have been looking at the GBP/USD and how it moves in different time frames and short term trend reversals. Still putting it together I can say this that the GBP does a lot of 10 15 pip channeling after 5pm us eastern up untill 2am eastern. Most people are say ya we know that. Yesterdays movement during the Asian was unusual. Another thing I have seen with the Gbp is if it moves 50 or more pips and retraces beyon 27 pips the trend will only recover to about 15 to 20 pips beyond the point of it retracing. If it retraces more than 27 pips the run is pretty much dun (done). Looking back the last 21/2 months at the charts I have probably see a half a dozen exceptions to this. A couple of them happening just of late. So if got a run of 30 to 50 pips and you can hang in there with a 20 pip or so retracement much beyond that the trade off does not seem to worth the risk. Any additional in put is appreciated. This can be mostly picked up on the 15 minute charts.

Tom

good point, Tom. those are the things i wanted to pick up statistically. guess the only approach will be constany observation.

one more thing. for example, if in a downtrend, one paticular day makes a new low, but closes up. how profitable will be if we buy the next opening? these are kind of things i think we should take notice. mabye we can calculate a percentage, again it is all about odds, just like pokers. If you go all in on a backdoor straight draw, then your chance of winning is probably very low. any poker player here?

ONE more thing i am studying is the high low study. classical support resistance. what kind of bars makes local high and low. doji, hammer, or just regular bars. what is the percentage made up of each bar?