| User: editor -- 2010-06-23 << 543 545 >> |
| Hits: 3038 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| How to generate Money Flow Index (MFI) and related Moving Average from stock data? Formula: 1. Typical Price = (High + Low + Close) / 3 2. Money Flow = Typical Price * Volume Positive MF: If today's Typical Price is greater than yesterday's Typical Price Negative MF: If today's Typical Price is less than yesterday's Typical Price 3. PMF = the sum of the Positive Money Flow in p1 periods NMF = the sum of the Negative Money Flow in p1 periods 4. MFI = 100-(100/(1+( PMF/NMF))) |
| 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 MFI(14) MA(10)_of_MFI 12/16/09 00:00 6.18 6.18 5.99 16330 6.05 100.00 0.00 12/17/09 00:00 6.03 6.08 6.00 74300 6.06 18.08 50.00 12/18/09 00:00 5.66 5.74 5.14 1677700 5.51 1.02 39.36 12/21/09 00:00 5.51 5.60 5.45 388200 5.47 18.87 29.78 12/22/09 00:00 5.48 5.72 5.48 336178 5.72 30.06 27.60 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open source csv/txt file 2. ctrl-h open 'replace' window * set "Replace Scope" to "Line" * set "search for pattern" to: * set "replace with pattern" to: * click "Advanced Page", set "Run following for each matched unit" to: 3. click "Replace", done! |
| Download Script: scripts/544.rst.zip |
Similar Examples: |
| How to calculate Elder's Force Index (EFI) and related MA, EMA for stock data? (60%) How to generate EMA columns and related STD of close value from stock data? (57%) How to generate Acc/Dist, OBV, MFI and related MA from stock data? (57%) How to generate EMA of close of different periods and related STD from stock data? (56%) How to calculate SUM of EMAs and Covariance of close value from stock data? (50%) How to generate a full number list base on given number range list? (50%) How to calculate CFMO 15 and CFMO 21 from csv file of stock data? (48%) How to generate 200 random numbers in the range of 100 to 300? (47%) |
Check Demo of Advanced search and replace |
| Keywords: |
| money flow mfi money index greater price periods average rage period if greater than if else generate from search data replace with data data replace sum replace search and replace open source |