Calculate Net Amount by taking both date and ticker

[criperc]

Hey guys,

I have this example dataset: (see image)

The goal for me is to calculate Net Amount, which is Dividend for ticker X on the specific date minus Taxes for ticker X on the specific date.

How can I do this? I have in mind creating a concat of ticker and date and then join rows? or perhaps a complex formula tile? or transpose the data?

Help is appreciated it!

[apathetichell]

try this...

I made the taxes negative - since I usually don't get taxes back with dividends. mlp distributions - maybe who knows those k1s are crazy....