View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Kyle Kyle is offline
external usenet poster
 
Posts: 66
Default measuring waves in the currency market



marcus,

thanks again for trying to help me out. we're still not there yet but
thanks again for working with me. first, i'm sorry but i'm using a different
set of data now. so i hope that doesn't confuse things.

in the following spreadsheet, the starting point should be the open at row
2, 1.4504, but that really doesn't matter because once we get the ultimate
trough, or peak things will be the same.

here is the data that i'm using. in it i have highlighted in yellow the
peaks and the troughs. in red i have highlighted the point at which we
subtract the peak from the former trough or vice versa.

http://spreadsheets.google.com/ccc?k...xUVdTdWc&hl=en

in this spreadsheet i have listen the peaks and troughs and at what row they
occurred. i also showed the results for your algorithm. your algorithm only
caught two troughs and one peak, whereas there should be 4 troughs and 3
peaks. i also have listed at what row do we then subtract the last peak or
trough from the peak or trough before it.

remember once the price travels 33 pips up from a trough or 33 pips down
from a peak that is the moment that we subtract the peak or trough from the
peak or trough before it.

http://spreadsheets.google.com/ccc?k...wbjZwSXc&hl=en

for instance, at row 61 a trough is reached at price 1.4429, once the price
is greater than 1.4462 then we subtract that trough from the starting point.
that happens in row 62. then in row 78 a peak is reached at 1.4531, as soon
as the price slips below 1.4498 then we subtract that peak from the trough
before it. unfortunately that happens in that same cell. that might be a
problem. we do not know if the price first went to 1.4498 then shot up to
1.4531 or vice versa. i guess we'll just assume that the former happened,
but i realize that might make your algorithm harder to make.

i have a visual uploaded he

http://i87.photobucket.com/albums/k1...Picture8-3.png