"A Python based application to monitor your stock market and crypto holdings in one place"
APIs Used
Cryptocompare
I used the Cryptocompare API in order to monitor crypto-currency prices. It's used in functions when informing users on net gain and adding a new holding. The API pulls from sites such as Bitfinex, Coinbase, and BitStamp.
IEXFinance
I used the IEXFinance API in order to monitor stock prices. It is written in a similar fashion to the Yahoo Finance API, which was discontinued. I used it in functions informing users on net gain and adding a new holding. The API pulls from the Innvestor's Exchange developer platform.
Database Schema
Users Table
| UserID | Username | Password |
|---|---|---|
| 1 | ebwinters | 8411cee2db364f1da0f399580d2405 |
| 2 | licanalister | ef070509d3df6492e0e280c3da8af3 |
| 3 | jgocaldise | 2c5d7e6b28bf822f21a56c4da605f8 |
Holdings Table
| HoldingID | UserID | Abrv | Hold | Bought_At | Crypt |
|---|---|---|---|---|---|
| 1 | 1 | AAPL | 81.7 Shares | $159.32 | 1 |
| 2 | 1 | BTC | 3.7 Shares | $12000.81 | 0 |
| 3 | 2 | TEUM | 10.7 Shares | $1.27 | 1 |
| 4 | 3 | XRB | 37.9 Shares | $10.92 | 0 |
| 5 | 3 | BLT | 103.42 Shares | $0.68 | 0 |
UserID
Integer - user identification number
(primary key)
HoldingID
Integer - holding identification number
(primary key)
Abrv
Varchar - Abreviation for stock or crypto holding
Hold
Money - The amount of stock or crypto that the user is holding
Bought_At
Money - The price in USD at which the user bought at
Crypt
Boolean - 0 for a cryptocurrency, 1 for a stock
