Search found 180 matches

by ecofin
Sun Jul 29, 2018 12:52 pm
Forum: General Information and Tips and Tricks
Topic: xlsx to EViews
Replies: 2
Views: 276

Re: xlsx to EViews

Oups! i missed this idea (Drag the Excel file onto EViews...etc), Thank you so much.
by ecofin
Sun Jul 29, 2018 7:16 am
Forum: General Information and Tips and Tricks
Topic: xlsx to EViews
Replies: 2
Views: 276

xlsx to EViews

Hi everybody 1/I have xlsx file named exchange_rate with three sheets named ( USD_DZD, EURO_DZD, GBP_DZD) from 01/01/2008 to 20/07/2018 every sheet have six columns (Date, Price, Open, Hight, Low, Change) and 2769 rows. How can import the three sheets directly in my workfile with the three pages?. (...
by ecofin
Mon Apr 10, 2017 2:36 pm
Forum: Data Manipulation
Topic: rename dummy and diagonal dummy
Replies: 74
Views: 8411

Re: rename dummy and diagonal dummy

Great, thank you for your help EViews Matt. 8)
Nice day.
by ecofin
Mon Apr 10, 2017 9:30 am
Forum: Data Manipulation
Topic: rename dummy and diagonal dummy
Replies: 74
Views: 8411

Re: rename dummy and diagonal dummy

Hello, if i use the one of previous code (in page two) it doesn't work correctly, and i would to generate all the (d_, t_, b_, d1_, t1_, b1_) not one by one, and the " series {%series_name1} = @recode({%series_name}, @nan({%series_name}(-1), 0)+2 , 0)" generate this t_001= 1 2 2 00000, her...
by ecofin
Sat Apr 08, 2017 2:47 am
Forum: Data Manipulation
Topic: rename dummy and diagonal dummy
Replies: 74
Views: 8411

Re: rename dummy and diagonal dummy

Hello, All previous programs generate dummy equal 1 and rename it by different way as required "d_{same date}" for each frequency ( day, month, week, interday, or by spanning by two month, two weeks...), how can generate and rename defferent trend "t_{same date}" "b_{same da...
by ecofin
Fri Apr 07, 2017 2:13 pm
Forum: Data Manipulation
Topic: rename dummy and diagonal dummy
Replies: 74
Views: 8411

Re: rename dummy and diagonal dummy

Hi everybody, I would have a follow up question on that: "De-trending with a level shift and/or a broken trend", i have several series that contaned multiple break points, to solve this it is necessary two have two series level shift and broken trend. 1) how can reverse the series d_.... i...
by ecofin
Thu Mar 30, 2017 1:26 am
Forum: Programming
Topic: simulate arch(1) & arch(2)
Replies: 7
Views: 1550

Re: simulate arch(1) & arch(2)

Any help please.
by ecofin
Tue Mar 28, 2017 11:56 am
Forum: Programming
Topic: simulate arch(1) & arch(2)
Replies: 7
Views: 1550

Re: simulate arch(1) & arch(2)

I don't follow you :roll: , could you solve this Mr startz.
by ecofin
Mon Mar 27, 2017 1:58 pm
Forum: Programming
Topic: simulate arch(1) & arch(2)
Replies: 7
Views: 1550

Re: simulate arch(1) & arch(2)

No idea!, whats wrong with the code :oops:
by ecofin
Mon Mar 27, 2017 11:21 am
Forum: Programming
Topic: simulate arch(1) & arch(2)
Replies: 7
Views: 1550

Re: simulate arch(1) & arch(2)

1/Got it! Mr startz, the first code work perfectly now, but the second code after some modification it work but i get NA from the third obs to the last. Any help. the second code is attached below. 2/another question: if i would like to simulate ARCH(p) should be the variances in the second part of ...
by ecofin
Sun Mar 26, 2017 1:58 pm
Forum: Programming
Topic: simulate arch(1) & arch(2)
Replies: 7
Views: 1550

simulate arch(1) & arch(2)

Hi everyone I have problem with this two code, i get NA series after the first observation for the 1st code, and i get error message for the second code. i would highly appreciate if any of you could help me! 1/first code ARCH(1) ' program 1 simulation ARCH(1) wfcreate u 1000 smpl @all 'define serie...
by ecofin
Thu Mar 09, 2017 8:48 am
Forum: Programming
Topic: rename series in the group, or rename variables in eq object
Replies: 2
Views: 933

rename series in the group, or rename variables in eq object

Hi everybody, i have two question: 1/ i have group named g1 with 14 series, (GDP, INF, @month=1, @month=2,....,@month=12) with my equation estmation ls stock c GDP INF @expand(@month) , i want to rename the 12 last series (@month=1 will be dum1 and @month=2 will be dum2.....etc ) by this code i get ...
by ecofin
Tue Jan 10, 2017 3:28 pm
Forum: Data Manipulation
Topic: many trend in the series
Replies: 11
Views: 1981

Re: many trend in the series

solved thank you Mr Gareth and Mr starz series trends=@recode(@during("2005m01 2005m07") or @during("2005m10 2005m12") or @during("2007m01 2007m04") or @during("2008m01 2009m02"),1,0) trends=@recode(@during("2005m01 2005m07") or @during("2005m10...
by ecofin
Tue Jan 10, 2017 11:52 am
Forum: Data Manipulation
Topic: many trend in the series
Replies: 11
Views: 1981

Re: many trend in the series

i get the same result when i write this code Mr Gareth, and it take long time to use smpl each time smpl @all series ss=0 smpl 2005m01 2005m07 series ss=@recode(trends,@cumsum(trends),0) smpl 2005m10 2005m12 series ss=@recode(trends,@cumsum(trends),0) smpl 2005m10 2005m12 series ss=@recode(trends,@c...

Go to advanced search