I have an existing spreadsheet that I run market scenarios on.? I would like a macro to pull historical data off of yahoo finance, populate a certain section of the spreadsheet, while allowing my existing formulas to draw that data as the input in the model.? If I could enter the ticker into? a black cell in the spreadsheet and have the macro pull data after hitting enter that would be great.? ? Yahoo already keeps a database of historical data on each stock that can be downloaded to a spreadsheet, I just need the process to be faster and easier to use so I can do it all within excel.? If I liked how this turns out, the project could definetly grow and give opportunity for more in depth programming...?
I would email you the spreadsheet? file.? That way I can show you exactly where the data should populate.? Many of the formulas will already be in place to pull from the data coming from yahoo.? Basicly I want to be able to enter a ticker symbol into a blank space at the top and have the software go to yahoo and gather data for me so I do not have to download multiple spreadsheets to analyze multiple stocks.? This way I can etner ticker after ticker and monitor historical prices (and current) very quickly.? Example below.