Search found 14 matches

by dhityayl
Fri Oct 05, 2018 3:27 pm
Forum: Programming
Topic: File IO Failed
Replies: 5
Views: 7078

Re: File IO Failed

Hi. It works fine on other computer. I think the problem is not on the eviews program.
Thank you
by dhityayl
Fri Oct 05, 2018 3:55 am
Forum: Programming
Topic: File IO Failed
Replies: 5
Views: 7078

File IO Failed

Hi, I have a code for loop programming below. So basically i loop a rolling regression and after that i want to save to excel. The code below works for the looping itself (without wfsave), but in the middle of the looping with wfsave, the loop failed. The error message is : File IO failed for file '...
by dhityayl
Thu Oct 04, 2018 6:58 am
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

Re: MTOS

Hi Steve,
The code works well for me.
Thank you so much for the help.
by dhityayl
Thu Oct 04, 2018 6:49 am
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

Re: MTOS

Hi Steve, I've tried that, but the file saved to my folder is not in excel but in csv file and i don't think that the file saved is the right series. is there anything else wrong with my code? I attached the csv file saved to my folder in this post. Thankyou cd "c:\Users\Dhitya\Desktop\Program\...
by dhityayl
Thu Oct 04, 2018 6:34 am
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

Re: MTOS

Hi Steve I've tried to add %file to my program below but it doesn't work. The error message is "Path in 'C:\Users\Dhitya\Desktop\test\%file.xlsx' does not exist in "WFSAVE(TYPE=EXCELXML) "C:\USERS\DHITYA\DESKTOP\TEST\%FILE" @KEEP DATE RETURN G1". cd "c:\Users\Dhitya\Des...
by dhityayl
Thu Oct 04, 2018 3:22 am
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

Re: MTOS

Hi. So i still haven't figure out how to save using wfsave. I have already tried the programming below, and it seems that the loop isn't working for saving the file. If i run the program below, it's just the last workfile that saved. Does anyone know which part is wrong? Also can i save the workfile...
by dhityayl
Wed Oct 03, 2018 9:13 pm
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

Re: MTOS

Ow okay I’ll try it again later.
Thankyou so much
by dhityayl
Wed Oct 03, 2018 7:04 pm
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

Re: MTOS

Hi Matt, I've tried the @keep, and it doesn't work. If i add the wfsave and @keep in my programming below, the error message said that "WSAFE is not defined or is an illegal command in "WSAFE(TYPE=EXCELXML) "C:\USERS\DHITYA\DESKTOP\TEST" @KEEP G1". Should I insert the filena...
by dhityayl
Tue Oct 02, 2018 6:36 pm
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

Re: MTOS

Thanks Matt, it works well. And i have one more question. After change the matrix to series, i want each file i loop to be save in excel file. Could eviews programm automatically export just the series i want on each file to excel? What syntax should i use? I’ve tried write and wfsave before but i d...
by dhityayl
Tue Oct 02, 2018 6:05 pm
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

Re: MTOS

Hi Matt
I’ve tried to change the !nrolls to !nrolls=!length-!window +1/!step, but it stil didnt work. The error message is S1 already exist in ‘SAMPLE S1 @first+59 @last’
Thankyou
by dhityayl
Tue Oct 02, 2018 4:32 pm
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

Re: MTOS

Garreth, I’ve already tried to change smpl to sample, and the error message said that R1 is not the same length as MTOS. Sorry Matt, i don’t quite understand, my calculation of !nrolls is off by one? What should the calculation be? Did i simply add +1 in the calculation? cd "c:\Users\Dhitya\Des...
by dhityayl
Tue Oct 02, 2018 8:00 am
Forum: Programming
Topic: MTOS
Replies: 18
Views: 13501

MTOS

Hi. I have a loop rolling regression programming using window 60 and step 1. The result is in matrix, and i need the result in series. First the matrix is (5,132), but i transpose it to (132,5). I wonder if i can change the matrix to series in eviews using MTOS. I've tried using the programming belo...
by dhityayl
Tue Oct 02, 2018 4:18 am
Forum: Programming
Topic: Transpose matrix & export to excel
Replies: 1
Views: 3479

Transpose matrix & export to excel

Hi. So i have 1300 csv data that i want to regress using rolling regression (with for loop). So I manage to do the loop programming, but the result comes in matrix (5,@nrolls). I want to transpose the matrix so it will be (@nrolls,5). After that, i want to change the matrix into series, so i can sav...
by dhityayl
Tue Aug 28, 2018 7:00 pm
Forum: Programming
Topic: Eviews rolling regression for next month beta
Replies: 0
Views: 3720

Eviews rolling regression for next month beta

Hi, so i'm new to eviews and i've been learning to use eviews for my dissertation. I've been using eviews for fixed window rolling regression and i've download a roll add in. So my window for rolling regression are 60 and step 1, to regress stock return and indices (monthly data). If i use data from...

Go to advanced search