Search found 47 matches

by dagfinnrime
Sun Feb 02, 2020 4:01 pm
Forum: Data Manipulation
Topic: Vertical axis with "gap"
Replies: 1
Views: 2448

Vertical axis with "gap"

Hi, I have values in my data that make it very difficult to show the (main) variation (big "outliers"). I can cap the axis to show the normal variation, but then I miss the maximum value. Is there a way to present vertical (data)-axis with "gaps"? Example: Ordinary variation is w...
by dagfinnrime
Wed Sep 21, 2016 5:50 am
Forum: Data Manipulation
Topic: Accessing Datastream
Replies: 5
Views: 4687

Re: Accessing Datastream

Since I have been struggling with this I post my successful attempt here: 0. You can find the zip-file here https://drive.google.com/file/d/0B2n4Rkc61L-TcHhBUkFxVmN4Z3M/view?usp=sharing (I was struggling finding it at Thomson Reuters) 1. Unzip the file to the Datastream folder (In my case: C:\Progra...
by dagfinnrime
Tue Sep 20, 2016 1:07 am
Forum: Programming
Topic: Using functions on groups
Replies: 3
Views: 1770

Re: Using functions on groups

Hi, I too would like to use functions on groups. (User request!!!). The way I fix it now is the following: for !i = 1 to gr_data.@count %varname = gr_data.@seriesname(!i) tab_descstats(1,!c) = %varname !mret = (1+@mean({%varname}))^12-1 !sdret = @stdev({%varname}) tab_descstats(2,!c) = !mret ' Retur...
by dagfinnrime
Sun Jul 10, 2016 2:20 am
Forum: Data Manipulation
Topic: Setting "distance" between symbols in graphs
Replies: 1
Views: 1514

Setting "distance" between symbols in graphs

Hi,

If have long time-span of high-frequency data. If I use symbols in time-series line-graphs it becomes so many that the line becomes impossible to see.

How can I set distance between symbols? A bit similar to how one can set distance between labels on X-axis.

Thanks in advance,

Dagfinn
by dagfinnrime
Sat Jul 02, 2016 1:06 am
Forum: Programming
Topic: Passing arguments to programs
Replies: 2
Views: 1424

Re: Passing arguments to programs

Thanks.
For some reason I thought I couldn't call a subroutine from within a subroutine.

So if I want the SUBROUTINE in a program for later reference, I can use a INCLUDE-command, and then CALL it in the program.
by dagfinnrime
Thu Jun 30, 2016 12:01 pm
Forum: Programming
Topic: Passing arguments to programs
Replies: 2
Views: 1424

Passing arguments to programs

Hi, I want to have a code that I can reuse to create "significant-asteriks" next to regression-coefficents in tables. This attempt works : subroutine signif(string %eq, scalar !coef) !sig10 = 0 !sig5 = 0 !sig1 = 0 if {%eq}.@pval(!coef) < 0.01 then !sig1=1 endif if {%eq}.@pval(!coef) < 0.05...
by dagfinnrime
Sun Apr 10, 2016 12:17 pm
Forum: Programming
Topic: Group Sum
Replies: 2
Views: 4688

Re: Group Sum

Hi, @rsum is of course very nice, but it propagates NAs. Code above can be fixed to deal with NAs. 'some group grp series grpsum = 0 for !grcount = 1 to grp.@count grpsum = grpsum + @nan(grp(!grcount),0) next Maybe add a version of group-row functions that don't propagate NAs? Like with moving-stat ...
by dagfinnrime
Thu Sep 17, 2015 6:26 am
Forum: Data Manipulation
Topic: ranking problem with @ranks
Replies: 6
Views: 3532

Re: ranking problem with @ranks

Hi a request: it would be very useful if @ranks could control how NAs are treated. Useful example is eg. for constructing portfolios in empirical asset pricing. However, a solution is: group x x_* !n = @obsrange !m = x.@count stomna(x,_tmp_mx) matrix(!n,!m) m_Ranks for !r = 1 to !n rowvector _tmp_rv...
by dagfinnrime
Thu Jun 18, 2015 1:45 am
Forum: Programming
Topic: notepad++ syntax highlingting for EViews
Replies: 9
Views: 10061

Re: notepad++ syntax highlingting for EViews

Hi,

thanks for making this available.

I already have NotePad++ installed for other purposes. Which files do I need to take from your "full" setup in order to make it similar?

Solution?
Just copy into my existing notepad++-folder and keep any files with same name?


Thanks
Dagfinn
by dagfinnrime
Tue Jun 16, 2015 5:37 am
Forum: Data Manipulation
Topic: import data into eViews from SAS
Replies: 4
Views: 5513

Re: import data into eViews from SAS

Hi, Eviews 8 and 9 read the ordinary sas7bdat-files. However, it doesn't translate eg. SAS-date to Eviews date (number-format is different). Using the SAS ODBC link does this, hence is very useful. (Of course, since SAS-time is seconds since midnight, and Eviews-time is share of day (I think/hope), ...
by dagfinnrime
Tue Feb 10, 2015 6:00 am
Forum: Data Manipulation
Topic: options for reading Excel files in wfopen
Replies: 3
Views: 2833

Re: options for reading Excel files in wfopen

Hi, dropping the "latsobs" option is unfortunate. It would be very handy. I have lots of Excel-files from which I want to import lots of different pieces of information. I know upper left corner, but I don't know the number of columns or observations in each file. Take this file as an exam...
by dagfinnrime
Tue Dec 16, 2014 1:24 am
Forum: General Information and Tips and Tricks
Topic: Problems with Eviews and DataStream (Win 8.1)
Replies: 3
Views: 2476

Re: Problems with Eviews and DataStream (Win 8.1)

Sorry!

Yes, I receive the ordinary about "Datastream Series Picker" error message (don't remember exact wording as I'm on a different machine now). The one that is supposed to be fixed with the updated DLL.

Best,
Dagfinn
by dagfinnrime
Mon Dec 15, 2014 3:12 am
Forum: General Information and Tips and Tricks
Topic: Problems with Eviews and DataStream (Win 8.1)
Replies: 3
Views: 2476

Problems with Eviews and DataStream (Win 8.1)

Hi, I have problems with Datastream-integration on Windows 8.1 64b. * I have most recent Eviews 8.1 32b * I have downloaded the DSSSeriesPicker.dll from ThomsonReuters. * Ran register.bat, choosing Use Admin rights when right-clicking bat-file Didnt' work. * Copied the dll-file to directory of exe-f...
by dagfinnrime
Fri Oct 31, 2014 6:14 am
Forum: Programming
Topic: wfopen: cannot get the "types=" option to work with xlsx
Replies: 1
Views: 1382

Re: wfopen: cannot get the "types=" option to work with xlsx

Hi,
I have been struggling with the same. Try capital letters for the type-codes.
Like

Code: Select all

wfopen "c:\Data\test.xlsx" range=a1:a4 nonames types=(A)
by dagfinnrime
Wed Jul 02, 2014 6:08 am
Forum: Add-in Support
Topic: EqBootstrap (bootstrap standard errors)
Replies: 28
Views: 30900

Re: EqBootstrap (bootstrap standard errors)

How do I get access to the bootstrap-results? Since it's not stored, using eg. equation.@tstats(2) won't work. I tried the following, and it didn't work. freeze(mode=overwrite,_temptab2) _tmpeq.eqbootstrap(bs=5000,se,res) It runs the bootstrap and show me the results in the equation window. But seem...

Go to advanced search