EViews.com

Hello, EViews 8 Jun 19 2013 build I would like to blank out (-label) the date axis of a graph (axis(b)) object, thus getting rid of 2009, 2010, 2013, 2014, 2015, 2016, 2017, and instead adding a custom label in the form of an existing alpha (T-3, T-2,T-1,T,T+1,T+2,T+3). I checked 'axis' and 'datelab...

Great, thanks Gareth.

EViews 8 (Jun 19 build) Hi, I have a question on copying objects to another page (by value). This does what I want: wfcreate(page=Page1) u 100 series x = nrnd series y = nrnd pool Panel1 al ak ar store(o) Panel1 pagecopy(bylink,page=Page2) x y fetch Panel1 But can I do it without store/fetch using s...

Cool, thanks Gareth. It now runs in half the time (and having the Excel file open is actually what I'd prefer). One thing though ... in my case using import is still considerably slower than using the old read command (with a .xls file). I wonder if it's because import caters for many more 'argument...

Hi, I'm hoping to get some advice on using 'import' with Excel 2010 (.xlsx) files. With Gareth's help, I can import my data (very straighforward stuff/arrangement, nothing tricky, all 'tables' of same dimensions) without problems. But it is slow. It takes almost 20 seconds to run the program where a...

Hi Gareth, I don't mean to be annoying but something is bothering me. Could you please try the sequence of experiments below. 1. Using the data.xls file above, run: tic wfcreate a 1995 2015 for %sheet sheet1 sheet2 sheet3 sheet4 sheet5 read(t,s={%sheet},d4) data.xls 5 next !elapsed = @toc statusline...

Thanks very much Gareth for your suggestion. This does what I want it to do: wfopen data.xls range="Sheet1!c1:x8" byrow import data.xls range="Sheet2!c1:x8" byrow import data.xls range="Sheet3!c1:x8" byrow import data.xls range="Sheet4!c1:x8" byrow import data...

Thanks for the suggestion. A couple more questions: 1. How can I make it read in or create the dates (i.e. 1995 2015)? 2. I actually have more like 40 worksheets. How would I make it import the data (all located in the same cell locations) in all sheets in as few lines of code as possible, since wfo...

Hi, Can someone please help me with an efficient use of import or wfopen instead of read in: wfcreate a 1995 2015 for %sheet sheet1 sheet2 sheet3 sheet4 sheet5 read(t,d4,s={%sheet}) data.xls 5 next The code above is nice since it automatically reads in the variable names (located in column c). FYI, ...

Thanks Gareth, that worked.

Vlad.

Thanks Gareth. I'm still having some problems with this. FYI, my alpha series Country is a lot larger than 15 observations and contains country codes that are not listed in alphabetical order. After creating the group g, the group members will be: CODE="AUT" CODE="BLX" CODE="...

Hi, I am using EViews 7. In an undated workfile with range = 15 I have an alpha series named Country: Country = {AUT, AUT, AUT, BLX, BLX, BLX, BLX, BGR, BGR, CYP, CYP, CYP, CYP, CYP, CZE}. Is there an easy way for me to create the following five dummies? d_AUT = {1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...

Hello,

I'd like to add 'left rotated' text on a graph but positioned using coordinates.

If I do "graph.addtext(0.80,0.60,l) Hello" the "l" option ignores the (0.8,0.6) coordinates.

Can someone show me how I can overcome this?

Thanks.

Vlad.

Thanks Gareth ... that worked.

Sorry I wasn't clear. I have 3 time series W, X, Y. I'd like to generate a new series Z which, at each obervation, we have the average of W, X and Y. Kinda like the average(b2:d10) type function in Excel.

Hi,

Is there a function to calculate the average of multiple series, eg.

smpl 1990 2007
series z = (w+x+y)/3
show z

@mean(w,x,y,"1990 2007") would return an error since @mean essentially works on just one series (?).