Search found 41 matches

by Elderfield.A
Tue Jun 23, 2020 4:11 pm
Forum: Programming
Topic: VBA to Eviews
Replies: 4
Views: 454

Re: VBA to Eviews

Thanks for the useful responses Steve and Gareth - personal opinions around which way data should run when people set up spreadsheets aside, it would be a nice feature to have in future. I also couldn't find any reference to this little quirk in the white paper (although I could have missed it) - ar...
by Elderfield.A
Mon Jun 22, 2020 8:42 pm
Forum: Programming
Topic: VBA to Eviews
Replies: 4
Views: 454

Re: VBA to Eviews

Turns out this is happening because my range runs across columns. It appears that for this to work I need the data to be transposed: I have changed this Dim rngAdjustedProfile As Variant, rngAdjustedProfileT as Variant And this rngAdjustedProfile = shWorkingAdd.Range("AdjustedProfile").Val...
by Elderfield.A
Mon Jun 22, 2020 6:23 pm
Forum: Programming
Topic: VBA to Eviews
Replies: 4
Views: 454

VBA to Eviews

Hi, I am writing some VBA to take data from excel into eviews: Dim shReadMe As Worksheet, shWorkingAdd As Worksheet Dim mgr As New EViews.Manager Dim app As EViews.Application Dim Path As String, SeriesName As String Dim rngAdjustedProfile As Range Set shReadMe = Worksheets("READ ME") Set ...
by Elderfield.A
Sun Jun 21, 2020 11:28 pm
Forum: Programming
Topic: Hessian is singular at iteration 1
Replies: 2
Views: 433

Re: Hessian is singular at iteration 1

I gather you are running an optimal control scenario. In my experience, this happens when your control variable(s) do not have an effect on your target variables - it usually happens to me when I forget to update a sample :lol:
by Elderfield.A
Sun Jun 21, 2020 4:30 pm
Forum: Econometric Discussions
Topic: Cholesky ordering
Replies: 1
Views: 517

Re: Cholesky ordering

Hi,

You might find Ouliaris et al. book useful - https://www.eviews.com/StructVAR/structvar.html

Adam
by Elderfield.A
Mon May 18, 2020 9:40 pm
Forum: General Information and Tips and Tricks
Topic: Pasting linked data in Excel
Replies: 3
Views: 641

Re: Pasting linked data in Excel

Hi Steve, Sorry, I should have included all this detail. Using Eviews 10+, 64bit and was built Feb 26 2018. Excel is 2016 version. However, I actually think the problem was occurring as I didn't declare a named object, when I declare a group followed by a list of variables, I can than copy and paste...
by Elderfield.A
Sun May 17, 2020 10:20 pm
Forum: General Information and Tips and Tricks
Topic: Pasting linked data in Excel
Replies: 3
Views: 641

Pasting linked data in Excel

Hi,

Not sure if this is an Eviews thing or an Excel thing, but I don't have the option to paste data as a link in Excel - I have attached a screenshot. Has anyone come across this before? And is there a solution?

Funnily enough, I don't have this issue with powerpoint.

Thanks

Adam
by Elderfield.A
Wed Apr 22, 2020 4:03 pm
Forum: Programming
Topic: Position text box based on data
Replies: 4
Views: 845

Re: Position text box based on data

Hi Jason,

Thanks for you reply and example. Unfortunately, my organisation is using Eviews 10+ (sorry I should have mentioned that from the outset). Is there a workaround here?

Thanks

Adam
by Elderfield.A
Tue Apr 21, 2020 11:15 pm
Forum: Programming
Topic: Position text box based on data
Replies: 4
Views: 845

Position text box based on data

Hi, I am trying to think of a neat way to position text boxes in charts based on the respective data in the chart, my first attempt of this (below) works, but still requires me to move the text boxes around to somewhere more visually appealing: for !h =1 to data.@count 'data is a group object with t...
by Elderfield.A
Tue Apr 21, 2020 11:06 pm
Forum: Add-in Writing area
Topic: Creating default options for add-in
Replies: 8
Views: 3942

Re: Creating default options for add-in

Yep - must of been one of those days for me. This works, thanks!
by Elderfield.A
Thu Apr 16, 2020 4:55 pm
Forum: Add-in Writing area
Topic: Creating default options for add-in
Replies: 8
Views: 3942

Re: Creating default options for add-in

Sorry for note being clear on this, I want to create a new series, based on the data contained in _this. My attempts of manipulating _this. directly were failing, but I more than likely was doing something wrong.
by Elderfield.A
Thu Apr 16, 2020 4:26 pm
Forum: Add-in Writing area
Topic: Creating default options for add-in
Replies: 8
Views: 3942

Re: Creating default options for add-in

I was trying to access the series objects data so I could transform it. As I understand it, .sheet brings the spreadsheet view of the object?
by Elderfield.A
Tue Apr 14, 2020 5:13 pm
Forum: Add-in Writing area
Topic: Creating default options for add-in
Replies: 8
Views: 3942

Re: Creating default options for add-in

That was just exactly what I was after, thanks Gareth. I am having a little trouble with the use of "_this" - I have read the post in this forum about it but I couldn't really answer my problem. What I want to do, if the option is specified is transform the selected variable %name1 = @getn...
by Elderfield.A
Tue Apr 14, 2020 12:54 am
Forum: Add-in Writing area
Topic: Creating default options for add-in
Replies: 8
Views: 3942

Creating default options for add-in

Hi, I am wondering how to write an add-in that has some default options pre-populated, which can then be overridden with the procs command. For example, say I have an add-in called "silly_addin" that creates a copy of a variable, then multiplies it by 100. And I want to be able to provide ...
by Elderfield.A
Mon Apr 13, 2020 8:52 pm
Forum: Add-in Writing area
Topic: Help with registering add-in
Replies: 4
Views: 819

Re: Help with registering add-in

This didn't actually work, but it was because I didn't declare a menu name - sorted now.

Go to advanced search