Search found 11 matches
- Thu Dec 01, 2011 5:28 pm
- Forum: Data Manipulation
- Topic: Help with importing cross section constant data
- Replies: 9
- Views: 5848
Re: Help with importing cross section constant data
You should open up the smaller dataset as a new workfile in EViews. Then copy from that smaller one to the larger one. When you do the copy you can use Paste-Special (rather than Paste) and set the copy stuff. Holy crap that worked perfectly! You are my eff'ing hero! You have no idea how many ways ...
- Thu Dec 01, 2011 5:09 pm
- Forum: Data Manipulation
- Topic: Help with importing cross section constant data
- Replies: 9
- Views: 5848
Re: Help with importing cross section constant data
You might have to explicitly tell it how the dates are structured when you do the copy. Where/how do I specify it? I have tried the "reset current sample to (I)current sample (2) workfile range (3) To end of range" options, and it seemed to do the same thing every time. I feel there may b...
- Wed Nov 30, 2011 10:51 pm
- Forum: Data Manipulation
- Topic: Help with importing cross section constant data
- Replies: 9
- Views: 5848
Re: Help with importing cross section constant data
If you just copy from the smaller dataset to the bigger one, EViews should automatically expand it (assuming it recognises the dates as being the same). Just to clarify, does this work in Eviews 6? And by copy, do you mean by opening the xls file via import? I still cannot determine why the program...
- Mon Nov 28, 2011 10:28 am
- Forum: Data Manipulation
- Topic: Help with importing cross section constant data
- Replies: 9
- Views: 5848
Re: Help with importing cross section constant data
Yeah unfortunately, they are huge and some of the stats are under NDA. I'm glad to know that it is at least user error, and that the data expansion is a feature of eviews. Thanks.Hard to tell without seeing the files.
- Mon Nov 28, 2011 9:03 am
- Forum: Data Manipulation
- Topic: Help with importing cross section constant data
- Replies: 9
- Views: 5848
Re: Help with importing cross section constant data
If you just copy from the smaller dataset to the bigger one, EViews should automatically expand it (assuming it recognises the dates as being the same). What may be wrong if it is not recognizing the dates as the same? They are formatted exactly alike and the smaller sets are both in csv and xls fo...
- Mon Nov 28, 2011 8:35 am
- Forum: Data Manipulation
- Topic: Help with importing cross section constant data
- Replies: 9
- Views: 5848
Help with importing cross section constant data
Hi all, So I have one massive dataset consisting of option valuations. Each entry has greeks, stats, and prices for a strike/expiry/day combination sold on a given day for all combinations available on that given day. This is thus a massive data set with about 800 entries per day over a year, or abo...
- Sun Oct 02, 2011 9:59 am
- Forum: Data Manipulation
- Topic: Access database in Student Version
- Replies: 7
- Views: 5598
Re: Access database in Student Version
Ah, I found that saving it as an mdb allows easy importing. Thread resolved!
- Sun Oct 02, 2011 9:46 am
- Forum: Data Manipulation
- Topic: Access database in Student Version
- Replies: 7
- Views: 5598
Re: Access database in Student Version
I have access to a regular, non-enterprise version on campus that I can save the workfile on. Then I think the student version will still allow me to manipulate it without being able to save changes.
- Sun Oct 02, 2011 9:36 am
- Forum: Data Manipulation
- Topic: Access database in Student Version
- Replies: 7
- Views: 5598
Re: Access database in Student Version
My first set has seven series and 224933 entries per series. Another set has five series and 709006 entries per series.
- Sun Oct 02, 2011 9:15 am
- Forum: Data Manipulation
- Topic: Access database in Student Version
- Replies: 7
- Views: 5598
Re: Access database in Student Version
So how can I convert this database so that I can open it with eviews? I was under the impression that e6 could open some type of file from access since it says "Simply drag-and-drop your existing Microsoft® Excel, Microsoft® Access, Stata®, SPSS, SAS® Portable, Rats, TSPTM, or PcGive Profession...
- Sun Oct 02, 2011 8:27 am
- Forum: Data Manipulation
- Topic: Access database in Student Version
- Replies: 7
- Views: 5598
Access database in Student Version
Hi I recently purchased the student version of eviews 6. When I try to open my access database (.accdb) in eviews, it requests a format string. What is this string or what filetype should I use to easily get this data into a workfile? This is a huge dataset (709006 entries, each with about 12 column...
