Thanks in advance for you time! Disclaimer: I'm not a statistician.
Using Excel to analyze stock trading strategy. Uses monthly ending prices and formula-based buying/selling based on my inputs. In addition to the ending prices, I have three input variables which I adjust for each simulation run.
I run Monte Carlo simulation using randomized range of actual stock prices with calculated results output to Data Table (What-if Analysis). Calculated results per each run are $Drawdown; $End Portfolio Value; $Cash Required; %Annualized Return; %Total Return.
Can I use XLRisk to run simulations of the calculated results from my worksheet? Specifically, does it generate tables/charts based on my five calculated results? If so, can I input my acceptable range of input variables also?
Are the generated tables/charts static or dynamic? I run histogram (with pareto), box and whisker and scatterplot charts of my results. I also run a probability table for the results.
Hope this makes sense. Thanks!
Image of SS attached; green are inputs, yellow are results
![image](https://private-user-images.githubusercontent.com/153878736/290706305-21bab85f-c3fc-41e6-9991-157cc2a45cbe.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjMxOTU2MzUsIm5iZiI6MTcyMzE5NTMzNSwicGF0aCI6Ii8xNTM4Nzg3MzYvMjkwNzA2MzA1LTIxYmFiODVmLWMzZmMtNDFlNi05OTkxLTE1N2NjMmE0NWNiZS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODA5JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgwOVQwOTIyMTVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT02ZjBkNTQyOWM2ODQ2NjhjNmJiNTc4MzVjNTBiNzA2Yjg2ZDcyOGQ2NmVjZDJlYWZkMzg2OThiZDg1ZmVjYzRkJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.lROxCGw_zuKcDHf0spEdUnjUhd0aKjGYrDZXShQ0eHE)