Hi all,
I am currently looking to automate a backtest for the foreign exchange market.
All currency pairs trade to four decimal points. I would like Excel to tell me when a value crosses a round number eg. 1.2800 and half round number eg. 1.2850.
I'm assuming the easiest way to do this would be by using an IF statement, but I have limited experience with formulas in Excel.
I have attached an example spreadsheet.
Bookmarks