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"
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
Excel Add-in
Moderators: EViews Gareth, EViews Moderator
Excel Add-in
- Attachments
-
- Capture1.JPG (51.7 KiB) Viewed 31329 times
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Excel Add-in
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
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
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: Excel Add-in
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.
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.
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 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).
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 (47.93 KiB) Viewed 31226 times
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
Re: Excel Add-in
Dear Eviews,
Would it be a difficult to build additional feature - to import data in rows? Let's say, add some tickmark to "transpose" data...
Currently Add-in import data in columns
Andrejs
Would it be a difficult to build additional feature - to import data in rows? Let's say, add some tickmark to "transpose" data...
Currently Add-in import data in columns
Andrejs
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: Excel Add-in
Does the checkbox (Open/Foreign data as workfile) at the bottom
do what you want?
do what you want?
Re: Excel Add-in
Richard, Are you talking about importing data from excel to Eviews?
If anything, My question relates to importing data from Eviews databases to Excel by means of EXCEL Add-in
If anything, My question relates to importing data from Eviews databases to Excel by means of EXCEL Add-in
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: Excel Add-in
Sorry, I indeed misunderstood the direction.
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Excel Add-in
Andrejs:
We looked into this a while back but it turned out to be much more complicated than we thought.
On the Excel side, I don't think it has the ability to directly import from a data source and immediately transpose it before laying it out in a spreadsheet. It can definitely do this as a two-step process though.
On the EViews side, we would have to treat each observation as a separate object and we run into memory concerns and slow performance when we have to start reading a single obs across all objects as the data is usually stored grouped by their object instead of by obs number.
In short, I don't see this happening.
Steve
We looked into this a while back but it turned out to be much more complicated than we thought.
On the Excel side, I don't think it has the ability to directly import from a data source and immediately transpose it before laying it out in a spreadsheet. It can definitely do this as a two-step process though.
On the EViews side, we would have to treat each observation as a separate object and we run into memory concerns and slow performance when we have to start reading a single obs across all objects as the data is usually stored grouped by their object instead of by obs number.
In short, I don't see this happening.
Steve
Return to “Suggestions and Requests”
Who is online
Users browsing this forum: No registered users and 27 guests