Hi i have a price column b and quantity column a (which is either + buy or - sell). If quantity = 0 (i.e buy 2 sell 1 and sell 1 at a different price). Then I want another column to illustrate if this transaction has been profitable or not (depending on the price) Bearing in mind that there will be many transactions and that a result is illustrated only when buys equal sell and so on?? Thank you very much
Copyright © 2024 Q2A.ES - All rights reserved.
Answers & Comments
Verified answer
your question is unclear...if you provide like an example or simplfy the question i may be able to help you