unable to put data in RATS

For questions and discussion related to reading in and working with data.
Irishlad
Posts: 1
Joined: Wed Aug 01, 2012 9:23 am

unable to put data in RATS

Unread post by Irishlad »

Hey all, I am currently researching the effect of liquidity constraints on the monetary policy setting of the Bank of England. I am using taylor type rule variables as well as UK TED spread (liquidity) to measure the impulse reaction functions in question. I also need to perform a VAR and use Cholesky decomposition to isolate shocks. It is my first occasion using RATS and I am unable to import the data from Microsoft excel into the Rats econometric package. Any suggestions will be greatly appreciated if any expertise knowledge from yourselves could be passed on. I have attached the file I am currently trying to import in.
Attachments
Rats so far.PRG
(8.3 KiB) Downloaded 1129 times
TomDoan
Posts: 7814
Joined: Wed Nov 01, 2006 4:36 pm

Re: unable to put data in RATS

Unread post by TomDoan »

You'll have to use Excel to sort the data (entire file) in increasing order by date. While you're at it, you should add series labels to the first row, which will make it easier to handle. With the dates in the proper order, you should be able to use the Data wizard to get the data in quite easily.
Post Reply