Force freq=q when pageload .xlsx

[paues]

Is there some way to force pageload to import data using a particular frequency? Inspired by an old forum post, I have tried the command below. It gives me the observations I want but imports them as an undated panel.

Code: Select all

pageload myFile.xlsx range="Sheet1!B2" byrow names=(test1,test2,test3) @smpl 2010q1 2012q3 @freq q

[EViews Gareth]

Try:

Code: Select all

pageload myFile.xlsx range="Sheet1!B2" byrow names=(test1,test2,test3) @freq q 2010

[paues]

That works, but it does not allow me to restrict what observations should be read. It seems that adjusting the range to cover only the cells that I want works (below). That however leaves me with the hassle of having to figure out what would be the last column (similar to what I have mentioned in this post).

Code: Select all

pageload myFile.xlsx range="Sheet1!B2:L4" byrow names=(test1,test2,test3) @freq q 2010q1

[EViews Gareth]

Since you're doing a pageload, you could always do the pageload followed by a pagecontract to lop off the ones you don't want.

[paues]

Thanks for the tip! The way I suggested now seems a bit idiotic :D Nevertheless, I think that it should be possible to combine the @freq argument with a @smpl argument.