Oct 13 2021 11:45 PM
Hello,
My data consists of 5 Parameters ( each with 3 - 5 values).
500 unique combinations of those parameters iterated over my target ( 250 different stocks ) produce different results ( profit)
I want to evaluate :
1.) each Parameters "strenght" of impact on Profit
2.) Correlation between Parameter and Stocks MarketCap/Volume Ratio for max Profit
3.) And Finally get a) universally best Parameter Configurations b) Individually best Parameter Configurations ( dependant upon MarketCap/Volume)
Before I start writing all kinds of formulas , maybe Solver/Data Analysis AddIns have this kind of functionality ? This kind of Data Analysis is fairly new to me , please point out whether Im looking in the right direction , thank you .
Oct 14 2021 05:40 AM