Web query to create historical stock data

C

ChrisT

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
 
C

ChrisT

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Source of historical intraday stock prices? 0
Excel 2013 - Web Query Question 0
Import Historical Stock Data from Yahoo-Finance 0
Static Web Query 1
Lookup function for closing price stocks 4
Queris/Macro automatically running in a hourly basis 1
Inserting data question 1
Stock Symbol Column comparison 10

Top