Thanks for all your help Dale, I really appreciate you taking the time for me but I need to take a break from this until I get done with class tomorrow because I am just getting frustrated. No matter what I do I still seem to get the same stupid incorrect values that increase by way too much every day.
The following applies to Gold, data used is last 6 weeks or so
I'm calculating the SI values like this exactly: 50*(S7/R7)*(J7/3)
Where S7 is the numerator, or C2-C1 + .5 (C2-O2) + .25 (C1-O1)
R7 is R
J7 is K
and 3 is the limit
After getting these values, which for me are ranging between about -1200 and 500, I calculate the ASI by adding yesterday's ASI to today's SI value. These values are ranging between about -1000 and 2000. Finally, I take the ASI, and divide it by the pipfactor of 0.1 and get a new column called pASI where the values range between about -10000 and 20000. The only problem is, these values fluctuate thousands each day, which tells me that I'm doing something wrong.
|