| User: editor -- 2010-06-04 << 525 527 >> |
| Hits: 3421 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| How to add a column of Close Location Value("CLV") on stock data base on example 525? http://www.mind-pioneer.com/services/525_Advanced_search_and_replace.html A formula to calculate a value based on the location of the close, relative to the range for the period... call this value the "Close Location Value" or CLV. The CLV ranges from plus one to minus one with the center point at zero. There are basically five combination: ( ( (C - L) - (H - C) ) / (H - L) ) = CLV |
| 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 MACD(12,26) EMA(9)_MACD Yesterday_OBV Today_OBV CLV 12/16/09 00:00 6.18 6.18 5.99 16330 6.05 -0.00 0.00 0 0 -0.37 12/17/09 00:00 6.03 6.08 6.00 74300 6.06 0.00 0.00 0 74300 0.50 12/18/09 00:00 5.66 5.74 5.14 1677700 5.51 -0.04 -0.01 74300 -1603400 0.23 12/21/09 00:00 5.51 5.60 5.45 388200 5.47 -0.08 -0.02 -1603400 -1991600 -0.73 12/22/09 00:00 5.48 5.72 5.48 336178 5.72 -0.10 -0.04 -1991600 -1655422 1.00 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open source text file 2. ctrl-h open replace window * set 'Replace Unit' to 'Chars' * set 'Replace Scope' to 'Lines' * enter following in 'Search for pattern' entry: * enter following in 'Replace with pattern' entry: click 'Advanced' page, enter following in 'run following for each matched unit' entry: 3. click 'Replace', done! |
| Download Script: scripts/526.rst.zip |
Similar Examples: |
| How to generate EMA columns and related STD of close value from stock data? (60%) How to calculate SUM of EMAs and Covariance of close value from stock data? (53%) How to add MACD, EMA, FAST%K, SLOW%D columns for CSV file of stock data? (53%) How to calculate Williams %R from stock data? (51%) How to calculate Acc/Dis, OBV and related MA values of stock data? (50%) How to produce two new columns: MACD(12,26) and MACD EMA(9) on stock data? (50%) How to add MACD, EMA, FAST%K, SLOW%D and BB columns for stock data? (49%) How to extract all commands from operation log file in unix platform? (48%) |
Check Demo of Text data calculation |
| Keywords: |
| close location value plus combination asic zero based on range period data base toc close location value calculation formula to calculate close location value add point calculate lines same value replace text in range calculation on stock data range replace |