Hi
I am doing financial calculations in Excel with stock prices found online, but most of the time I am not able to specify that I only want to download the stock price for the first day of every month, so I end up with daily stock prices (that means a lot of data when you work with 5-10 years). Of course, when saying "the first day of the month" I mean the first day when the Stock Exchange was open that month.
So I download everything and start deleting every row where the date is not the first of that month for that year (very time consuming). So, I realized I could probably write a Macro to do the work for me, but I quickly learned that I am terrible at writing code. Does anyone have a Macro that could do this sort of work?
Just to clarify, the Macro has to delete every row, but when the month changes that row is kept. In my case the date information is located in column A in the format dd.mm.yy.
Thank you very much for your help!
PS. I am aware that Yahoo Finance offers a list of monthly stock prices
Bookmarks