Basic Excel question about time series

Discussion in 'Trading Software' started by bigbiscuit, Apr 14, 2009.

  1. I've been told I need an: "Excel macro to move web query values to another location for long term storage and use"

    Can anyone offer any insight into how I do this? For example I want to store daily data for FTSE options. Using web queries from Yahoo, my data refreshes, but overwrites the early stuff. On refresh I want the old stuff to go somewhere else and progressively stack up so that I can marvel at it as a graph.

    Any help greatly appreciated.