The RATS Software Forum

Good afternoon

I have a daily data set in excel (xls) format. When I open the data in WinRats I don't have any trouble but in MacRats the data jumps from one date to another omitting some dates. For example the data jumps from observation 49 to 106 omitting the data in between as you can see bellow. I have tried to use another formats but the problem persists but in WinRats everything is ok.

Thanks for your help

Alejandro

40 -0.022593068132 2.000 -2.000 11.09717788288 0.011775432139
41 -0.057018840878 0.000 0.000 11.04015904201 0.011115962612
42 0.096553360933 0.000 0.000 10.27442038039 0.010913908186
43 0.145168058775 0.000 0.000 10.41958843916 0.010035446847
44 0.302993312095 0.000 0.000 10.72258175126 0.010568166722
45 0.222564896006 0.000 0.000 10.94514664726 0.009980118587
46 0.227666971279 0.000 0.000 11.17281361854 0.009452348144
47 -0.069722056113 0.000 0.000 11.10309156243 0.008849945231
48 -0.193134364814 0.000 0.000 10.90995719761 0.008891849725
49 -0.035712099639 0.000 0.000 10.87424509798 0.009486357219
106 1.114004785364 0.000 0.000 17.86338711812 0.013860661185
107 0.149046085654 0.000 0.000 18.01243320378 0.014607916150
108 0.249484684899 0.000 0.000 18.26191788868 0.012595224370
109 -0.081367160848 0.000 0.000 18.18055072783 0.010970505983
110 -0.445161964618 0.000 0.000 17.73538876321 0.010176179952
111 -0.421045276908 0.000 0.000 17.31434348630 0.009218647850
112 0.722123817738 0.000 0.000 18.03646730404 0.009757139444
113 -0.526773286441 0.000 0.000 17.50969401760 0.008431877278

What is it that you're showing there?

When I use these commands

OPEN DATA "/Users/Alejandrogamboa/Research Warwick/Chapter III/STARGARCH.xlsx"
DATA(FORMAT=XLSX,ORG=COLUMNS,SHEET="COP") 1 3420 RETCOP INTCOP INTMCOP FUNDCOP IDIFFCOP
table
print

and after the option print this is what I get. I just show one part of what I am getting to show that MacRats is missing some observations.

You would have to send us a copy of the data file (to support@estima.com). The code for handling an XLSX file is identical on the two systems, so I'm not sure what might be happening.

Thanks Tom

I emailed my data set

Your data are actually fine. If you check the TABLE instructions, they match. It's the PRINT instruction that's having a problem with the volume of information being thrown at the editor. (Windows and Mac differ somewhat on how the editor works).

I just saw this and it seems all the regressions and models that I run use the right number of observations that my data has. Thanks a lot for this Tom

Best,