| User: editor -- 2010-10-26 << 638 640 >> |
| Hits: 3376 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| How to generate EMA columns and related STD of close value from stock data? Can Replace-Pioneer produce two columns of data, calculating a 20 day standard deviation STD or STDDEV comparing column 1 - 6 and column 7 - 12 from base Script 602 STD_EMA1=STD of ( column 1 - 6 ) STD_EMA2=STD of ( column 7 - 12) column 1-6 = EMA(Close) of 3,5,8,10,12,15 days column 7-12= EMA(Close) of 30,35,40,45,50,60 days |
| Input Sample: |
| CODE,DATE,OPEN,HIGH,LOW,CLOSE,VOLUME AIQ,12/16/09,6.18,6.18,5.99,6.05,16330 AIQ,12/17/09,6.03,6.08,6.00,6.06,74300 AIQ,12/18/09,5.66,5.74,5.14,5.51,1677700 AIQ,12/21/09,5.51,5.60,5.45,5.47,388200 AIQ,12/22/09,5.48,5.72,5.48,5.72,336178 |
| Output Sample: |
| DATE TIME OPEN HIGH LOW VOLUME CLOSE STD_EMA1 STD_EMA2 12/16/09 00:00 6.18 6.18 5.99 16330 6.05 0.00 0.00 12/17/09 00:00 6.03 6.08 6.00 74300 6.06 0.00 0.00 12/18/09 00:00 5.66 5.74 5.14 1677700 5.51 2.16 0.00 12/21/09 00:00 5.51 5.60 5.45 388200 5.47 2.08 0.00 12/22/09 00:00 5.48 5.72 5.48 336178 5.72 2.66 0.00 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open source csv file 2. ctrl-h open replace dialog * set 'replace scope' to 'Line' * set 'search for pattern' to: * set 'replace with pattern' to: * click 'advanced' page, in 'run following for each matched unit', enter: 3. click 'Replace', done. 4. ctrl-s save to file. |
| Download Script: scripts/639.rst.zip |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |