I am looking at share prices across a five-year period and have them on a daily basis. If I want to graph them, there is little point in charting five-years worth of daily prices, as the graph loses clarity. I would like to be able to see long-term graphs in, say, weeks or months worth of data. Is there a way that I can run a Macro, or such thing that would automatically convert daily data into longer time frames according to my design?
Bookmarks