Hello,
Is it possible to to use a word in a transition column ex. Buy or Sell and give it an action like plus or minus? So you can import data and figure out how many stock shares you have bought and sold?
to help figurer out quantity held and dollar cost average of stocks.
Thank you
Hello,
Yes, if the data is already imported you often use the IF function in a helper column to determine what to do.
It can also be handled during import, where you use Power Query to do the job.
Br,
Anders
Hi Anders,
Would you happen to know what the formula would be for the helper column using the attached sheet? Im kind of new at this so I would have to even look up what a Power Query is.
Thank you
Hi Cody
You can try this :
=IF([@[Transaction Type]]="Buy","+",IF([@[Transaction Type]]="Sell","-",""))
Sunny
If is one of the most useful functions in excel, you can learn more about it here.
