Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Web query to create historical stock data
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Web query to create historical stock data
You will need to (use a macro) move to another sheet.
-- Don Guillett SalesAid Software "ChrisT" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Web query to create historical stock data
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 "Don Guillett" wrote: You will need to (use a macro) move to another sheet. -- Don Guillett SalesAid Software "ChrisT" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query doesn't add/delete data in rows on refresh | Excel Discussion (Misc queries) | |||
Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions |