I do get that Gareth. Thks a lot.
If i want to save other table in the same file but in an other tabs.
What shoud i do ?
I tried :
freeze(mytab) gmm1.stats
mytab.save e:\these\data\gmm
freeze(mytab2) gmm2.stats
mytab2.save e:\these\data\gmm range="gmm2"
But did not work
Search found 13 matches
- Sat Apr 18, 2015 10:39 am
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
- Fri Apr 17, 2015 2:07 pm
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
I didnot get what you said.
In the code, gmm1 is one of my regression and i want to so save it on file, excel if possible.
freeze gmm1
gmm1.save (t=xls) gmm
It's the code you gave me, with modification according to my regressions.
In the code, gmm1 is one of my regression and i want to so save it on file, excel if possible.
freeze gmm1
gmm1.save (t=xls) gmm
It's the code you gave me, with modification according to my regressions.
- Fri Apr 17, 2015 12:00 pm
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
freeze gmm1
gmm1.save (t=xls) gmm
gmm1.save (t=xls) gmm
- Thu Apr 16, 2015 4:53 pm
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
freeze gmm1
gmm1.save (t=xls) gmm
gmm1.save (t=xls) gmm
- Thu Apr 16, 2015 4:16 pm
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
i did it wrong the first time, but it's still saying SAVE IS NOT A VALID VIEW
- Thu Apr 16, 2015 3:49 pm
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
It said tab1 is not defined 
- Wed Apr 15, 2015 9:06 am
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
I tried this without any success
'freeze[mytab] eq.stats
'tab1.save(t=xls) e:\these\data\essai1.xls
What should i do ?
'freeze[mytab] eq.stats
'tab1.save(t=xls) e:\these\data\essai1.xls
What should i do ?
- Mon Apr 13, 2015 12:23 pm
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
I tried this without any success
'freeze[mytab] eq.stats
'tab1.save(t=xls) e:\these\data\essai1.xls
'freeze[mytab] eq.stats
'tab1.save(t=xls) e:\these\data\essai1.xls
- Mon Apr 13, 2015 10:52 am
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
How do i create a table to extract it afterwards on a excel file or compatible file ?
- Mon Apr 13, 2015 10:25 am
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
In fact i have 4 regression for each model i run.
I am analyzing liquidity timing, market timing and volatility timing on different dates.
So i have around 30 regression in total.
If i do understand what you said, i should create a table for each regression in order to extract it ?
I am analyzing liquidity timing, market timing and volatility timing on different dates.
So i have around 30 regression in total.
If i do understand what you said, i should create a table for each regression in order to extract it ?
- Mon Apr 13, 2015 9:53 am
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
Re: EXPORT REGRESSION TO EXCEL
I did 4 OLS regression on my diferent portfolios.
I want to export automaticaly the results from the OLS regression into excel in order to present my results on word afterwards.
I want to export automaticaly the results from the OLS regression into excel in order to present my results on word afterwards.
- Sun Apr 12, 2015 7:23 pm
- Forum: Programming
- Topic: EXPORT REGRESSION TO EXCEL
- Replies: 19
- Views: 14431
EXPORT REGRESSION TO EXCEL
I want to export all my regression tables to excel.
I tried the function write, WRITE(T=XLS,T,B2,s=data) e:\these\data\these.xls
However, it did not work.
Which function should i use to do it ?
I tried the function write, WRITE(T=XLS,T,B2,s=data) e:\these\data\these.xls
However, it did not work.
Which function should i use to do it ?
- Fri Feb 20, 2015 2:05 pm
- Forum: Data Manipulation
- Topic: Remove nan
- Replies: 1
- Views: 2286
Remove nan
Hi,
I am trying to remove the nan in different series i have.
I used the following code : X=@recode(X=na,0,X)
However, how can i do it once for all the series ?
Thanks in advance
I am trying to remove the nan in different series i have.
I used the following code : X=@recode(X=na,0,X)
However, how can i do it once for all the series ?
Thanks in advance
