SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : EZ-PnF, a P&F Charting Program
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Mr. BSL who wrote (2)2/8/1998 3:27:00 PM
From: Ben Antanaitis  Read Replies (2) of 178
 
duke60,

Should be no problemo........

In fact it looks like you get some choices in how you do it.

First, (cop out time), I don't have Excel, but I do have Lotus 1-2-3 and Quattro, and I am confident they all have to cover the same basic capabilities so here goes my thoughts on this question:

You have an Excel worksheet that has a column that shows the numeric result of the RS calculation ie a column that is the quotient of dividing the stock price by either the DJ30 or the NASDAQ100 or the Sector value for that same day. If you highlight that column of quotients and select the option that lets you 'export' the highlighted column as a particular file type with a specific format. In this case it looks like it could either be CSV (comma separated variable, but it would only have one variable and wouldn't need commas) with a new name like CSCO_RS.CSV, OR perhaps it could be TEXT which I think would give you a file with each data value wrapped in quotation marks, one value per line, with as many lines as there are data values.
Key here is to try it, create the output file. Then look at the file with a text processor.. you should be able to view it and see if it came out like one of the 600+ layouts I cranked into the User-ASCII definitions.

Does this help?

Ben A.
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News