This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have derived necessary information such as Mean, Std Deviation and number of days for which simulator need to generate data. This is calculated based on historical stock prices I have sourced using yahoo API.
I now want to generate 1000 stock price movement time series using this information. How can I dynamically configure Simulated Sampling tool to pick up the above information and generate values I need.
I have attached a workflow that generates one time series using python and calculates stock price movements starting from 'Last_Adj Close' for the specified number of days. I want data set with 1000 days worth simulated stock prices.
Hi Simple and very interesting! Note that every time you run it, the predicted curve price has a different behavior. This is a good way to teach about volatility on stock market, and why is so important to choose good business, diversify investments and stick it to the long term. Well, on my humble point of view. Thanks for sharing it!
Hi @patel_bm, assuming you are looking to iterate your Python code 1000 times, I put together a solution to help you achieve this objective. I used a combination of Generate Rows and Batch Macro to achieve the result.
I also managed to iterate using similar method to generate multiple time series.
However I am now working to use Alteryx tool 'Simulated Sampling' to achieve the same result. I will post final version of the workflows with both variations(Python as well as Simulated Sampling tool).
Here's my solution to the simulation problem using both Python as well Alteryx tool of Simulation Sampling using batch macros. Please don't forget to disable one of the container when running the workflow as each takes up to 15 minuted to execute depending upon machine specification.
Pardon me for not producing best of visual report of the data generated but we seem to have resolved issue of generated simulated data.
Thank you all for important inputs to the solution. Much appreciated.
Sorry but the solution I posted earlier has a bug that simulated sample tool seed was static value. It was defeating the purpose of MonteCarlo simulation. I have modified the workflow to generate random seed every time prices are generated.
I was getting only one prince line in interactive chart and it was driving me mad.. Finally managed to resolve it.