Good morning everyone,
I am conducting a study on the impact of covid-19 in the stock market. For this, I need to calculate the covid-19 variable. I will use the daily growth rate in covid-19 cases (in some cases #DIV/0! is coming) or the natural logarithm of covid-19 confirmed cases (in some cases #NUM! is coming) as its indicator. Now, how to deal with #DIV/0! and #NUM! in the case of time-series data? Since neither date can be deleted nor I can replace them with 0 value. Also, interpolation cannot be done in this case as covid-19 data is not missing. Please guide me.
Lots of thanks in advance.