ok I have been looking at all the replies to the questions I asked but it is still not quite what I was looking to do with the program
so let's try this I would like to calculate the say the closing cost for the next 5 days beyond the last day of data. I order to do this I want to use a formula that would change the end result each successive day based on the calculation performed on the previous day. So it would look something like this: close = EOD close1 = close * .1 + close close2 = close1 * .05 + close1 close3 = close2 * .025 + close2 etc. now is this possible where the look ahead start with the data obtained and then using some mathimatical calculations forcing the data to look into the future? Shift will give me the results for one day if I xshift 5 days it still only returns the same value as if looking just one day. Disq
