# Getting Asset Avg. Open Price which includes Fees/Taxes calculation

**URL:** <https://community.mycapitally.com/t/getting-asset-avg-open-price-which-includes-fees-taxes-calculation/602>\
**Category:** Proposals\
**Tags:** assets\
**Created:** [June 12, 2025, 9:42pm UTC](https://community.mycapitally.com/t/getting-asset-avg-open-price-which-includes-fees-taxes-calculation/602 "2025-06-12T21:42:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mazin\_Ahsan](https://community.mycapitally.com/letter_avatar_proxy/v4/letter/m/16a34a/32.png) [@Mazin\_Ahsan](https://community.mycapitally.com/u/Mazin_Ahsan)\
**Post date:** [June 12, 2025, 9:42pm UTC](https://community.mycapitally.com/t/getting-asset-avg-open-price-which-includes-fees-taxes-calculation/602/1 "2025-06-12T21:42:02Z")

</div>

Hi,

I am trying to get Avg. Open Price for stock asset after including the Fee + taxes costs.  
Do we have an option to add column in the table for such open price from Select columns & sorting option or if we can add customized column using our formula and add such column in the table. Thanks.

 ![image](https://community.mycapitally.com/uploads/default/original/1X/326078d14b05020d7466873ed45d0677be3b34ec.png)

---

<div class="post-metadata">

**Author:** ![rafal](https://community.mycapitally.com/user_avatar/community.mycapitally.com/rafal/32/18_2.png) [@rafal](https://community.mycapitally.com/u/rafal)\
**Post date:** [June 13, 2025, 5:21am UTC](https://community.mycapitally.com/t/getting-asset-avg-open-price-which-includes-fees-taxes-calculation/602/2 "2025-06-13T05:21:50Z")

</div>

There’s no such metric at the moment. I’m moving this into proposals in order not to forget about it and possibly implement it when there’s a good opportunity.

One problem I see here, is that taxes are mostly not due upon open - mostly at close. Many fees as well.

Currently the avg open price is simply `principal / qty`. It could be `principal - fees - taxes` but then old taxes and fees would be included for currently open positions - which is wrong, and if we include fees and taxes from currently open positions, the costs at close would not be included again 🤔

What do you want to know by looking at this metric?