## Search found 107 matches

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

### 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.
Wed May 16, 2018 4:02 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 2699

### 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.
Wed May 16, 2018 2:55 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 2699

### 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.
Wed May 16, 2018 2:44 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 2699

### 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.
Sun May 06, 2018 6:45 pm
Forum: Estimation
Topic: Toda and Yamamoto causality test
Replies: 19
Views: 16730

### 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...
Sun May 06, 2018 6:38 pm
Forum: Estimation
Topic: Toda and Yamamoto causality test
Replies: 19
Views: 16730

### Re: Toda and Yamamoto causality test

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

### 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...
Fri Apr 27, 2018 4:52 pm
Forum: Data Manipulation
Topic: Using last observation in graph text
Replies: 8
Views: 2699

### 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 ...
Mon Jan 08, 2018 10:11 pm
Forum: Programming
Topic: Appending date ids - possible?
Replies: 12
Views: 3563

### 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.
Mon Jan 08, 2018 9:58 pm
Forum: Programming
Topic: Appending date ids - possible?
Replies: 12
Views: 3563

### 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.
Mon Jan 08, 2018 9:31 pm
Forum: Programming
Topic: Appending date ids - possible?
Replies: 12
Views: 3563

### 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...
Mon Jan 08, 2018 2:50 pm
Forum: Programming
Replies: 0
Views: 883

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

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

### 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?
Tue Dec 19, 2017 4:12 pm
Replies: 12
Views: 8548