Missing Observations

[upani]

Dear All,


I have a data set of daily trading data (5 days per week). As there are some observations missing from the data, i have deleted those dates from the data set. The problem with reading the data follows:

When i am reading the data from my XLSX file, i got some missing observations. If i want to have undated daily data for the attached file, the no of observation should be 2330. If i am going for basic statistics calculation it is taking 1956 observation, the missing observation counts to be 108 observations. So the total no of observation coming out to be 2064. Why there are still 266 days are missing from my data.

I am not able to get the logic, how RATS reads the data.

Please help me to understand.

With sincere regards,
Upananda

[TomDoan]

OPEN DATA "COPPER.xlsx"
DATA(FORMAT=XLSX,ORG=COLUMNS) 1 2330 FP1 SP1

seems to work fine.

[upani]

Thanks

If i want to add year into the data set to graph, how will i do that ?

Regards,
Upananda