J
Joe
Hi -
I have what - at least for me - seems to be a complicated problem that I
sure would like to simplify if possible.
I'm working with 4 data fields representing the "Opening Price", "High",
"Low" and "Closing Price" of various stocks. The object of the exercise is
to experiment with various price patterns to see if there is statistical
relevance to be found.
One example would be if the "Close" is up 3 days in a row, what percentage
of time is it higher 1, 2, 3, 4 and 5 days later. Note, this is a simple
situation - there are many others and some are quite a bit more complicated.
So far, I've done this by coping the formulas in the cells, but this is very
cumbersome. I'm sure VB would help, but I've no idea where to start, or if I
should at all.
Any input will be much appreciated.
Thanks,
Joe
I have what - at least for me - seems to be a complicated problem that I
sure would like to simplify if possible.
I'm working with 4 data fields representing the "Opening Price", "High",
"Low" and "Closing Price" of various stocks. The object of the exercise is
to experiment with various price patterns to see if there is statistical
relevance to be found.
One example would be if the "Close" is up 3 days in a row, what percentage
of time is it higher 1, 2, 3, 4 and 5 days later. Note, this is a simple
situation - there are many others and some are quite a bit more complicated.
So far, I've done this by coping the formulas in the cells, but this is very
cumbersome. I'm sure VB would help, but I've no idea where to start, or if I
should at all.
Any input will be much appreciated.
Thanks,
Joe