Hi. It works fine on other computer. I think the problem is not on the eviews program.
Thank you
Search found 14 matches
- Fri Oct 05, 2018 3:27 pm
- Forum: Programming
- Topic: File IO Failed
- Replies: 5
- Views: 7078
- 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 '...
- 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.
The code works well for me.
Thank you so much for the help.
- 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\...
- 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...
- 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...
- 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
Thankyou so much
- 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...
- 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...
- 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
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
- 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...
- 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...
- 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...
- 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...