Hello all! I am trying to find the formula to calculate consecutive wins from my journal spreadsheet in cell "L" onto my Overview spreadsheet in cell "N 12". I don't do much excel formulas so I would need to understand how to enter this so it calculates from one sheet onto another sheet. I have...
Sam your formulas are adding and subtracting the value but not based off of the long or short position. I am attaching a file that you can look at from dropbox.com if you like. Thanks for the help!
https://www.dropbox.com/s/stdmqhdy8r9tu82/Carl%27s%20Trading%20Log.xlsm
Hello! I am trading forex and made a trading journal using excel and I am keeping track of my profit/loss. In forex if you enter a long trade then you are buying and expect the price to increase. So if you enter a trade at 1.30000 and exit at 1.30500 then that would be a 50 pip profit. If the...