Code a program
Budget: $10 – $90 USD
Hi
I need a coder who can code the following in excel or any other program so I can easily use it and get the result.
I will copy and paste the data and the specific dates and I want the result to be calculated immediately.
I want to be able to calculate the following:
- The success rate of maximum change of price of at least 5% , 10% 15% 20% based on the next 10 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
- The success rate maximum change of price of at least 5% , 10% 15% 20% based on the next 15 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
- The success rate maximum change of price of at least 5% , 10% 15% 20% based on the next 20 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
- The success rate maximum change of price of at least 5% , 10% 15% 20% based on the next 30 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
- The success rate maximum change of price of at least 5% , 10% 15% 20% based on the next 60 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
I will add the following information for each instrument and I want to automatically get the result:
- Date, open price, close price, high price, low price, implied volatility level and historical volatility level and IV percentile level.
- Specific dates for each year where the calculation should start from for the above requirements.
Check the picture attached.
If you have small knowledge if options, or logic with coding experience its easy job.
Thanks,
I need a coder who can code the following in excel or any other program so I can easily use it and get the result.
I will copy and paste the data and the specific dates and I want the result to be calculated immediately.
I want to be able to calculate the following:
- The success rate of maximum change of price of at least 5% , 10% 15% 20% based on the next 10 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
- The success rate maximum change of price of at least 5% , 10% 15% 20% based on the next 15 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
- The success rate maximum change of price of at least 5% , 10% 15% 20% based on the next 20 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
- The success rate maximum change of price of at least 5% , 10% 15% 20% based on the next 30 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
- The success rate maximum change of price of at least 5% , 10% 15% 20% based on the next 60 trading days for up and down move, For IV bigger than HV and for HV bigger than IM and for IV percentile less than specific number.
I will add the following information for each instrument and I want to automatically get the result:
- Date, open price, close price, high price, low price, implied volatility level and historical volatility level and IV percentile level.
- Specific dates for each year where the calculation should start from for the above requirements.
Check the picture attached.
If you have small knowledge if options, or logic with coding experience its easy job.
Thanks,