search

achannarasappa / ticker

Terminal stock ticker with live updates and position tracking
GNU General Public License v3.0
5.02k stars 273 forks source link

Feature request: Provide "sell" option for lots to calculate average cost #152

Closed ghost closed 3 years ago

ghost commented 3 years ago

Problem Statement Is your feature request related to a problem? Please describe.

If I sell part of a stock being tracked on Ticker (with multiple lots for the same symbol), I want Ticker to be able to recompute the average cost automatically. Right now I have to perform the calculation by hand and then input the adjusted unit cost and quantity.

Proposed Solution A clear and concise description of what you want to happen.

We have:

lots:
  - symbol: "ABC"
    quantity: 100
    unit_cost: 50
  - symbol: "ABC"
    quantity: 100
    unit_cost: 40

We sell 50 units of ABC at $60. Right now I have to calculate the adjusted cost and quantity myself and then input it into Ticker. It would be nice to have something like:

sells:
  - symbol: "ABC"
    quantity: 50
    unit_cost: 60

Where we tell Ticker we have sold part of that stock, and Ticker will recompute our total quantity and average cost.

Alternatives A clear and concise description of any alternative solutions or features you've considered.

N/A

Use Cases A clear and concise description of any alternative solutions or features you've considered.

N/A

Additional context Add any other context or screenshots about the feature request here.

N/A

achannarasappa commented 3 years ago

Thanks for the suggestion however I don't think it should be possible to represent sales in the config. The reason is that the current cost basis lots are intended represent your account at the current moment in time without any knowledge of it's previous state. Introducing the ability to represent sales or purchases means that the config would be able to represent previous states however there is no way to view these previous states in the UI (and at the moment do not see any use cases for this). Further this introduces the complexity of having to account for the sales strategy (e.g. LIFO/FIFO).

Anecdotally, exchanges I've used myself readjust tax lots after sales so there may be a way to find these without having to perform a manual calculation.