Whats the most efficient way to re-resolve stock data? I have 10m data in a database that I am using for 3-5day trading purposes (e.g a 5 day chart). Now for a 1 month chart, I am multiplying 10 by 4 so I need 40minute resolution.
2 Questions I have about this:
- Is a 10m for 5 day chart trading (technical analysis) good? Is 40m for 1 month charts good? These were the values I generally found looking at online charts, etc
- Is there a easy way to re-resolve 10m data into 40m data? and What is the proper way to do it? How do you re-resolve volume?
Currently my plans are to write an algorithm to iterate through every 4 datapoints and calculate the running totals. The 40m open would be the open d1 (datapoint one), close would be close of d4, high would be the highest high of d1-d4, and low would be the lowest low of d1-d4. I have no idea how to re-resolve volume.
Would I be better off getting the data in 40m intervals as well. I think all the iteration of the stocks (monitoring 100 different stocks) might turn out to be to memory/process intensive.