Excel help required please

Hi everyone,

I have enclosed an Excel file that I have used for a few years - until yesterday :-)

I have been using the file on a Mac under Office 2008. Yesterday I bought the Office 2016 version. On opening the Excel file there now seem to be a few programming problems or changes in code, they become apparent upon opening the file as I have entered a few bits of data to highlight the problem. I only have very basic Excel knowledge. I know there are a lot of very skilled people on FF and I was hoping someone might be able to have a quick look at the file and maybe fix the problem. I would be eternally grateful, and who knows, someone might find the file useful.

Many thanks in advance to anyone who takes the time to have a look.

Happy trading.

I doubt that I would be the one to fix this, but to get started there is input needed in your Data Copy worksheet.

The price entries at line 10 trade 3 are inconsistent with the other entries, ie not to 5 decimal places.
I think you need to enter a S/L for all entries.

HTH

Edit: This seems to clean up a lot of the errors on your journal worksheet.

If you now look at cell E13 on this worksheet ie #DIV / 0! - this will occur when you have a formula that boils down to zero divided by zero. So again it looks like incomplete data entry or an entry that's not expected.