Search found 13 matches

by nano17440
Sat Apr 18, 2015 10:39 am
Forum: Programming
Topic: EXPORT REGRESSION TO EXCEL
Replies: 19
Views: 14431

Re: EXPORT REGRESSION TO EXCEL

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
by nano17440
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.
by nano17440
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
by nano17440
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
by nano17440
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
by nano17440
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 :|
by nano17440
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 ?
by nano17440
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
by nano17440
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 ?
by nano17440
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 ?
by nano17440
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.
by nano17440
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 ?
by nano17440
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

Go to advanced search