Building QS with the Testable Architecture
Stock and Options Portfolio Tracker
"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:
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 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 Currently exploring an option to use a noSql DB, Pricing API - for equities: IEX, options: Tradier Broker API (optional) Importing portfolio from spreadsheet/CSV Mobile app/front-end (iOS) SCARY!!