I have 2 excel spreadsheets with multiple worksheets in which I have to add one data point each month on each worksheet. I would like to be able to put all the new monthly data in a separate worksheet and for the rest of the file, the graphs and tables to be updated. I would also like the tables and graphs to be saved as a picture so they can easily be inputed into presentations.
If we take the CTA spreadsheet as an example and the Tulip worksheet, I put new data on column A and B on a monthly basis I manualy put the column I too and then I want the column. What I would like is to have a worksheet data where I only have to put the last month data for each fund and the benchmark and for the individual graphs and table and the data in each worksheet to be updated.
I would like to have 2-3 extra worksheets to add new funds and for them to be integrated in the Piguet CTA and Piguet CTA G&T worksheets. If a fund is not updated (because it is not part of the selection anymore, it should be shown at a 0 weighting in the graph in Piguet CTA worksheet but the historical allocation should still be visible.
With regard to the weighting, I would like to have the weighting forward to be updated but also to be able to change it manually, if this could be done in the same additional worksheet where i would input the data monthly it would be great
I would like all the graphs and tables updated in the various worksheets and saved in separate pictures too (pictures i can input in various presentation
The same is required for the fixed income sheet