apalmerfinance
New Member
- Joined
- Jul 24, 2014
- Messages
- 1
Hello and thank you for opening this thread. I've struggled to think of or find a solution and would appreciate any help.
I would like to be able to convert daily stock market data, Open/High/Low/Close, into quarterly data which I can then chart in excel. I’m wondering if anyone had any suggestions for doing this?
I could build the quarterly data the long way by setting Open to the first day of quarter (using the Daily data) and setting Close to the last day of the quarter. I would use the MINA() function and select all the Lows within that given quarter, to give me the lowest price of that quarterly bar. I would then use the Max() function to select all the daily highs in that quarter to get the High for the given quarter.
The problem is its very time consuming. I would greatly appreciate any suggestions for how I can more easily convert daily data into quarterly data.
Thank you!
Alan
I would like to be able to convert daily stock market data, Open/High/Low/Close, into quarterly data which I can then chart in excel. I’m wondering if anyone had any suggestions for doing this?
I could build the quarterly data the long way by setting Open to the first day of quarter (using the Daily data) and setting Close to the last day of the quarter. I would use the MINA() function and select all the Lows within that given quarter, to give me the lowest price of that quarterly bar. I would then use the Max() function to select all the daily highs in that quarter to get the High for the given quarter.
The problem is its very time consuming. I would greatly appreciate any suggestions for how I can more easily convert daily data into quarterly data.
Thank you!
Alan