The RATS Software Forum

Posted: **Wed Jun 01, 2022 5:21 am**

Dear All,

I would like to read my data using the following code.

DATA(FORMAT=XLSX,ORG=COLUMNS) 2005:01:07 2021:10:01 MCX COMEX SPOT

*
set rmcx  = 100.0*log(mcx/mcx{1})
set rcomex = 100.0*log(comex/comex{1})
set rspot    = 100.0*log(spot/spot{1})

After calculating the return series, how drop the first observation. As Rats is giving me the following error.
## REG20. GARCH Cannot Be Used with Gaps/Missing Values.

Please guide me on how to rectify the error in my code.
I have attached the data set for your reference.

With sincere regards,
Upananda

Posted: **Wed Jun 01, 2022 8:44 am**

You have embedded missing values in your data:

2010:12:31 NA NA NA
2016:12:30 NA NA NA

Given that you are using weekly data anyway, you should probably put in the nearest trading day for those entries.

Posted: **Wed Jun 01, 2022 11:33 pm**

Dear Sir,

Thanks a lot for your reply.

With sincere regards,
Upananda

The RATS Software Forum

how to read the return data

how to read the return data

Re: how to read the return data

Re: how to read the return data