Search found 32 matches

by dravenous
Thu Apr 06, 2017 6:20 pm
Forum: Bug Reports
Topic: COM automation bug?
Replies: 4
Views: 1361

COM automation bug?

Hey guys, So I'm using Eviews 9.5 and I've had a VBA macro that has worked for the last 2 years. Suddenly I attempted to run the macro yesterday and I was no longer able to. The macro just breaks and says some mumbo jumbo like "Automation Error -2147417848 The object invoked has disconnected fr...
by dravenous
Thu Mar 09, 2017 1:45 pm
Forum: Programming
Topic: Export string objects to Excel
Replies: 4
Views: 1010

Re: Export string objects to Excel

Alrighty, thanks.
by dravenous
Thu Mar 09, 2017 1:40 pm
Forum: Programming
Topic: Export string objects to Excel
Replies: 4
Views: 1010

Re: Export string objects to Excel

You mean with the com automation? because that pagesave doesn't grab it.
by dravenous
Thu Mar 09, 2017 1:19 pm
Forum: Programming
Topic: Export string objects to Excel
Replies: 4
Views: 1010

Export string objects to Excel

Hey guys, I was wondering if/how you can export a string object from eviews to excel. I was trying something along these lines. Pagesave works for the regular series obviously, but it doesn't seem to recognize it if it's a string object. I've exported a string object to eviews before using the COM a...
by dravenous
Mon Sep 21, 2015 12:31 pm
Forum: Data Manipulation
Topic: Read in Data to Excel from database in VBA
Replies: 6
Views: 1773

Re: Read in Data to Excel from database in VBA

Does the app.Get below work with string objects? It doesn't seem to recognize them?

Code: Select all

Range(rng10).FormulaR1C1 = app.Get(S & emp & State, NATypeAsExcelNA)



Never mind, I got it to work. Forgot the quotes on the S.....
by dravenous
Fri Sep 18, 2015 11:46 am
Forum: Data Manipulation
Topic: Read in Data to Excel from database in VBA
Replies: 6
Views: 1773

Re: Read in Data to Excel from database in VBA

Following up on this-- I have everything working beautifully in terms of importing from Eviews using the VBA, but is there a way to ensure that the data label is also imported? ( I guess technically "description" in eviews)
by dravenous
Tue Sep 15, 2015 2:12 pm
Forum: Data Manipulation
Topic: Read in Data to Excel from database in VBA
Replies: 6
Views: 1773

Re: Read in Data to Excel from database in VBA

Thanks for quick response.

I thought that was the closest to what I was after. Where do you specify the database you want? Do I have to individually open it within a workfile for that interface to work?
by dravenous
Tue Sep 15, 2015 2:07 pm
Forum: Data Manipulation
Topic: Read in Data to Excel from database in VBA
Replies: 6
Views: 1773

Read in Data to Excel from database in VBA

I have been trying to figure out the most effective way to read in data to Excel with VBA code using eviews. I have been looking through a few references and can't seem to find exactly how to implement what I need.(examples below) I just need some VBA code that grabs a series from a specified databa...
by dravenous
Thu Apr 09, 2015 6:35 am
Forum: Programming
Topic: Syntax Error in seemingly identical code?
Replies: 5
Views: 1147

Re: Syntax Error in seemingly identical code?

It seems that the only way to get the correct growth rate, is to use the code below as opposed to what I mentioned earlier. Rather clunky work around, unfortunately. for %z {%met} series cheat1 = {%0}{%z}_1/{%0}{%z}_1(-!h1) series cheat2 = {%0}{%z}_{%old1}/{%0}{%z}_{%old1}(-!h1) series cheat3 = {%0}...
by dravenous
Thu Apr 09, 2015 6:08 am
Forum: Programming
Topic: Syntax Error in seemingly identical code?
Replies: 5
Views: 1147

Re: Syntax Error in seemingly identical code?

Wow, thanks Gareth. What a sensitive thing. I didn't think they would make a difference. Doesn't this mess up the order of operations? I need to raise the (A/B)^(-!h1) for %z {%met} series PCD{%0}{%z}_{%old1}= (({%0}{%z}_1-{%0}{%z}_{%old1})/({%0}{%z}_{%old1}))*100 series PCD{%0}{%z}_{%old2} = (({%0}...
by dravenous
Wed Apr 08, 2015 6:01 pm
Forum: Programming
Topic: Syntax Error in seemingly identical code?
Replies: 5
Views: 1147

Syntax Error in seemingly identical code?

I am writing some code and it keeps giving me a syntax error when I don't believe that I should be getting one. I took a small portion of the first program that I wrote below. This code works fine, but for some reason the second iteration fails. series histwa{%st} = ((wa{%st}/wa{%st}(-!h1))^(4/!h1)-...
by dravenous
Fri Feb 06, 2015 9:44 am
Forum: Data Manipulation
Topic: Mapping N/A values to a new value
Replies: 2
Views: 1221

Re: Mapping N/A values to a new value

Yea you are correct about wanting to multiply it by the previous value. The @recode is working much better. Thanks.
by dravenous
Fri Feb 06, 2015 8:59 am
Forum: Data Manipulation
Topic: Mapping N/A values to a new value
Replies: 2
Views: 1221

Mapping N/A values to a new value

Hello there. This is probably something ridiculously simple. I am trying to replace missing data points within multiple series with a new value generated off the last year's growth rate. So if I am missing 2014q3 I take the growth rate from 2013q2-2013q3 and use that to interpolate the 2014q3 value....
by dravenous
Fri Jan 30, 2015 10:17 am
Forum: Bug Reports
Topic: Attempted Aliasing map crashes eviews
Replies: 4
Views: 965

Re: Attempted Aliasing map crashes eviews

I don't often use the procedure, but it only happened on one day. It was the first time I had encountered the error. I did not log off the pc or reboot it, it corrected randomly without it. Eviews restarted multiple times during my attempts to access the aliasing mapping as it forced shutdown each t...

Go to advanced search