The RATS Software Forum

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 Choleski 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.

Please don't post the same question twice.

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.