Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

639.Text data calculation -- How to generate EMA columns and related STD of close value from stock data?

User: editor -- 2010-10-26          << 638  640 >>
Hits: 1840
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


Similar Examples:
How to generate EMA of close of different periods and related STD from stock data? (71%)
How to calculate SUM of EMAs and Covariance of close value from stock data? (67%)
How to generate 12 columns EMA with different periods based on "close" value? (63%)
How to calculate Acc/Dis, OBV and related MA values of stock data? (63%)
How to generate Acc/Dist, OBV, MFI and related MA from stock data? (61%)
How to add a column of Close Location Value("CLV") on stock data? (60%)
How to generate a TREND column of Hodrick-Prescott Filter base on CLOSE value? (56%)
How to generate files from template file, where some variables come from a list? (55%)

Check Demo of Text data calculation
Keywords:
101  1st  toc  stock  day  comp  script  scrip  two  scr  data base  generate column  search and replace column in a csv file  column search and replace in csv  replace from csv  csv from  value column  search replace csv