[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[RT] Re: S&P data in excel format



PureBytes Links

Trading Reference Links

--- In realtraders@xxxx, MrLynnG@xxxx wrote:
> In a message dated 03/25/2001 3:08:38 PM Pacific Standard Time, 
> chrischeatham@xxxx writes:
> 
> 
> > YOu can write  a quick little ela to write an ascii file of 5 min 
or 
> > .
> ***********************
> Chris:
> NO, YOU may be able to write a quick ela but I am ela challenged 
and don't 
> have a clue how to do it.  I still need the S&P data in excel 
format for last 
> 30 trading days of the March contract unless someone can write the 
ela with 
> instructions of how to use it.
> Lynn

here you go -- Excel can read the ascii file that this makes.

Input: DIR("c:\"), NAME("filename"),  oval(o), hval(h), Lval(l),Cval
(c);

If currentbar = 1 then filedelete(DIR+name +".txt");


If currentbar >= 1 then FileAppend(DIR+name +".txt",  NumToStr
(1900+year(date),0) +"/"+ NumToStr(month(date),0) +"/"+ NumToStr
(FracPortion(date/100)*100,0) + ","  + NumToStr(oval,4) + ","  + 
NumToStr(hval,4) + "," + NumToStr(lval,4) + "," + NumToStr(cval,4) + 
newline );

if c<> c then plot1(1," ");


------------------------ Yahoo! Groups Sponsor ---------------------~-~>
Make good on the promise you made at graduation to keep
in touch. Classmates.com has over 14 million registered
high school alumni--chances are you'll find your friends!
http://us.click.yahoo.com/03IJGA/DMUCAA/4ihDAA/zf_UlB/TM
---------------------------------------------------------------------_->

To unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/