Hi this is my first time posting in here, and hopefully I am in the right place. I have an excel file that I use to track all my financial investments. The file is already set up with a query to retrieve stock prices when I refresh the document.

I would like to be able to open up the document, and store the closing price of the stock(s) with a date in the next column over. With this information I can graph weekly, monthly annually, or any time period I want.

I have been searching for a couple of hours now, and I could not find anything similar to this. I would think this is a pretty common idea for many people tracking their investments with Excel, so if it has been covered perhaps someone can point me in the right direction.

I don't have any programming experience in excel so as detailed of an explanation as possible would be much appreciated. Thanks in advance.