Excel Macro - Probability calculation / Statistics
Budget: $10 – $20 SGD
The dataset is composed of: in column A the date, Column B the ticker daily close price, Column C to column T the moving averages from 5 days to 90 days by an increment of 5 days.
The objective is to calculate the probability that the ticker price of column B cross under the next moving average when the previous moving average is crossed.
In plain English, I should be able to read in a table that when the ticker is crossing under the 5 day moving average then there is a 20% probability that it will cross under the 10 day moving average, and so on with the next moving average.
I need a macro that allows me to copy/paste the same dataset structure in a new tab and get the results.
The objective is to calculate the probability that the ticker price of column B cross under the next moving average when the previous moving average is crossed.
In plain English, I should be able to read in a table that when the ticker is crossing under the 5 day moving average then there is a 20% probability that it will cross under the 10 day moving average, and so on with the next moving average.
I need a macro that allows me to copy/paste the same dataset structure in a new tab and get the results.