Homework H18

Execution Engine!

Learning Goals

Executing stock and option transactions, and editing the portfolio.

Context

FinCalc

“Welcome back, Mr. Bonds! How was your Italian vacation?”
Stockton sweeps onto the trading floor looking unusually relaxed, sun-tanned, and carrying the unmistakable air of a man who has recently eaten very well.   “SPLENDIFEROUS!” he declares. “I ADORE the Amalfi Coast.”
You have never heard another human being use the word 'splendiferous' in normal conversation. At this point, however, you are accustomed to Stockton’s ways.
“Magnificent food. Impeccable views. Boats. Sunsets. Civilization at its finest!” he continues, spreading his arms as if presenting the entire Mediterranean.
Then, without missing a beat, he pivots back to business. “And I have seen your work with the Spartan Trader…” he says, eyes narrowing with curiosity. “…does it actually trade?”
“It does.”
“Can I try?”
“Be my guest.”
For a moment neither of you says anything. Stockton selects a symbol. Enters the quantity. The transaction type. Then clicks Execute.
And then neither of you can suppress a giddy smile when the Spartan Trader executes - flawlessly! - its very first manual trade.

Task

Build a system that satisfies the requirements.
Want to submit as a team?  These are are instructions.

Criteria/Requirements

Your work must satisfy the following requirements

  • Everything from all previous homework must be implemented correctly
  • From now on use your team ID, not teamID 30
  • The Trader must be able to execute all available trades on all databases and immediately update your teamPortfolios, the transaction queue, and all the metrics (except delta and sumTE)
  • The trader highlights in green a few cells to signify they the trade was sent successfully.
  • At the user request, the Trader reset and edits the remote portfolio and updates all its data.

Hints and Tips

  • This homework requires DB access (= you may not use the big Shumway lab and most of RRH 300).
  • As before and for the remainder of the Spartan Trader series, the videos are strong hints, but not the full solution.
  • The confirmation tickets and the last three columns of the TrasactionQueue do not update yet.  They do so only when Athens (the exchange) is running.
  • Some tables may be empty or contain different data than in the video. That is OK. Check against the databases.
  • Feel free to change the look and feel of your app, provided that the interface is easily understandable by the grader.  You are the developer and the user. You build it the way you like it. You will use it in the Hedge Tournament.

Patches

  • The video cuts off the last line of IsAPentryValid. It should be:
        Return False
    End Function