Search found 107 matches

by terrya
Wed May 16, 2018 8:19 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 7396

Re: Using last observation in graph text

Hi

I tried it and it worked. What I didn't realise was that I had to use %text as the text for the graph.


So thanks for all this.
by terrya
Wed May 16, 2018 4:02 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 7396

Re: Using last observation in graph text

Yes I copied it straight from here (using copy instruction). Will try again when I get back to the laptop.
by terrya
Wed May 16, 2018 2:55 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 7396

Re: Using last observation in graph text

Hi

I just tried @stripquotes to see if this fixed things but it didn't, presumably because I used %last_year still.
by terrya
Wed May 16, 2018 2:44 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 7396

Re: Using last observation in graph text

Hi

This works except it puts quotes about the last date, i.e., "2017" rather than 2017 making the label look a little odd.
by terrya
Sun May 06, 2018 6:45 pm
Forum: Estimation
Topic: Toda and Yamamoto causality test
Replies: 19
Views: 29272

Re: Toda and Yamamoto causality test

Further point: This is what Tom Doan says about the TY approach: "We've had several recent questions about the use of the Toda-Yamamoto variant on causality tests (including one user who had a referee insist that he use it). The reference on this is Toda, H.Y., Yamamoto, T., 1995. Statistical i...
by terrya
Sun May 06, 2018 6:38 pm
Forum: Estimation
Topic: Toda and Yamamoto causality test
Replies: 19
Views: 29272

Re: Toda and Yamamoto causality test

Look at Dave Giles post for Friday, April 29, 2011
by terrya
Mon Apr 30, 2018 5:51 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 7396

Re: Using last observation in graph text

The problem isn't getting the last observation, it's concatenating that value with text so that the range displayed in the graph text is updated correctly. For example, suppose the basic text is "Temperature from 1850-". I want to add the date of the last observation to that text so that t...
by terrya
Fri Apr 27, 2018 4:52 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 7396

Using last observation in graph text

How do I convert the date of the last observation in a time series so that I can use the addtext instruction in a graph? The purpose being to update the range of data automatically in a programme. For example, suppose that I want to use the text "Data 1999-lastdate". I've tried x.@last in ...
by terrya
Mon Jan 08, 2018 10:11 pm
Forum: Programming
Topic: Appending date ids - possible?
Replies: 12
Views: 8879

Re: Appending date ids - possible?

Thanks for this. It'll be very helpful as I really don't know anything about the inner workings of excel.
by terrya
Mon Jan 08, 2018 9:58 pm
Forum: Programming
Topic: Appending date ids - possible?
Replies: 12
Views: 8879

Re: Appending date ids - possible?

Thanks. I was intending to ring tomorrow (our time) to ask whether there's a problem with their files. However,as I indicated earlier, there appears to be no problem with reading the files into R. And your procedure with xls files worked really well.
by terrya
Mon Jan 08, 2018 9:31 pm
Forum: Programming
Topic: Appending date ids - possible?
Replies: 12
Views: 8879

Re: Appending date ids - possible?

Thanks that's precisely what I want to avoid. I used to do this. Anyway, I can get the data via an R script. I want to get the data directly into an Eviews programme since for what I want to do is done far better in Eviews. Also, I doubt that the files aren't Excel files. There is a problem with htt...
by terrya
Mon Jan 08, 2018 2:50 pm
Forum: Programming
Topic: Downloading xlsx files in programme
Replies: 0
Views: 2015

Downloading xlsx files in programme

Is it possible to modify the programme referred to in this topic for xlsx files?

viewtopic.php?f=5&t=18043
by terrya
Thu Dec 28, 2017 4:49 pm
Forum: Programming
Topic: Appending date ids - possible?
Replies: 12
Views: 8879

Re: Appending date ids - possible?

Hi

Since I posted this, the RBNZ has changed to xlsx files. I've tried to modify the procedure suggested above but can get only the data 1999-2013. Is there a way around this?
by terrya
Tue Dec 19, 2017 4:12 pm
Forum: Add-in Support
Topic: BBQ add-in
Replies: 12
Views: 19189

Re: BBQ add-in

Installed add-in as suggested. Definitely working. Thanks.
by terrya
Tue Dec 19, 2017 4:08 pm
Forum: Add-in Support
Topic: BBQ add-in
Replies: 12
Views: 19189

Re: BBQ add-in

Thanks will try late

Go to advanced search