Hi everyone,
I currently write my Master thesis in the field of renewable energy. I want to implement the famous mean-variance analysis by Markowitz to show how all possible combinations of 10 wind parks are different in terms of return/risk ratio.
There must be 2 specific formulas, respectively for calculating the return and risk of each combination. But some variables in these formulas must be alternately omitted (must be simply equal to 0) depending on which parks are not included in a combination. There are 1023 different combinations (when all parks are present, when only 1 park is excluded, then 2 and etc.).
So I need that Excel understands what variables must be present/absent in the formulas that make calculations for each combination and then takes necessary values from Excel's table and calculate with them 1023 results for each formula.
Do you guys know how I could do it? Maybe someone has a code for that?
Unfortunately, I'm very new to VBA and know only the most basics as if/do cycles, for example. So any direction as appropriate website or YouTube video would be helpful.
Thank you very much in advance!
Best regards,
Aleksei
I currently write my Master thesis in the field of renewable energy. I want to implement the famous mean-variance analysis by Markowitz to show how all possible combinations of 10 wind parks are different in terms of return/risk ratio.
There must be 2 specific formulas, respectively for calculating the return and risk of each combination. But some variables in these formulas must be alternately omitted (must be simply equal to 0) depending on which parks are not included in a combination. There are 1023 different combinations (when all parks are present, when only 1 park is excluded, then 2 and etc.).
So I need that Excel understands what variables must be present/absent in the formulas that make calculations for each combination and then takes necessary values from Excel's table and calculate with them 1023 results for each formula.
Do you guys know how I could do it? Maybe someone has a code for that?
Unfortunately, I'm very new to VBA and know only the most basics as if/do cycles, for example. So any direction as appropriate website or YouTube video would be helpful.
Thank you very much in advance!
Best regards,
Aleksei