Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

582.Text data calculation -- How to calculate Williams %R from stock data?

User: editor -- 2010-08-06          << 581  583 >>
Hits: 454
Type: Text data calculation   
Search all Text data calculation examples
Description:
How to calculate Williams %R from stock data?

The formula for Williams %R (WMS)
formula Let's start with 10 days.

WMS = 100 * [(today's Close - Highest High in p1 periods) /
(Highest High in p1 periods - Lowest Low in p1 periods)]
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 WMS(10)
12/16/09 00:00 6.18 6.18 5.99 16330 6.05 -68.42
12/17/09 00:00 6.03 6.08 6.00 74300 6.06 -63.16
12/18/09 00:00 5.66 5.74 5.14 1677700 5.51 -64.42
12/21/09 00:00 5.51 5.60 5.45 388200 5.47 -68.27
12/22/09 00:00 5.48 5.72 5.48 336178 5.72 -44.23
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source text/csv 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/582.rst.zip

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to calculate Parabolic SAR on a 5 days basis of stock data? (67%)
How to calculate OBV(On Balance Volume) base on stock data? (67%)
How to calculate Acc/Dis, OBV and related MA values of stock data? (63%)
How to calculate CFMO 15 and CFMO 21 from csv file of stock data? (62%)
How to calculate SUM of EMAs and Covariance of close value from stock data? (61%)
How to calculate Acc/Dis and corresponding 24 days' MA base on stock data? (56%)
How to calculate Elder's Force Index (EFI) and related MA, EMA for stock data? (54%)
How to calculate the number of days between every two adjacent dates? (53%)

Check Demo of Text data calculation
Keywords:
williams r  calculate williams r  how to calculate williams r  calculate williams  how to calculate williams  highest high  period  pages  stock  toc  search calculate replace  search replace calculate  if else  replace with data  data replace  replace from  replace if  if replace