End-of-Day Excel Template
I have finished the write up on the Range Expansion Indicator (REI) template for Excel spreadsheets, and will convert it for PC users sometime next week. Right now it is complete for Macintosh versions of Excel 4.0 (later versions will run it as well) and the documentation is in simpletext. The rewrite for PC/Windows users will be in Excel 5.0 and the docs in .txt format.
The short version goes like this - you open the template and save it in a stock's name or symbol. Then you input the open, high, low, and close. If you preload 7 days of this data, it gives you an answer immediately, otherwise you have to keep loading data for that many days to get it started. Essentially it looks to see whether a trending stock is reaching an overbought or oversold (OB/OS) condition and returns a number between +100 and -100. Its more spophisticated than a stochastic (trust me, I wouldn't have done all this work if it wasthat simple), which can show a stock as OB or OS for a long time while it continues to rise or fall or stay level. That's it. You create one spreadsheet for each stock and then take a few seconds to enter its data each night. I put in some guidelines for buy and sell price strategies as well as how to set/calculate protective stop limits. There are also a few examples (PNF, IOM, etc.) and a recommendation of what kind of stocks to use it on (less volitile, basically).
I created it to test some stocks for which I didn't get nightly downloads. Its actually a simplified version of one of the metrics in the neural net. After I made it I realized that for someone who didn't do technical analysis or only tracked a few stocks it would be real useful. And if they did do TA, this augments the analysis. For anyone using ProTA (Mac) I have a second template that takes the exported data from your entire portfolio and generates a single ranking of the best to worst based on the indicator. That is a lot easier since you create a specific portfolio format with the data you need from all stocks in it and export that file. That template also uses a macro I wrote to copy, paste and (more importantly) sort the data and results from the exported file into the other template - all that takes about two seconds.
If JENNA WILL EVER RETURN MY EMAIL I will get the export and data structure format for MetaStock and create a similar spreadsheet and macro for PC users. You can write the formula into a custom MetsStock or ProTA Gold (not publically available yet) indicator, but I haven't done that yet.
At any rate, sorry to drag this out, but if you want it email me at lastshadow@earthlink.net and specify if you have a Mac or a PC. Hopefully everyone will get one version or the other by the end of next week. Play with it, backtest a few, and let me know if you have any questions. If you use MetaStock, note that in case I need a backup source. Its free, so give it to anyone you want. Take credit for it if will help you get a date. If you sell it to anyone I will send my college daughter to drain every cent from your bank account...and leave you with overdraft notices.
And please forgive if you read all this and really didn't want to go there. Have a safe weekend everyone.
lastshadow |
