Web Data Query: Automatically Add or Append New Web Query Data to Previous Data

[krismiller1982]

I'm still struggling to find a solution after several months of searching for an answer. Surely this concept is simple. Yes?

I have setup a web query to grab information from Yahoo Finance ( STOCKHISTORY function does not include adjusted stock prices, so I must use Yahoo Finance ). I'm trying to accomplish the following:

Upon web query refresh, new data is added or appended to the previously queried data. Thus automatically adding new rows of daily data into the table. Is there a way to do this? I appreciate anyones help. Thank you.

 

[krismiller1982]

Hi krismiller1982,
Did you find a solution using VBA? Please upload an excel-sheet if you did. Thx!

I did not. But I plan on finding a VBA solution in the following weeks. I've been busy with work & haven't had time to fart around with Excel the past few months.