| User: editor -- 2010-06-27 << 547 549 >> |
| Hits: 3526 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| How to generate Acc/Dist, OBV, MFI and related MA from stock data? The formula of Acc/Dist, OBV and MA please refer to http://www.mind-pioneer.com/services/533_Advanced_search_and_replace.html The formula of MFI please refer to http://www.mind-pioneer.com/services/544_Advanced_search_and_replace.html |
| 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 Acc/Dist MA(24)_Acc_Dist OBV MA(12)_OBV MFI(14) MA(10)_of_MFI 12/16/09 00:00 6.18 6.18 5.99 16330 6.05 -6016.32 -6016.32 0 0.00 100.00 0.00 12/17/09 00:00 6.03 6.08 6.00 74300 6.06 37150.00 15566.84 -74300 -37150.00 18.08 50.00 12/18/09 00:00 5.66 5.74 5.14 1677700 5.51 391463.33 140865.67 -1752000 -608766.67 1.02 39.36 12/21/09 00:00 5.51 5.60 5.45 388200 5.47 -284680.00 34479.25 -2140200 -991625.00 18.87 29.78 ... |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open source txt/csv file 2. ctrl-h open replace window * set 'replace scope' to 'line' * in 'search for pattern', enter: * in 'replace with pattern', enter: click 'Advanced' page: * in 'Run following for each matched unit', enter: 3. click 'Replace', done |
| Download Script: scripts/548.rst.zip |
Similar Examples: |
| How to calculate Acc/Dis, OBV and related MA values of stock data? (78%) How to generate EMA columns and related STD of close value from stock data? (64%) How to generate EMA of close of different periods and related STD from stock data? (63%) How to calculate Elder's Force Index (EFI) and related MA, EMA for stock data? (60%) How to calculate Acc/Dis and corresponding 24 days' MA base on stock data? (58%) How to generate Money Flow Index (MFI) and Moving Average from stock data? (57%) How to generate a csv file from a template file and a list of words? (53%) How to calculate OBV(On Balance Volume) base on stock data? (52%) |
Check Demo of Advanced search and replace |
| Keywords: |
| obv mfi mfi obv load scrip toc stock refer script else scrip download page replace unit script replace download download replace if else replace script generate from line data |