Search found 70 matches

by RDS
Thu Feb 14, 2019 6:39 am
Forum: General Information and Tips and Tricks
Topic: Program a regression line in a scatter plot
Replies: 3
Views: 128

Re: Program a regression line in a scatter plot

When I plot the chart, essentially they are a group of variables.
Unfortunately, if I change the sample period, also the chart changes.

Is it possible to freeze the cross-plot with the regression line as Figures?
by RDS
Wed Feb 13, 2019 8:54 am
Forum: General Information and Tips and Tricks
Topic: Program a regression line in a scatter plot
Replies: 3
Views: 128

Re: Program a regression line in a scatter plot

Perfect.

Is there a possibility to show the coefficients and the R2?

Is there a possibility to relabel the axis: for example Y is OUTPUT and X is PRICES?
by RDS
Wed Feb 13, 2019 8:25 am
Forum: General Information and Tips and Tricks
Topic: Program a regression line in a scatter plot
Replies: 3
Views: 128

Program a regression line in a scatter plot

I would like to create a scatter plot between Y and X and add a regression line

graph FIG.scat Y X

Whats is the programming lines needed to add the regression line to the chart (FIG)?
by RDS
Wed Jan 30, 2019 3:20 pm
Forum: General Information and Tips and Tricks
Topic: Fill in a vector with a large number of scalars
Replies: 1
Views: 153

Fill in a vector with a large number of scalars

I would like to save and store one coefficient of the equation below in a vector(200) in order to generate a graph. I generate n numbers of scalars, which I then try to put together in a vector. However, the last part of the code is not working properly. It gives me a constant, namely the last esti...
by RDS
Thu Nov 22, 2018 11:06 pm
Forum: General Information and Tips and Tricks
Topic: Stars on coefficients' significance
Replies: 1
Views: 3817

Stars on coefficients' significance

Is it possible to program stars (***, **, *) on coefficients, if the correspondent t-stat is greater than xxx, xx, x (where x are numbers)?


The objective is to construct a table after estimating an equation (i.e. eq1) such as

EQ1
intercept 1.2****
alfa 3.2**
by RDS
Thu Jun 28, 2018 12:10 am
Forum: General Information and Tips and Tricks
Topic: NA versus zero values
Replies: 4
Views: 1230

Re: NA versus zero values

Yes, SERIES3 has NAs for the same observations that SERIES1 did originally
by RDS
Sat Jun 23, 2018 12:47 am
Forum: General Information and Tips and Tricks
Topic: NA versus zero values
Replies: 4
Views: 1230

NA versus zero values

I have some time series that in some periods have "NA" I set the "NA" to zero with the following expression: smpl @all if SERIES1 =NA genr SERIES1 = 0 However, when I sum SERIES1 with another complete SERIES2, the generated SERIES3 has exactly the "NA" of SERIES1: SERIE...
by RDS
Wed Mar 21, 2018 10:20 am
Forum: Programming
Topic: Import a large number of excel files
Replies: 8
Views: 955

Re: Import a large number of excel files

Import is not stable: Eviews crashes. I continue to prefer read smpl {%startdate2} {%lastdate} for %series 1 2 3 4 5 6 7 8 9 10 11 12 13 read(e,c2,s={%series}_) OECD_CLI_EA.xls CLI_{%series} next rename cli_1 cli_AT rename cli_2 cli_BE rename cli_3 cli_DE rename cli_4 cli_EA rename cli_5 cli_ES rena...
by RDS
Wed Mar 21, 2018 9:51 am
Forum: Programming
Topic: Import a large number of excel files
Replies: 8
Views: 955

Re: Import a large number of excel files

Steve,

I am not sure I understand your point.

I have imported the first file

import OECD_CLI_EA.xls range="1_!c2:c187" @smpl {%startdate2} {%lastdate} @rename series01 cli_AT

Is there a loop I can create around range="1_!c2:c187"
by RDS
Wed Mar 21, 2018 1:45 am
Forum: Programming
Topic: Import a large number of excel files
Replies: 8
Views: 955

Import a large number of excel files

I need to import a large number of excel files with sheets numbered from 1_ to 100_ Is there an efficient way to import them? The tentative approaches below give me an error for !i = 1 to 100 read(e,c2,s={!i}_) OECD_CLI_EA.xls CLI_{!i} next for !i = 1 to 100 read(e,c2,s=!i_) OECD_CLI_EA.xls CLI_!i n...
by RDS
Fri Mar 16, 2018 12:48 am
Forum: Programming
Topic: Save tables in specific excel worksheets
Replies: 7
Views: 869

Re: Save tables in specific excel worksheets

It would be useful if the Eviews team could create a piece of programme, which allows to export n tables in n different sheets of the same excel file, such as


for %table 1 2 3
filename.save(r=x:y, t=xls, sheet{%table}) c:\files\table
next
by RDS
Wed Mar 14, 2018 10:45 am
Forum: Programming
Topic: Save tables in specific excel worksheets
Replies: 7
Views: 869

Re: Save tables in specific excel worksheets

but this does not allow me to create many worksheets.

I would like to save tables t1, t2, t3 ... t100, in the same excel file but in different worksheets automatically.
by RDS
Wed Mar 14, 2018 1:01 am
Forum: Programming
Topic: Save tables in specific excel worksheets
Replies: 7
Views: 869

Re: Save tables in specific excel worksheets

If I am not mistaken the thread is for time series. I do not want to export a time series, but a table created in Eviews. Assume that I have created a table labeled "Tabletobesaved" and I would like to export this table in an excel file called macro.xls and in a sheet labeled worksheet1. T...
by RDS
Tue Mar 13, 2018 3:17 pm
Forum: Programming
Topic: Save tables in specific excel worksheets
Replies: 7
Views: 869

Save tables in specific excel worksheets

I would like to save tables t1, t2 and t3 in the same excel file but in different worksheets.

How can I modify the following code which save the tables in three different excel files?


for %endvar 1 2 3
t{%endvar}.save(r=A1:L23, t=csv) t{%endvar}
next
by RDS
Tue Mar 13, 2018 9:13 am
Forum: Estimation
Topic: Markov switching TVTP result
Replies: 3
Views: 637

Re: Markov switching TVTP result

can you provide us the link to the manual?

Go to advanced search