Search found 77 matches

by farrel
Mon Nov 04, 2019 4:12 am
Forum: Suggestions and Requests
Topic: Excel Add-in
Replies: 4
Views: 492

Re: Excel Add-in

startz wrote:Steve,

Also consider a second sheet that serves as a data dictionary with first column names and second column description. That's a pretty common format.


This is interesting solution. I suppose the question is - is it possible to automate using EXCEL add-in?!

Thanks
by farrel
Mon Nov 04, 2019 3:59 am
Forum: Suggestions and Requests
Topic: Excel Add-in
Replies: 4
Views: 492

Re: Excel Add-in

1/ Ideallly, I would expect a description to appear above the name of the series in the EXCEL (attached pic). But, unfortunately, I have no clue on compatibility issues with EXCEL data type. Appending description to the name of the series?! I think that users would prefer to keep names of series sep...
by farrel
Wed Oct 30, 2019 12:20 am
Forum: Suggestions and Requests
Topic: Excel Add-in
Replies: 4
Views: 492

Excel Add-in

Dear Eviews, I have 2 suggestions to improve Excel Add-in for Eviews (I have Eviews 11) 1. Is it possible to import a description of the series along with series name into the EXCEL? Otherwise, once you have hundreds of series, it means series names are coded with short name and it's difficult to un...
by farrel
Thu May 09, 2019 12:41 am
Forum: Programming
Topic: ARDL Long Run Form and F statistics
Replies: 0
Views: 661

ARDL Long Run Form and F statistics

Eviewers, Anyone knows how to effectively extract F-stastistics and critical values from "ARDL Long Run Form and Bounds Test" view using programming? Freeze of the table doesn't really work, since I have 40 equations and "F-statistics" position in the table changes from equation ...
by farrel
Wed Apr 03, 2019 3:09 am
Forum: Bug Reports
Topic: Area Band
Replies: 0
Views: 700

Area Band

Dear Views, I tried to replicate Area Band as given in an example workfile “Forecast_unemp.WF1”. Area bands are ok, but I fail to see MEAN line. Manual says that "If there is an odd number of series in the group, the final series will, by default, be plotted as a line.". But it does not ha...
by farrel
Thu Mar 07, 2019 11:44 pm
Forum: Models
Topic: Model. Options for solving
Replies: 2
Views: 623

Re: Model. Options for solving

pity
by farrel
Thu Mar 07, 2019 7:17 am
Forum: Models
Topic: Model. Options for solving
Replies: 2
Views: 623

Model. Options for solving

Hi Eviewsers, Forecasting with EQUATION object there is a possibility to opt out tick mark, which says "insert actuals for out-of-sample observations". It means new series WILL NOT be filled with actual observations out of forecasting horizon. Is there any similar option for solving MODEL ...
by farrel
Sun Jan 27, 2019 12:37 pm
Forum: Econometric Discussions
Topic: estimation of Engle-Granger 2 step procedure
Replies: 7
Views: 12614

Re: estimation of Engle-Granger 2 step procedure

I just imagine that usually wages do not pass to prices immediately (due to any reason - price rigidity or nature of wage shock, or how markets are (im)perfect etc.). Then it's would be natural to assume that long-run relationship holds exactly entering wages with lag... But then, I'm curious whethe...
by farrel
Fri Jan 18, 2019 2:31 am
Forum: Econometric Discussions
Topic: estimation of Engle-Granger 2 step procedure
Replies: 7
Views: 12614

Re: estimation of Engle-Granger 2 step procedure

Whether anyone knows, is it THEORETICALLY correct to estimate the 1st step of Engle/Grenger 2-step procedure, i.e. estimating the long-run relationship with lag of explanatory variable? For example, relationship between prices and wages: PRICE = c(1) + c(2) * WAGE_{t-1} + u_{t} Is it correct to esti...
by farrel
Wed Jan 16, 2019 5:27 am
Forum: Econometric Discussions
Topic: Single-equation cointegration test
Replies: 0
Views: 335

Single-equation cointegration test

Dear all, I estimate cointegration between wages and prices (in logs) using Single-equation cointegration test. I aim at finding cointegration between some cointegration there, however, the results show that according to Tau-statistic I cannot reject Null, but according to z-statistic I reject Null....
by farrel
Wed Aug 15, 2018 2:04 am
Forum: Data Manipulation
Topic: Using import/wfopen instead of read
Replies: 16
Views: 6685

Re: Using import/wfopen instead of read

EViews Gareth wrote:Yes, it does.


I found that Eviews works with opened Excel only if I switch on "Share Workbook" in excel options (.xlsx).
Is this the way how do you enable Eviews to work with opened excel?
by farrel
Mon Aug 13, 2018 11:28 pm
Forum: Data Manipulation
Topic: Using import/wfopen instead of read
Replies: 16
Views: 6685

Re: Using import/wfopen instead of read

EViews Gareth wrote:Are you sure it was an Excel file and not a CSV file?


Gareth,

Whether your Eviews is working with opened EXCEL (.xlsx) file?
by farrel
Fri Aug 10, 2018 5:48 am
Forum: Data Manipulation
Topic: Using import/wfopen instead of read
Replies: 16
Views: 6685

Re: Using import/wfopen instead of read

as I see it - Yes! at least I judge the file by extension, which is ".xlsx"
by farrel
Thu Aug 09, 2018 7:29 am
Forum: Data Manipulation
Topic: Using import/wfopen instead of read
Replies: 16
Views: 6685

Re: Using import/wfopen instead of read

.xslx is a compressed file format. .xls is not. Try running the program whilst the file is open in Excel. Should be much faster (since Excel has already uncompressed). Dear Gareth, I tried running the program, while the EXCEL file is open, but I've got error message saying "Sharing violation f...
by farrel
Tue Jul 31, 2018 4:58 am
Forum: Bug Reports
Topic: Eviews crashes transforming data
Replies: 1
Views: 1308

Eviews crashes transforming data

Dear All, I have unregular issue with EViews crash when transforming data to monthly or annual changes. In particular, crash happens when I open group of variables, choose required transformation and it crashes (or start to scroll and crashes). Anyone experienced such weirdness?! I cannot really pro...

Go to advanced search