Hi, I'd like you to help me update stock weightings on a monthly basis over about 16 months.
I've added a sheet called weightings.
For each month, June 16 - Oct 17, I'd like you to put in the weight of each stock. This can be taken from the values on AS or PA sheets.
You may need to adjust for currency (end of the month) as it all needs to be in USD. This data is in the sheets.
Once you have the value for each stock, please divide by the 'Closing capital' cell.
Each row will have a different stock with the same first five columns as in 'Returns Analysis'