Silicon Investor (SI) -- The First Internet Community

STOCKTALK

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 : TA-Quotes Plus -- Ignore unavailable to you. Want to Upgrade?

To: Ken Adams who wrote (5408)	7/15/1998 6:27:00 PM
From: Pumpkinhead	Read Replies (1) \| Respond to of 11149

OFF-TOPIC on Q+ but strictly ON-TOPIC when it comes to making money. I am interested in supplementing system testing with TA programs (such as MS6.5) by using Excel, my spreadsheet program. I sense awesome power in Excel and want to tap into it. Does anyone know of a book or other source that would give me a hand? I know there are many books on business statistics out there, but slogging through them for occasional nuggets to help my trading sounds like a real pain in the arse. Sure would appreciate it. Thanks.

To: Ken Adams who wrote (5408)	7/15/1998 7:19:00 PM
From: Roy Yorgensen	Read Replies (1) \| Respond to of 11149

Ken, This is quick and dirty but I think it does what you want. You could add a For Next Loop to allow going back and looking at previous days. Output "test.lst"; IssueType Common; Integer N; Float Pct; Pct:=.05; //Enter the increase amount you desire as a decimal N:=5; //Enter the Num of Days you want to 'look back' If Close(0)=>Close(-N)(1+Pct) Then PrintLn Symbol:-8,"Pct increase in ",N," days is ",((Close(0)/Close(-N))-1)100:3:1,"%"; EndIf Sample Output AAC Pct increase in 5 days is 8.2% AACE Pct increase in 5 days is 7.9% AAN Pct increase in 5 days is 8.1% AAPL Pct increase in 5 days is 9.6% AATT Pct increase in 5 days is 6.0% ABAX Pct increase in 5 days is 7.4%

To: Ken Adams who wrote (5408)	7/16/1998 11:38:00 AM
From: John Schott	Read Replies (1) \| Respond to of 11149

(Revised posting) I didn't notice that Yorgenson beat me to it with a better and more detailed responce - so following is only an added comment: * Seems to me there is something similar that can be adapted at <http://www.geocities.com/WallStreet/Exchange/1216> which is an archive of scans here. You can download (and also print) these. Using the QP2 IMPORT feature, you can then get them into SCAN and edit to your hearts content. Alternatively, print them out. Thanks to Brooke, that makes a great tutorial on what you can do with SCAN.