Blank cell cant make calculations !

[TheSardOz]

Hello Forum!
I have this data and I would like to calculate the profit loss,( entry value - exit value) or the other way around it depend if is a long or a short.
The problem I am facing is that I can't make the calculation because the data in not linear but shifted, what's the best solution ?


Thank you !

 

[TheSardOz]

hi ThesardOz,
From your last results, it seems the conditional part of the formula needs some amendments. I'd suggest evaluating formula steps with matching conditions using the [F9] key and then changing the matching criteria, if needed.
Initially the formula was designed to compute results based on a single group, CODE, and then matches the criteria of Long/Short etc., e.g. if you had 4 rows of code DOC then the computations were made starting from 1st occurrence of DOC till the last one, keeping in view Long/Short. But now, maybe, I think you are computing the results for 2 rows, I m sorry but I have no experience in trading therefore, it might be getting way over my head.

I hope my explanation makes sense.

Thank you very much for taking your time to help!

 

[fadee2]

Thank you very much for taking your time to help!

Though, in the end the result was nothing , but you are very welcome... always happy to help...