Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add the other eTrade tax strategies that could have been selected #82

Open
hickeng opened this issue Mar 5, 2024 · 0 comments
Open

Add the other eTrade tax strategies that could have been selected #82

hickeng opened this issue Mar 5, 2024 · 0 comments
Labels
solver Relating to the solver logic for applying tax strategy, aka manual per-lot treatment tweak Relating to a tweak option

Comments

@hickeng
Copy link
Owner

hickeng commented Mar 5, 2024

I started the sheet with pro-rata, then added an optimizer to try for the MT strategy. During some discussion, someone mentioned about FIFO and it prompted me to realize that there's an entire set of strategies that could have been selected in eTrade account preferences.

This issue is to add a comparator to allow use of whichever strategy was active, given that was the only way to communicate with eTrade the intent for handling:

  • FIFO
  • LIFO
  • LOFO
  • HIFO
  • MT
@hickeng hickeng added tweak Relating to a tweak option solver Relating to the solver logic for applying tax strategy, aka manual per-lot treatment labels Mar 5, 2024
hickeng pushed a commit that referenced this issue Mar 11, 2024
Generalization of optimizer to Apply Strategy
bd9319a 
Previously I had functions called variations on optimizer which were my
WIP towards the MT strategy.

This pauses that MT work to generalize this to a broader "Apply Strategy"
so that people can select whatever eTrade tax strategy they had active in
their profile.

This:
* moves the "Use for Fraction" heading down into the dataheading row.
* moves the balance calc to a cell formula so that manual adjustment to
  cash/shares via dropdown will result in immediate recalc
* forces fractional lot to be shares - could use balance as well, but this is
  simpler than trying to determine minimum valid ratio and consequence
  of total lot sale.
* renames menu items to reflect eTrade strategy names
* adds a pro-rata to the Prefer dropdown to allow pinning a lot to the
  holding ratio

Towards #82
hickeng pushed a commit that referenced this issue Mar 11, 2024
@hickeng
Generalization of optimizer to Apply Strategy
9510406 
Previously I had functions called variations on optimizer which were my
WIP towards the MT strategy.

This pauses that MT work to generalize this to a broader "Apply Strategy"
so that people can select whatever eTrade tax strategy they had active in
their profile.

This:
* moves the "Use for Fraction" heading down into the dataheading row.
* moves the balance calc to a cell formula so that manual adjustment to
  cash/shares via dropdown will result in immediate recalc
* forces fractional lot to be shares - could use balance as well, but this is
  simpler than trying to determine minimum valid ratio and consequence
  of total lot sale.
* renames menu items to reflect eTrade strategy names
* adds a pro-rata to the Prefer dropdown to allow pinning a lot to the
  holding ratio

Towards #82
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
solver Relating to the solver logic for applying tax strategy, aka manual per-lot treatment tweak Relating to a tweak option
Projects
VMware/Broadcom merger finances
Status: No status
Milestone
No milestone
Development

No branches or pull requests
1 participant
@hickeng