Excel Add-in

For making suggestions and/or requests for new features you'd like added to EViews.

Moderators: EViews Gareth, EViews Moderator

farrel
Posts: 85
Joined: Thu Sep 18, 2008 11:13 pm

Excel Add-in

Postby farrel » Wed Oct 30, 2019 12:20 am

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 understand for other user in EXCEL what these series mean
e.g. it might be imported using the check box "include Description series"

Image

2. Minor issue, is it possible to add horizontal scroll of the import data window, so that user can see a full description of the series?
Picture below - it's not possible to see full description

Thanks
Andrei
Attachments
Capture1.JPG
Capture1.JPG (51.7 KiB) Viewed 5312 times

EViews Steve
EViews Developer
Posts: 621
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Excel Add-in

Postby EViews Steve » Wed Oct 30, 2019 1:58 pm

Regarding your first request:


We could potentially include attributes as additional rows at the beginning or at the end of the data rows, but this can confuse Excel as it may decide your column data type based on the first few rows of data which now can be different data types.

Or maybe we could append the description to the series name?

As for your second suggestion:
We can add a horizontal scrollbar. We'll try to do this sometime soon.

Steve

startz
Non-normality and collinearity are NOT problems!
Posts: 3606
Joined: Wed Sep 17, 2008 2:25 pm

Re: Excel Add-in

Postby startz » Wed Oct 30, 2019 4:25 pm

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.

farrel
Posts: 85
Joined: Thu Sep 18, 2008 11:13 pm

Re: Excel Add-in

Postby farrel » Mon Nov 04, 2019 3:59 am

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 separate from description. I believe the Description of the series is very useful feature for end-users, which usually don't care about the names Eviews users exploit in programming...

2/ And one more minor issue - EXCEL Add-in imports ID series as "General format". That's would be nice to set @DATE, e.g. as Excel number category: Date (which sets DATE type to default regional settings of the user).
Attachments
Capture2.JPG
Capture2.JPG (47.93 KiB) Viewed 5209 times

farrel
Posts: 85
Joined: Thu Sep 18, 2008 11:13 pm

Re: Excel Add-in

Postby farrel » Mon Nov 04, 2019 4:12 am

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


Return to “Suggestions and Requests”

Who is online

Users browsing this forum: No registered users and 14 guests