Search found 137 matches

by miorinnovo
Wed Jan 16, 2019 8:39 am
Forum: Programming
Topic: Programming the renaming of multiple variables
Replies: 1
Views: 46

Programming the renaming of multiple variables

Is it possible to import a list of variables in a particular order and then programming them to be renamed in a systematic way rather than have a long list of "rename x y". For example, if I have 100 variables and I want them to be renamed A1,A2...A10,B1,B2,...B10 etc.

Thanks
by miorinnovo
Thu Dec 20, 2018 8:20 am
Forum: Programming
Topic: Can I normalize just one axis on a graph
Replies: 0
Views: 76

Can I normalize just one axis on a graph

Hi, I know how to normalize a graph (n) but how can I normalize one axis of a graph? graph graph.bar(l,d) group This code creates a bar chart on one axis with the first series in group and a line graph on the right axis for the other series. I'd like the bar chart axis to be normalized. Is that poss...
by miorinnovo
Fri Dec 14, 2018 6:31 am
Forum: Programming
Topic: Programming a colour in every other row of a table
Replies: 1
Views: 107

Programming a colour in every other row of a table

The code below makes the table white form rows 1 to 15. is there a away to only change the colour of every other row?

Code: Select all

table.setfillcolor(1:15) white
by miorinnovo
Wed Dec 12, 2018 2:26 pm
Forum: Programming
Topic: frequency conversion
Replies: 1
Views: 90

frequency conversion

Can I copy a monthly series into a quarterly page such that the monthly values get averaged over the quarter and when there are months in a quarter that don't have data the last data point is repeated. For example If I have a series Jan=1 Feb=2 March=3 April=4 May=5 Can I get it sod that Q1 is 2 and...
by miorinnovo
Wed Dec 12, 2018 2:24 pm
Forum: General Information and Tips and Tricks
Topic: Size of graphs
Replies: 2
Views: 447

Re: Size of graphs

damn. thanks anyway
by miorinnovo
Wed Dec 12, 2018 1:01 pm
Forum: General Information and Tips and Tricks
Topic: Size of graphs
Replies: 2
Views: 447

Size of graphs

I can't seem to figure out how to get graphs to open larger than the standard size right away rather than resizing with the pointer. Is it possible?
Thanks
by miorinnovo
Wed Dec 12, 2018 12:05 pm
Forum: Programming
Topic: sample question - using series info
Replies: 4
Views: 137

Re: sample question - using series info

nice
by miorinnovo
Wed Dec 12, 2018 11:49 am
Forum: Programming
Topic: sample question - using series info
Replies: 4
Views: 137

Re: sample question - using series info

Thanks Gareth.

I was looking to use the last date of the sample as the last date in my series. I was able to easily adjust your example to get that though, so for future readers looking how to do this:

Code: Select all

%lastdate = @otod(@ilast(CANADAALLSTARTS))
smpl  {%lastdate}-5  {%lastdate}

by miorinnovo
Wed Dec 12, 2018 10:03 am
Forum: Programming
Topic: sample question - using series info
Replies: 4
Views: 137

sample question - using series info

Hi

If I want to have a sample of the last 6 months of my workbook I can use the code:
sample sample1 @last-6 @last

Is there a way to do this with the last date of a series rather than the last date in the workbook?

Thanks!
by miorinnovo
Thu Dec 06, 2018 9:02 am
Forum: Programming
Topic: Tables that contain series that sometimes aren't populated
Replies: 8
Views: 229

Re: Tables that contain series that sometimes aren't populated

Right, this is what I had in mind but I'm not sure how to code an if statement for whether a series exists.
by miorinnovo
Thu Dec 06, 2018 8:35 am
Forum: Programming
Topic: Tables that contain series that sometimes aren't populated
Replies: 8
Views: 229

Re: Tables that contain series that sometimes aren't populated

The issue is I would rather not have to comment out and uncomment lines of tables all the time. I would like the table code to stay as it is whether all series are populated or only some are populated.
by miorinnovo
Thu Dec 06, 2018 8:16 am
Forum: Programming
Topic: Tables that contain series that sometimes aren't populated
Replies: 8
Views: 229

Re: Tables that contain series that sometimes aren't populated

Thanks, That would create a second problem though because another formula is dependent on how many series get populated.
by miorinnovo
Thu Dec 06, 2018 7:38 am
Forum: Programming
Topic: Tables that contain series that sometimes aren't populated
Replies: 8
Views: 229

Tables that contain series that sometimes aren't populated

I have a table in my program that displays a number of series. These series only get created if certain conditions are met. So I'm wondering if , when those conditions are not met, and the series is not created, can i somehow still have the table show up with an NA rather than the message I currentl...
by miorinnovo
Tue Mar 20, 2018 1:00 pm
Forum: Programming
Topic: Replace the for loop line with
Replies: 1
Views: 308

Replace the for loop line with

Hello, I have a few of the exact same for loops in a program. I was wondering if there is a way change them all at once. In other words, my for loop goes through a list of variables which I am adding to, rather than going to every line where that for loop appears is it possible to change it once in ...

Go to advanced search