so a litlte background on what I am doing:
making candlestick charts that contain open(first), high, low, and close(last) price of a stock for a certain period. I have 95000 1 minute data ranges, and from these ranges I could derive any time frame I wish (If I wanted to make a 5 minute candle I would use the open from the 1 minute, the range of next four 1 minute highs/lows, and the close of the 5th minute.)
heres a pic to better illustrate: (I am using openoffice instead of excel but its works identically)
\1
So, I can get it to display the wanted data in another sheet, but I cannot get it to offset the data by 5 rows every time to get what the data would be on a 5 minute chart, for all 95000 1 minute bars.
I hope it is clear what I want to do, feel free to ask questions if you need to.
THANKS!
Bookmarks