adding two data arrays to produce higher price increment/range
My challenge is to take basic data at the lowest increment and process it into a larger increment. The basic data can be increasing/decreasing in price. Eg
high low
1.0 0.9
1.1 1.0
1.0 0.9
0.9 0.8
The lowest increment is 0.1 and is also the lowest range as can be seen in the small table above. Now lets say I want to have an increment(range) of (1.0). How can I create a process to take the lowest range and produce the desired range (1.0)? My understanding regarding the logic is "if next price is higher or lower than the desired range value, then begin to add anew until once again the desired range value is exceeded. My challenge is I have limited understanding of how to do this, but I imagine some kind of looping with conditional statements is necessary. Could someone please suggest or provide coding info? Please understand, I want to learn, but also want to feel the progress. thx!
PS this is not homework!
high low
1.0 0.9
1.1 1.0
1.0 0.9
0.9 0.8
The lowest increment is 0.1 and is also the lowest range as can be seen in the small table above. Now lets say I want to have an increment(range) of (1.0). How can I create a process to take the lowest range and produce the desired range (1.0)? My understanding regarding the logic is "if next price is higher or lower than the desired range value, then begin to add anew until once again the desired range value is exceeded. My challenge is I have limited understanding of how to do this, but I imagine some kind of looping with conditional statements is necessary. Could someone please suggest or provide coding info? Please understand, I want to learn, but also want to feel the progress. thx!
PS this is not homework!
Last edited on
Topic archived. No new replies allowed.