Automate Analysis and Optimization from Detailed Excel Spreadsheet Data

Greetings! I am a profitable trader looking to optimize my stock trading edge. NO FINANCIAL OR MARKET KNOWLEDGE IS NECESSARY FOR THIS PROJECT. You will be analyzing how much a series of stock panics end up bouncing and will find the optimal bounce target that is the most profitable over the series of trades. Project Summary: Each Panic % Bin has its own optimal bounce target. The series of optimal bounce targets across these Panic % Bins is used to find the Optimization Curve. The methodology of finding this curve will be explored as we get to this step. The purpose of this curve is to use it as a general formula and also to interpolate to different categories and extrapolate to higher Panic % Bins (eg. -70%) Table Example: The table rows are testing Target %’s for each Panic % Bin column. So, as an example- the 5% Target row and -20% Panic column. Only panics from -20.0000% to -19.0001% are considered. Each instance where 5% is under or equal to the Bounce %, 5% is noted (please include the word 'Money' in your reply to show you have read my summary). Each instance where 5% is above the % bounce, that is noted as a loss (which is different for each bin and is found using the Loss % Curve). The value of the cell in the 5% Target row and -20% Panic column is the summation of the total result. So, if there was one win and one loss, it would be: 0.05 + loss Input/Output System: An easy way to input data will be needed as well as a built in output report with all the required analysis results and curves. Please see attached files for more detailed info. Please ask as many questions as you need! I will reply ASAP. This is a big project and needs to be done correctly to maximize productivity.