Forex Trading Spreadsheet
Help with Excel (advanced)?
I'm building a worksheet to backtest Forex trading strategies. I want to be able to find the difference between the circle values. Ideally, put the value in cell L93. http://img205.imageshack.us/img205/4206/yahooal4.jpg The only difficult part is not always There are three rows between each number to be used. Sometimes there can be only one row, or there may be 10 rows. Is there a way to stand out in search of values ??between two of the same number? As the 0's? I'm asking b / c need to do this hundreds or perhaps thousands of times. I can see the difference between the amounts of each two columns with ease, but I want to be able to do this too. Thanks
It can be done with a macro, of course. But if you. There is a surplus in a column place outside the normal view and print areas. 2. The difference you want to display in column L is that in each row where there is a positive value in column K 3 The the difference is positive above the last value in column J less than the value in column K row of the screen. Then you can do with only two formulas (with copy the entire column.) I selected the Z column of the spine on the middle row and 85 to enter formulas. In cell Z85 type = IF (J85> 0, J85, Z84) In cell L85 type = IF (K85> 0, Z85-K85, "") copy of each of the formulas of theses in their respective column for the full range data and you will see the differences to which they belong. You may need to adjust the formula at the beginning of the data or anywhere there is an interruption in the data, but you do not have any of those, so I can not say what would be required. We hope you can take it. Or you can add to your question for help.
Forex Trading Spreadsheet – www.TradingSpreadsheets.com
