-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Financial formulas: Macro to calculate Williams %R
- Thread starter datalyst
- Start date
Hello T,
Finally i found a solution to this. now that i know how to calculate Will%R, I am looking to implement this. shall i make a UI form to get inputs form the user? how is "period" used to calculate this %age?
you may want to take a look at this:
http://stockcharts.com/h-sc/ui?c=INTC,UU[L,A]DACLNIMY[P][VC60][IUK14]
scroll to the bottom of the page and there you will see a section called indicators. you can select an indicator and define period.
Finally i found a solution to this. now that i know how to calculate Will%R, I am looking to implement this. shall i make a UI form to get inputs form the user? how is "period" used to calculate this %age?
you may want to take a look at this:
http://stockcharts.com/h-sc/ui?c=INTC,UU[L,A]DACLNIMY[P][VC60][IUK14]
scroll to the bottom of the page and there you will see a section called indicators. you can select an indicator and define period.
Upvote
0
tweedle
Well-known Member
- Joined
- Aug 1, 2010
- Messages
- 1,559
The time-slice is whatever you define, or whatever is specified to you.
In the case of stocks, it's usually the high, low, close for the day.
If you're mapping tides, and measure the same time every day for a 15 days, then you would take the high, low and close (last reading) to date and graph those 3 values. If you're graphing petrol prices, you can take readings every n periods and graph the h/l/c in the defined range. The point is in graphing the 3 measurements. The Low has to be the lowest value for the period, the High has to be the highest value for the period, and the close has to be somewhere >=Low AND <= High. It's a measure of agression for the period.
How you acquire the periodic measurements is up to you and your requirement.
Edit: The period simply defines which set of records to use to select H/L/C from.
In the case of stocks, it's usually the high, low, close for the day.
If you're mapping tides, and measure the same time every day for a 15 days, then you would take the high, low and close (last reading) to date and graph those 3 values. If you're graphing petrol prices, you can take readings every n periods and graph the h/l/c in the defined range. The point is in graphing the 3 measurements. The Low has to be the lowest value for the period, the High has to be the highest value for the period, and the close has to be somewhere >=Low AND <= High. It's a measure of agression for the period.
How you acquire the periodic measurements is up to you and your requirement.
Edit: The period simply defines which set of records to use to select H/L/C from.
Last edited:
Upvote
0
