## Search found 82 matches

Sat Sep 05, 2015 2:12 am
Forum: Programming
Topic: Graphs: Adding a line in a scatter plot
Replies: 9
Views: 2405

### Re: Graphs: Adding a line in a scatter plot

I also found the way to add the vertical line crossing the zero. The questions left are: 1) automatic standardization of the variables (n) 2) rather than a linear fit, what would be the command to add a polynomial (power = 2) in the graph? All the information for fitting regressions in graphs are no...
Fri Sep 04, 2015 11:34 pm
Forum: Programming
Topic: Graphs: Adding a line in a scatter plot
Replies: 9
Views: 2405

### Re: Graphs: Adding a line in a scatter plot

I have figure out how to add a text:
myscat.addtext(.2, .1) Relation between x and y

but not how to standardize variables with the option (n)

Once standardized the variables, is it possible to add a vertical line crossing the zero?

Best
Fri Sep 04, 2015 11:04 pm
Forum: Programming
Topic: Graphs: Adding a line in a scatter plot
Replies: 9
Views: 2405

### Re: Graphs: Adding a line in a scatter plot

It is useful, but it seems not flexible enough.

For example you cannot standardize variables with the option (n):
myscat.scat(n)

or you cannot add a text with the option
myscat.addtext(.2, .1, x) Relation between x and y
Fri Sep 04, 2015 10:54 am
Forum: Programming
Topic: Graphs: Adding a line in a scatter plot
Replies: 9
Views: 2405

### Graphs: Adding a line in a scatter plot

I would like to add a line showing the relationship between two variables x and y in a scatter plot. graph gra_b1.scat(n) x y gra_b1.option linepat gra_b1.setelem(1) lcolor(blue) lwidth(2) symbol(circle) gra_b1.setelem(2) lcolor(blue) lwidth(2) symbol(circle) what is the command to add the line? Tha...
Tue Aug 18, 2015 7:17 am
Forum: Programming
Topic: Importing .xlsx files
Replies: 13
Views: 2144

### Re: Importing .xlsx files

This imports all the worsheet "Data" and not X Y Z.
Immagine I have 100 time series and I want to import only X Y Z starting from cell B10
Tue Aug 18, 2015 6:50 am
Forum: Programming
Topic: Importing .xlsx files
Replies: 13
Views: 2144

### Re: Importing .xlsx files

Can you please make me an example of uploading three time series X Y Z from cell B10 in a worksheet titled "Data" which is in a file titled example.xlxs?

Many thanks.
Tue Aug 18, 2015 3:29 am
Forum: Programming
Topic: Importing .xlsx files
Replies: 13
Views: 2144

### Re: Importing .xlsx files

It would be very useful if Eviews could validate the read command also for .xlxs files.
Is one useful value added compared to STATA and RATZ.
Mon Aug 17, 2015 9:33 am
Forum: Programming
Topic: Importing .xlsx files
Replies: 13
Views: 2144

### Re: Importing .xlsx files

In the same file, I have many worksheet.
When I do what you suggest, I get one variable with a time series and other variables with strange names and with a sample size from 1 to 205
Mon Aug 17, 2015 9:19 am
Forum: Programming
Topic: Importing .xlsx files
Replies: 13
Views: 2144

### Re: Importing .xlsx files

Unfortunately I could not find the answer in the Command and Programming Reference. This does not work: wfopen(e,b10,s=ip_cpi_un) database_monthly_lastfriday.xlsx EA_IP US_IP EA_CPI US_CPI EA_UR US_UR EA_loans_hh EA_loans_nfcs I need to get the data from cell "b10" in worksheet "ip_cp...
Mon Aug 17, 2015 9:00 am
Forum: Programming
Topic: Importing .xlsx files
Replies: 13
Views: 2144

### Re: Importing .xlsx files

This file can be imported (.xls): read(e,b10,s=ip_cpi_un) database_monthly_lastfriday.xls EA_IP US_IP EA_CPI US_CPI EA_UR US_UR EA_loans_hh EA_loans_nfcs This one does not works (.xlsx): read(e,b10,s=ip_cpi_un) database_monthly_lastfriday.xlsx EA_IP US_IP EA_CPI US_CPI EA_UR US_UR EA_loans_hh EA_loa...
Mon Aug 17, 2015 8:39 am
Forum: Programming
Topic: Importing .xlsx files
Replies: 13
Views: 2144

### Importing .xlsx files

It seems that Eviews 8 cannot import .xlsx files.
If this statement is incorrect, how do you import such files?
Mon Aug 10, 2015 10:28 am
Forum: Programming
Topic: Time varying standard deviation across variables
Replies: 3
Views: 713

### Re: Time varying standard deviation across variables

Thank you.

This provides the standard deviation based on a sample (i.e. N-1).

Is it possible to compute the standard deviation basen on the entire populations (i.e. N)?
Mon Aug 10, 2015 8:11 am
Forum: Programming
Topic: Time varying standard deviation across variables
Replies: 3
Views: 713

### Time varying standard deviation across variables

Consider three monthly time series Y, X and Z from January to August 2015.

I am interested in computing the monthly standard deviation among Y, X and Z and then plot the resulting time series.
It is a standard deviation among three numbers for each month.

How do you program it with Eviews 8? Best.
Wed May 27, 2015 4:51 am
Forum: General Information and Tips and Tricks
Topic: Interaction with fixed effect
Replies: 1
Views: 1737

### Interaction with fixed effect

Considere 3 countries: DE, US and BR For each country I have a specific time series y1, y2, y3 and a global factor z I counstrcut the following panel and I run the following regression: pool model_FE de us br model_FE.ls(cx=f) y1_? y2_? y3_? z_? How do I interact the country fixed effects with the e...
Thu Nov 07, 2013 11:01 am
Forum: General Information and Tips and Tricks
Topic: VAR Data Members
Replies: 9
Views: 3273

### Re: VAR Data Members

There is a bug in eviews 7.2?