- Excel 2007 (or later)
- Excel 2003
2. Move downloaded Add In file to your Excel AddIns directory
- For example, if you use Excel 2007 (or later) on Windows 7, the directory may be 'C:\Users\XXXX\AppData\Roaming\Microsoft\AddIns' where 'XXXX' is your Windows 7 login name.
3. Open Excel and install Elliott Pattern Helper Add In
- For Excel Add In installations, follow Excel's Help.
- After installing EPH, check whether EPH context menus are created properly.
4. Load data
- Using your home trading system software, feed stock price or index data to your Excel sheet.
5. If needed, change high, low and date labels appropriately.
- (Context Menu) → 'Data Helper' → 'Label Setting'
6. Execute Batch
- (Context Menu) → 'Helper Batch' → 'Batch with S' or 'Batch with B'
- Sheet with name 'EPH' will be created as shown below.
- (Context Menu) → 'Helper Batch' → 'Batch for weekly'
- Sheet with name 'EPH_w' will be created as shown below, which contains weekly data and chart generated automatically from daily data.
- Sheet 'EPH' can be generated step-by-step using menus other than ones in 'Helper Batch'.
- First execute (Context Menu) → 'Data Helper' → 'Prepare Data', second (Context Menu) → 'Data Helper' → 'Make monowaves', third (Context Menu) → 'Pattern Helper' → 'Find Labels', and (Context Menu) → 'Pattern Helper' → 'Elliott Chart', then you will have the same 'EPH' sheet as the one shown above.
7. Analyze structure and progress labels of a monowave
- On a cell containing 'Rule and Condition' data, i.e., column E, execute (Context Menu) → 'Pattern Helper' → 'Wave Structure'.
- Small chart with structure and progress labels of the selected monowave will be created as shown below.
8. Check smaller portion of whole chart
- Make a selection on column C and execute (Context Menu) → 'Pattern Helper' → 'Elliott Chart', then smaller chart containing selected waves will be created.
댓글 없음:
댓글 쓰기