Regression and Histogram output automation

[Section8]

Hi eviews forum! I was wondering if you could help me. Before I explain anything, I am using Eviews 7.

I have approximately 40 data series that I am attempting to automate the output to either word or excel. Each series has to be tested against two different benchmark series and the output of the regression (as seen on the stats page) as well as the histogram of the regression has to be outputted. If this is not possible, is there a way to output the JB test from the histogram page? Up until now, I have been doing this manually, simply by copying and pasting, but I cannot imagine that there is no way to automate the process. I am struggling with the programming as I am not a programmer, so any assistance, however minute, would be greatly appreciated!

[trubador]

You can find Spool object very useful. But you'll have to become familiar with programming features of EViews:

Code: Select all

spool charts 'create a spool object to hold histograms equation reg matrix(40,2) jbera 'create a matrix to hold jbera statistics for !i=1 to 40 reg.ls y!i c x1 x2 reg.makeresids res freeze(mode=overwrite,grout) reg.hist 'histogram of residuals charts.append grout freeze(mode=overwrite,tabout) res.stats 'stats of residuals jbera(!i,1) = @val(tabout(14,2)) 'jbera statistic jbera(!i,2) = @val(tabout(15,2)) 'jbera p-value next 'Save the spool as a RTF file charts.save(t=rtf) c:\users\...\documents\chartout 'Or save it as a PDF file charts.save(t=pdf) c:\users\...\documents\chartout

[Section8]

Thanks very much for your assistance! I have been playing around and have managed to get most things in order. The spool object is very useful, though I'm wondering if there is any way to live update the data without appending new objects to the spool, or do I simply have to create a new spool each time I would like to update the data?