I need to:
1. Modify an Excel spreadsheet so that it updates closing stock prices from Yahoo finance upon opening and deletes one day a year ago to end up with one year of prices.
2. Dynamically update charts with the updated prices as is shown in attached spreadsheet.
3. Generate additional charts to match same parameters as is shown on present charts, based on a check mark beside the stock symbol in the Correlation Box on the "Calculations" sheet. In other words, for all symbols check, confirm that a chart is set up on one of the sheets and if not, generate one.
Sir, I ll code a VBA maro to get the prices from Yahoo finances, update the sheet, and also update the charts. For the missing charts, it will be as well done. Ready t start. Thanks
13 pekerja bebas membida secara purata $106 untuk pekerjaan ini
Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, MOHIUDDIN.
I have gone through your project description and I'm confident to take up this project as I have done similar projects in the past. You can trust my work and award to start from now. Thanks