EViews.com

Hello -

I am importing an excel spreadsheet with several time series into a workfile, where the first row represents the names of the series. Is it possible for me to get the list of all the names in the workfile?

I have version 8.1. Don't see ttom in the function list.

Hi - is there any functionality available to convert a table row (not an Alpha series, same type) to a matrix/series?

Is there a function to count number of occurrences of a string pattern in string list? Before writing a function, I want to know if there is out-of-the-box functionality to compute number of occurrences of a string pattern in a string list? Thanks,

Hello - I am using Eviews 8.1. I have a sVector allSeries and I want to be able to pull unique strings and store it in an another sVector. I wrote this: string comboStr = @wjoin(allSeries) string uniqueList = @wunique(comboStr) svector uniqueSVector = @wsplit(uniqueList) However, I get this error &q...

Hello all - any thoughts on this? I cannot figure out how I can pick the last point of a series in a panel and store it in a matrix in a rolling time horizon or an expanding time horizon regression? I can do that for t stats and coefficients with ease using : colplace(statsTstat,eqSolve.@tstats,!i) ...

Another approach I tried: In my previous post, I changed smpl s1 @last-!numMonths+!horizon @last-!numMonths+!horizon stom(fittedSeries,fittedHolder,s1) to smpl @last-!numMonths+!horizon @last-!numMonths+!horizon colplace(fittedHolder,fittedSeries,!i) But then I get an error - MAtrix size mismatch in...

Thanks. To get the last element of the fitted series, I have added following code (last three lines below): . . !numMonths = 12 matrix(!numCountries,!numMonths) fittedHolder . . . for !horizon = 1 to !numMonths smpl @first @last-!numMonths+!horizon equation.eqSolve ****** eqSolve.fit fittedSeries sm...

Gareth - thanks for your response. I can use equation.fit and equation.makeresid function. For each of the cross sections in the panel, I would like to pick the last reading (last fitted value and last residual). I lose ids if I make a matrix out of the series. So, I combine the fitted values and re...

I would like to capture fair value and residuals along with various rolling stats - R-squared, t-stats etc. I can create an array to capture stats in a fair value, but I would like to capture a lot of data for each roll including fair value/residuals along with regression stats/coefficients. What is...