Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Yearly Capital Gain Discrepancy

I have a discrepancy in capital gain figures in different tables/worksheets.
In Monthly worksheet, Grand Total column/row cell I have a figure X. It matches with Holdings table Capital Gain/Grand Total cell using 2020 filter. But it is different to Yearly worksheet, Yearly Movements table, Capital Gain/2020 cell. Shouldn't they be the same?

Comments

  • Peter,

    Different worksheets have different filters on symbols. Holdings table shows just symbols that are currently "holding" and total capital gain will include just these symbols. Yearly worksheet does not have same filter, so it will include all symbols, for example if symbol was sold in 2020, it will not be included in Holdings, but included in Yearly. Would that explain difference?
  • Right again Vidas. I should have looked at filters before asking, especially in light of my previous question which was kind of related... Anyway, many thanks!
Sign In or Register to comment.