Web query to create historical stock data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Web query is easy to schedule 5 minute refresh, however I want to retain this
5minute data to create a database continuing throughout the trading day to
generate 5 minute intraday price/volume data, my question is how can I move
the data up or down so as not to remove the previous 5minutes data as the new
data is generated. Any suggestions appreciated. thx
 
Thx Don,
If you suggest a macro, then how would I sync it to the scheduled web query,
the macro would need to run seconds after the scheduled web query, or the
macro would need to contain the web query, sorry Excel is a new endeavour for
me, TIA
Chris
 
Back
Top