-
vba1.jpgvba2.jpg
If you look at the first link, in this particular portfolio, I have 4 assets with weights in each column, J:M. However, I want the flexibility to choose any number of assets, even 100 or more.
Also, if you look at the second picture, you'll see the data I selected doesn't go to the bottom of the column, which is why I want to be able to highlight the data manually, flexible for any situation, like I did in the example.
In this example, I would want the result of
(Sum(abs(J5-J4):abs(J34-J33))/30 = SumAsset1 = SA1
then loop Asset 1:Asset 4 and sum the sums, which are columns J:M.
Sorry, I don't have permission to link the addresses.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules