Skip to content

Latest commit

 

History

History
109 lines (80 loc) · 3.34 KB

README.md

File metadata and controls

109 lines (80 loc) · 3.34 KB
Raw

Building Tawny with the Testable Architecture

Stock and Options Portfolio Tracker

  1. "Table stakes": track purchases and sales of equities

    a. Stock Purchase info: symbol (AAPL) date/time (2020-09-10 11:33AM) qty of shares purchase price (cost basis) --> current value, (virtual) gain/loss b. Stock Sale info:

  2. Track purchase/sale of options ("intermediate")

    Opening a Position Examples:

    a. Call option purchase: Symbol: AAPL Position: BTO Type: Call (vs. Put) Option Expiration Date: Oct 16 2020 Strike Price: 125 Cost: 5 Qty: 1 Date/Time --> cost basis: qty * cost * 100 --> break even: 125 + 5 = 130

     Scenarios
 ---------

 Feature: View Portfolio 

 Given a portfolio with
     BTO 1 AAPL 2020-10-16 125 C @ 6.40 on 2020-09-15-15-50
 When I click view portfolio
 Then I can see:

 Symbol | C/P | Qty | Expiration | Strike | Cost Each | Total Cost | Current Price | Value  | Gain/Loss | Percent |
 -------+-----+-----+------------+--------+-----------+------------+---------------+--------+-----------+---------+
 AAPL   |  C  |   1 | Oct 16 20  | 125.00 |      6.40 |     640.00 |         6.35  | 635.00 |   ($5.00) |   (8%)  |


 Feature: Open Position with a Buy Call Option
 
 Given an empty portfolio
 When I click on the "Open Position" button
 And I enter position information (AMD, etc.)
 Then I can see the purchase information, without current price-related information

 Symbol | C/P | Qty | Expiration | Strike | Cost Each | Total Cost | Current Price | Value  | Gain/Loss | Percent |
 -------+-----+-----+------------+--------+-----------+------------+---------------+--------+-----------+---------+
 AMD    |  C  |   1 | Oct 16 20  |  75.00 |      3.20 |     320.00 |          ??  |   ??    |        ?? |    ??   |


 Feature: Update Current Price-related Information from Tradier API

 Given...

    b. Put option sale: Symbol: AMD Position: STO (sell to open) Type: Put Expiration: Oct 2 2020 Strike Price: 77 Cost: 2.19 Qty: 10 Date/Time --> cost basis: -qty * cost * 100 -> 2.19 * 100 * 10 = 2,190

    c. Bull Call Spread Symbol: AMD Position: BTO STO Strike Price: 75 90 Type: Call Call Expiration: Oct 16 Oct 16 Cost: 7.00 1.60 Qty: 10 10 Net Cost: 7.00 - 1.60 = 5.40 --> cost basis: 5.40 * 100 = $5,400

     10 * AMD 2020-10-16 75 C/2020-10-16 90 C

  3. Track rollover of options ("advanced")

    Given: -1 AAPL 2020-09-18 115 C (STO) @ 4.20

    Roll: +1 AAPL 2020-09-18 115 C (BTC) @ 2.40 -1 AAPL 2020-10-16 115 C (STO) @ 6.40 Net: +4.00 (income)

    Overall Net: 4.00 + 4.20

    -1 AAPL 2020-10-16 115 C (STO) @ 6.40 --> 4.00

Infrastructure:

  • Database - relational
  • Pricing API - for equities: IEX, options: Tradier
  • Broker API (optional)
  • Importing portfolio from spreadsheet/CSV
  • Mobile app/front-end (iOS) SCARY!!

UI Notes