member badge
Jack
To accomodate the tax regulations in my country, I want to be able to modify the "long-term" period breakdown. I.e. choose 2 years instead of the default 1.
Workaround
I can break down capital gains based on a custom holding period if I:
  • Download the "Capital gains" report
  • Open it in Excel or Google Sheets
  • Add an additional column "Days held" calculated using
    =DAYSBETWEEN()
    formula
  • Add an additional column "Holding period" using
    =IF()
    formula
  • Pivot the table based on "Holding period"