EViews.com

Ok, I got it - should have left out the " " here...sorry for the hassle ;-)

Hey Gareth, thanks for the quicky reply - actually I stumbled across "sec" soon after i posted & tried it out straightaway. import(type=excelxml) "00_intraday" range="Aufzeichnung!A1:BB1000000" colhead=2 namepos=last @freq "Sec" 11/05/2013 10:04:09 However...

Sorry, I forgot: I'm using Eviews 7.2. The error report reads:

Invalid frequency specification: "s" 11/05/2013 10:04:09 in "IMPORT(TYPE=EXCELXML) "00_INTRADAY" RANGE="AUFZEICHNUNG!A1:BB10000 ...

Hello! I'm trying to import secondwise data from an xlsx-file. However, my command doesn't work (it did for monthly data with "@freq m" instead of "@freq s"). import(type=excelxml) "00_intraday" range="Aufzeichnung!A1:BB1000000" colhead=2 namepos=last @freq &q...

hello! i try to extract the p-values and R^2 out of a mass of different equation objects into a table. i have the following problem: - using freeze on the equation works fine, however these extracted values seem to be strings rather than numbers. this is an issue for me as i would like to plot those...

thanks! now thats what i call easy ;-)

hello! I have been looking for an easy way to traxsform discrete time series data into binary format, e.g. for the return series +3% -1% -2% +5% +1% I would like to create a series that reflects only the sign of the returns (return<0--> "0", return>0 --> "1") that would then be t...

jap, that works just fine! thanks a lot!!

Hey there, the best tip I can give here is: Do it yourself! Have a close look at the formula of the test statistic (actually, a VERY close look, as even one missing or wrong parenthesis can obviously screw things up completely...!), and then program it step by step (it helped me a lot to program int...

Hey there! I intend to automate the import of data from an .xls to a workfile. Using the "import"-command, the system starts to take the data from upper left cell (a1). Is there a possibility to define the upper left cell where the import should start? I know you can define the upper left ...

Hey Guys! I have a quite lenghty program that is to be applied to every page of a worksheet. As there are many pages (and many worksheets) i would like to know whether there is a command which automatically changes to the NEXT page in the active worksheet, so the programme runs over this next page.....

Hey trubador, thanks for your reply .. that works perfectly! However - is there an overview of all the tables i can freeze in this manner? For example, the next thing i intend to do is grab a certain test statistic (Anderson-Darling) from the "Empirical distribution test (for normal distributio...

hello! can anybody tell me how to refer to the table of the variance inflation factors of a regression? for example i try to fill in a cell of my table with the respective value, however "vif" does not seem to be the right expression...: statistik_regressionen(!i+1,14) = @val(vif!i(11,3)) ...

hello, today a statistician suggested me to use the shapiro-wilk-test instead of the jarque-bera-statistic in order to test for normal distribution of the residuals. is this test implemented in eviews? i found this topic: http://forums.eviews.com/viewtopic.php?f=7&t=1927, however if i open the w...

perfect thanks!